PREVIEW / futures_1hour / 2023-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-13.parquet
  size:    65 KB
  rows:    2,025

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-06-13 00:00:00	ES	Futures	4828.45	4830.11	4827.61	4828.17	1470.0
2023-06-13 01:00:00	ES	Futures	4827.61	4830.39	4827.06	4829.55	2218.0
2023-06-13 02:00:00	ES	Futures	4829.55	4834.82	4827.89	4831.77	5043.0
2023-06-13 03:00:00	ES	Futures	4831.5	4834.27	4827.06	4829.28	8248.0
2023-06-13 04:00:00	ES	Futures	4829.0	4832.61	4827.06	4830.66	5565.0
2023-06-13 05:00:00	ES	Futures	4830.39	4833.16	4825.95	4825.95	6265.0
2023-06-13 06:00:00	ES	Futures	4826.23	4827.06	4820.4	4823.18	10283.0
2023-06-13 07:00:00	ES	Futures	4823.18	4825.12	4819.02	4820.12	8075.0
2023-06-13 08:00:00	ES	Futures	4820.12	4843.98	4810.14	4843.98	30265.0
2023-06-13 09:00:00	ES	Futures	4843.7	4855.07	4831.77	4838.98	76845.0
2023-06-13 10:00:00	ES	Futures	4839.26	4846.2	4826.78	4842.04	61225.0
2023-06-13 11:00:00	ES	Futures	4842.04	4856.18	4838.15	4842.59	59143.0
2023-06-13 12:00:00	ES	Futures	4842.31	4853.41	4838.98	4853.13	36011.0
2023-06-13 13:00:00	ES	Futures	4853.13	4856.74	4846.75	4851.19	31371.0
2023-06-13 14:00:00	ES	Futures	4851.19	4852.57	4834.82	4842.59	58253.0
2023-06-13 15:00:00	ES	Futures	4842.59	4850.91	4842.59	4849.25	61103.0
2023-06-13 16:00:00	ES	Futures	4849.52	4853.96	4846.75	4850.91	14170.0
2023-06-13 18:00:00	ES	Futures	4850.36	4852.57	4847.58	4852.3	1498.0
2023-06-13 19:00:00	ES	Futures	4852.3	4852.57	4849.52	4850.08	607.0
2023-06-13 20:00:00	ES	Futures	4849.8	4849.8	4845.92	4846.75	1786.0
2023-06-13 21:00:00	ES	Futures	4847.03	4851.19	4847.03	4850.63	1130.0
2023-06-13 22:00:00	ES	Futures	4850.36	4850.63	4847.03	4848.69	1047.0
2023-06-13 23:00:00	ES	Futures	4848.41	4849.52	4847.31	4848.97	716.0
2023-06-13 00:00:00	NQ	Futures	16742.55	16745.65	16735.51	16741.99	1110.0
2023-06-13 01:00:00	NQ	Futures	16740.86	16745.65	16734.67	16740.58	1351.0
2023-06-13 02:00:00	NQ	Futures	16740.58	16774.08	16735.79	16765.64	3188.0
2023-06-13 03:00:00	NQ	Futures	16765.36	16783.38	16735.79	16758.04	5543.0
2023-06-13 04:00:00	NQ	Futures	16758.6	16778.87	16749.59	16765.64	2585.0
2023-06-13 05:00:00	NQ	Futures	16765.64	16769.02	16730.44	16740.02	3145.0
2023-06-13 06:00:00	NQ	Futures	16740.02	16748.46	16708.48	16715.52	3132.0
2023-06-13 07:00:00	NQ	Futures	16716.37	16737.48	16691.87	16700.04	3265.0
2023-06-13 08:00:00	NQ	Futures	16700.04	16813.78	16663.72	16812.38	18602.0
2023-06-13 09:00:00	NQ	Futures	16812.94	16856.86	16699.75	16713.27	46059.0
2023-06-13 10:00:00	NQ	Futures	16713.27	16749.87	16644.85	16740.02	36400.0
2023-06-13 11:00:00	NQ	Futures	16739.73	16811.53	16721.72	16746.49	25968.0
2023-06-13 12:00:00	NQ	Futures	16746.77	16800.83	16728.47	16800.27	16195.0
2023-06-13 13:00:00	NQ	Futures	16800.27	16815.19	16756.35	16786.19	13263.0
2023-06-13 14:00:00	NQ	Futures	16786.19	16793.23	16701.16	16760.29	18729.0
2023-06-13 15:00:00	NQ	Futures	16760.01	16800.55	16753.25	16793.51	18378.0
2023-06-13 16:00:00	NQ	Futures	16793.51	16812.66	16785.35	16806.46	4131.0
2023-06-13 18:00:00	NQ	Futures	16808.72	16818.85	16802.52	16816.6	893.0
2023-06-13 19:00:00	NQ	Futures	16816.04	16817.72	16798.3	16803.93	450.0
2023-06-13 20:00:00	NQ	Futures	16803.08	16803.93	16787.6	16787.88	1037.0
2023-06-13 21:00:00	NQ	Futures	16788.72	16811.25	16788.72	16807.87	1066.0
2023-06-13 22:00:00	NQ	Futures	16807.87	16808.15	16791.82	16799.71	495.0
2023-06-13 23:00:00	NQ	Futures	16798.58	16800.83	16790.7	16797.45	336.0
2023-06-13 00:00:00	YM	Futures	37699.9	37728.4	37695.5	37697.7	1497.0
2023-06-13 01:00:00	YM	Futures	37697.7	37716.3	37694.4	37715.2	1294.0
2023-06-13 02:00:00	YM	Futures	37715.2	37743.7	37699.9	37719.6	2476.0
2023-06-13 03:00:00	YM	Futures	37718.5	37725.1	37680.2	37692.2	2795.0

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

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