PREVIEW / futures_1hour / 2023-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-09.parquet
  size:    55 KB
  rows:    1,634

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-09 00:00:00	ES	Futures	4764.93	4764.93	4762.16	4762.44	2128.0
2023-06-09 01:00:00	ES	Futures	4762.44	4765.76	4762.16	4765.21	4982.0
2023-06-09 02:00:00	ES	Futures	4765.21	4765.21	4760.49	4761.88	5743.0
2023-06-09 03:00:00	ES	Futures	4761.88	4762.16	4752.73	4759.94	20813.0
2023-06-09 04:00:00	ES	Futures	4760.22	4764.38	4756.61	4764.1	11492.0
2023-06-09 05:00:00	ES	Futures	4764.1	4767.7	4761.05	4762.44	13562.0
2023-06-09 06:00:00	ES	Futures	4762.16	4764.65	4758.83	4762.44	12518.0
2023-06-09 07:00:00	ES	Futures	4762.71	4769.92	4761.88	4767.15	17770.0
2023-06-09 08:00:00	ES	Futures	4767.15	4772.42	4766.32	4772.42	29497.0
2023-06-09 09:00:00	ES	Futures	4772.7	4791.56	4770.2	4787.4	193060.0
2023-06-09 10:00:00	ES	Futures	4787.4	4798.77	4782.13	4788.78	257187.0
2023-06-09 11:00:00	ES	Futures	4789.06	4795.16	4768.81	4770.48	247717.0
2023-06-09 12:00:00	ES	Futures	4770.76	4776.03	4763.82	4774.64	147071.0
2023-06-09 13:00:00	ES	Futures	4774.36	4783.51	4772.7	4783.24	103300.0
2023-06-09 14:00:00	ES	Futures	4783.24	4785.46	4775.19	4779.63	102352.0
2023-06-09 15:00:00	ES	Futures	4779.91	4782.4	4772.7	4776.03	176483.0
2023-06-09 16:00:00	ES	Futures	4776.3	4780.46	4775.19	4775.75	50633.0
2023-06-09 00:00:00	NQ	Futures	16329.79	16330.07	16316.28	16316.84	1392.0
2023-06-09 01:00:00	NQ	Futures	16317.12	16339.08	16316.84	16332.33	2761.0
2023-06-09 02:00:00	NQ	Futures	16332.89	16334.02	16316.84	16327.82	2221.0
2023-06-09 03:00:00	NQ	Futures	16328.1	16330.07	16285.31	16307.27	7235.0
2023-06-09 04:00:00	NQ	Futures	16307.27	16336.27	16301.36	16332.61	5243.0
2023-06-09 05:00:00	NQ	Futures	16332.61	16348.94	16321.07	16328.95	4816.0
2023-06-09 06:00:00	NQ	Futures	16328.39	16347.81	16312.06	16325.57	6045.0
2023-06-09 07:00:00	NQ	Futures	16325.85	16363.86	16325.85	16350.07	7191.0
2023-06-09 08:00:00	NQ	Futures	16349.78	16394.55	16349.5	16388.92	12640.0
2023-06-09 09:00:00	NQ	Futures	16389.48	16519.84	16375.12	16503.23	84159.0
2023-06-09 10:00:00	NQ	Futures	16503.51	16541.24	16397.08	16430.31	106366.0
2023-06-09 11:00:00	NQ	Futures	16430.87	16491.97	16364.71	16365.55	85008.0
2023-06-09 12:00:00	NQ	Futures	16365.27	16397.65	16325.85	16390.05	53460.0
2023-06-09 13:00:00	NQ	Futures	16390.05	16459.87	16384.7	16452.55	40152.0
2023-06-09 14:00:00	NQ	Futures	16452.55	16459.31	16398.21	16423.55	35342.0
2023-06-09 15:00:00	NQ	Futures	16424.68	16427.77	16373.15	16393.71	43024.0
2023-06-09 16:00:00	NQ	Futures	16393.14	16410.88	16391.45	16404.69	8751.0
2023-06-09 00:00:00	YM	Futures	37384.8	37384.8	37367.2	37367.2	403.0
2023-06-09 01:00:00	YM	Futures	37368.3	37384.8	37366.1	37380.4	709.0
2023-06-09 02:00:00	YM	Futures	37380.4	37381.5	37349.5	37359.4	1250.0
2023-06-09 03:00:00	YM	Futures	37358.3	37373.8	37294.2	37372.7	4396.0
2023-06-09 04:00:00	YM	Futures	37373.8	37373.8	37331.8	37369.4	2746.0
2023-06-09 05:00:00	YM	Futures	37370.5	37391.5	37341.7	37353.9	2437.0
2023-06-09 06:00:00	YM	Futures	37353.9	37362.7	37327.4	37352.8	2247.0
2023-06-09 07:00:00	YM	Futures	37351.7	37379.3	37337.3	37366.1	2605.0
2023-06-09 08:00:00	YM	Futures	37365.0	37381.5	37332.9	37372.7	3128.0
2023-06-09 09:00:00	YM	Futures	37373.8	37499.8	37355.0	37466.6	22370.0
2023-06-09 10:00:00	YM	Futures	37465.5	37580.5	37465.5	37538.5	25800.0
2023-06-09 11:00:00	YM	Futures	37540.7	37559.5	37373.8	37407.0	22314.0
2023-06-09 12:00:00	YM	Futures	37407.0	37437.9	37367.2	37421.3	13992.0
2023-06-09 13:00:00	YM	Futures	37422.4	37491.0	37405.8	37491.0	10497.0
2023-06-09 14:00:00	YM	Futures	37492.1	37518.6	37462.2	37482.1	8451.0
2023-06-09 15:00:00	YM	Futures	37483.2	37514.2	37449.0	37482.1	14591.0

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

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