PREVIEW / futures_1hour / 2021-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-14.parquet
  size:    60 KB
  rows:    1,882

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-14 00:00:00	ES	Futures	4643.86	4648.64	4643.86	4647.79	3684.0
2021-04-14 01:00:00	ES	Futures	4647.79	4650.32	4646.95	4650.04	6045.0
2021-04-14 02:00:00	ES	Futures	4650.04	4650.32	4644.7	4647.51	7280.0
2021-04-14 03:00:00	ES	Futures	4647.79	4650.6	4645.27	4646.11	15984.0
2021-04-14 04:00:00	ES	Futures	4645.83	4651.73	4645.27	4650.89	9849.0
2021-04-14 05:00:00	ES	Futures	4650.6	4652.01	4649.48	4649.76	7764.0
2021-04-14 06:00:00	ES	Futures	4649.76	4649.76	4645.55	4646.67	10378.0
2021-04-14 07:00:00	ES	Futures	4646.39	4651.17	4646.11	4650.04	14071.0
2021-04-14 08:00:00	ES	Futures	4650.32	4650.89	4642.46	4643.58	22240.0
2021-04-14 09:00:00	ES	Futures	4643.58	4655.66	4641.05	4655.66	167973.0
2021-04-14 10:00:00	ES	Futures	4655.38	4657.35	4648.36	4650.89	197261.0
2021-04-14 11:00:00	ES	Futures	4650.89	4653.13	4643.3	4650.89	145835.0
2021-04-14 12:00:00	ES	Futures	4651.17	4652.85	4644.98	4651.45	108443.0
2021-04-14 13:00:00	ES	Futures	4651.45	4651.73	4633.18	4636.56	107635.0
2021-04-14 14:00:00	ES	Futures	4636.27	4641.89	4625.88	4627.85	248540.0
2021-04-14 15:00:00	ES	Futures	4627.85	4636.84	4622.51	4630.37	319341.0
2021-04-14 16:00:00	ES	Futures	4630.37	4635.15	4630.09	4634.03	66698.0
2021-04-14 18:00:00	ES	Futures	4634.31	4637.68	4632.62	4635.43	5476.0
2021-04-14 19:00:00	ES	Futures	4635.71	4635.99	4631.78	4633.75	3441.0
2021-04-14 20:00:00	ES	Futures	4634.03	4638.8	4633.18	4636.27	8550.0
2021-04-14 21:00:00	ES	Futures	4636.27	4638.24	4629.81	4633.18	11337.0
2021-04-14 22:00:00	ES	Futures	4633.18	4634.31	4630.37	4630.94	6531.0
2021-04-14 23:00:00	ES	Futures	4630.94	4634.03	4630.09	4633.18	4687.0
2021-04-14 00:00:00	NQ	Futures	16177.58	16192.34	16175.84	16188.87	1833.0
2021-04-14 01:00:00	NQ	Futures	16189.16	16196.97	16180.76	16191.76	2793.0
2021-04-14 02:00:00	NQ	Futures	16192.34	16194.08	16166.29	16180.76	3077.0
2021-04-14 03:00:00	NQ	Futures	16180.76	16201.31	16174.39	16181.34	6402.0
2021-04-14 04:00:00	NQ	Futures	16181.34	16215.79	16179.31	16212.6	5849.0
2021-04-14 05:00:00	NQ	Futures	16212.03	16220.71	16204.79	16215.21	5186.0
2021-04-14 06:00:00	NQ	Futures	16215.5	16215.5	16202.18	16210.58	4260.0
2021-04-14 07:00:00	NQ	Futures	16210.87	16245.32	16210.0	16241.26	8481.0
2021-04-14 08:00:00	NQ	Futures	16241.26	16241.55	16214.63	16217.53	10057.0
2021-04-14 09:00:00	NQ	Futures	16216.95	16218.39	16146.02	16182.21	86847.0
2021-04-14 10:00:00	NQ	Futures	16181.92	16182.79	16110.41	16114.47	97537.0
2021-04-14 11:00:00	NQ	Futures	16114.47	16131.84	16042.96	16104.04	79863.0
2021-04-14 12:00:00	NQ	Futures	16104.04	16116.49	16063.22	16110.41	56225.0
2021-04-14 13:00:00	NQ	Futures	16110.41	16111.28	16004.75	16016.33	54290.0
2021-04-14 14:00:00	NQ	Futures	16016.04	16049.04	15961.03	15987.38	96349.0
2021-04-14 15:00:00	NQ	Futures	15987.38	16022.98	15948.58	15990.27	109382.0
2021-04-14 16:00:00	NQ	Futures	15990.56	16012.56	15989.4	16011.69	11230.0
2021-04-14 18:00:00	NQ	Futures	16011.41	16022.7	15999.54	16006.48	3086.0
2021-04-14 19:00:00	NQ	Futures	16006.77	16009.96	15983.9	15992.88	2003.0
2021-04-14 20:00:00	NQ	Futures	15994.32	16021.83	15991.43	16006.77	4193.0
2021-04-14 21:00:00	NQ	Futures	16006.77	16015.46	15967.69	15986.51	5318.0
2021-04-14 22:00:00	NQ	Futures	15985.93	15992.88	15968.85	15969.72	3676.0
2021-04-14 23:00:00	NQ	Futures	15970.59	15995.19	15969.72	15991.14	2996.0
2021-04-14 00:00:00	YM	Futures	37349.7	37393.1	37348.6	37388.7	882.0
2021-04-14 01:00:00	YM	Futures	37388.7	37405.4	37376.4	37400.9	1169.0
2021-04-14 02:00:00	YM	Futures	37403.1	37403.1	37365.3	37394.2	1758.0
2021-04-14 03:00:00	YM	Futures	37394.2	37410.9	37374.2	37382.0	3371.0

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

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