PREVIEW / futures_1hour / 2021-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-24.parquet
  size:    61 KB
  rows:    1,948

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-24 00:00:00	ES	Futures	5049.05	5049.9	5048.77	5049.33	1519.0
2021-08-24 01:00:00	ES	Futures	5049.05	5052.15	5049.05	5051.3	4681.0
2021-08-24 02:00:00	ES	Futures	5051.3	5059.47	5050.46	5058.91	12908.0
2021-08-24 03:00:00	ES	Futures	5058.91	5059.19	5051.87	5052.71	16502.0
2021-08-24 04:00:00	ES	Futures	5052.71	5054.96	5050.46	5051.87	10731.0
2021-08-24 05:00:00	ES	Futures	5051.87	5052.99	5045.95	5046.52	10293.0
2021-08-24 06:00:00	ES	Futures	5046.52	5051.87	5046.23	5051.59	11557.0
2021-08-24 07:00:00	ES	Futures	5051.59	5051.87	5046.8	5047.36	13281.0
2021-08-24 08:00:00	ES	Futures	5047.64	5048.77	5042.29	5044.83	24329.0
2021-08-24 09:00:00	ES	Futures	5044.83	5051.87	5043.14	5049.9	137907.0
2021-08-24 10:00:00	ES	Futures	5049.9	5054.96	5047.64	5051.87	119389.0
2021-08-24 11:00:00	ES	Futures	5051.87	5054.12	5046.8	5050.18	84865.0
2021-08-24 12:00:00	ES	Futures	5049.9	5050.18	5045.11	5048.77	50844.0
2021-08-24 13:00:00	ES	Futures	5049.05	5053.27	5048.77	5052.43	41198.0
2021-08-24 14:00:00	ES	Futures	5052.43	5055.53	5051.87	5055.25	36367.0
2021-08-24 15:00:00	ES	Futures	5055.25	5055.53	5046.52	5049.33	114717.0
2021-08-24 16:00:00	ES	Futures	5049.33	5051.02	5047.64	5050.18	44278.0
2021-08-24 18:00:00	ES	Futures	5049.9	5051.02	5049.05	5049.33	2454.0
2021-08-24 19:00:00	ES	Futures	5049.33	5049.9	5045.67	5047.64	3670.0
2021-08-24 20:00:00	ES	Futures	5047.64	5052.15	5047.36	5047.64	6671.0
2021-08-24 21:00:00	ES	Futures	5047.64	5049.05	5046.52	5046.8	4619.0
2021-08-24 22:00:00	ES	Futures	5046.8	5048.21	5043.14	5044.83	5889.0
2021-08-24 23:00:00	ES	Futures	5044.55	5045.95	5041.73	5043.98	4360.0
2021-08-24 00:00:00	NQ	Futures	17756.3	17759.78	17756.3	17759.2	760.0
2021-08-24 01:00:00	NQ	Futures	17758.62	17778.03	17754.85	17776.29	3006.0
2021-08-24 02:00:00	NQ	Futures	17776.0	17823.8	17769.92	17823.8	7898.0
2021-08-24 03:00:00	NQ	Futures	17822.93	17825.83	17808.16	17817.71	7533.0
2021-08-24 04:00:00	NQ	Futures	17817.43	17822.35	17809.6	17812.79	4670.0
2021-08-24 05:00:00	NQ	Futures	17813.08	17821.77	17780.64	17785.85	6088.0
2021-08-24 06:00:00	NQ	Futures	17785.56	17794.54	17780.93	17791.06	4180.0
2021-08-24 07:00:00	NQ	Futures	17791.64	17792.8	17762.39	17765.57	5214.0
2021-08-24 08:00:00	NQ	Futures	17765.86	17769.92	17739.5	17756.3	10436.0
2021-08-24 09:00:00	NQ	Futures	17756.59	17790.77	17743.56	17766.15	69991.0
2021-08-24 10:00:00	NQ	Futures	17766.15	17821.77	17755.14	17796.86	67532.0
2021-08-24 11:00:00	NQ	Futures	17796.57	17807.0	17765.28	17798.02	44881.0
2021-08-24 12:00:00	NQ	Futures	17798.31	17800.62	17763.54	17776.87	27591.0
2021-08-24 13:00:00	NQ	Futures	17776.58	17791.64	17769.05	17783.24	22052.0
2021-08-24 14:00:00	NQ	Futures	17783.53	17800.62	17776.58	17799.75	21234.0
2021-08-24 15:00:00	NQ	Futures	17799.75	17812.5	17780.93	17793.38	41354.0
2021-08-24 16:00:00	NQ	Futures	17793.67	17802.65	17787.3	17802.07	7176.0
2021-08-24 18:00:00	NQ	Futures	17800.62	17803.52	17794.83	17795.7	1435.0
2021-08-24 19:00:00	NQ	Futures	17795.7	17796.28	17787.88	17795.7	1735.0
2021-08-24 20:00:00	NQ	Futures	17795.41	17808.16	17793.38	17795.12	2565.0
2021-08-24 21:00:00	NQ	Futures	17794.25	17802.65	17789.91	17795.99	2420.0
2021-08-24 22:00:00	NQ	Futures	17795.7	17802.07	17784.11	17791.35	2654.0
2021-08-24 23:00:00	NQ	Futures	17791.06	17795.12	17782.66	17785.85	1995.0
2021-08-24 00:00:00	YM	Futures	39492.6	39499.3	39491.5	39493.7	312.0
2021-08-24 01:00:00	YM	Futures	39492.6	39511.6	39488.2	39498.2	1049.0
2021-08-24 02:00:00	YM	Futures	39499.3	39554.1	39488.2	39548.5	2883.0
2021-08-24 03:00:00	YM	Futures	39546.3	39548.5	39471.4	39482.6	3330.0

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

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