PREVIEW / futures_1hour / 2020-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-10.parquet
  size:    51 KB
  rows:    1,482

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-07-10 00:00:00	ES	Futures	3501.99	3503.11	3493.62	3494.17	11458.0
2020-07-10 01:00:00	ES	Futures	3494.45	3495.01	3477.7	3481.33	24196.0
2020-07-10 02:00:00	ES	Futures	3481.61	3487.19	3475.46	3479.09	24242.0
2020-07-10 03:00:00	ES	Futures	3478.82	3491.38	3477.98	3491.1	31248.0
2020-07-10 04:00:00	ES	Futures	3490.82	3501.43	3486.91	3490.26	32461.0
2020-07-10 05:00:00	ES	Futures	3490.54	3495.57	3483.28	3493.62	25076.0
2020-07-10 06:00:00	ES	Futures	3493.89	3498.64	3490.26	3497.53	14732.0
2020-07-10 07:00:00	ES	Futures	3497.53	3503.11	3491.66	3492.5	22842.0
2020-07-10 08:00:00	ES	Futures	3492.5	3511.49	3483.0	3502.55	73847.0
2020-07-10 09:00:00	ES	Futures	3502.55	3518.19	3500.04	3505.62	207974.0
2020-07-10 10:00:00	ES	Futures	3505.62	3525.17	3492.22	3518.19	223791.0
2020-07-10 11:00:00	ES	Futures	3517.91	3528.24	3511.49	3526.85	146467.0
2020-07-10 12:00:00	ES	Futures	3526.57	3529.92	3516.23	3526.57	99705.0
2020-07-10 13:00:00	ES	Futures	3526.57	3536.06	3524.33	3534.11	74188.0
2020-07-10 14:00:00	ES	Futures	3534.39	3539.13	3530.48	3538.85	69403.0
2020-07-10 15:00:00	ES	Futures	3538.57	3549.46	3534.39	3546.67	178696.0
2020-07-10 16:00:00	ES	Futures	3546.39	3553.37	3546.39	3551.42	54705.0
2020-07-10 00:00:00	NQ	Futures	12370.19	12374.53	12351.68	12356.02	3352.0
2020-07-10 01:00:00	NQ	Futures	12355.44	12357.76	12319.29	12329.99	8287.0
2020-07-10 02:00:00	NQ	Futures	12331.73	12354.0	12324.21	12334.33	9142.0
2020-07-10 03:00:00	NQ	Futures	12333.75	12362.67	12327.1	12361.23	11883.0
2020-07-10 04:00:00	NQ	Futures	12361.8	12388.41	12352.84	12364.12	13854.0
2020-07-10 05:00:00	NQ	Futures	12364.7	12390.14	12351.1	12384.07	8927.0
2020-07-10 06:00:00	NQ	Futures	12384.65	12393.32	12367.59	12384.65	5660.0
2020-07-10 07:00:00	NQ	Futures	12385.23	12405.47	12361.8	12367.88	9851.0
2020-07-10 08:00:00	NQ	Futures	12368.46	12424.27	12343.3	12403.45	22093.0
2020-07-10 09:00:00	NQ	Futures	12402.87	12435.26	12327.1	12347.06	89499.0
2020-07-10 10:00:00	NQ	Futures	12347.06	12415.3	12290.67	12393.61	92769.0
2020-07-10 11:00:00	NQ	Futures	12393.32	12432.65	12368.46	12424.56	54906.0
2020-07-10 12:00:00	NQ	Futures	12424.56	12429.18	12392.17	12424.27	42992.0
2020-07-10 13:00:00	NQ	Futures	12423.98	12465.62	12415.88	12456.37	34136.0
2020-07-10 14:00:00	NQ	Futures	12456.65	12485.57	12436.99	12483.26	28471.0
2020-07-10 15:00:00	NQ	Futures	12482.97	12526.93	12467.07	12516.51	46599.0
2020-07-10 16:00:00	NQ	Futures	12517.09	12547.46	12512.76	12543.12	11092.0
2020-07-10 00:00:00	YM	Futures	28107.7	28119.8	28015.2	28022.9	3487.0
2020-07-10 01:00:00	YM	Futures	28021.8	28027.3	27877.6	27908.4	6933.0
2020-07-10 02:00:00	YM	Futures	27910.6	27957.9	27851.1	27877.6	6266.0
2020-07-10 03:00:00	YM	Futures	27877.6	28007.5	27873.2	27999.8	7505.0
2020-07-10 04:00:00	YM	Futures	27999.8	28100.0	27961.2	27993.2	8381.0
2020-07-10 05:00:00	YM	Futures	27994.3	28030.6	27928.2	28010.8	5971.0
2020-07-10 06:00:00	YM	Futures	28013.0	28058.1	27983.3	28050.4	3643.0
2020-07-10 07:00:00	YM	Futures	28050.4	28102.2	27999.8	28006.4	5353.0
2020-07-10 08:00:00	YM	Futures	28008.6	28168.3	27927.1	28097.8	13332.0
2020-07-10 09:00:00	YM	Futures	28096.7	28321.3	28090.1	28204.6	35106.0
2020-07-10 10:00:00	YM	Futures	28204.6	28394.0	28100.0	28338.9	31343.0
2020-07-10 11:00:00	YM	Futures	28338.9	28427.0	28289.4	28416.0	18108.0
2020-07-10 12:00:00	YM	Futures	28416.0	28453.5	28311.4	28413.8	20111.0
2020-07-10 13:00:00	YM	Futures	28413.8	28492.0	28361.0	28482.1	11299.0
2020-07-10 14:00:00	YM	Futures	28483.2	28530.5	28453.5	28507.4	10432.0
2020-07-10 15:00:00	YM	Futures	28507.4	28614.2	28468.9	28577.9	19920.0

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

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