PREVIEW / futures_1hour / 2022-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-20.parquet
  size:    57 KB
  rows:    1,619

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-05-20 00:00:00	ES	Futures	4447.18	4457.66	4445.76	4456.53	10776.0
2022-05-20 01:00:00	ES	Futures	4456.25	4459.93	4449.73	4455.4	11301.0
2022-05-20 02:00:00	ES	Futures	4455.4	4459.08	4438.96	4444.91	17135.0
2022-05-20 03:00:00	ES	Futures	4444.63	4468.43	4440.94	4462.77	25207.0
2022-05-20 04:00:00	ES	Futures	4463.05	4474.67	4455.11	4468.72	19614.0
2022-05-20 05:00:00	ES	Futures	4468.43	4477.79	4463.9	4466.45	17109.0
2022-05-20 06:00:00	ES	Futures	4466.73	4472.12	4464.18	4466.73	12494.0
2022-05-20 07:00:00	ES	Futures	4466.73	4476.65	4459.93	4470.42	17715.0
2022-05-20 08:00:00	ES	Futures	4470.42	4472.4	4454.83	4461.92	51684.0
2022-05-20 09:00:00	ES	Futures	4462.2	4470.42	4443.21	4455.96	237266.0
2022-05-20 10:00:00	ES	Futures	4455.96	4461.92	4395.59	4396.72	272037.0
2022-05-20 11:00:00	ES	Futures	4396.44	4401.26	4372.92	4381.14	264107.0
2022-05-20 12:00:00	ES	Futures	4381.14	4383.12	4332.1	4344.57	266655.0
2022-05-20 13:00:00	ES	Futures	4344.29	4357.04	4316.79	4350.24	268729.0
2022-05-20 14:00:00	ES	Futures	4350.24	4365.55	4325.58	4350.52	234251.0
2022-05-20 15:00:00	ES	Futures	4350.81	4423.65	4336.92	4419.68	432156.0
2022-05-20 16:00:00	ES	Futures	4419.68	4427.34	4412.03	4423.93	93953.0
2022-05-20 00:00:00	NQ	Futures	13897.92	13937.36	13890.96	13932.14	4852.0
2022-05-20 01:00:00	NQ	Futures	13931.56	13948.38	13904.59	13938.52	5330.0
2022-05-20 02:00:00	NQ	Futures	13939.39	13955.34	13877.05	13901.98	8724.0
2022-05-20 03:00:00	NQ	Futures	13901.98	13994.78	13887.77	13980.86	12720.0
2022-05-20 04:00:00	NQ	Futures	13978.54	14020.87	13955.05	13994.49	10238.0
2022-05-20 05:00:00	NQ	Futures	13994.2	14031.02	13968.39	13981.15	8504.0
2022-05-20 06:00:00	NQ	Futures	13982.02	14003.47	13963.17	13971.29	7046.0
2022-05-20 07:00:00	NQ	Futures	13971.87	14017.68	13946.64	13991.3	9475.0
2022-05-20 08:00:00	NQ	Futures	13990.72	13995.36	13927.79	13954.47	14834.0
2022-05-20 09:00:00	NQ	Futures	13954.47	13980.28	13855.3	13913.29	91288.0
2022-05-20 10:00:00	NQ	Futures	13913.87	13931.56	13679.86	13689.14	100470.0
2022-05-20 11:00:00	NQ	Futures	13690.01	13708.28	13586.78	13610.56	86649.0
2022-05-20 12:00:00	NQ	Futures	13610.27	13621.58	13378.29	13427.29	98864.0
2022-05-20 13:00:00	NQ	Futures	13427.0	13496.6	13328.7	13467.31	90824.0
2022-05-20 14:00:00	NQ	Futures	13467.6	13503.56	13360.6	13441.5	74930.0
2022-05-20 15:00:00	NQ	Futures	13441.79	13741.63	13391.92	13728.0	118503.0
2022-05-20 16:00:00	NQ	Futures	13726.26	13750.62	13686.82	13730.9	24710.0
2022-05-20 00:00:00	YM	Futures	35349.7	35419.6	35338.4	35412.8	834.0
2022-05-20 01:00:00	YM	Futures	35410.6	35433.1	35368.9	35398.2	1323.0
2022-05-20 02:00:00	YM	Futures	35399.3	35424.1	35285.5	35326.0	2701.0
2022-05-20 03:00:00	YM	Futures	35327.2	35497.4	35300.1	35459.1	3966.0
2022-05-20 04:00:00	YM	Futures	35456.8	35530.1	35391.4	35491.8	4463.0
2022-05-20 05:00:00	YM	Futures	35490.6	35565.0	35460.2	35477.1	3547.0
2022-05-20 06:00:00	YM	Futures	35478.2	35519.9	35463.6	35496.3	2134.0
2022-05-20 07:00:00	YM	Futures	35495.1	35536.8	35441.0	35494.0	3332.0
2022-05-20 08:00:00	YM	Futures	35491.8	35510.9	35389.2	35437.6	5698.0
2022-05-20 09:00:00	YM	Futures	35436.5	35494.0	35296.7	35366.6	27755.0
2022-05-20 10:00:00	YM	Futures	35364.4	35410.6	34956.3	34965.3	27558.0
2022-05-20 11:00:00	YM	Futures	34965.3	35007.0	34836.8	34927.0	21823.0
2022-05-20 12:00:00	YM	Futures	34925.8	34939.4	34626.0	34697.0	21286.0
2022-05-20 13:00:00	YM	Futures	34693.6	34751.1	34479.4	34699.2	21013.0
2022-05-20 14:00:00	YM	Futures	34703.8	34831.1	34542.5	34738.7	21526.0
2022-05-20 15:00:00	YM	Futures	34737.6	35205.4	34627.1	35176.1	33188.0

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

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