PREVIEW / futures_1hour / 2020-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-14.parquet
  size:    50 KB
  rows:    1,484

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-08-14 00:00:00	ES	Futures	3767.27	3769.51	3766.72	3767.55	2567.0
2020-08-14 01:00:00	ES	Futures	3767.55	3772.02	3767.55	3770.35	4172.0
2020-08-14 02:00:00	ES	Futures	3770.35	3775.93	3768.11	3768.11	10371.0
2020-08-14 03:00:00	ES	Futures	3768.11	3769.23	3748.01	3753.59	34785.0
2020-08-14 04:00:00	ES	Futures	3753.59	3753.87	3741.86	3744.66	30862.0
2020-08-14 05:00:00	ES	Futures	3744.93	3750.8	3741.86	3749.96	26193.0
2020-08-14 06:00:00	ES	Futures	3750.24	3753.03	3743.82	3752.75	17241.0
2020-08-14 07:00:00	ES	Futures	3752.47	3761.97	3751.08	3759.73	18441.0
2020-08-14 08:00:00	ES	Futures	3759.73	3764.2	3754.71	3756.66	31225.0
2020-08-14 09:00:00	ES	Futures	3756.66	3760.85	3751.08	3760.01	132342.0
2020-08-14 10:00:00	ES	Futures	3760.01	3763.92	3754.15	3758.34	146286.0
2020-08-14 11:00:00	ES	Futures	3758.06	3767.27	3756.1	3764.48	105380.0
2020-08-14 12:00:00	ES	Futures	3764.48	3766.72	3761.97	3763.36	76600.0
2020-08-14 13:00:00	ES	Futures	3763.36	3768.11	3761.13	3768.11	54603.0
2020-08-14 14:00:00	ES	Futures	3768.11	3768.11	3758.62	3758.9	76805.0
2020-08-14 15:00:00	ES	Futures	3758.62	3762.25	3748.56	3761.69	193218.0
2020-08-14 16:00:00	ES	Futures	3761.97	3762.25	3753.31	3757.22	46434.0
2020-08-14 00:00:00	NQ	Futures	12956.07	12965.32	12953.17	12957.51	946.0
2020-08-14 01:00:00	NQ	Futures	12957.51	12971.1	12957.51	12964.74	1532.0
2020-08-14 02:00:00	NQ	Futures	12965.03	12998.86	12963.87	12968.79	4163.0
2020-08-14 03:00:00	NQ	Futures	12968.79	12972.84	12895.92	12915.29	9948.0
2020-08-14 04:00:00	NQ	Futures	12915.58	12922.23	12893.03	12908.64	8201.0
2020-08-14 05:00:00	NQ	Futures	12908.64	12917.32	12895.05	12915.87	4082.0
2020-08-14 06:00:00	NQ	Futures	12915.58	12947.39	12883.48	12939.58	6241.0
2020-08-14 07:00:00	NQ	Futures	12939.29	12972.55	12928.88	12959.83	6763.0
2020-08-14 08:00:00	NQ	Futures	12959.83	12975.44	12941.32	12951.73	10302.0
2020-08-14 09:00:00	NQ	Futures	12950.86	12963.01	12880.59	12924.26	58328.0
2020-08-14 10:00:00	NQ	Futures	12923.97	12939.29	12834.9	12858.03	74414.0
2020-08-14 11:00:00	NQ	Futures	12857.75	12915.87	12846.18	12884.64	45739.0
2020-08-14 12:00:00	NQ	Futures	12884.64	12930.62	12880.3	12918.18	32811.0
2020-08-14 13:00:00	NQ	Futures	12918.76	12924.55	12893.03	12914.71	25570.0
2020-08-14 14:00:00	NQ	Futures	12914.42	12914.71	12875.39	12892.74	28202.0
2020-08-14 15:00:00	NQ	Futures	12893.03	12915.29	12862.08	12908.64	47487.0
2020-08-14 16:00:00	NQ	Futures	12908.35	12912.11	12874.52	12894.18	11757.0
2020-08-14 00:00:00	YM	Futures	30670.1	30691.0	30664.5	30675.6	579.0
2020-08-14 01:00:00	YM	Futures	30674.5	30706.4	30673.4	30696.5	1032.0
2020-08-14 02:00:00	YM	Futures	30695.4	30733.9	30672.3	30672.3	2602.0
2020-08-14 03:00:00	YM	Futures	30672.3	30682.2	30491.7	30536.8	8128.0
2020-08-14 04:00:00	YM	Futures	30536.8	30536.8	30382.7	30421.2	7819.0
2020-08-14 05:00:00	YM	Futures	30423.4	30496.1	30400.3	30492.8	4304.0
2020-08-14 06:00:00	YM	Futures	30491.7	30502.7	30448.7	30499.4	3272.0
2020-08-14 07:00:00	YM	Futures	30497.2	30578.7	30491.7	30554.4	3613.0
2020-08-14 08:00:00	YM	Futures	30555.5	30595.2	30504.9	30522.5	5629.0
2020-08-14 09:00:00	YM	Futures	30521.4	30555.5	30472.9	30545.6	18106.0
2020-08-14 10:00:00	YM	Futures	30547.8	30631.5	30532.4	30599.6	21339.0
2020-08-14 11:00:00	YM	Futures	30598.5	30681.1	30584.2	30680.0	14453.0
2020-08-14 12:00:00	YM	Futures	30680.0	30710.8	30644.7	30645.8	11276.0
2020-08-14 13:00:00	YM	Futures	30646.9	30724.0	30640.3	30717.4	7974.0
2020-08-14 14:00:00	YM	Futures	30717.4	30720.7	30626.0	30628.2	7908.0
2020-08-14 15:00:00	YM	Futures	30629.3	30678.9	30553.3	30676.7	17585.0

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

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