PREVIEW / futures_1hour / 2022-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-11-17.parquet
  size:    69 KB
  rows:    2,068

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
2022-11-17 00:00:00	ES	Futures	4476.75	4484.93	4476.47	4480.42	5472.0
2022-11-17 01:00:00	ES	Futures	4480.42	4495.36	4480.13	4493.1	9218.0
2022-11-17 02:00:00	ES	Futures	4493.1	4498.46	4487.75	4491.97	13314.0
2022-11-17 03:00:00	ES	Futures	4491.97	4499.3	4483.52	4483.52	17872.0
2022-11-17 04:00:00	ES	Futures	4483.52	4485.21	4462.09	4466.32	26016.0
2022-11-17 05:00:00	ES	Futures	4466.6	4473.65	4448.84	4449.13	22418.0
2022-11-17 06:00:00	ES	Futures	4449.13	4454.76	4438.13	4449.97	28785.0
2022-11-17 07:00:00	ES	Futures	4449.97	4452.23	4433.62	4435.31	36621.0
2022-11-17 08:00:00	ES	Futures	4435.03	4436.16	4414.17	4415.3	85302.0
2022-11-17 09:00:00	ES	Futures	4415.3	4431.09	4411.63	4415.86	205372.0
2022-11-17 10:00:00	ES	Futures	4415.58	4436.72	4413.04	4417.84	194409.0
2022-11-17 11:00:00	ES	Futures	4417.84	4448.0	4415.02	4447.15	159684.0
2022-11-17 12:00:00	ES	Futures	4447.44	4463.22	4442.64	4460.12	145539.0
2022-11-17 13:00:00	ES	Futures	4459.84	4468.01	4453.64	4459.56	116397.0
2022-11-17 14:00:00	ES	Futures	4459.56	4464.63	4440.11	4447.15	143162.0
2022-11-17 15:00:00	ES	Futures	4447.44	4461.81	4429.96	4460.68	218414.0
2022-11-17 16:00:00	ES	Futures	4460.4	4467.45	4456.74	4466.32	46146.0
2022-11-17 18:00:00	ES	Futures	4465.76	4473.09	4457.3	4457.87	8987.0
2022-11-17 19:00:00	ES	Futures	4458.15	4464.63	4456.74	4464.63	9085.0
2022-11-17 20:00:00	ES	Futures	4464.35	4467.45	4458.71	4462.09	9158.0
2022-11-17 21:00:00	ES	Futures	4462.09	4466.04	4460.12	4460.97	6756.0
2022-11-17 22:00:00	ES	Futures	4460.97	4466.6	4459.27	4463.5	5607.0
2022-11-17 23:00:00	ES	Futures	4463.79	4463.79	4457.58	4459.56	4419.0
2022-11-17 00:00:00	NQ	Futures	13502.88	13535.35	13502.88	13518.68	2835.0
2022-11-17 01:00:00	NQ	Futures	13518.11	13566.38	13517.25	13559.77	4208.0
2022-11-17 02:00:00	NQ	Futures	13559.48	13587.93	13541.38	13564.94	7206.0
2022-11-17 03:00:00	NQ	Futures	13565.52	13593.39	13531.33	13531.9	9427.0
2022-11-17 04:00:00	NQ	Futures	13532.76	13537.36	13462.65	13476.45	12899.0
2022-11-17 05:00:00	NQ	Futures	13476.16	13503.74	13407.2	13410.07	12638.0
2022-11-17 06:00:00	NQ	Futures	13410.36	13434.5	13380.48	13427.89	15011.0
2022-11-17 07:00:00	NQ	Futures	13428.46	13433.92	13357.78	13364.96	16230.0
2022-11-17 08:00:00	NQ	Futures	13364.96	13371.28	13281.06	13286.52	38567.0
2022-11-17 09:00:00	NQ	Futures	13287.1	13372.43	13249.46	13319.28	87515.0
2022-11-17 10:00:00	NQ	Futures	13318.7	13415.53	13298.59	13338.82	83679.0
2022-11-17 11:00:00	NQ	Futures	13338.82	13459.21	13329.62	13456.62	79078.0
2022-11-17 12:00:00	NQ	Futures	13456.91	13522.42	13424.73	13502.59	59888.0
2022-11-17 13:00:00	NQ	Futures	13502.59	13533.05	13478.17	13500.01	47712.0
2022-11-17 14:00:00	NQ	Futures	13500.01	13512.07	13405.76	13427.6	59561.0
2022-11-17 15:00:00	NQ	Futures	13428.18	13465.24	13361.23	13460.93	73911.0
2022-11-17 16:00:00	NQ	Futures	13460.93	13502.02	13453.17	13500.29	17229.0
2022-11-17 18:00:00	NQ	Futures	13501.73	13516.38	13467.54	13469.26	4176.0
2022-11-17 19:00:00	NQ	Futures	13470.12	13493.11	13464.38	13491.1	3773.0
2022-11-17 20:00:00	NQ	Futures	13492.54	13504.03	13466.96	13482.48	4476.0
2022-11-17 21:00:00	NQ	Futures	13481.91	13500.87	13476.73	13479.03	3795.0
2022-11-17 22:00:00	NQ	Futures	13479.32	13503.17	13473.0	13492.82	2345.0
2022-11-17 23:00:00	NQ	Futures	13492.82	13493.11	13470.41	13475.87	2829.0
2022-11-17 00:00:00	YM	Futures	37700.3	37758.7	37698.1	37732.9	1746.0
2022-11-17 01:00:00	YM	Futures	37731.7	37841.7	37730.6	37818.2	2083.0
2022-11-17 02:00:00	YM	Futures	37818.2	37850.7	37785.6	37805.8	2623.0
2022-11-17 03:00:00	YM	Futures	37804.7	37855.2	37758.7	37759.8	3343.0

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

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