PREVIEW / futures_1hour / 2018-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-19.parquet
  size:    46 KB
  rows:    1,371

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-01-19 00:00:00	ES	Futures	3054.44	3055.81	3053.89	3055.26	3320.0
2018-01-19 01:00:00	ES	Futures	3055.26	3056.35	3054.17	3054.99	3676.0
2018-01-19 02:00:00	ES	Futures	3055.26	3056.63	3054.17	3056.08	7639.0
2018-01-19 03:00:00	ES	Futures	3055.81	3060.18	3055.81	3060.18	16742.0
2018-01-19 04:00:00	ES	Futures	3060.18	3065.92	3059.91	3065.37	23319.0
2018-01-19 05:00:00	ES	Futures	3065.37	3067.83	3064.83	3066.19	15421.0
2018-01-19 06:00:00	ES	Futures	3066.47	3067.56	3065.65	3066.19	11280.0
2018-01-19 07:00:00	ES	Futures	3066.19	3067.29	3064.83	3065.37	14675.0
2018-01-19 08:00:00	ES	Futures	3065.37	3065.65	3056.9	3060.73	56411.0
2018-01-19 09:00:00	ES	Futures	3060.73	3070.29	3060.73	3067.56	239445.0
2018-01-19 10:00:00	ES	Futures	3067.56	3069.75	3061.82	3064.83	202892.0
2018-01-19 11:00:00	ES	Futures	3064.55	3067.01	3060.73	3063.73	115326.0
2018-01-19 12:00:00	ES	Futures	3063.73	3068.11	3063.46	3066.19	64967.0
2018-01-19 13:00:00	ES	Futures	3066.19	3067.01	3064.01	3065.65	48843.0
2018-01-19 14:00:00	ES	Futures	3065.65	3071.93	3065.37	3070.29	87216.0
2018-01-19 15:00:00	ES	Futures	3070.29	3075.21	3068.93	3074.94	202168.0
2018-01-19 16:00:00	ES	Futures	3074.94	3077.67	3071.39	3075.21	118841.0
2018-01-19 00:00:00	NQ	Futures	8080.41	8084.27	8078.34	8083.97	1242.0
2018-01-19 01:00:00	NQ	Futures	8083.97	8085.75	8079.52	8081.9	1084.0
2018-01-19 02:00:00	NQ	Futures	8082.79	8088.72	8082.19	8086.64	1530.0
2018-01-19 03:00:00	NQ	Futures	8086.05	8099.4	8085.75	8098.8	3083.0
2018-01-19 04:00:00	NQ	Futures	8098.51	8124.01	8098.21	8120.75	7249.0
2018-01-19 05:00:00	NQ	Futures	8120.45	8129.95	8117.49	8121.64	4167.0
2018-01-19 06:00:00	NQ	Futures	8121.94	8126.68	8118.97	8120.75	2467.0
2018-01-19 07:00:00	NQ	Futures	8121.05	8124.9	8117.19	8118.67	5771.0
2018-01-19 08:00:00	NQ	Futures	8118.67	8119.56	8097.32	8106.51	15327.0
2018-01-19 09:00:00	NQ	Futures	8106.51	8134.99	8102.36	8106.51	59757.0
2018-01-19 10:00:00	NQ	Futures	8106.51	8107.7	8083.08	8089.31	63262.0
2018-01-19 11:00:00	NQ	Futures	8089.31	8108.59	8080.12	8095.24	34620.0
2018-01-19 12:00:00	NQ	Futures	8095.24	8112.15	8094.95	8106.22	18572.0
2018-01-19 13:00:00	NQ	Futures	8105.92	8110.67	8100.29	8104.44	13015.0
2018-01-19 14:00:00	NQ	Futures	8104.73	8121.05	8103.55	8114.52	20878.0
2018-01-19 15:00:00	NQ	Futures	8114.52	8124.61	8110.96	8121.05	32218.0
2018-01-19 16:00:00	NQ	Futures	8120.75	8132.02	8117.49	8126.68	12535.0
2018-01-19 00:00:00	YM	Futures	28180.6	28202.4	28176.3	28193.7	958.0
2018-01-19 01:00:00	YM	Futures	28194.8	28203.5	28165.4	28176.3	1252.0
2018-01-19 02:00:00	YM	Futures	28177.4	28199.1	28174.1	28192.6	1387.0
2018-01-19 03:00:00	YM	Futures	28190.4	28239.3	28190.4	28237.1	2941.0
2018-01-19 04:00:00	YM	Futures	28237.1	28289.3	28235.0	28280.6	3979.0
2018-01-19 05:00:00	YM	Futures	28280.6	28307.8	28275.2	28291.5	2341.0
2018-01-19 06:00:00	YM	Futures	28290.4	28310.0	28286.1	28291.5	1894.0
2018-01-19 07:00:00	YM	Futures	28291.5	28302.4	28264.3	28277.4	5540.0
2018-01-19 08:00:00	YM	Futures	28277.4	28282.8	28185.0	28214.3	12875.0
2018-01-19 09:00:00	YM	Futures	28214.3	28306.7	28204.5	28270.8	25029.0
2018-01-19 10:00:00	YM	Futures	28269.8	28285.0	28212.1	28240.4	29826.0
2018-01-19 11:00:00	YM	Futures	28241.5	28252.4	28189.3	28204.5	15240.0
2018-01-19 12:00:00	YM	Futures	28204.5	28246.9	28201.3	28221.9	9371.0
2018-01-19 13:00:00	YM	Futures	28224.1	28232.8	28192.6	28219.8	6187.0
2018-01-19 14:00:00	YM	Futures	28220.8	28290.4	28217.6	28275.2	9978.0
2018-01-19 15:00:00	YM	Futures	28276.3	28330.6	28264.3	28326.3	14825.0

> showing 50 of 1,371 rows — these rows as CSV

> unlock the full archive -- $79 one-time