PREVIEW / futures_1hour / 2022-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-02.parquet
  size:    57 KB
  rows:    1,642

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-09-02 00:00:00	ES	Futures	4492.12	4498.92	4492.12	4498.35	5848.0
2022-09-02 01:00:00	ES	Futures	4498.35	4499.2	4485.6	4488.15	6817.0
2022-09-02 02:00:00	ES	Futures	4488.15	4501.18	4481.64	4500.62	15456.0
2022-09-02 03:00:00	ES	Futures	4500.62	4501.47	4484.47	4488.44	19337.0
2022-09-02 04:00:00	ES	Futures	4488.15	4503.73	4487.87	4501.47	16088.0
2022-09-02 05:00:00	ES	Futures	4501.18	4501.18	4494.39	4499.48	9575.0
2022-09-02 06:00:00	ES	Futures	4499.48	4501.18	4487.02	4493.54	15103.0
2022-09-02 07:00:00	ES	Futures	4493.54	4499.2	4487.02	4496.65	20694.0
2022-09-02 08:00:00	ES	Futures	4496.65	4534.61	4492.97	4527.81	146360.0
2022-09-02 09:00:00	ES	Futures	4527.53	4542.82	4509.12	4513.65	279985.0
2022-09-02 10:00:00	ES	Futures	4513.93	4554.16	4502.03	4540.56	343752.0
2022-09-02 11:00:00	ES	Futures	4540.28	4551.89	4536.88	4549.34	183425.0
2022-09-02 12:00:00	ES	Futures	4549.62	4552.17	4488.44	4496.65	306616.0
2022-09-02 13:00:00	ES	Futures	4496.93	4496.93	4447.36	4449.06	339651.0
2022-09-02 14:00:00	ES	Futures	4449.06	4467.76	4447.93	4451.61	219131.0
2022-09-02 15:00:00	ES	Futures	4451.61	4468.04	4425.83	4447.93	379621.0
2022-09-02 16:00:00	ES	Futures	4448.21	4457.84	4446.51	4456.71	85735.0
2022-09-02 00:00:00	NQ	Futures	14203.66	14245.89	14203.66	14232.01	4151.0
2022-09-02 01:00:00	NQ	Futures	14232.01	14238.37	14181.39	14191.8	4778.0
2022-09-02 02:00:00	NQ	Futures	14192.38	14248.2	14166.06	14245.31	8884.0
2022-09-02 03:00:00	NQ	Futures	14245.31	14247.63	14181.97	14200.77	11643.0
2022-09-02 04:00:00	NQ	Futures	14199.9	14246.76	14198.17	14235.77	8867.0
2022-09-02 05:00:00	NQ	Futures	14234.9	14235.48	14199.9	14216.39	5272.0
2022-09-02 06:00:00	NQ	Futures	14216.97	14223.04	14161.72	14184.28	8843.0
2022-09-02 07:00:00	NQ	Futures	14183.7	14214.94	14162.3	14202.22	9332.0
2022-09-02 08:00:00	NQ	Futures	14201.64	14351.17	14152.47	14305.47	53038.0
2022-09-02 09:00:00	NQ	Futures	14305.47	14370.55	14221.02	14240.4	96902.0
2022-09-02 10:00:00	NQ	Futures	14240.4	14417.41	14198.74	14342.79	123802.0
2022-09-02 11:00:00	NQ	Futures	14343.65	14387.04	14322.54	14367.66	72351.0
2022-09-02 12:00:00	NQ	Futures	14367.95	14374.89	14114.0	14155.36	96981.0
2022-09-02 13:00:00	NQ	Futures	14155.94	14156.52	13981.82	13983.55	101805.0
2022-09-02 14:00:00	NQ	Futures	13984.13	14063.09	13977.77	14005.82	74212.0
2022-09-02 15:00:00	NQ	Futures	14006.11	14067.43	13930.04	14011.03	99676.0
2022-09-02 16:00:00	NQ	Futures	14011.32	14042.27	14003.8	14034.17	20209.0
2022-09-02 00:00:00	YM	Futures	35685.0	35723.4	35683.9	35717.7	829.0
2022-09-02 01:00:00	YM	Futures	35718.8	35725.6	35636.5	35651.1	1165.0
2022-09-02 02:00:00	YM	Futures	35652.3	35732.4	35610.5	35725.6	2322.0
2022-09-02 03:00:00	YM	Futures	35725.6	35732.4	35624.1	35645.5	2454.0
2022-09-02 04:00:00	YM	Futures	35646.6	35764.0	35643.2	35751.6	2343.0
2022-09-02 05:00:00	YM	Futures	35751.6	35752.7	35707.6	35749.3	1667.0
2022-09-02 06:00:00	YM	Futures	35749.3	35765.1	35673.7	35721.1	2079.0
2022-09-02 07:00:00	YM	Futures	35718.8	35741.4	35662.4	35722.2	2891.0
2022-09-02 08:00:00	YM	Futures	35723.4	35970.5	35704.2	35940.0	15922.0
2022-09-02 09:00:00	YM	Futures	35941.1	36054.0	35792.2	35861.0	32788.0
2022-09-02 10:00:00	YM	Futures	35863.3	36099.1	35773.0	36034.8	24514.0
2022-09-02 11:00:00	YM	Futures	36034.8	36139.7	36019.0	36111.5	13617.0
2022-09-02 12:00:00	YM	Futures	36113.8	36132.9	35691.8	35744.8	19010.0
2022-09-02 13:00:00	YM	Futures	35747.1	35747.1	35378.1	35405.2	27820.0
2022-09-02 14:00:00	YM	Futures	35407.4	35538.3	35390.5	35400.7	16538.0
2022-09-02 15:00:00	YM	Futures	35396.1	35505.6	35184.0	35347.6	26243.0

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

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