PREVIEW / futures_1hour / 2023-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-19.parquet
  size:    66 KB
  rows:    2,029

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
2023-07-19 00:00:00	ES	Futures	5035.91	5036.19	5035.09	5035.64	2763.0
2023-07-19 01:00:00	ES	Futures	5035.64	5037.56	5035.36	5035.91	7157.0
2023-07-19 02:00:00	ES	Futures	5036.19	5040.58	5034.81	5040.3	16569.0
2023-07-19 03:00:00	ES	Futures	5040.58	5043.05	5034.81	5035.64	22512.0
2023-07-19 04:00:00	ES	Futures	5035.36	5041.4	5034.54	5040.85	14076.0
2023-07-19 05:00:00	ES	Futures	5040.85	5042.23	5038.93	5040.58	12312.0
2023-07-19 06:00:00	ES	Futures	5040.3	5040.85	5038.11	5040.85	10807.0
2023-07-19 07:00:00	ES	Futures	5040.85	5040.85	5033.99	5036.74	21815.0
2023-07-19 08:00:00	ES	Futures	5037.01	5040.58	5035.91	5039.48	25839.0
2023-07-19 09:00:00	ES	Futures	5039.21	5058.15	5038.66	5056.5	193217.0
2023-07-19 10:00:00	ES	Futures	5056.77	5060.34	5040.85	5048.54	228690.0
2023-07-19 11:00:00	ES	Futures	5048.26	5058.15	5046.62	5056.5	159943.0
2023-07-19 12:00:00	ES	Futures	5056.5	5061.17	5042.5	5049.36	222489.0
2023-07-19 13:00:00	ES	Futures	5049.36	5049.91	5041.4	5046.34	105364.0
2023-07-19 14:00:00	ES	Futures	5046.07	5050.74	5038.38	5049.64	124548.0
2023-07-19 15:00:00	ES	Futures	5049.64	5057.32	5045.52	5046.62	192953.0
2023-07-19 16:00:00	ES	Futures	5046.34	5048.81	5041.4	5046.34	76135.0
2023-07-19 18:00:00	ES	Futures	5043.6	5044.7	5030.15	5032.07	15224.0
2023-07-19 19:00:00	ES	Futures	5031.79	5035.09	5030.97	5034.26	5959.0
2023-07-19 20:00:00	ES	Futures	5034.26	5038.93	5033.99	5038.11	6505.0
2023-07-19 21:00:00	ES	Futures	5038.11	5041.68	5037.56	5040.03	8035.0
2023-07-19 22:00:00	ES	Futures	5040.03	5040.85	5036.46	5038.93	6482.0
2023-07-19 23:00:00	ES	Futures	5038.66	5040.03	5037.56	5039.48	3575.0
2023-07-19 00:00:00	NQ	Futures	17759.51	17759.79	17752.55	17752.55	1289.0
2023-07-19 01:00:00	NQ	Futures	17752.83	17763.96	17752.55	17759.51	3058.0
2023-07-19 02:00:00	NQ	Futures	17759.79	17786.76	17755.06	17782.59	7561.0
2023-07-19 03:00:00	NQ	Futures	17782.59	17790.1	17767.85	17770.08	7031.0
2023-07-19 04:00:00	NQ	Futures	17769.8	17792.05	17760.34	17786.49	6725.0
2023-07-19 05:00:00	NQ	Futures	17785.93	17811.24	17777.59	17803.45	6692.0
2023-07-19 06:00:00	NQ	Futures	17803.45	17806.51	17784.82	17805.96	5561.0
2023-07-19 07:00:00	NQ	Futures	17806.23	17810.13	17780.09	17791.49	10309.0
2023-07-19 08:00:00	NQ	Futures	17792.05	17816.8	17789.82	17811.24	13265.0
2023-07-19 09:00:00	NQ	Futures	17810.68	17841.56	17775.36	17802.9	94260.0
2023-07-19 10:00:00	NQ	Futures	17803.17	17849.07	17768.13	17801.51	114087.0
2023-07-19 11:00:00	NQ	Futures	17801.51	17855.74	17790.1	17829.04	72215.0
2023-07-19 12:00:00	NQ	Futures	17828.48	17870.2	17742.26	17772.3	113377.0
2023-07-19 13:00:00	NQ	Futures	17772.02	17777.31	17719.18	17742.54	55242.0
2023-07-19 14:00:00	NQ	Futures	17742.82	17750.33	17701.66	17746.99	50404.0
2023-07-19 15:00:00	NQ	Futures	17747.27	17800.39	17745.88	17752.55	66876.0
2023-07-19 16:00:00	NQ	Futures	17752.83	17773.14	17711.67	17733.09	30316.0
2023-07-19 18:00:00	NQ	Futures	17714.45	17717.79	17628.23	17641.3	12324.0
2023-07-19 19:00:00	NQ	Futures	17642.14	17647.98	17624.89	17641.3	4859.0
2023-07-19 20:00:00	NQ	Futures	17641.3	17663.55	17640.19	17657.71	4817.0
2023-07-19 21:00:00	NQ	Futures	17657.99	17685.25	17655.76	17675.79	5729.0
2023-07-19 22:00:00	NQ	Futures	17675.79	17681.07	17656.6	17670.23	4823.0
2023-07-19 23:00:00	NQ	Futures	17669.95	17673.84	17663.0	17670.78	2680.0
2023-07-19 00:00:00	YM	Futures	38515.0	38520.5	38510.6	38511.7	633.0
2023-07-19 01:00:00	YM	Futures	38512.8	38529.2	38511.7	38521.6	1576.0
2023-07-19 02:00:00	YM	Futures	38521.6	38565.4	38516.1	38563.2	4365.0
2023-07-19 03:00:00	YM	Futures	38563.2	38596.1	38522.7	38525.9	5971.0

> showing 50 of 2,029 rows — these rows as CSV

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