PREVIEW / futures_1hour / 2019-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-10.parquet
  size:    51 KB
  rows:    1,655

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
2019-12-10 00:00:00	ES	Futures	3407.61	3408.97	3407.34	3408.15	4207.0
2019-12-10 01:00:00	ES	Futures	3408.15	3410.33	3407.88	3408.43	4990.0
2019-12-10 02:00:00	ES	Futures	3408.43	3410.06	3407.61	3408.7	7626.0
2019-12-10 03:00:00	ES	Futures	3408.7	3409.24	3392.4	3395.39	42057.0
2019-12-10 04:00:00	ES	Futures	3395.39	3395.39	3391.58	3393.76	35051.0
2019-12-10 05:00:00	ES	Futures	3393.76	3398.92	3393.21	3395.93	27445.0
2019-12-10 06:00:00	ES	Futures	3395.93	3396.2	3385.88	3395.66	31701.0
2019-12-10 07:00:00	ES	Futures	3395.66	3396.2	3392.67	3393.49	21573.0
2019-12-10 08:00:00	ES	Futures	3393.21	3413.86	3392.67	3409.24	134603.0
2019-12-10 09:00:00	ES	Futures	3409.24	3410.06	3395.93	3403.54	216287.0
2019-12-10 10:00:00	ES	Futures	3403.54	3413.86	3402.72	3412.5	186783.0
2019-12-10 11:00:00	ES	Futures	3412.23	3414.94	3404.35	3408.7	163091.0
2019-12-10 12:00:00	ES	Futures	3408.7	3409.51	3404.08	3408.15	83514.0
2019-12-10 13:00:00	ES	Futures	3408.43	3410.6	3406.52	3407.07	48198.0
2019-12-10 14:00:00	ES	Futures	3407.34	3410.87	3406.52	3407.88	48548.0
2019-12-10 15:00:00	ES	Futures	3408.15	3409.78	3398.38	3403.81	177279.0
2019-12-10 16:00:00	ES	Futures	3403.81	3408.7	3403.81	3408.43	44092.0
2019-12-10 18:00:00	ES	Futures	3406.8	3409.78	3404.62	3405.17	8650.0
2019-12-10 19:00:00	ES	Futures	3405.44	3406.8	3401.09	3403.26	11676.0
2019-12-10 20:00:00	ES	Futures	3402.99	3403.81	3400.28	3402.45	9121.0
2019-12-10 21:00:00	ES	Futures	3402.45	3404.62	3401.91	3404.62	5080.0
2019-12-10 22:00:00	ES	Futures	3404.35	3405.98	3403.81	3405.71	3752.0
2019-12-10 23:00:00	ES	Futures	3405.71	3406.8	3404.62	3404.89	3627.0
2019-12-10 00:00:00	NQ	Futures	9719.58	9724.81	9718.71	9722.49	1648.0
2019-12-10 01:00:00	NQ	Futures	9722.2	9730.62	9721.62	9722.78	2473.0
2019-12-10 02:00:00	NQ	Futures	9722.78	9727.72	9720.74	9723.65	2245.0
2019-12-10 03:00:00	NQ	Futures	9723.65	9724.81	9665.26	9675.72	17032.0
2019-12-10 04:00:00	NQ	Futures	9675.72	9679.78	9667.0	9674.85	12268.0
2019-12-10 05:00:00	NQ	Futures	9675.14	9689.66	9672.52	9676.59	8767.0
2019-12-10 06:00:00	NQ	Futures	9676.59	9677.17	9640.86	9672.52	12584.0
2019-12-10 07:00:00	NQ	Futures	9672.81	9674.85	9660.9	9665.55	8470.0
2019-12-10 08:00:00	NQ	Futures	9665.55	9741.37	9660.61	9728.3	38100.0
2019-12-10 09:00:00	NQ	Futures	9728.01	9732.07	9689.08	9717.26	57772.0
2019-12-10 10:00:00	NQ	Futures	9717.55	9754.15	9712.61	9749.21	52759.0
2019-12-10 11:00:00	NQ	Futures	9749.21	9758.22	9721.33	9735.85	51259.0
2019-12-10 12:00:00	NQ	Futures	9735.85	9736.14	9721.91	9732.94	24641.0
2019-12-10 13:00:00	NQ	Futures	9732.94	9742.53	9725.97	9726.84	13609.0
2019-12-10 14:00:00	NQ	Futures	9727.13	9735.85	9721.33	9727.13	15396.0
2019-12-10 15:00:00	NQ	Futures	9727.13	9733.53	9693.73	9712.32	41164.0
2019-12-10 16:00:00	NQ	Futures	9712.32	9723.94	9710.87	9723.36	6975.0
2019-12-10 18:00:00	NQ	Futures	9721.33	9728.88	9712.03	9715.22	2888.0
2019-12-10 19:00:00	NQ	Futures	9715.22	9719.87	9700.41	9706.8	4692.0
2019-12-10 20:00:00	NQ	Futures	9706.8	9709.41	9696.63	9705.06	4510.0
2019-12-10 21:00:00	NQ	Futures	9704.77	9712.03	9703.31	9711.45	2281.0
2019-12-10 22:00:00	NQ	Futures	9711.74	9717.84	9708.25	9715.81	1865.0
2019-12-10 23:00:00	NQ	Futures	9715.81	9719.87	9712.32	9713.19	1760.0
2019-12-10 00:00:00	YM	Futures	30379.2	30381.4	30374.8	30380.3	15.0
2019-12-10 01:00:00	YM	Futures	30383.5	30392.2	30379.2	30383.5	34.0
2019-12-10 02:00:00	YM	Futures	30381.4	30389.0	30373.7	30382.4	20.0
2019-12-10 03:00:00	YM	Futures	30382.4	30382.4	30247.4	30267.0	95.0

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

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