PREVIEW / futures_1hour / 2021-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-28.parquet
  size:    52 KB
  rows:    1,567

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-28 00:00:00	ES	Futures	4735.74	4735.74	4733.21	4734.9	2891.0
2021-05-28 01:00:00	ES	Futures	4734.9	4736.58	4729.84	4730.68	8967.0
2021-05-28 02:00:00	ES	Futures	4730.96	4731.52	4727.87	4731.24	8421.0
2021-05-28 03:00:00	ES	Futures	4730.96	4733.49	4728.99	4733.21	10872.0
2021-05-28 04:00:00	ES	Futures	4733.21	4736.58	4733.21	4736.58	10801.0
2021-05-28 05:00:00	ES	Futures	4736.58	4737.99	4734.05	4737.14	8741.0
2021-05-28 06:00:00	ES	Futures	4736.86	4739.11	4734.9	4738.83	13371.0
2021-05-28 07:00:00	ES	Futures	4738.83	4739.67	4734.61	4734.9	13847.0
2021-05-28 08:00:00	ES	Futures	4735.18	4735.74	4728.99	4730.4	31819.0
2021-05-28 09:00:00	ES	Futures	4730.68	4736.02	4727.31	4733.21	128941.0
2021-05-28 10:00:00	ES	Futures	4733.49	4735.46	4723.09	4728.43	148882.0
2021-05-28 11:00:00	ES	Futures	4728.71	4735.18	4727.31	4734.05	79725.0
2021-05-28 12:00:00	ES	Futures	4734.33	4737.7	4732.65	4733.49	67537.0
2021-05-28 13:00:00	ES	Futures	4733.49	4734.9	4729.56	4731.24	68354.0
2021-05-28 14:00:00	ES	Futures	4731.52	4733.49	4728.71	4732.09	69409.0
2021-05-28 15:00:00	ES	Futures	4732.37	4734.33	4721.41	4724.22	260899.0
2021-05-28 16:00:00	ES	Futures	4723.94	4727.59	4723.09	4723.94	57429.0
2021-05-28 00:00:00	NQ	Futures	15864.63	15866.37	15853.05	15859.42	1547.0
2021-05-28 01:00:00	NQ	Futures	15860.29	15866.66	15831.92	15836.26	3256.0
2021-05-28 02:00:00	NQ	Futures	15835.39	15836.84	15821.21	15836.55	3651.0
2021-05-28 03:00:00	NQ	Futures	15835.68	15854.21	15825.84	15847.84	4605.0
2021-05-28 04:00:00	NQ	Futures	15847.55	15864.63	15847.55	15861.16	4304.0
2021-05-28 05:00:00	NQ	Futures	15861.45	15881.13	15854.79	15875.92	4374.0
2021-05-28 06:00:00	NQ	Futures	15876.21	15894.45	15870.42	15894.16	5392.0
2021-05-28 07:00:00	NQ	Futures	15893.58	15893.87	15874.76	15880.55	5119.0
2021-05-28 08:00:00	NQ	Futures	15880.26	15881.71	15841.18	15849.0	11909.0
2021-05-28 09:00:00	NQ	Futures	15849.29	15910.37	15845.81	15890.69	57728.0
2021-05-28 10:00:00	NQ	Futures	15890.11	15901.98	15857.97	15881.42	57120.0
2021-05-28 11:00:00	NQ	Futures	15881.71	15922.24	15873.61	15921.08	34288.0
2021-05-28 12:00:00	NQ	Futures	15921.08	15937.87	15919.35	15929.77	28202.0
2021-05-28 13:00:00	NQ	Futures	15929.77	15935.56	15872.16	15883.45	34705.0
2021-05-28 14:00:00	NQ	Futures	15883.16	15908.92	15872.74	15901.11	24615.0
2021-05-28 15:00:00	NQ	Futures	15901.69	15902.55	15843.5	15853.34	54390.0
2021-05-28 16:00:00	NQ	Futures	15853.63	15863.76	15848.71	15848.71	10065.0
2021-05-28 00:00:00	YM	Futures	38551.5	38551.5	38531.4	38548.1	559.0
2021-05-28 01:00:00	YM	Futures	38548.1	38555.9	38511.4	38520.3	1583.0
2021-05-28 02:00:00	YM	Futures	38519.2	38542.6	38493.6	38531.4	2019.0
2021-05-28 03:00:00	YM	Futures	38532.5	38550.4	38515.8	38540.3	2058.0
2021-05-28 04:00:00	YM	Futures	38539.2	38579.3	38538.1	38571.5	2912.0
2021-05-28 05:00:00	YM	Futures	38571.5	38581.6	38533.7	38553.7	2487.0
2021-05-28 06:00:00	YM	Futures	38552.6	38563.7	38525.9	38558.2	2004.0
2021-05-28 07:00:00	YM	Futures	38557.1	38571.5	38529.2	38530.3	1953.0
2021-05-28 08:00:00	YM	Futures	38530.3	38547.0	38495.8	38505.8	4303.0
2021-05-28 09:00:00	YM	Futures	38506.9	38558.2	38462.4	38508.0	19945.0
2021-05-28 10:00:00	YM	Futures	38511.4	38522.5	38421.2	38479.1	16602.0
2021-05-28 11:00:00	YM	Futures	38479.1	38511.4	38462.4	38485.8	7511.0
2021-05-28 12:00:00	YM	Futures	38484.7	38524.7	38476.9	38494.7	6495.0
2021-05-28 13:00:00	YM	Futures	38494.7	38504.7	38460.1	38494.7	6655.0
2021-05-28 14:00:00	YM	Futures	38496.9	38505.8	38462.4	38492.4	6075.0
2021-05-28 15:00:00	YM	Futures	38492.4	38515.8	38431.2	38452.4	14962.0

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

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