PREVIEW / futures_1hour / 2019-12-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	3516.1	3516.4	3514.2	3514.7	3498.0
2019-12-30 01:00:00	ES	Futures	3514.7	3515.0	3513.7	3514.2	3194.0
2019-12-30 02:00:00	ES	Futures	3514.2	3515.6	3513.1	3513.4	4945.0
2019-12-30 03:00:00	ES	Futures	3513.7	3516.6	3512.8	3515.8	15786.0
2019-12-30 04:00:00	ES	Futures	3515.8	3516.1	3513.1	3513.4	9292.0
2019-12-30 05:00:00	ES	Futures	3513.7	3513.9	3510.1	3511.2	8432.0
2019-12-30 06:00:00	ES	Futures	3511.2	3511.2	3508.2	3511.2	10718.0
2019-12-30 07:00:00	ES	Futures	3510.9	3513.1	3510.9	3511.2	7639.0
2019-12-30 08:00:00	ES	Futures	3511.5	3514.7	3510.7	3514.2	15837.0
2019-12-30 09:00:00	ES	Futures	3514.5	3515.8	3495.5	3497.4	194522.0
2019-12-30 10:00:00	ES	Futures	3497.7	3499.3	3487.4	3494.7	225745.0
2019-12-30 11:00:00	ES	Futures	3494.7	3498.5	3490.4	3496.9	115575.0
2019-12-30 12:00:00	ES	Futures	3496.9	3503.4	3496.6	3501.2	79540.0
2019-12-30 13:00:00	ES	Futures	3500.9	3502.0	3497.4	3499.8	64972.0
2019-12-30 14:00:00	ES	Futures	3499.8	3500.1	3493.1	3493.3	62280.0
2019-12-30 15:00:00	ES	Futures	3493.3	3496.6	3488.7	3493.1	185253.0
2019-12-30 16:00:00	ES	Futures	3493.3	3496.0	3493.1	3493.9	48290.0
2019-12-30 18:00:00	ES	Futures	3493.9	3495.8	3492.3	3495.5	3976.0
2019-12-30 19:00:00	ES	Futures	3495.5	3496.6	3494.7	3496.0	2731.0
2019-12-30 20:00:00	ES	Futures	3495.8	3499.3	3495.5	3497.7	6236.0
2019-12-30 21:00:00	ES	Futures	3497.7	3499.3	3497.7	3498.8	2050.0
2019-12-30 22:00:00	ES	Futures	3498.8	3499.0	3497.4	3498.5	3400.0
2019-12-30 23:00:00	ES	Futures	3498.2	3499.0	3497.9	3497.9	2175.0
2019-12-30 00:00:00	NQ	Futures	10189.31	10190.18	10182.66	10184.39	1987.0
2019-12-30 01:00:00	NQ	Futures	10184.68	10184.97	10179.19	10180.92	1731.0
2019-12-30 02:00:00	NQ	Futures	10180.92	10184.68	10171.96	10173.69	3139.0
2019-12-30 03:00:00	NQ	Futures	10173.69	10186.13	10172.54	10182.66	7094.0
2019-12-30 04:00:00	NQ	Futures	10182.37	10182.66	10168.78	10170.22	4987.0
2019-12-30 05:00:00	NQ	Futures	10170.51	10171.67	10157.79	10161.55	4824.0
2019-12-30 06:00:00	NQ	Futures	10161.55	10163.28	10150.85	10161.84	5993.0
2019-12-30 07:00:00	NQ	Futures	10161.84	10170.22	10161.84	10162.99	3970.0
2019-12-30 08:00:00	NQ	Futures	10163.28	10173.12	10157.79	10168.78	9174.0
2019-12-30 09:00:00	NQ	Futures	10168.78	10172.25	10067.57	10080.0	82966.0
2019-12-30 10:00:00	NQ	Futures	10080.0	10093.59	10053.11	10089.54	79220.0
2019-12-30 11:00:00	NQ	Futures	10089.54	10109.5	10073.64	10105.74	44889.0
2019-12-30 12:00:00	NQ	Futures	10106.03	10128.0	10104.0	10121.64	32382.0
2019-12-30 13:00:00	NQ	Futures	10121.64	10125.11	10112.1	10120.78	24078.0
2019-12-30 14:00:00	NQ	Futures	10121.06	10121.64	10098.51	10101.11	24445.0
2019-12-30 15:00:00	NQ	Futures	10100.82	10112.68	10086.65	10099.67	38666.0
2019-12-30 16:00:00	NQ	Futures	10099.67	10107.18	10095.91	10100.82	9428.0
2019-12-30 18:00:00	NQ	Futures	10099.95	10105.16	10094.75	10103.71	1618.0
2019-12-30 19:00:00	NQ	Futures	10104.0	10108.63	10100.82	10107.18	1853.0
2019-12-30 20:00:00	NQ	Futures	10107.18	10118.75	10106.32	10116.15	2806.0
2019-12-30 21:00:00	NQ	Futures	10115.86	10121.35	10115.28	10119.62	1373.0
2019-12-30 22:00:00	NQ	Futures	10119.33	10119.33	10115.28	10117.88	1181.0
2019-12-30 23:00:00	NQ	Futures	10118.17	10119.62	10117.31	10117.31	767.0
2019-12-30 00:00:00	YM	Futures	31192.5	31194.6	31175.1	31181.6	935.0
2019-12-30 01:00:00	YM	Futures	31182.7	31183.8	31171.8	31177.2	652.0
2019-12-30 02:00:00	YM	Futures	31177.2	31188.1	31167.4	31170.7	1655.0
2019-12-30 03:00:00	YM	Futures	31170.7	31203.4	31168.5	31191.4	4374.0

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

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