PREVIEW / futures_1hour / 2021-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-11.parquet
  size:    59 KB
  rows:    1,815

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-11 00:00:00	ES	Futures	4394.67	4397.76	4393.27	4394.39	6320.0
2021-03-11 01:00:00	ES	Futures	4394.95	4401.69	4390.74	4401.69	8276.0
2021-03-11 02:00:00	ES	Futures	4401.69	4406.18	4397.76	4404.5	12222.0
2021-03-11 03:00:00	ES	Futures	4404.5	4407.02	4400.85	4406.46	25282.0
2021-03-11 04:00:00	ES	Futures	4406.74	4410.95	4404.78	4406.74	17241.0
2021-03-11 05:00:00	ES	Futures	4406.46	4410.95	4403.94	4408.43	10351.0
2021-03-11 06:00:00	ES	Futures	4408.43	4409.55	4402.53	4403.37	15302.0
2021-03-11 07:00:00	ES	Futures	4403.37	4408.99	4400.01	4405.62	24070.0
2021-03-11 08:00:00	ES	Futures	4405.9	4408.43	4398.04	4401.69	41761.0
2021-03-11 09:00:00	ES	Futures	4401.69	4414.04	4399.73	4413.2	182912.0
2021-03-11 10:00:00	ES	Futures	4413.48	4426.95	4402.53	4425.83	188328.0
2021-03-11 11:00:00	ES	Futures	4425.83	4439.58	4425.83	4434.81	135665.0
2021-03-11 12:00:00	ES	Futures	4435.09	4441.55	4431.44	4435.65	85314.0
2021-03-11 13:00:00	ES	Futures	4435.93	4444.07	4429.48	4431.72	92510.0
2021-03-11 14:00:00	ES	Futures	4432.0	4438.18	4425.83	4426.11	74735.0
2021-03-11 15:00:00	ES	Futures	4426.39	4428.35	4417.13	4419.37	182843.0
2021-03-11 16:00:00	ES	Futures	4419.65	4420.78	4415.44	4417.69	57011.0
2021-03-11 18:00:00	ES	Futures	4420.5	4429.48	4418.53	4424.42	7157.0
2021-03-11 19:00:00	ES	Futures	4424.71	4429.48	4423.3	4425.83	7376.0
2021-03-11 20:00:00	ES	Futures	4425.55	4428.92	4424.71	4426.11	9048.0
2021-03-11 21:00:00	ES	Futures	4426.11	4430.04	4416.29	4419.65	9936.0
2021-03-11 22:00:00	ES	Futures	4419.65	4426.11	4418.25	4425.83	4885.0
2021-03-11 23:00:00	ES	Futures	4425.83	4430.04	4424.14	4429.76	3541.0
2021-03-11 00:00:00	NQ	Futures	14864.74	14884.42	14854.03	14866.19	3861.0
2021-03-11 01:00:00	NQ	Futures	14867.34	14926.1	14846.5	14925.81	7559.0
2021-03-11 02:00:00	NQ	Futures	14925.52	14977.33	14910.76	14970.38	10568.0
2021-03-11 03:00:00	NQ	Futures	14970.09	15019.58	14930.44	15017.56	13813.0
2021-03-11 04:00:00	NQ	Futures	15017.85	15049.4	15014.66	15029.72	12510.0
2021-03-11 05:00:00	NQ	Futures	15029.72	15066.76	15002.8	15048.24	9657.0
2021-03-11 06:00:00	NQ	Futures	15047.66	15055.76	15009.17	15018.72	8893.0
2021-03-11 07:00:00	NQ	Futures	15018.72	15066.18	14984.85	15041.29	16428.0
2021-03-11 08:00:00	NQ	Futures	15041.0	15063.0	14979.06	15003.96	24087.0
2021-03-11 09:00:00	NQ	Futures	15003.96	15058.66	14970.96	15010.61	74998.0
2021-03-11 10:00:00	NQ	Futures	15010.32	15082.97	14949.25	15078.05	79060.0
2021-03-11 11:00:00	NQ	Futures	15078.34	15150.7	15077.76	15130.15	47587.0
2021-03-11 12:00:00	NQ	Futures	15131.31	15161.7	15113.36	15137.09	28514.0
2021-03-11 13:00:00	NQ	Futures	15136.81	15188.61	15116.26	15135.94	35846.0
2021-03-11 14:00:00	NQ	Futures	15135.94	15158.51	15119.15	15121.75	20455.0
2021-03-11 15:00:00	NQ	Futures	15122.62	15152.15	15096.0	15104.39	40522.0
2021-03-11 16:00:00	NQ	Futures	15104.1	15130.44	15095.42	15100.92	10308.0
2021-03-11 18:00:00	NQ	Futures	15114.23	15150.12	15104.68	15131.6	3454.0
2021-03-11 19:00:00	NQ	Futures	15131.02	15160.25	15130.15	15148.96	3624.0
2021-03-11 20:00:00	NQ	Futures	15147.8	15160.54	15127.54	15127.54	4536.0
2021-03-11 21:00:00	NQ	Futures	15127.83	15139.41	15046.21	15065.03	8912.0
2021-03-11 22:00:00	NQ	Futures	15065.03	15088.76	15048.24	15087.31	4272.0
2021-03-11 23:00:00	NQ	Futures	15087.89	15128.99	15087.31	15128.41	3720.0
2021-03-11 00:00:00	YM	Futures	35976.3	35995.3	35967.4	35970.8	92.0
2021-03-11 01:00:00	YM	Futures	35977.4	35999.7	35949.6	35997.5	117.0
2021-03-11 02:00:00	YM	Futures	35987.5	35995.3	35967.4	35987.5	211.0
2021-03-11 03:00:00	YM	Futures	35973.0	35989.7	35919.5	35948.5	228.0

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

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