PREVIEW / futures_1hour / 2021-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-30.parquet
  size:    53 KB
  rows:    1,572

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
2021-04-30 00:00:00	ES	Futures	4711.57	4713.26	4709.33	4709.89	4498.0
2021-04-30 01:00:00	ES	Futures	4710.17	4711.29	4704.55	4706.24	7918.0
2021-04-30 02:00:00	ES	Futures	4706.24	4713.26	4705.96	4712.98	9389.0
2021-04-30 03:00:00	ES	Futures	4712.7	4716.07	4711.29	4713.26	13901.0
2021-04-30 04:00:00	ES	Futures	4713.26	4713.82	4707.64	4710.45	10008.0
2021-04-30 05:00:00	ES	Futures	4710.73	4713.26	4705.67	4706.52	10785.0
2021-04-30 06:00:00	ES	Futures	4706.52	4707.08	4692.19	4695.84	25159.0
2021-04-30 07:00:00	ES	Futures	4696.12	4701.46	4693.87	4701.46	19816.0
2021-04-30 08:00:00	ES	Futures	4701.18	4703.99	4691.34	4700.62	44225.0
2021-04-30 09:00:00	ES	Futures	4700.9	4707.64	4694.15	4707.36	197854.0
2021-04-30 10:00:00	ES	Futures	4707.08	4708.2	4694.15	4695.84	279028.0
2021-04-30 11:00:00	ES	Futures	4695.84	4699.21	4687.41	4698.09	249078.0
2021-04-30 12:00:00	ES	Futures	4697.81	4700.9	4691.91	4696.12	103157.0
2021-04-30 13:00:00	ES	Futures	4696.12	4700.9	4683.76	4686.85	125350.0
2021-04-30 14:00:00	ES	Futures	4686.85	4696.12	4684.88	4691.34	145295.0
2021-04-30 15:00:00	ES	Futures	4691.63	4697.53	4683.48	4694.72	468003.0
2021-04-30 16:00:00	ES	Futures	4694.44	4700.34	4693.03	4698.37	91805.0
2021-04-30 00:00:00	NQ	Futures	16092.46	16103.18	16085.52	16092.75	2542.0
2021-04-30 01:00:00	NQ	Futures	16092.75	16099.12	16056.28	16071.91	5499.0
2021-04-30 02:00:00	NQ	Futures	16071.33	16115.62	16069.01	16112.15	5355.0
2021-04-30 03:00:00	NQ	Futures	16113.02	16123.15	16094.2	16102.31	5991.0
2021-04-30 04:00:00	NQ	Futures	16101.73	16110.41	16085.23	16099.12	4205.0
2021-04-30 05:00:00	NQ	Futures	16100.28	16113.6	16073.07	16077.99	5560.0
2021-04-30 06:00:00	NQ	Futures	16078.86	16086.96	16018.64	16040.35	11351.0
2021-04-30 07:00:00	NQ	Futures	16041.22	16061.49	16028.49	16060.33	8052.0
2021-04-30 08:00:00	NQ	Futures	16060.04	16062.65	16003.01	16043.83	15193.0
2021-04-30 09:00:00	NQ	Futures	16044.12	16105.78	16021.54	16103.75	71170.0
2021-04-30 10:00:00	NQ	Futures	16104.33	16161.65	16066.7	16094.49	94171.0
2021-04-30 11:00:00	NQ	Futures	16094.78	16115.91	16049.91	16102.89	70664.0
2021-04-30 12:00:00	NQ	Futures	16102.31	16118.52	16062.65	16084.36	43333.0
2021-04-30 13:00:00	NQ	Futures	16084.36	16097.39	16009.09	16024.43	46323.0
2021-04-30 14:00:00	NQ	Futures	16024.72	16066.12	16017.77	16045.57	46614.0
2021-04-30 15:00:00	NQ	Futures	16045.57	16069.3	16011.41	16050.78	78762.0
2021-04-30 16:00:00	NQ	Futures	16051.07	16075.09	16050.49	16055.7	13548.0
2021-04-30 00:00:00	YM	Futures	37754.0	37766.2	37737.3	37744.0	805.0
2021-04-30 01:00:00	YM	Futures	37744.0	37754.0	37699.4	37718.3	1620.0
2021-04-30 02:00:00	YM	Futures	37719.5	37761.8	37716.1	37751.8	1963.0
2021-04-30 03:00:00	YM	Futures	37751.8	37785.2	37745.1	37766.2	2591.0
2021-04-30 04:00:00	YM	Futures	37765.1	37766.2	37721.7	37744.0	2280.0
2021-04-30 05:00:00	YM	Futures	37742.8	37767.4	37708.3	37716.1	2079.0
2021-04-30 06:00:00	YM	Futures	37716.1	37716.1	37603.6	37631.5	5623.0
2021-04-30 07:00:00	YM	Futures	37632.6	37661.5	37609.2	37654.9	3608.0
2021-04-30 08:00:00	YM	Futures	37653.7	37684.9	37598.1	37657.1	5658.0
2021-04-30 09:00:00	YM	Futures	37659.3	37710.5	37607.0	37699.4	17923.0
2021-04-30 10:00:00	YM	Futures	37699.4	37712.8	37554.6	37582.5	22087.0
2021-04-30 11:00:00	YM	Futures	37583.6	37588.0	37511.2	37582.5	20374.0
2021-04-30 12:00:00	YM	Futures	37581.3	37599.2	37552.4	37584.7	7954.0
2021-04-30 13:00:00	YM	Futures	37581.3	37653.7	37542.4	37558.0	9642.0
2021-04-30 14:00:00	YM	Futures	37559.1	37627.0	37540.1	37589.1	10686.0
2021-04-30 15:00:00	YM	Futures	37589.1	37645.9	37535.7	37631.5	22292.0

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

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