PREVIEW / futures_1hour / 2021-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-17.parquet
  size:    64 KB
  rows:    1,954

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-02-17 00:00:00	ES	Futures	4407.87	4414.04	4407.87	4409.55	6152.0
2021-02-17 01:00:00	ES	Futures	4409.55	4414.6	4408.15	4413.2	5306.0
2021-02-17 02:00:00	ES	Futures	4413.2	4414.04	4406.18	4407.3	9082.0
2021-02-17 03:00:00	ES	Futures	4407.3	4414.6	4396.92	4412.08	31103.0
2021-02-17 04:00:00	ES	Futures	4412.36	4412.64	4401.97	4404.22	18900.0
2021-02-17 05:00:00	ES	Futures	4404.22	4408.71	4403.66	4405.9	14010.0
2021-02-17 06:00:00	ES	Futures	4406.18	4408.43	4403.94	4408.15	15247.0
2021-02-17 07:00:00	ES	Futures	4408.15	4412.64	4407.02	4410.95	14349.0
2021-02-17 08:00:00	ES	Futures	4410.95	4412.08	4390.46	4396.64	65236.0
2021-02-17 09:00:00	ES	Futures	4396.64	4401.69	4374.47	4394.39	279920.0
2021-02-17 10:00:00	ES	Futures	4394.39	4401.69	4382.61	4395.52	233578.0
2021-02-17 11:00:00	ES	Futures	4395.24	4396.36	4376.15	4388.5	179667.0
2021-02-17 12:00:00	ES	Futures	4388.22	4397.2	4386.25	4393.83	83657.0
2021-02-17 13:00:00	ES	Futures	4393.83	4400.29	4392.99	4396.36	68166.0
2021-02-17 14:00:00	ES	Futures	4396.64	4406.46	4396.36	4402.81	85280.0
2021-02-17 15:00:00	ES	Futures	4402.81	4412.08	4401.97	4409.83	141882.0
2021-02-17 16:00:00	ES	Futures	4409.83	4410.11	4406.74	4408.71	31205.0
2021-02-17 18:00:00	ES	Futures	4410.11	4413.2	4405.34	4412.64	7578.0
2021-02-17 19:00:00	ES	Futures	4412.92	4418.81	4412.08	4416.85	16020.0
2021-02-17 20:00:00	ES	Futures	4416.85	4417.41	4405.62	4408.99	15627.0
2021-02-17 21:00:00	ES	Futures	4408.99	4416.57	4405.62	4415.16	10885.0
2021-02-17 22:00:00	ES	Futures	4415.44	4416.57	4400.85	4404.5	14629.0
2021-02-17 23:00:00	ES	Futures	4404.5	4404.78	4394.11	4399.73	12957.0
2021-02-17 00:00:00	NQ	Futures	15924.93	15943.17	15924.64	15928.41	2995.0
2021-02-17 01:00:00	NQ	Futures	15928.41	15948.96	15925.22	15944.62	2977.0
2021-02-17 02:00:00	NQ	Futures	15944.62	15947.8	15921.17	15925.8	3740.0
2021-02-17 03:00:00	NQ	Futures	15926.38	15959.38	15894.25	15952.14	12076.0
2021-02-17 04:00:00	NQ	Futures	15952.43	15954.46	15899.17	15909.88	8721.0
2021-02-17 05:00:00	NQ	Futures	15909.88	15920.3	15900.62	15907.28	4370.0
2021-02-17 06:00:00	NQ	Futures	15907.28	15917.41	15898.02	15914.51	3741.0
2021-02-17 07:00:00	NQ	Futures	15914.51	15929.56	15900.33	15917.99	5705.0
2021-02-17 08:00:00	NQ	Futures	15917.12	15920.3	15814.37	15834.92	25636.0
2021-02-17 09:00:00	NQ	Futures	15833.76	15852.29	15757.64	15827.11	97790.0
2021-02-17 10:00:00	NQ	Futures	15827.68	15847.08	15719.44	15805.11	118032.0
2021-02-17 11:00:00	NQ	Futures	15804.82	15811.48	15679.2	15744.33	84370.0
2021-02-17 12:00:00	NQ	Futures	15744.33	15801.35	15735.35	15785.72	41711.0
2021-02-17 13:00:00	NQ	Futures	15785.14	15827.68	15778.77	15807.42	34206.0
2021-02-17 14:00:00	NQ	Futures	15808.29	15848.81	15790.06	15813.21	38559.0
2021-02-17 15:00:00	NQ	Futures	15813.79	15873.12	15811.48	15860.39	45207.0
2021-02-17 16:00:00	NQ	Futures	15860.39	15861.55	15848.81	15860.1	7817.0
2021-02-17 18:00:00	NQ	Futures	15860.39	15871.97	15840.13	15864.44	2919.0
2021-02-17 19:00:00	NQ	Futures	15865.31	15887.89	15862.42	15878.05	7730.0
2021-02-17 20:00:00	NQ	Futures	15878.05	15881.23	15814.66	15834.34	6092.0
2021-02-17 21:00:00	NQ	Futures	15834.05	15859.23	15817.84	15857.5	9072.0
2021-02-17 22:00:00	NQ	Futures	15857.5	15860.39	15796.43	15812.63	6811.0
2021-02-17 23:00:00	NQ	Futures	15812.63	15814.66	15758.8	15776.74	10943.0
2021-02-17 00:00:00	YM	Futures	34886.4	34934.1	34885.3	34903.0	1459.0
2021-02-17 01:00:00	YM	Futures	34903.0	34934.1	34893.1	34927.4	1117.0
2021-02-17 02:00:00	YM	Futures	34925.2	34928.6	34879.8	34883.1	2294.0
2021-02-17 03:00:00	YM	Futures	34882.0	34923.0	34798.8	34903.0	6616.0

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

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