PREVIEW / futures_1hour / 2023-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-07.parquet
  size:    67 KB
  rows:    2,020

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-03-07 00:00:00	ES	Futures	4542.49	4543.05	4539.41	4540.53	3387.0
2023-03-07 01:00:00	ES	Futures	4540.53	4541.93	4537.46	4538.01	6296.0
2023-03-07 02:00:00	ES	Futures	4538.01	4540.25	4535.5	4535.78	7026.0
2023-03-07 03:00:00	ES	Futures	4536.06	4543.05	4534.38	4540.53	18349.0
2023-03-07 04:00:00	ES	Futures	4540.25	4545.84	4538.01	4538.57	16915.0
2023-03-07 05:00:00	ES	Futures	4538.57	4542.49	4538.29	4540.81	12226.0
2023-03-07 06:00:00	ES	Futures	4540.81	4543.61	4536.9	4537.73	10691.0
2023-03-07 07:00:00	ES	Futures	4537.73	4538.57	4534.66	4537.46	14222.0
2023-03-07 08:00:00	ES	Futures	4537.46	4541.37	4536.06	4536.34	25890.0
2023-03-07 09:00:00	ES	Futures	4536.34	4536.62	4527.39	4530.46	131930.0
2023-03-07 10:00:00	ES	Futures	4530.19	4530.19	4485.17	4486.01	565513.0
2023-03-07 11:00:00	ES	Futures	4486.01	4496.07	4478.74	4479.86	302263.0
2023-03-07 12:00:00	ES	Futures	4479.86	4503.9	4478.46	4484.89	216150.0
2023-03-07 13:00:00	ES	Futures	4484.89	4485.73	4460.28	4462.8	205616.0
2023-03-07 14:00:00	ES	Futures	4462.8	4468.95	4454.13	4455.53	151320.0
2023-03-07 15:00:00	ES	Futures	4455.53	4471.47	4454.97	4461.96	247269.0
2023-03-07 16:00:00	ES	Futures	4461.96	4465.6	4460.28	4462.24	58798.0
2023-03-07 18:00:00	ES	Futures	4462.52	4465.88	4461.96	4463.92	7354.0
2023-03-07 19:00:00	ES	Futures	4463.92	4465.32	4457.49	4461.96	12321.0
2023-03-07 20:00:00	ES	Futures	4462.24	4466.16	4460.56	4462.24	10429.0
2023-03-07 21:00:00	ES	Futures	4461.96	4463.92	4455.81	4457.77	10578.0
2023-03-07 22:00:00	ES	Futures	4457.77	4461.12	4457.49	4458.33	7359.0
2023-03-07 23:00:00	ES	Futures	4458.33	4463.92	4458.33	4462.24	6621.0
2023-03-07 00:00:00	NQ	Futures	14073.92	14075.63	14057.99	14061.12	1966.0
2023-03-07 01:00:00	NQ	Futures	14061.4	14065.39	14041.2	14042.34	4896.0
2023-03-07 02:00:00	NQ	Futures	14042.91	14054.86	14032.67	14037.22	4211.0
2023-03-07 03:00:00	NQ	Futures	14037.79	14071.93	14034.66	14062.83	7006.0
2023-03-07 04:00:00	NQ	Futures	14062.26	14089.57	14051.45	14052.87	7591.0
2023-03-07 05:00:00	NQ	Futures	14052.87	14073.64	14052.3	14068.52	3679.0
2023-03-07 06:00:00	NQ	Futures	14067.66	14078.19	14050.31	14054.86	4573.0
2023-03-07 07:00:00	NQ	Futures	14054.29	14062.83	14043.76	14051.16	5675.0
2023-03-07 08:00:00	NQ	Futures	14050.88	14069.94	14047.46	14048.03	10899.0
2023-03-07 09:00:00	NQ	Futures	14048.03	14068.52	14011.9	14035.51	68875.0
2023-03-07 10:00:00	NQ	Futures	14035.23	14035.23	13860.84	13900.66	175151.0
2023-03-07 11:00:00	NQ	Futures	13900.95	13955.86	13892.98	13910.05	79203.0
2023-03-07 12:00:00	NQ	Futures	13910.34	14008.77	13904.08	13951.3	77041.0
2023-03-07 13:00:00	NQ	Futures	13951.3	13955.0	13848.32	13864.53	68045.0
2023-03-07 14:00:00	NQ	Futures	13865.39	13887.58	13817.59	13822.14	50336.0
2023-03-07 15:00:00	NQ	Futures	13822.43	13868.23	13819.01	13848.03	72236.0
2023-03-07 16:00:00	NQ	Futures	13848.32	13867.66	13844.62	13855.43	12326.0
2023-03-07 18:00:00	NQ	Futures	13849.17	13865.67	13849.17	13856.28	3305.0
2023-03-07 19:00:00	NQ	Futures	13856.85	13861.69	13828.12	13844.62	5840.0
2023-03-07 20:00:00	NQ	Futures	13845.19	13865.1	13838.36	13849.17	5015.0
2023-03-07 21:00:00	NQ	Futures	13849.46	13856.57	13813.61	13822.43	6622.0
2023-03-07 22:00:00	NQ	Futures	13822.43	13834.95	13819.01	13821.29	4046.0
2023-03-07 23:00:00	NQ	Futures	13821.58	13848.03	13821.58	13840.35	3826.0
2023-03-07 00:00:00	YM	Futures	37316.2	37318.4	37300.6	37307.3	476.0
2023-03-07 01:00:00	YM	Futures	37306.1	37319.5	37295.0	37300.6	813.0
2023-03-07 02:00:00	YM	Futures	37299.5	37317.3	37282.8	37290.6	1140.0
2023-03-07 03:00:00	YM	Futures	37290.6	37321.7	37271.6	37302.8	2147.0

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

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