PREVIEW / futures_1hour / 2020-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-09.parquet
  size:    59 KB
  rows:    1,873

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
2020-01-09 00:00:00	ES	Futures	3537.2	3541.3	3536.4	3539.7	8937.0
2020-01-09 01:00:00	ES	Futures	3539.7	3541.0	3538.9	3539.7	6295.0
2020-01-09 02:00:00	ES	Futures	3539.7	3547.5	3538.0	3546.4	20989.0
2020-01-09 03:00:00	ES	Futures	3546.2	3548.9	3543.2	3545.6	24788.0
2020-01-09 04:00:00	ES	Futures	3545.6	3546.4	3543.7	3545.1	16613.0
2020-01-09 05:00:00	ES	Futures	3545.4	3547.0	3543.2	3544.0	11972.0
2020-01-09 06:00:00	ES	Futures	3544.3	3546.2	3543.5	3545.9	9635.0
2020-01-09 07:00:00	ES	Futures	3545.9	3547.8	3541.6	3542.9	29519.0
2020-01-09 08:00:00	ES	Futures	3542.9	3546.4	3541.6	3545.4	23351.0
2020-01-09 09:00:00	ES	Futures	3545.4	3548.9	3539.7	3543.7	210899.0
2020-01-09 10:00:00	ES	Futures	3543.5	3549.7	3540.2	3548.9	144872.0
2020-01-09 11:00:00	ES	Futures	3548.9	3550.2	3544.6	3549.2	119570.0
2020-01-09 12:00:00	ES	Futures	3549.4	3550.2	3538.3	3544.0	129074.0
2020-01-09 13:00:00	ES	Futures	3544.3	3548.6	3540.8	3545.6	106923.0
2020-01-09 14:00:00	ES	Futures	3545.9	3551.9	3545.4	3548.9	85904.0
2020-01-09 15:00:00	ES	Futures	3548.9	3551.1	3544.8	3550.5	172116.0
2020-01-09 16:00:00	ES	Futures	3550.5	3551.9	3549.2	3550.2	54005.0
2020-01-09 18:00:00	ES	Futures	3550.5	3554.6	3550.2	3553.2	8488.0
2020-01-09 19:00:00	ES	Futures	3553.5	3558.9	3552.7	3557.0	20419.0
2020-01-09 20:00:00	ES	Futures	3557.3	3558.4	3555.7	3557.3	10184.0
2020-01-09 21:00:00	ES	Futures	3557.0	3558.1	3555.9	3557.8	4841.0
2020-01-09 22:00:00	ES	Futures	3557.6	3559.2	3557.0	3558.6	4411.0
2020-01-09 23:00:00	ES	Futures	3558.9	3560.3	3558.1	3558.9	5275.0
2020-01-09 00:00:00	NQ	Futures	10357.03	10371.49	10353.56	10365.99	4021.0
2020-01-09 01:00:00	NQ	Futures	10366.28	10369.75	10359.63	10365.99	6578.0
2020-01-09 02:00:00	NQ	Futures	10365.71	10397.8	10360.21	10394.33	10253.0
2020-01-09 03:00:00	NQ	Futures	10394.33	10403.01	10383.92	10391.73	10320.0
2020-01-09 04:00:00	NQ	Futures	10392.02	10397.8	10388.55	10394.04	6588.0
2020-01-09 05:00:00	NQ	Futures	10394.04	10399.25	10385.66	10387.68	4740.0
2020-01-09 06:00:00	NQ	Futures	10387.68	10395.78	10385.08	10393.47	3370.0
2020-01-09 07:00:00	NQ	Futures	10393.47	10405.03	10380.45	10389.42	12869.0
2020-01-09 08:00:00	NQ	Futures	10389.13	10409.95	10384.79	10405.03	12191.0
2020-01-09 09:00:00	NQ	Futures	10405.03	10435.97	10400.41	10415.15	79238.0
2020-01-09 10:00:00	NQ	Futures	10414.86	10430.77	10401.27	10423.83	53534.0
2020-01-09 11:00:00	NQ	Futures	10424.12	10426.14	10403.3	10418.33	41942.0
2020-01-09 12:00:00	NQ	Futures	10418.05	10421.23	10355.29	10387.39	57766.0
2020-01-09 13:00:00	NQ	Futures	10387.68	10407.64	10378.43	10399.25	39630.0
2020-01-09 14:00:00	NQ	Futures	10399.25	10416.6	10395.49	10408.21	29127.0
2020-01-09 15:00:00	NQ	Futures	10407.92	10418.91	10391.73	10417.47	45077.0
2020-01-09 16:00:00	NQ	Futures	10417.47	10421.8	10411.11	10420.07	8726.0
2020-01-09 18:00:00	NQ	Futures	10421.8	10431.35	10419.49	10428.17	4133.0
2020-01-09 19:00:00	NQ	Futures	10428.46	10449.28	10428.46	10444.36	9597.0
2020-01-09 20:00:00	NQ	Futures	10444.65	10448.12	10437.71	10442.63	5788.0
2020-01-09 21:00:00	NQ	Futures	10442.63	10446.96	10439.44	10446.1	3212.0
2020-01-09 22:00:00	NQ	Futures	10445.81	10455.06	10444.36	10454.19	3033.0
2020-01-09 23:00:00	NQ	Futures	10454.19	10457.95	10451.59	10452.75	2190.0
2020-01-09 00:00:00	YM	Futures	31353.6	31389.5	31348.2	31374.3	2125.0
2020-01-09 01:00:00	YM	Futures	31374.3	31386.3	31369.9	31376.5	1444.0
2020-01-09 02:00:00	YM	Futures	31377.6	31446.1	31364.5	31436.3	5767.0
2020-01-09 03:00:00	YM	Futures	31436.3	31449.4	31403.7	31423.3	6143.0

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

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