PREVIEW / futures_1hour / 2020-01-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	3575.2	3577.1	3574.9	3576.8	6211.0
2020-01-16 01:00:00	ES	Futures	3576.8	3577.1	3575.4	3576.5	6486.0
2020-01-16 02:00:00	ES	Futures	3576.5	3577.1	3574.6	3576.3	7872.0
2020-01-16 03:00:00	ES	Futures	3576.3	3585.7	3576.3	3582.2	45496.0
2020-01-16 04:00:00	ES	Futures	3582.2	3583.0	3578.4	3580.1	21436.0
2020-01-16 05:00:00	ES	Futures	3580.1	3582.2	3578.2	3582.2	19213.0
2020-01-16 06:00:00	ES	Futures	3582.2	3583.0	3579.2	3583.0	14684.0
2020-01-16 07:00:00	ES	Futures	3582.8	3583.3	3579.8	3580.3	14392.0
2020-01-16 08:00:00	ES	Futures	3580.3	3583.0	3580.1	3581.4	28636.0
2020-01-16 09:00:00	ES	Futures	3581.7	3586.3	3580.1	3582.5	223091.0
2020-01-16 10:00:00	ES	Futures	3582.5	3586.6	3580.6	3582.8	207093.0
2020-01-16 11:00:00	ES	Futures	3583.0	3585.5	3580.3	3584.4	130548.0
2020-01-16 12:00:00	ES	Futures	3584.7	3586.3	3583.6	3585.2	73174.0
2020-01-16 13:00:00	ES	Futures	3584.9	3587.6	3584.1	3586.8	70204.0
2020-01-16 14:00:00	ES	Futures	3586.8	3587.6	3584.9	3586.0	60019.0
2020-01-16 15:00:00	ES	Futures	3585.7	3596.3	3585.2	3596.0	240682.0
2020-01-16 16:00:00	ES	Futures	3596.0	3596.6	3593.9	3595.8	76656.0
2020-01-16 18:00:00	ES	Futures	3595.2	3602.3	3594.4	3598.5	17999.0
2020-01-16 19:00:00	ES	Futures	3598.5	3598.8	3596.9	3598.2	8189.0
2020-01-16 20:00:00	ES	Futures	3598.2	3598.5	3595.2	3596.9	9304.0
2020-01-16 21:00:00	ES	Futures	3597.1	3599.3	3596.6	3597.4	9330.0
2020-01-16 22:00:00	ES	Futures	3597.7	3597.9	3596.0	3596.9	4262.0
2020-01-16 23:00:00	ES	Futures	3596.9	3597.4	3596.0	3596.0	2788.0
2020-01-16 00:00:00	NQ	Futures	10496.7	10505.95	10495.54	10504.8	2554.0
2020-01-16 01:00:00	NQ	Futures	10505.09	10506.82	10499.59	10506.82	3889.0
2020-01-16 02:00:00	NQ	Futures	10506.53	10507.98	10500.46	10504.51	2814.0
2020-01-16 03:00:00	NQ	Futures	10504.51	10537.18	10504.22	10527.64	14197.0
2020-01-16 04:00:00	NQ	Futures	10527.64	10530.82	10511.74	10515.21	8757.0
2020-01-16 05:00:00	NQ	Futures	10515.79	10525.62	10510.87	10524.75	5972.0
2020-01-16 06:00:00	NQ	Futures	10525.04	10525.91	10512.89	10524.75	5710.0
2020-01-16 07:00:00	NQ	Futures	10524.75	10527.93	10514.63	10516.36	5854.0
2020-01-16 08:00:00	NQ	Futures	10516.08	10525.62	10514.92	10518.39	10238.0
2020-01-16 09:00:00	NQ	Futures	10518.39	10546.73	10512.03	10536.9	68483.0
2020-01-16 10:00:00	NQ	Futures	10536.9	10548.46	10514.05	10517.52	68391.0
2020-01-16 11:00:00	NQ	Futures	10517.81	10529.38	10498.72	10518.97	49890.0
2020-01-16 12:00:00	NQ	Futures	10518.97	10524.46	10514.63	10517.52	21635.0
2020-01-16 13:00:00	NQ	Futures	10517.52	10533.43	10512.61	10532.27	21588.0
2020-01-16 14:00:00	NQ	Futures	10532.27	10539.79	10529.09	10531.98	20096.0
2020-01-16 15:00:00	NQ	Futures	10531.98	10570.73	10528.8	10569.86	52800.0
2020-01-16 16:00:00	NQ	Futures	10569.86	10572.46	10563.5	10570.44	11123.0
2020-01-16 18:00:00	NQ	Futures	10568.7	10593.0	10564.66	10578.83	6894.0
2020-01-16 19:00:00	NQ	Futures	10578.54	10582.01	10574.78	10578.25	3087.0
2020-01-16 20:00:00	NQ	Futures	10578.25	10579.4	10567.84	10571.31	5623.0
2020-01-16 21:00:00	NQ	Futures	10571.31	10582.3	10569.57	10573.62	5555.0
2020-01-16 22:00:00	NQ	Futures	10573.91	10576.51	10568.42	10571.6	3209.0
2020-01-16 23:00:00	NQ	Futures	10571.6	10573.33	10566.39	10566.68	2320.0
2020-01-16 00:00:00	YM	Futures	31644.3	31663.9	31641.0	31657.4	944.0
2020-01-16 01:00:00	YM	Futures	31657.4	31660.6	31644.3	31651.9	1262.0
2020-01-16 02:00:00	YM	Futures	31651.9	31659.5	31636.7	31656.3	1790.0
2020-01-16 03:00:00	YM	Futures	31656.3	31731.4	31656.3	31700.9	8639.0

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

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