PREVIEW / futures_1hour / 2023-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-06-02.parquet
  size:    57 KB
  rows:    1,658

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-02 00:00:00	ES	Futures	4698.64	4700.59	4698.37	4699.2	3090.0
2023-06-02 01:00:00	ES	Futures	4698.92	4701.97	4698.64	4700.31	4844.0
2023-06-02 02:00:00	ES	Futures	4700.31	4704.19	4697.81	4703.36	10038.0
2023-06-02 03:00:00	ES	Futures	4703.08	4706.69	4700.31	4706.69	23211.0
2023-06-02 04:00:00	ES	Futures	4706.69	4710.02	4705.58	4709.74	18478.0
2023-06-02 05:00:00	ES	Futures	4709.46	4716.67	4707.8	4712.23	20483.0
2023-06-02 06:00:00	ES	Futures	4712.51	4715.84	4711.12	4713.62	14356.0
2023-06-02 07:00:00	ES	Futures	4713.34	4717.78	4711.68	4712.23	22267.0
2023-06-02 08:00:00	ES	Futures	4712.51	4722.77	4698.37	4713.62	87385.0
2023-06-02 09:00:00	ES	Futures	4713.62	4741.36	4713.62	4718.89	332323.0
2023-06-02 10:00:00	ES	Futures	4719.17	4746.63	4713.9	4746.63	338867.0
2023-06-02 11:00:00	ES	Futures	4746.63	4756.33	4745.79	4753.01	223697.0
2023-06-02 12:00:00	ES	Futures	4753.28	4761.05	4747.46	4759.94	125934.0
2023-06-02 13:00:00	ES	Futures	4759.94	4763.82	4755.78	4761.05	116038.0
2023-06-02 14:00:00	ES	Futures	4761.33	4764.65	4753.56	4763.27	124318.0
2023-06-02 15:00:00	ES	Futures	4763.27	4767.98	4755.78	4758.55	309496.0
2023-06-02 16:00:00	ES	Futures	4758.27	4759.38	4755.78	4758.0	66674.0
2023-06-02 00:00:00	NQ	Futures	16338.52	16343.87	16335.42	16338.52	2145.0
2023-06-02 01:00:00	NQ	Futures	16338.52	16350.35	16334.86	16336.55	2875.0
2023-06-02 02:00:00	NQ	Futures	16336.55	16351.47	16322.47	16346.97	4708.0
2023-06-02 03:00:00	NQ	Futures	16346.97	16350.91	16327.26	16345.84	7832.0
2023-06-02 04:00:00	NQ	Futures	16345.56	16363.02	16332.89	16362.74	7583.0
2023-06-02 05:00:00	NQ	Futures	16362.74	16401.59	16358.23	16376.53	9793.0
2023-06-02 06:00:00	NQ	Futures	16377.09	16391.45	16359.36	16363.58	7877.0
2023-06-02 07:00:00	NQ	Futures	16363.3	16403.28	16363.3	16388.07	10716.0
2023-06-02 08:00:00	NQ	Futures	16388.36	16396.52	16322.75	16343.31	32066.0
2023-06-02 09:00:00	NQ	Futures	16343.03	16473.95	16299.95	16309.24	137719.0
2023-06-02 10:00:00	NQ	Futures	16309.52	16430.31	16294.32	16426.65	106295.0
2023-06-02 11:00:00	NQ	Futures	16427.21	16448.61	16397.65	16426.93	63085.0
2023-06-02 12:00:00	NQ	Futures	16427.49	16452.83	16390.05	16433.97	41480.0
2023-06-02 13:00:00	NQ	Futures	16433.69	16448.61	16414.82	16426.93	33312.0
2023-06-02 14:00:00	NQ	Futures	16427.49	16439.88	16389.48	16427.21	46422.0
2023-06-02 15:00:00	NQ	Futures	16427.77	16443.26	16403.28	16419.33	68646.0
2023-06-02 16:00:00	NQ	Futures	16419.61	16432.28	16417.64	16428.9	14932.0
2023-06-02 00:00:00	YM	Futures	36652.0	36663.1	36643.2	36646.5	657.0
2023-06-02 01:00:00	YM	Futures	36647.6	36668.6	36645.4	36663.1	1000.0
2023-06-02 02:00:00	YM	Futures	36664.2	36706.2	36648.7	36692.9	1840.0
2023-06-02 03:00:00	YM	Futures	36692.9	36742.7	36676.3	36740.5	3490.0
2023-06-02 04:00:00	YM	Futures	36739.3	36761.5	36718.3	36748.2	2800.0
2023-06-02 05:00:00	YM	Futures	36747.1	36781.3	36727.2	36758.1	2814.0
2023-06-02 06:00:00	YM	Futures	36761.5	36790.2	36751.5	36790.2	2321.0
2023-06-02 07:00:00	YM	Futures	36791.3	36806.8	36759.2	36764.8	3025.0
2023-06-02 08:00:00	YM	Futures	36762.6	36843.2	36679.7	36804.6	10823.0
2023-06-02 09:00:00	YM	Futures	36803.5	37073.1	36801.2	37000.2	46662.0
2023-06-02 10:00:00	YM	Futures	37000.2	37149.4	36961.5	37147.2	36258.0
2023-06-02 11:00:00	YM	Futures	37147.2	37284.3	37147.2	37267.7	25889.0
2023-06-02 12:00:00	YM	Futures	37267.7	37345.1	37238.9	37343.9	15623.0
2023-06-02 13:00:00	YM	Futures	37343.9	37373.8	37299.7	37371.6	14645.0
2023-06-02 14:00:00	YM	Futures	37372.7	37414.7	37329.6	37400.3	12372.0
2023-06-02 15:00:00	YM	Futures	37401.4	37429.1	37361.6	37381.5	24251.0

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

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