PREVIEW / futures_1hour / 2023-03-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	4457.62	4461.23	4456.79	4460.4	6667.0
2023-03-29 01:00:00	ES	Futures	4460.67	4470.38	4459.57	4470.38	14575.0
2023-03-29 02:00:00	ES	Futures	4470.38	4470.38	4464.28	4469.0	13288.0
2023-03-29 03:00:00	ES	Futures	4468.72	4476.48	4468.72	4474.26	28721.0
2023-03-29 04:00:00	ES	Futures	4474.26	4479.53	4470.66	4477.32	19494.0
2023-03-29 05:00:00	ES	Futures	4477.04	4482.31	4476.48	4481.2	15187.0
2023-03-29 06:00:00	ES	Futures	4481.2	4481.75	4476.48	4477.32	14445.0
2023-03-29 07:00:00	ES	Futures	4477.32	4479.26	4474.26	4474.54	16017.0
2023-03-29 08:00:00	ES	Futures	4474.82	4478.43	4472.6	4477.59	23454.0
2023-03-29 09:00:00	ES	Futures	4477.59	4489.24	4477.59	4485.91	175741.0
2023-03-29 10:00:00	ES	Futures	4485.64	4490.63	4473.16	4474.26	196638.0
2023-03-29 11:00:00	ES	Futures	4474.26	4486.75	4473.43	4486.47	115557.0
2023-03-29 12:00:00	ES	Futures	4486.47	4489.24	4481.75	4483.69	82962.0
2023-03-29 13:00:00	ES	Futures	4483.97	4492.57	4480.64	4482.86	107259.0
2023-03-29 14:00:00	ES	Futures	4482.86	4495.62	4478.98	4494.79	115790.0
2023-03-29 15:00:00	ES	Futures	4494.79	4505.61	4488.96	4502.83	277870.0
2023-03-29 16:00:00	ES	Futures	4502.55	4504.77	4500.06	4502.0	61087.0
2023-03-29 18:00:00	ES	Futures	4502.0	4503.94	4499.23	4500.89	4551.0
2023-03-29 19:00:00	ES	Futures	4500.89	4501.45	4497.01	4497.29	5273.0
2023-03-29 20:00:00	ES	Futures	4497.29	4499.78	4495.9	4498.95	9049.0
2023-03-29 21:00:00	ES	Futures	4498.95	4500.89	4496.45	4499.5	6633.0
2023-03-29 22:00:00	ES	Futures	4499.5	4503.94	4497.56	4497.84	7178.0
2023-03-29 23:00:00	ES	Futures	4497.84	4499.78	4497.01	4499.5	4154.0
2023-03-29 00:00:00	NQ	Futures	14386.23	14402.84	14384.26	14400.03	3350.0
2023-03-29 01:00:00	NQ	Futures	14399.47	14433.53	14396.93	14433.53	6340.0
2023-03-29 02:00:00	NQ	Futures	14433.53	14439.73	14417.49	14436.63	7408.0
2023-03-29 03:00:00	NQ	Futures	14436.91	14479.15	14435.5	14461.69	12705.0
2023-03-29 04:00:00	NQ	Futures	14461.13	14472.67	14446.49	14460.28	8477.0
2023-03-29 05:00:00	NQ	Futures	14460.0	14478.58	14458.87	14474.08	6267.0
2023-03-29 06:00:00	NQ	Futures	14473.8	14475.77	14452.68	14455.49	6587.0
2023-03-29 07:00:00	NQ	Futures	14454.65	14475.49	14449.58	14460.0	7573.0
2023-03-29 08:00:00	NQ	Futures	14460.28	14484.21	14452.4	14475.77	13333.0
2023-03-29 09:00:00	NQ	Futures	14475.49	14559.67	14474.36	14545.59	81617.0
2023-03-29 10:00:00	NQ	Futures	14544.75	14565.02	14476.89	14483.65	75484.0
2023-03-29 11:00:00	NQ	Futures	14483.93	14548.69	14481.96	14547.28	60457.0
2023-03-29 12:00:00	NQ	Futures	14547.56	14562.49	14517.44	14526.16	47105.0
2023-03-29 13:00:00	NQ	Futures	14526.73	14569.81	14516.59	14537.15	52075.0
2023-03-29 14:00:00	NQ	Futures	14537.15	14588.11	14521.66	14583.04	51476.0
2023-03-29 15:00:00	NQ	Futures	14583.04	14634.0	14566.71	14605.84	81389.0
2023-03-29 16:00:00	NQ	Futures	14605.56	14606.41	14592.33	14595.99	13078.0
2023-03-29 18:00:00	NQ	Futures	14598.52	14605.84	14585.01	14590.36	2739.0
2023-03-29 19:00:00	NQ	Futures	14590.92	14595.99	14573.75	14576.56	2788.0
2023-03-29 20:00:00	NQ	Futures	14577.13	14584.45	14563.61	14580.22	3941.0
2023-03-29 21:00:00	NQ	Futures	14580.5	14587.26	14568.96	14580.5	3329.0
2023-03-29 22:00:00	NQ	Futures	14581.07	14597.12	14570.37	14571.49	4234.0
2023-03-29 23:00:00	NQ	Futures	14571.49	14578.82	14567.55	14576.56	2376.0
2023-03-29 00:00:00	YM	Futures	36148.0	36162.4	36141.4	36158.0	1604.0
2023-03-29 01:00:00	YM	Futures	36158.0	36219.9	36146.9	36219.9	2315.0
2023-03-29 02:00:00	YM	Futures	36219.9	36222.1	36137.0	36188.9	3364.0
2023-03-29 03:00:00	YM	Futures	36190.0	36227.6	36166.8	36208.8	7415.0

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

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