PREVIEW / futures_1hour / 2021-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-16.parquet
  size:    62 KB
  rows:    1,946

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-16 00:00:00	ES	Futures	5013.57	5015.54	5012.73	5014.98	3757.0
2021-08-16 01:00:00	ES	Futures	5014.98	5017.51	5013.85	5014.42	5628.0
2021-08-16 02:00:00	ES	Futures	5014.42	5014.7	5009.07	5010.76	10521.0
2021-08-16 03:00:00	ES	Futures	5010.76	5019.48	5007.1	5017.8	24867.0
2021-08-16 04:00:00	ES	Futures	5017.51	5019.48	5014.98	5015.26	12195.0
2021-08-16 05:00:00	ES	Futures	5015.54	5016.95	5013.01	5014.42	8023.0
2021-08-16 06:00:00	ES	Futures	5014.42	5015.26	5002.03	5014.13	25942.0
2021-08-16 07:00:00	ES	Futures	5014.13	5016.11	5008.5	5011.32	14153.0
2021-08-16 08:00:00	ES	Futures	5011.04	5011.32	5005.97	5008.22	24041.0
2021-08-16 09:00:00	ES	Futures	5007.94	5013.57	4994.99	4998.37	166495.0
2021-08-16 10:00:00	ES	Futures	4998.37	5006.53	4992.45	4995.27	229235.0
2021-08-16 11:00:00	ES	Futures	4995.55	5009.63	4994.71	5007.38	125123.0
2021-08-16 12:00:00	ES	Futures	5007.38	5015.54	5006.53	5015.26	85953.0
2021-08-16 13:00:00	ES	Futures	5015.26	5023.99	5014.13	5023.71	84263.0
2021-08-16 14:00:00	ES	Futures	5023.99	5032.44	5022.3	5028.78	84479.0
2021-08-16 15:00:00	ES	Futures	5029.06	5040.04	5027.93	5038.91	168859.0
2021-08-16 16:00:00	ES	Futures	5039.2	5042.01	5034.41	5036.94	58609.0
2021-08-16 18:00:00	ES	Futures	5036.94	5037.22	5033.85	5034.69	4826.0
2021-08-16 19:00:00	ES	Futures	5034.97	5037.22	5034.41	5035.82	3235.0
2021-08-16 20:00:00	ES	Futures	5035.82	5036.1	5029.34	5030.75	10036.0
2021-08-16 21:00:00	ES	Futures	5031.03	5031.31	5027.65	5029.9	8503.0
2021-08-16 22:00:00	ES	Futures	5029.9	5030.47	5027.93	5029.62	5110.0
2021-08-16 23:00:00	ES	Futures	5029.34	5029.9	5026.81	5027.65	4291.0
2021-08-16 00:00:00	NQ	Futures	17505.44	17509.78	17503.99	17504.86	1285.0
2021-08-16 01:00:00	NQ	Futures	17504.86	17516.45	17501.38	17504.28	2290.0
2021-08-16 02:00:00	NQ	Futures	17503.7	17504.28	17482.84	17490.09	4042.0
2021-08-16 03:00:00	NQ	Futures	17490.38	17519.34	17484.29	17507.18	8000.0
2021-08-16 04:00:00	NQ	Futures	17506.89	17514.71	17501.09	17502.83	3736.0
2021-08-16 05:00:00	NQ	Futures	17503.12	17506.31	17489.51	17498.78	3162.0
2021-08-16 06:00:00	NQ	Futures	17498.78	17500.8	17451.56	17484.58	8203.0
2021-08-16 07:00:00	NQ	Futures	17484.87	17493.56	17459.67	17468.94	5949.0
2021-08-16 08:00:00	NQ	Futures	17468.36	17475.31	17453.88	17464.59	8275.0
2021-08-16 09:00:00	NQ	Futures	17464.3	17510.94	17406.08	17417.38	84000.0
2021-08-16 10:00:00	NQ	Futures	17417.38	17428.96	17284.99	17302.95	138432.0
2021-08-16 11:00:00	NQ	Futures	17302.95	17389.86	17297.74	17368.71	84028.0
2021-08-16 12:00:00	NQ	Futures	17369.0	17415.93	17362.63	17407.53	52446.0
2021-08-16 13:00:00	NQ	Futures	17407.53	17471.26	17403.18	17466.33	47460.0
2021-08-16 14:00:00	NQ	Futures	17466.33	17496.75	17457.93	17484.87	42665.0
2021-08-16 15:00:00	NQ	Futures	17484.87	17539.62	17482.26	17536.14	58366.0
2021-08-16 16:00:00	NQ	Futures	17536.14	17541.94	17523.4	17537.3	12848.0
2021-08-16 18:00:00	NQ	Futures	17533.25	17535.85	17522.82	17523.4	2604.0
2021-08-16 19:00:00	NQ	Futures	17523.11	17535.57	17522.24	17531.51	2217.0
2021-08-16 20:00:00	NQ	Futures	17531.51	17533.83	17507.18	17514.42	4358.0
2021-08-16 21:00:00	NQ	Futures	17514.71	17521.08	17506.02	17515.58	2994.0
2021-08-16 22:00:00	NQ	Futures	17515.29	17517.61	17510.36	17513.26	1643.0
2021-08-16 23:00:00	NQ	Futures	17513.26	17514.13	17505.73	17508.62	1830.0
2021-08-16 00:00:00	YM	Futures	39428.9	39465.8	39422.2	39461.3	1230.0
2021-08-16 01:00:00	YM	Futures	39459.1	39480.3	39445.7	39452.4	1431.0
2021-08-16 02:00:00	YM	Futures	39453.5	39458.0	39397.7	39417.8	2208.0
2021-08-16 03:00:00	YM	Futures	39416.7	39502.7	39379.8	39494.9	5838.0

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

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