PREVIEW / futures_1hour / 2021-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-03.parquet
  size:    52 KB
  rows:    1,557

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-09-03 00:00:00	ES	Futures	5117.19	5119.45	5116.63	5118.6	5233.0
2021-09-03 01:00:00	ES	Futures	5118.32	5120.01	5116.63	5118.6	6563.0
2021-09-03 02:00:00	ES	Futures	5118.6	5118.88	5114.38	5116.63	7189.0
2021-09-03 03:00:00	ES	Futures	5116.35	5118.04	5112.13	5117.19	16653.0
2021-09-03 04:00:00	ES	Futures	5117.19	5118.04	5115.79	5116.07	8483.0
2021-09-03 05:00:00	ES	Futures	5115.79	5116.91	5115.22	5115.79	8030.0
2021-09-03 06:00:00	ES	Futures	5115.79	5118.6	5115.5	5117.19	8141.0
2021-09-03 07:00:00	ES	Futures	5116.91	5118.04	5114.1	5114.94	11014.0
2021-09-03 08:00:00	ES	Futures	5114.94	5124.23	5100.58	5111.28	101477.0
2021-09-03 09:00:00	ES	Futures	5111.28	5114.38	5090.16	5099.74	251866.0
2021-09-03 10:00:00	ES	Futures	5100.02	5106.49	5096.64	5101.43	177513.0
2021-09-03 11:00:00	ES	Futures	5101.14	5107.06	5099.45	5101.71	100406.0
2021-09-03 12:00:00	ES	Futures	5101.71	5105.09	5100.58	5103.11	60988.0
2021-09-03 13:00:00	ES	Futures	5102.83	5111.56	5102.83	5111.0	71211.0
2021-09-03 14:00:00	ES	Futures	5111.0	5111.56	5108.46	5110.44	48610.0
2021-09-03 15:00:00	ES	Futures	5110.44	5113.53	5105.09	5107.34	142326.0
2021-09-03 16:00:00	ES	Futures	5107.34	5107.62	5105.37	5106.49	47692.0
2021-09-03 00:00:00	NQ	Futures	18100.15	18107.4	18098.42	18103.63	1571.0
2021-09-03 01:00:00	NQ	Futures	18103.92	18107.11	18096.68	18101.02	2021.0
2021-09-03 02:00:00	NQ	Futures	18101.31	18102.18	18087.7	18097.26	2546.0
2021-09-03 03:00:00	NQ	Futures	18096.39	18106.53	18084.22	18102.76	4236.0
2021-09-03 04:00:00	NQ	Futures	18103.34	18110.87	18088.28	18088.86	3969.0
2021-09-03 05:00:00	NQ	Futures	18089.15	18097.55	18087.12	18094.36	2664.0
2021-09-03 06:00:00	NQ	Futures	18094.65	18102.76	18091.17	18095.81	2765.0
2021-09-03 07:00:00	NQ	Futures	18095.81	18111.16	18094.65	18100.44	3903.0
2021-09-03 08:00:00	NQ	Futures	18100.15	18165.91	18038.74	18084.8	44709.0
2021-09-03 09:00:00	NQ	Futures	18085.09	18126.8	18020.78	18123.04	99087.0
2021-09-03 10:00:00	NQ	Futures	18123.04	18154.9	18080.46	18106.82	83259.0
2021-09-03 11:00:00	NQ	Futures	18106.24	18139.84	18092.04	18113.19	45477.0
2021-09-03 12:00:00	NQ	Futures	18113.48	18139.26	18109.13	18129.7	31374.0
2021-09-03 13:00:00	NQ	Futures	18129.41	18155.48	18128.83	18141.58	32930.0
2021-09-03 14:00:00	NQ	Futures	18141.58	18143.9	18127.38	18138.68	25295.0
2021-09-03 15:00:00	NQ	Futures	18138.97	18156.93	18122.46	18136.94	45188.0
2021-09-03 16:00:00	NQ	Futures	18136.65	18141.0	18128.54	18139.84	8492.0
2021-09-03 00:00:00	YM	Futures	39640.1	39656.9	39635.6	39647.9	952.0
2021-09-03 01:00:00	YM	Futures	39647.9	39666.9	39635.6	39658.0	1137.0
2021-09-03 02:00:00	YM	Futures	39659.1	39661.3	39615.5	39630.0	2006.0
2021-09-03 03:00:00	YM	Futures	39628.9	39641.2	39589.8	39634.5	2920.0
2021-09-03 04:00:00	YM	Futures	39634.5	39649.0	39625.6	39632.3	1340.0
2021-09-03 05:00:00	YM	Futures	39633.4	39637.9	39620.0	39624.5	1362.0
2021-09-03 06:00:00	YM	Futures	39624.5	39652.4	39622.2	39645.7	1605.0
2021-09-03 07:00:00	YM	Futures	39644.6	39645.7	39611.1	39614.4	1821.0
2021-09-03 08:00:00	YM	Futures	39614.4	39649.0	39511.6	39586.5	14638.0
2021-09-03 09:00:00	YM	Futures	39587.6	39624.5	39397.7	39425.6	34854.0
2021-09-03 10:00:00	YM	Futures	39425.6	39536.2	39380.9	39503.8	24887.0
2021-09-03 11:00:00	YM	Futures	39503.8	39557.4	39463.6	39468.0	12797.0
2021-09-03 12:00:00	YM	Futures	39466.9	39491.5	39455.8	39472.5	8631.0
2021-09-03 13:00:00	YM	Futures	39471.4	39549.6	39470.3	39542.9	8778.0
2021-09-03 14:00:00	YM	Futures	39542.9	39555.2	39527.3	39536.2	5429.0
2021-09-03 15:00:00	YM	Futures	39536.2	39554.1	39493.7	39498.2	11137.0

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

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