PREVIEW / futures_1hour / 2021-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-13.parquet
  size:    53 KB
  rows:    1,575

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-08-13 00:00:00	ES	Futures	5016.67	5017.8	5016.39	5016.67	1728.0
2021-08-13 01:00:00	ES	Futures	5016.95	5017.51	5015.26	5016.67	3518.0
2021-08-13 02:00:00	ES	Futures	5016.67	5018.36	5015.54	5017.51	4262.0
2021-08-13 03:00:00	ES	Futures	5017.8	5021.74	5017.23	5020.33	10612.0
2021-08-13 04:00:00	ES	Futures	5020.33	5022.02	5018.36	5021.74	9218.0
2021-08-13 05:00:00	ES	Futures	5022.02	5023.15	5020.33	5022.3	9567.0
2021-08-13 06:00:00	ES	Futures	5022.58	5022.58	5019.48	5019.77	6392.0
2021-08-13 07:00:00	ES	Futures	5019.48	5020.05	5018.36	5018.36	9674.0
2021-08-13 08:00:00	ES	Futures	5018.36	5022.3	5018.36	5022.02	12451.0
2021-08-13 09:00:00	ES	Futures	5022.3	5025.68	5017.51	5021.46	110580.0
2021-08-13 10:00:00	ES	Futures	5022.02	5025.4	5016.95	5021.46	138028.0
2021-08-13 11:00:00	ES	Futures	5021.46	5023.99	5020.33	5022.02	67387.0
2021-08-13 12:00:00	ES	Futures	5022.02	5023.15	5020.05	5022.58	45672.0
2021-08-13 13:00:00	ES	Futures	5022.58	5025.4	5020.61	5024.55	42477.0
2021-08-13 14:00:00	ES	Futures	5024.55	5024.83	5018.64	5020.89	63691.0
2021-08-13 15:00:00	ES	Futures	5020.89	5027.09	5020.05	5026.52	147751.0
2021-08-13 16:00:00	ES	Futures	5026.52	5027.09	5022.86	5023.15	46647.0
2021-08-13 00:00:00	NQ	Futures	17464.01	17468.36	17462.86	17463.72	731.0
2021-08-13 01:00:00	NQ	Futures	17463.43	17465.46	17455.61	17459.09	1607.0
2021-08-13 02:00:00	NQ	Futures	17459.38	17472.99	17456.77	17470.68	2062.0
2021-08-13 03:00:00	NQ	Futures	17470.68	17492.69	17470.68	17486.9	4198.0
2021-08-13 04:00:00	NQ	Futures	17487.19	17489.8	17477.63	17487.77	3127.0
2021-08-13 05:00:00	NQ	Futures	17487.77	17490.95	17471.26	17481.11	3181.0
2021-08-13 06:00:00	NQ	Futures	17481.11	17482.26	17471.84	17473.86	2652.0
2021-08-13 07:00:00	NQ	Futures	17474.44	17477.05	17447.79	17451.27	6609.0
2021-08-13 08:00:00	NQ	Futures	17451.56	17472.41	17444.9	17470.97	7314.0
2021-08-13 09:00:00	NQ	Futures	17470.97	17506.6	17459.96	17495.88	65861.0
2021-08-13 10:00:00	NQ	Futures	17496.17	17545.12	17476.47	17513.84	82610.0
2021-08-13 11:00:00	NQ	Futures	17513.84	17528.03	17489.8	17497.33	39359.0
2021-08-13 12:00:00	NQ	Futures	17497.33	17519.63	17487.77	17516.45	29960.0
2021-08-13 13:00:00	NQ	Futures	17516.45	17518.76	17503.41	17514.71	22235.0
2021-08-13 14:00:00	NQ	Futures	17515.0	17516.45	17490.66	17505.73	24150.0
2021-08-13 15:00:00	NQ	Futures	17505.73	17529.48	17500.22	17527.16	44640.0
2021-08-13 16:00:00	NQ	Futures	17526.87	17531.51	17520.5	17522.24	9784.0
2021-08-13 00:00:00	YM	Futures	39556.3	39566.4	39554.1	39559.7	453.0
2021-08-13 01:00:00	YM	Futures	39558.5	39566.4	39550.7	39565.2	819.0
2021-08-13 02:00:00	YM	Futures	39564.1	39576.4	39553.0	39567.5	1131.0
2021-08-13 03:00:00	YM	Futures	39570.8	39596.5	39561.9	39586.5	1857.0
2021-08-13 04:00:00	YM	Futures	39586.5	39608.8	39575.3	39608.8	1995.0
2021-08-13 05:00:00	YM	Futures	39607.7	39624.5	39603.2	39622.2	1973.0
2021-08-13 06:00:00	YM	Futures	39623.3	39627.8	39597.6	39598.8	1330.0
2021-08-13 07:00:00	YM	Futures	39599.9	39620.0	39592.1	39609.9	1658.0
2021-08-13 08:00:00	YM	Futures	39611.1	39636.7	39603.2	39633.4	2555.0
2021-08-13 09:00:00	YM	Futures	39632.3	39683.7	39589.8	39605.5	17428.0
2021-08-13 10:00:00	YM	Futures	39604.3	39607.7	39542.9	39583.1	18133.0
2021-08-13 11:00:00	YM	Futures	39580.9	39613.3	39577.5	39604.3	7397.0
2021-08-13 12:00:00	YM	Futures	39604.3	39611.1	39584.2	39590.9	3923.0
2021-08-13 13:00:00	YM	Futures	39589.8	39605.5	39567.5	39598.8	5132.0
2021-08-13 14:00:00	YM	Futures	39597.6	39599.9	39529.5	39544.0	6182.0
2021-08-13 15:00:00	YM	Futures	39545.1	39578.7	39531.7	39575.3	9850.0

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

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