PREVIEW / futures_1hour / 2021-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-12.parquet
  size:    51 KB
  rows:    1,494

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-12 00:00:00	ES	Futures	4429.76	4430.6	4420.21	4421.34	4928.0
2021-03-12 01:00:00	ES	Futures	4421.62	4423.3	4416.85	4417.13	7964.0
2021-03-12 02:00:00	ES	Futures	4417.41	4418.25	4402.53	4406.46	18229.0
2021-03-12 03:00:00	ES	Futures	4406.46	4408.43	4391.31	4394.39	25136.0
2021-03-12 04:00:00	ES	Futures	4394.39	4400.01	4390.46	4394.39	13065.0
2021-03-12 05:00:00	ES	Futures	4394.67	4399.73	4389.9	4395.52	12010.0
2021-03-12 06:00:00	ES	Futures	4395.8	4400.01	4391.03	4395.8	10606.0
2021-03-12 07:00:00	ES	Futures	4395.8	4409.27	4394.39	4408.99	16761.0
2021-03-12 08:00:00	ES	Futures	4408.71	4412.08	4401.69	4402.25	25452.0
2021-03-12 09:00:00	ES	Futures	4402.25	4413.2	4394.67	4412.64	107533.0
2021-03-12 10:00:00	ES	Futures	4412.64	4415.16	4394.95	4401.41	122680.0
2021-03-12 11:00:00	ES	Futures	4401.13	4410.95	4393.83	4407.87	85969.0
2021-03-12 12:00:00	ES	Futures	4408.15	4417.41	4403.66	4409.27	44717.0
2021-03-12 13:00:00	ES	Futures	4408.99	4416.0	4405.9	4411.23	33516.0
2021-03-12 14:00:00	ES	Futures	4411.51	4419.93	4410.11	4418.53	45749.0
2021-03-12 15:00:00	ES	Futures	4418.53	4428.07	4412.08	4426.67	87544.0
2021-03-12 16:00:00	ES	Futures	4426.67	4431.72	4424.71	4425.27	32493.0
2021-03-12 00:00:00	NQ	Futures	15128.12	15129.86	15052.87	15068.21	6597.0
2021-03-12 01:00:00	NQ	Futures	15067.63	15076.02	15000.77	15021.9	9580.0
2021-03-12 02:00:00	NQ	Futures	15021.03	15027.11	14918.57	14935.07	17914.0
2021-03-12 03:00:00	NQ	Futures	14935.07	14939.41	14848.82	14855.77	16106.0
2021-03-12 04:00:00	NQ	Futures	14854.9	14874.0	14824.22	14835.79	10391.0
2021-03-12 05:00:00	NQ	Futures	14835.79	14874.58	14802.51	14853.45	9786.0
2021-03-12 06:00:00	NQ	Futures	14852.87	14883.26	14830.87	14848.82	8559.0
2021-03-12 07:00:00	NQ	Futures	14849.98	14932.47	14849.98	14926.97	11327.0
2021-03-12 08:00:00	NQ	Futures	14926.1	14933.62	14865.61	14871.68	15668.0
2021-03-12 09:00:00	NQ	Futures	14871.68	14928.7	14816.69	14922.34	53489.0
2021-03-12 10:00:00	NQ	Futures	14922.62	14941.15	14784.28	14809.75	68054.0
2021-03-12 11:00:00	NQ	Futures	14810.32	14909.31	14782.25	14887.6	38791.0
2021-03-12 12:00:00	NQ	Futures	14887.89	14965.17	14868.21	14904.68	26820.0
2021-03-12 13:00:00	NQ	Futures	14903.81	14946.07	14881.52	14914.81	17464.0
2021-03-12 14:00:00	NQ	Futures	14915.1	14961.99	14899.76	14946.07	16318.0
2021-03-12 15:00:00	NQ	Futures	14945.49	14985.43	14909.02	14977.91	27788.0
2021-03-12 16:00:00	NQ	Futures	14977.91	14988.33	14969.8	14976.75	5838.0
2021-03-12 00:00:00	YM	Futures	36172.4	36175.7	36123.4	36131.2	785.0
2021-03-12 01:00:00	YM	Futures	36131.2	36150.1	36110.0	36131.2	1857.0
2021-03-12 02:00:00	YM	Futures	36133.4	36146.7	36039.8	36077.7	3411.0
2021-03-12 03:00:00	YM	Futures	36077.7	36094.4	35966.3	35991.9	4877.0
2021-03-12 04:00:00	YM	Futures	35989.7	36037.6	35952.9	36033.1	3437.0
2021-03-12 05:00:00	YM	Futures	36035.4	36063.2	35999.7	36046.5	2585.0
2021-03-12 06:00:00	YM	Futures	36048.7	36052.1	36010.9	36034.3	1765.0
2021-03-12 07:00:00	YM	Futures	36036.5	36128.9	36025.3	36128.9	2674.0
2021-03-12 08:00:00	YM	Futures	36126.7	36171.3	36089.9	36094.4	3974.0
2021-03-12 09:00:00	YM	Futures	36094.4	36219.1	36066.6	36213.6	22176.0
2021-03-12 10:00:00	YM	Futures	36212.5	36273.7	36152.3	36230.3	20135.0
2021-03-12 11:00:00	YM	Futures	36229.2	36252.6	36169.0	36229.2	11917.0
2021-03-12 12:00:00	YM	Futures	36230.3	36271.5	36198.0	36234.7	8605.0
2021-03-12 13:00:00	YM	Futures	36234.7	36300.5	36215.8	36279.3	5123.0
2021-03-12 14:00:00	YM	Futures	36280.4	36340.6	36276.0	36322.7	6472.0
2021-03-12 15:00:00	YM	Futures	36323.8	36405.2	36292.7	36387.3	9656.0

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

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