PREVIEW / futures_1hour / 2023-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-02-20.parquet
  size:    51 KB
  rows:    1,595

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-02-20 00:00:00	ES	Futures	4570.17	4572.97	4568.21	4571.85	2846.0
2023-02-20 01:00:00	ES	Futures	4571.85	4573.24	4570.45	4572.13	2830.0
2023-02-20 02:00:00	ES	Futures	4571.85	4572.69	4568.21	4571.01	3965.0
2023-02-20 03:00:00	ES	Futures	4570.73	4571.29	4562.62	4565.98	9160.0
2023-02-20 04:00:00	ES	Futures	4565.98	4567.93	4557.87	4560.1	8854.0
2023-02-20 05:00:00	ES	Futures	4560.1	4564.02	4557.87	4562.9	5814.0
2023-02-20 06:00:00	ES	Futures	4563.18	4568.21	4560.94	4566.53	5557.0
2023-02-20 07:00:00	ES	Futures	4566.81	4568.49	4562.34	4565.42	7603.0
2023-02-20 08:00:00	ES	Futures	4565.42	4568.49	4565.14	4567.65	5306.0
2023-02-20 09:00:00	ES	Futures	4567.65	4567.93	4561.22	4562.34	8331.0
2023-02-20 10:00:00	ES	Futures	4562.62	4562.62	4557.31	4558.71	12011.0
2023-02-20 11:00:00	ES	Futures	4558.71	4561.78	4557.03	4557.31	8352.0
2023-02-20 12:00:00	ES	Futures	4557.31	4560.94	4555.63	4558.43	6408.0
2023-02-20 18:00:00	ES	Futures	4558.71	4560.66	4557.59	4559.82	4778.0
2023-02-20 19:00:00	ES	Futures	4560.1	4560.1	4551.72	4551.99	9282.0
2023-02-20 20:00:00	ES	Futures	4552.27	4555.07	4548.92	4553.95	10628.0
2023-02-20 21:00:00	ES	Futures	4553.95	4555.35	4550.88	4552.55	5116.0
2023-02-20 22:00:00	ES	Futures	4552.55	4553.39	4550.04	4552.83	3825.0
2023-02-20 23:00:00	ES	Futures	4552.83	4553.39	4551.16	4551.72	2340.0
2023-02-20 00:00:00	NQ	Futures	14105.22	14110.91	14090.71	14107.78	2129.0
2023-02-20 01:00:00	NQ	Futures	14107.49	14114.03	14102.66	14106.64	1709.0
2023-02-20 02:00:00	NQ	Futures	14107.21	14108.06	14091.56	14100.38	2208.0
2023-02-20 03:00:00	NQ	Futures	14099.53	14101.52	14067.95	14082.17	5343.0
2023-02-20 04:00:00	NQ	Futures	14081.32	14089.57	14058.56	14069.94	4124.0
2023-02-20 05:00:00	NQ	Futures	14069.65	14095.54	14065.1	14089.57	3638.0
2023-02-20 06:00:00	NQ	Futures	14089.57	14119.44	14082.17	14111.76	4181.0
2023-02-20 07:00:00	NQ	Futures	14112.61	14131.1	14099.24	14112.04	5918.0
2023-02-20 08:00:00	NQ	Futures	14113.18	14126.84	14105.78	14113.47	4244.0
2023-02-20 09:00:00	NQ	Futures	14112.61	14115.46	14090.99	14096.11	5772.0
2023-02-20 10:00:00	NQ	Futures	14095.83	14097.25	14078.19	14081.6	6238.0
2023-02-20 11:00:00	NQ	Futures	14081.89	14096.97	14079.61	14083.03	4291.0
2023-02-20 12:00:00	NQ	Futures	14082.74	14089.57	14072.21	14073.07	3110.0
2023-02-20 18:00:00	NQ	Futures	14075.91	14087.01	14067.38	14086.15	2819.0
2023-02-20 19:00:00	NQ	Futures	14086.72	14087.58	14047.18	14052.02	3974.0
2023-02-20 20:00:00	NQ	Futures	14052.02	14059.7	14035.51	14055.71	5313.0
2023-02-20 21:00:00	NQ	Futures	14055.71	14066.81	14046.33	14052.02	2960.0
2023-02-20 22:00:00	NQ	Futures	14051.73	14055.43	14042.34	14051.73	2034.0
2023-02-20 23:00:00	NQ	Futures	14051.73	14054.86	14044.9	14048.32	1318.0
2023-02-20 00:00:00	YM	Futures	37720.6	37736.2	37709.5	37726.2	323.0
2023-02-20 01:00:00	YM	Futures	37728.4	37730.7	37708.4	37719.5	624.0
2023-02-20 02:00:00	YM	Futures	37717.3	37741.8	37697.2	37732.9	1124.0
2023-02-20 03:00:00	YM	Futures	37732.9	37737.3	37678.3	37698.3	1526.0
2023-02-20 04:00:00	YM	Futures	37698.3	37721.7	37646.0	37653.8	1763.0
2023-02-20 05:00:00	YM	Futures	37654.9	37670.5	37627.0	37652.7	1298.0
2023-02-20 06:00:00	YM	Futures	37653.8	37682.7	37638.2	37659.3	842.0
2023-02-20 07:00:00	YM	Futures	37660.5	37669.4	37625.9	37658.2	1209.0
2023-02-20 08:00:00	YM	Futures	37662.7	37695.0	37656.0	37692.8	1302.0
2023-02-20 09:00:00	YM	Futures	37693.9	37693.9	37628.1	37650.4	2390.0
2023-02-20 10:00:00	YM	Futures	37649.3	37649.3	37595.8	37612.5	2119.0
2023-02-20 11:00:00	YM	Futures	37612.5	37622.6	37594.7	37600.3	1131.0

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

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