Skip to content

Instantly share code, notes, and snippets.

@cmsax

cmsax/day_transaction_history.sql

Last active August 1, 2019 01:47
Show Gist options
  • Save cmsax/74ce42e19efc10686bb78c1d0ee20773 to your computer and use it in GitHub Desktop.
Save cmsax/74ce42e19efc10686bb78c1d0ee20773 to your computer and use it in GitHub Desktop.
Download ZIP
#influxdb
Raw
day_transaction_history.sql
select time, close_price from "transaction"."autogen"."transaction_history" where stock_id = '000001' and time >= '2014-01-01' and time <= '2016-01-01' and type='day'
Raw
tick.sql
select time, amount from "transaction"."autogen"."transaction_history" where stock_id = '000001' and time >= '2014-01-01' and time <= '2016-01-01' and type='tick'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment