PREVIEW / futures_1hour / 2021-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-18.parquet
  size:    64 KB
  rows:    1,925

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-03-18 00:00:00	ES	Futures	4455.89	4458.98	4453.08	4458.14	6217.0
2021-03-18 01:00:00	ES	Futures	4458.14	4458.7	4453.36	4456.45	7504.0
2021-03-18 02:00:00	ES	Futures	4456.74	4464.32	4455.33	4463.2	6559.0
2021-03-18 03:00:00	ES	Futures	4463.2	4464.04	4439.32	4442.13	34283.0
2021-03-18 04:00:00	ES	Futures	4441.84	4444.37	4428.36	4431.45	37389.0
2021-03-18 05:00:00	ES	Futures	4431.17	4438.47	4430.32	4434.26	18989.0
2021-03-18 06:00:00	ES	Futures	4434.54	4442.41	4432.85	4437.63	17884.0
2021-03-18 07:00:00	ES	Futures	4437.63	4439.6	4419.65	4423.86	45125.0
2021-03-18 08:00:00	ES	Futures	4423.86	4430.04	4421.33	4426.11	50843.0
2021-03-18 09:00:00	ES	Futures	4425.83	4433.98	4417.96	4431.73	258404.0
2021-03-18 10:00:00	ES	Futures	4432.01	4435.94	4419.93	4431.73	252452.0
2021-03-18 11:00:00	ES	Futures	4432.01	4440.72	4430.32	4440.16	164996.0
2021-03-18 12:00:00	ES	Futures	4439.88	4449.15	4423.3	4426.39	168573.0
2021-03-18 13:00:00	ES	Futures	4426.11	4442.41	4425.55	4441.28	109582.0
2021-03-18 14:00:00	ES	Futures	4441.28	4442.13	4398.29	4411.22	266419.0
2021-03-18 15:00:00	ES	Futures	4411.22	4414.03	4383.68	4389.86	376189.0
2021-03-18 16:00:00	ES	Futures	4389.86	4402.23	4389.3	4394.92	74950.0
2021-03-18 18:00:00	ES	Futures	4395.2	4401.67	4389.86	4389.86	10952.0
2021-03-18 19:00:00	ES	Futures	4390.15	4397.17	4389.3	4394.36	8388.0
2021-03-18 20:00:00	ES	Futures	4393.8	4401.95	4392.39	4400.82	13334.0
2021-03-18 21:00:00	ES	Futures	4400.82	4404.48	4396.05	4403.63	11565.0
2021-03-18 22:00:00	ES	Futures	4403.35	4403.35	4392.39	4393.8	11064.0
2021-03-18 23:00:00	ES	Futures	4393.8	4401.67	4391.27	4393.24	13399.0
2021-03-18 00:00:00	NQ	Futures	15261.61	15281.88	15245.4	15277.53	3679.0
2021-03-18 01:00:00	NQ	Futures	15277.82	15289.69	15257.27	15280.43	3807.0
2021-03-18 02:00:00	NQ	Futures	15280.14	15318.64	15275.51	15300.69	4354.0
2021-03-18 03:00:00	NQ	Futures	15298.67	15305.91	15095.44	15131.34	22386.0
2021-03-18 04:00:00	NQ	Futures	15130.76	15157.68	15061.57	15069.68	19612.0
2021-03-18 05:00:00	NQ	Futures	15069.39	15119.18	15056.94	15097.47	12242.0
2021-03-18 06:00:00	NQ	Futures	15096.6	15124.39	15081.55	15100.36	8684.0
2021-03-18 07:00:00	NQ	Futures	15100.65	15107.31	14996.43	15022.49	23931.0
2021-03-18 08:00:00	NQ	Futures	15023.07	15049.41	15001.65	15020.17	20952.0
2021-03-18 09:00:00	NQ	Futures	15019.3	15079.52	14976.46	15048.25	82979.0
2021-03-18 10:00:00	NQ	Futures	15047.96	15048.54	14955.04	15014.09	97788.0
2021-03-18 11:00:00	NQ	Futures	15014.09	15040.15	14970.09	14999.62	57462.0
2021-03-18 12:00:00	NQ	Futures	14999.33	15063.6	14933.32	14938.54	59400.0
2021-03-18 13:00:00	NQ	Futures	14938.25	15029.15	14935.06	15019.88	43616.0
2021-03-18 14:00:00	NQ	Futures	15020.17	15025.09	14847.63	14874.27	72860.0
2021-03-18 15:00:00	NQ	Futures	14874.85	14891.64	14778.16	14801.31	81160.0
2021-03-18 16:00:00	NQ	Futures	14801.6	14851.69	14791.18	14810.58	16166.0
2021-03-18 18:00:00	NQ	Futures	14814.63	14848.21	14801.31	14803.34	5295.0
2021-03-18 19:00:00	NQ	Futures	14802.18	14816.66	14791.47	14803.92	4062.0
2021-03-18 20:00:00	NQ	Futures	14802.47	14842.71	14793.21	14832.58	5844.0
2021-03-18 21:00:00	NQ	Futures	14833.45	14845.03	14792.34	14839.53	7029.0
2021-03-18 22:00:00	NQ	Futures	14840.4	14840.4	14766.29	14785.68	7398.0
2021-03-18 23:00:00	NQ	Futures	14785.68	14841.55	14780.18	14791.76	6055.0
2021-03-18 00:00:00	YM	Futures	36731.5	36749.3	36713.7	36739.3	1722.0
2021-03-18 01:00:00	YM	Futures	36738.2	36748.2	36705.9	36722.6	2042.0
2021-03-18 02:00:00	YM	Futures	36725.9	36782.7	36709.2	36780.5	1690.0
2021-03-18 03:00:00	YM	Futures	36779.4	36790.5	36692.5	36705.9	6442.0

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

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