PREVIEW / futures_1hour / 2019-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-05.parquet
  size:    57 KB
  rows:    1,819

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-05 00:00:00	ES	Futures	3379.9	3380.72	3378.0	3378.82	5563.0
2019-12-05 01:00:00	ES	Futures	3378.82	3382.89	3378.27	3382.62	6140.0
2019-12-05 02:00:00	ES	Futures	3382.62	3389.14	3380.72	3388.05	25753.0
2019-12-05 03:00:00	ES	Futures	3388.05	3388.87	3382.89	3386.7	28523.0
2019-12-05 04:00:00	ES	Futures	3386.42	3389.14	3382.62	3388.87	15062.0
2019-12-05 05:00:00	ES	Futures	3388.6	3394.57	3386.97	3392.13	24258.0
2019-12-05 06:00:00	ES	Futures	3392.13	3395.12	3391.31	3392.67	15001.0
2019-12-05 07:00:00	ES	Futures	3392.4	3393.76	3389.95	3391.04	17932.0
2019-12-05 08:00:00	ES	Futures	3390.77	3392.13	3387.24	3389.68	31166.0
2019-12-05 09:00:00	ES	Futures	3389.95	3390.23	3380.45	3381.26	157326.0
2019-12-05 10:00:00	ES	Futures	3381.26	3381.81	3371.76	3380.18	263835.0
2019-12-05 11:00:00	ES	Futures	3380.18	3383.16	3376.92	3379.36	142895.0
2019-12-05 12:00:00	ES	Futures	3379.36	3381.53	3376.92	3379.36	66574.0
2019-12-05 13:00:00	ES	Futures	3379.09	3384.25	3378.0	3382.62	72171.0
2019-12-05 14:00:00	ES	Futures	3382.62	3387.24	3377.46	3382.89	123831.0
2019-12-05 15:00:00	ES	Futures	3382.89	3389.41	3382.35	3387.78	146515.0
2019-12-05 16:00:00	ES	Futures	3387.78	3388.87	3386.15	3387.78	49444.0
2019-12-05 18:00:00	ES	Futures	3387.51	3389.41	3386.7	3388.32	5197.0
2019-12-05 19:00:00	ES	Futures	3388.6	3393.49	3388.32	3392.4	13454.0
2019-12-05 20:00:00	ES	Futures	3392.4	3393.21	3390.23	3391.86	11550.0
2019-12-05 21:00:00	ES	Futures	3392.13	3392.94	3389.41	3389.95	6128.0
2019-12-05 22:00:00	ES	Futures	3389.68	3392.4	3389.14	3391.86	4296.0
2019-12-05 23:00:00	ES	Futures	3391.86	3392.13	3391.04	3391.31	2372.0
2019-12-05 00:00:00	NQ	Futures	9638.53	9641.15	9630.4	9633.6	3608.0
2019-12-05 01:00:00	NQ	Futures	9633.6	9648.12	9632.72	9647.25	3431.0
2019-12-05 02:00:00	NQ	Futures	9646.96	9670.78	9640.86	9667.58	9465.0
2019-12-05 03:00:00	NQ	Futures	9667.58	9667.87	9649.57	9660.03	9041.0
2019-12-05 04:00:00	NQ	Futures	9660.03	9667.29	9647.25	9665.84	5483.0
2019-12-05 05:00:00	NQ	Futures	9665.84	9689.37	9661.77	9679.49	7672.0
2019-12-05 06:00:00	NQ	Futures	9679.49	9690.82	9676.3	9682.98	5617.0
2019-12-05 07:00:00	NQ	Futures	9682.4	9687.63	9675.14	9679.2	5070.0
2019-12-05 08:00:00	NQ	Futures	9679.2	9684.72	9666.71	9675.43	11064.0
2019-12-05 09:00:00	NQ	Futures	9675.72	9676.01	9647.54	9652.19	50389.0
2019-12-05 10:00:00	NQ	Futures	9651.9	9652.77	9613.26	9635.92	69188.0
2019-12-05 11:00:00	NQ	Futures	9635.63	9644.93	9624.59	9636.5	38485.0
2019-12-05 12:00:00	NQ	Futures	9636.5	9642.02	9626.92	9633.89	20182.0
2019-12-05 13:00:00	NQ	Futures	9633.89	9647.83	9631.85	9645.22	20276.0
2019-12-05 14:00:00	NQ	Futures	9644.93	9659.74	9627.79	9645.22	30779.0
2019-12-05 15:00:00	NQ	Futures	9645.51	9663.52	9642.02	9658.87	32954.0
2019-12-05 16:00:00	NQ	Futures	9658.58	9661.19	9653.06	9656.84	7400.0
2019-12-05 18:00:00	NQ	Futures	9657.13	9663.81	9653.35	9661.48	1706.0
2019-12-05 19:00:00	NQ	Futures	9661.48	9676.59	9661.48	9674.27	5609.0
2019-12-05 20:00:00	NQ	Futures	9673.97	9678.33	9667.0	9673.97	4241.0
2019-12-05 21:00:00	NQ	Futures	9673.97	9677.17	9664.68	9665.55	2451.0
2019-12-05 22:00:00	NQ	Futures	9665.26	9673.97	9664.1	9672.52	2019.0
2019-12-05 23:00:00	NQ	Futures	9672.52	9673.68	9669.91	9670.49	838.0
2019-12-05 00:00:00	YM	Futures	30090.8	30098.4	30075.5	30083.1	1219.0
2019-12-05 01:00:00	YM	Futures	30082.1	30119.1	30081.0	30118.0	1123.0
2019-12-05 02:00:00	YM	Futures	30116.9	30169.1	30099.5	30159.3	4250.0
2019-12-05 03:00:00	YM	Futures	30159.3	30168.0	30107.1	30145.2	8390.0

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

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