PREVIEW / futures_1hour / 2021-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-26.parquet
  size:    61 KB
  rows:    1,950

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
2021-05-26 00:00:00	ES	Futures	4717.76	4718.6	4716.63	4717.47	2202.0
2021-05-26 01:00:00	ES	Futures	4717.47	4720.0	4716.91	4718.88	5040.0
2021-05-26 02:00:00	ES	Futures	4719.16	4723.09	4710.45	4721.13	15514.0
2021-05-26 03:00:00	ES	Futures	4720.85	4723.38	4714.38	4717.47	16308.0
2021-05-26 04:00:00	ES	Futures	4717.47	4720.57	4715.23	4716.63	10690.0
2021-05-26 05:00:00	ES	Futures	4716.63	4725.06	4715.51	4716.63	13298.0
2021-05-26 06:00:00	ES	Futures	4716.91	4718.88	4715.51	4716.91	6523.0
2021-05-26 07:00:00	ES	Futures	4717.19	4724.22	4716.35	4716.63	17318.0
2021-05-26 08:00:00	ES	Futures	4716.63	4721.41	4712.14	4714.67	26305.0
2021-05-26 09:00:00	ES	Futures	4714.67	4716.07	4698.93	4700.34	143924.0
2021-05-26 10:00:00	ES	Futures	4700.05	4711.86	4698.37	4711.29	148995.0
2021-05-26 11:00:00	ES	Futures	4711.29	4716.63	4709.05	4715.51	113837.0
2021-05-26 12:00:00	ES	Futures	4715.51	4718.04	4714.38	4716.63	56374.0
2021-05-26 13:00:00	ES	Futures	4716.63	4719.16	4705.96	4708.76	108483.0
2021-05-26 14:00:00	ES	Futures	4708.76	4714.38	4708.48	4710.73	76856.0
2021-05-26 15:00:00	ES	Futures	4710.45	4714.1	4707.64	4713.26	180394.0
2021-05-26 16:00:00	ES	Futures	4713.26	4713.82	4711.57	4713.26	48727.0
2021-05-26 18:00:00	ES	Futures	4712.42	4716.35	4711.57	4712.14	5524.0
2021-05-26 19:00:00	ES	Futures	4712.14	4712.42	4709.61	4712.42	4138.0
2021-05-26 20:00:00	ES	Futures	4712.42	4713.82	4706.24	4709.89	8554.0
2021-05-26 21:00:00	ES	Futures	4709.61	4710.17	4700.62	4703.43	15572.0
2021-05-26 22:00:00	ES	Futures	4703.71	4705.96	4701.18	4704.83	8036.0
2021-05-26 23:00:00	ES	Futures	4704.83	4708.48	4703.15	4707.64	5044.0
2021-05-26 00:00:00	NQ	Futures	15870.42	15875.05	15865.21	15871.58	1207.0
2021-05-26 01:00:00	NQ	Futures	15872.16	15885.76	15871.29	15879.68	2572.0
2021-05-26 02:00:00	NQ	Futures	15879.4	15884.9	15831.05	15876.79	7911.0
2021-05-26 03:00:00	NQ	Futures	15876.79	15880.84	15832.5	15860.87	8214.0
2021-05-26 04:00:00	NQ	Futures	15860.58	15872.45	15844.66	15851.6	5423.0
2021-05-26 05:00:00	NQ	Futures	15851.31	15880.26	15844.95	15850.45	5404.0
2021-05-26 06:00:00	NQ	Futures	15850.45	15868.39	15847.84	15864.63	2925.0
2021-05-26 07:00:00	NQ	Futures	15865.5	15897.34	15861.16	15877.37	7448.0
2021-05-26 08:00:00	NQ	Futures	15878.24	15892.13	15856.53	15864.92	8515.0
2021-05-26 09:00:00	NQ	Futures	15865.21	15874.47	15820.34	15830.76	53503.0
2021-05-26 10:00:00	NQ	Futures	15830.47	15879.68	15813.39	15872.16	53076.0
2021-05-26 11:00:00	NQ	Futures	15872.16	15885.19	15840.6	15879.68	37779.0
2021-05-26 12:00:00	NQ	Futures	15879.97	15893.0	15873.03	15877.66	24542.0
2021-05-26 13:00:00	NQ	Futures	15877.08	15892.42	15836.26	15848.71	33105.0
2021-05-26 14:00:00	NQ	Futures	15849.0	15877.66	15844.95	15867.24	21876.0
2021-05-26 15:00:00	NQ	Futures	15867.24	15874.47	15838.58	15866.37	38585.0
2021-05-26 16:00:00	NQ	Futures	15866.08	15875.05	15864.05	15867.53	7314.0
2021-05-26 18:00:00	NQ	Futures	15867.24	15884.32	15862.32	15869.26	3085.0
2021-05-26 19:00:00	NQ	Futures	15869.26	15873.89	15856.53	15873.32	2358.0
2021-05-26 20:00:00	NQ	Futures	15873.03	15879.97	15845.81	15857.68	3642.0
2021-05-26 21:00:00	NQ	Futures	15857.39	15859.42	15819.47	15833.08	5431.0
2021-05-26 22:00:00	NQ	Futures	15833.08	15841.18	15822.08	15833.08	2994.0
2021-05-26 23:00:00	NQ	Futures	15833.08	15844.37	15824.39	15839.44	2476.0
2021-05-26 00:00:00	YM	Futures	38267.5	38273.0	38259.7	38266.3	456.0
2021-05-26 01:00:00	YM	Futures	38266.3	38289.7	38261.9	38284.2	1090.0
2021-05-26 02:00:00	YM	Futures	38284.2	38309.8	38219.6	38293.1	3040.0
2021-05-26 03:00:00	YM	Futures	38294.2	38315.4	38248.5	38265.2	2798.0

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

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