PREVIEW / futures_1hour / 2021-08-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	5014.98	5016.39	5014.13	5016.11	2761.0
2021-08-23 01:00:00	ES	Futures	5016.11	5017.23	5013.01	5013.01	6504.0
2021-08-23 02:00:00	ES	Futures	5013.01	5016.11	5011.6	5015.26	10338.0
2021-08-23 03:00:00	ES	Futures	5015.26	5016.39	5006.81	5009.63	24052.0
2021-08-23 04:00:00	ES	Futures	5009.63	5012.73	5007.1	5012.16	14712.0
2021-08-23 05:00:00	ES	Futures	5012.16	5014.42	5009.91	5013.01	8607.0
2021-08-23 06:00:00	ES	Futures	5013.29	5015.54	5012.16	5014.7	9625.0
2021-08-23 07:00:00	ES	Futures	5014.42	5017.51	5011.6	5014.42	13604.0
2021-08-23 08:00:00	ES	Futures	5014.7	5015.82	5012.73	5015.26	16415.0
2021-08-23 09:00:00	ES	Futures	5015.26	5031.59	5012.73	5031.03	151252.0
2021-08-23 10:00:00	ES	Futures	5031.31	5042.01	5029.06	5041.45	147775.0
2021-08-23 11:00:00	ES	Futures	5041.45	5048.49	5040.88	5046.8	93852.0
2021-08-23 12:00:00	ES	Futures	5047.08	5051.87	5045.95	5051.59	57896.0
2021-08-23 13:00:00	ES	Futures	5051.59	5052.43	5043.14	5046.52	76704.0
2021-08-23 14:00:00	ES	Futures	5046.52	5051.02	5045.67	5049.9	52870.0
2021-08-23 15:00:00	ES	Futures	5050.18	5050.74	5040.32	5041.73	150370.0
2021-08-23 16:00:00	ES	Futures	5041.73	5047.92	5040.32	5047.36	62802.0
2021-08-23 18:00:00	ES	Futures	5047.08	5049.9	5045.95	5048.49	4610.0
2021-08-23 19:00:00	ES	Futures	5048.77	5049.9	5047.92	5049.9	2133.0
2021-08-23 20:00:00	ES	Futures	5049.9	5050.46	5047.36	5049.33	5146.0
2021-08-23 21:00:00	ES	Futures	5049.33	5051.02	5047.36	5050.18	5266.0
2021-08-23 22:00:00	ES	Futures	5050.18	5051.02	5048.49	5048.49	3376.0
2021-08-23 23:00:00	ES	Futures	5048.77	5049.9	5048.21	5049.05	2727.0
2021-08-23 00:00:00	NQ	Futures	17550.34	17554.39	17547.44	17552.37	1103.0
2021-08-23 01:00:00	NQ	Futures	17552.66	17558.74	17537.3	17539.04	2762.0
2021-08-23 02:00:00	NQ	Futures	17539.04	17548.02	17531.51	17546.86	4046.0
2021-08-23 03:00:00	NQ	Futures	17546.86	17547.73	17520.79	17528.32	7232.0
2021-08-23 04:00:00	NQ	Futures	17528.32	17543.1	17521.37	17540.49	6298.0
2021-08-23 05:00:00	NQ	Futures	17540.2	17540.78	17522.53	17531.51	3797.0
2021-08-23 06:00:00	NQ	Futures	17531.51	17534.41	17522.24	17530.93	3012.0
2021-08-23 07:00:00	NQ	Futures	17530.64	17543.68	17525.72	17532.96	4252.0
2021-08-23 08:00:00	NQ	Futures	17532.96	17535.57	17516.16	17524.56	6745.0
2021-08-23 09:00:00	NQ	Futures	17524.27	17622.47	17520.5	17617.26	63829.0
2021-08-23 10:00:00	NQ	Futures	17616.68	17696.92	17604.51	17695.18	69524.0
2021-08-23 11:00:00	NQ	Futures	17695.47	17744.43	17683.3	17741.24	41921.0
2021-08-23 12:00:00	NQ	Futures	17741.24	17756.59	17727.04	17754.85	33661.0
2021-08-23 13:00:00	NQ	Futures	17755.14	17760.07	17728.49	17745.29	32987.0
2021-08-23 14:00:00	NQ	Futures	17745.58	17771.95	17745.58	17767.02	31239.0
2021-08-23 15:00:00	NQ	Futures	17767.02	17769.05	17730.23	17735.74	55026.0
2021-08-23 16:00:00	NQ	Futures	17736.02	17762.1	17732.55	17761.23	12056.0
2021-08-23 18:00:00	NQ	Futures	17759.78	17766.15	17754.27	17759.49	2415.0
2021-08-23 19:00:00	NQ	Futures	17759.2	17763.83	17758.62	17763.25	1032.0
2021-08-23 20:00:00	NQ	Futures	17762.97	17767.6	17757.75	17764.7	2089.0
2021-08-23 21:00:00	NQ	Futures	17764.99	17769.92	17757.17	17760.65	2617.0
2021-08-23 22:00:00	NQ	Futures	17760.94	17763.54	17757.46	17757.75	1561.0
2021-08-23 23:00:00	NQ	Futures	17758.04	17759.49	17754.27	17757.17	1276.0
2021-08-23 00:00:00	YM	Futures	39321.7	39336.2	39312.7	39332.9	657.0
2021-08-23 01:00:00	YM	Futures	39331.7	39348.5	39316.1	39317.2	1262.0
2021-08-23 02:00:00	YM	Futures	39318.3	39341.8	39299.3	39322.8	2264.0
2021-08-23 03:00:00	YM	Futures	39323.9	39337.3	39247.9	39277.0	4299.0

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

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