PREVIEW / futures_1hour / 2021-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-22.parquet
  size:    61 KB
  rows:    1,903

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-22 00:00:00	ES	Futures	4380.03	4388.18	4379.19	4385.37	8187.0
2021-03-22 01:00:00	ES	Futures	4385.37	4386.77	4381.15	4382.28	5977.0
2021-03-22 02:00:00	ES	Futures	4382.56	4384.81	4379.19	4379.47	5645.0
2021-03-22 03:00:00	ES	Futures	4379.19	4382.56	4369.35	4374.13	14536.0
2021-03-22 04:00:00	ES	Futures	4374.13	4383.68	4367.95	4380.59	24187.0
2021-03-22 05:00:00	ES	Futures	4380.31	4382.56	4374.41	4381.15	12674.0
2021-03-22 06:00:00	ES	Futures	4381.15	4386.49	4380.31	4385.09	10526.0
2021-03-22 07:00:00	ES	Futures	4385.09	4395.48	4384.81	4393.24	21291.0
2021-03-22 08:00:00	ES	Futures	4392.96	4393.8	4387.06	4389.3	30052.0
2021-03-22 09:00:00	ES	Futures	4389.3	4403.91	4387.06	4401.67	210677.0
2021-03-22 10:00:00	ES	Futures	4401.67	4414.87	4398.57	4410.38	228328.0
2021-03-22 11:00:00	ES	Futures	4410.66	4416.56	4408.13	4414.03	108413.0
2021-03-22 12:00:00	ES	Futures	4414.03	4423.58	4413.75	4422.46	94203.0
2021-03-22 13:00:00	ES	Futures	4422.74	4424.7	4417.96	4424.7	69407.0
2021-03-22 14:00:00	ES	Futures	4424.7	4432.29	4423.58	4430.04	106413.0
2021-03-22 15:00:00	ES	Futures	4429.76	4433.13	4414.59	4416.28	215539.0
2021-03-22 16:00:00	ES	Futures	4416.28	4421.33	4415.71	4419.93	46705.0
2021-03-22 18:00:00	ES	Futures	4420.49	4422.74	4417.68	4420.21	6942.0
2021-03-22 19:00:00	ES	Futures	4419.93	4424.42	4418.8	4424.14	4221.0
2021-03-22 20:00:00	ES	Futures	4424.14	4426.67	4416.84	4419.09	12013.0
2021-03-22 21:00:00	ES	Futures	4418.8	4421.9	4415.43	4417.96	10526.0
2021-03-22 22:00:00	ES	Futures	4417.96	4418.8	4411.22	4412.62	11277.0
2021-03-22 23:00:00	ES	Futures	4412.34	4412.34	4408.13	4410.94	8055.0
2021-03-22 00:00:00	NQ	Futures	14939.11	14976.75	14933.9	14957.93	5097.0
2021-03-22 01:00:00	NQ	Futures	14957.35	14972.7	14930.14	14952.43	4854.0
2021-03-22 02:00:00	NQ	Futures	14953.01	14966.91	14941.72	14947.8	3133.0
2021-03-22 03:00:00	NQ	Futures	14946.64	14970.38	14903.22	14929.27	9118.0
2021-03-22 04:00:00	NQ	Futures	14931.01	14959.96	14904.66	14948.09	9948.0
2021-03-22 05:00:00	NQ	Futures	14946.93	14967.77	14926.67	14959.38	6025.0
2021-03-22 06:00:00	NQ	Futures	14961.12	15005.12	14953.88	14987.46	7343.0
2021-03-22 07:00:00	NQ	Futures	14986.88	15011.49	14977.33	14999.62	7661.0
2021-03-22 08:00:00	NQ	Futures	14999.62	15001.94	14965.75	14979.64	10846.0
2021-03-22 09:00:00	NQ	Futures	14980.8	15078.07	14970.09	15062.44	75672.0
2021-03-22 10:00:00	NQ	Futures	15063.31	15129.6	15033.49	15119.18	73024.0
2021-03-22 11:00:00	NQ	Futures	15119.47	15164.05	15109.92	15143.21	38731.0
2021-03-22 12:00:00	NQ	Futures	15143.21	15235.56	15142.92	15228.32	45104.0
2021-03-22 13:00:00	NQ	Futures	15227.74	15230.64	15186.92	15214.71	33150.0
2021-03-22 14:00:00	NQ	Futures	15215.0	15226.87	15198.5	15221.08	27147.0
2021-03-22 15:00:00	NQ	Futures	15221.66	15233.24	15131.34	15135.68	60218.0
2021-03-22 16:00:00	NQ	Futures	15135.68	15150.45	15123.81	15125.55	9372.0
2021-03-22 18:00:00	NQ	Futures	15133.66	15155.37	15129.31	15145.24	3637.0
2021-03-22 19:00:00	NQ	Futures	15144.37	15154.21	15135.97	15153.34	2199.0
2021-03-22 20:00:00	NQ	Futures	15153.92	15175.63	15112.52	15121.21	7496.0
2021-03-22 21:00:00	NQ	Futures	15121.21	15137.13	15089.94	15104.71	6714.0
2021-03-22 22:00:00	NQ	Futures	15103.84	15111.94	15076.91	15088.78	5137.0
2021-03-22 23:00:00	NQ	Futures	15087.63	15098.63	15068.81	15090.81	4668.0
2021-03-22 00:00:00	YM	Futures	36115.6	36174.6	36111.1	36153.4	1509.0
2021-03-22 01:00:00	YM	Futures	36153.4	36166.8	36122.2	36124.5	1129.0
2021-03-22 02:00:00	YM	Futures	36126.7	36137.8	36087.7	36088.8	1459.0
2021-03-22 03:00:00	YM	Futures	36087.7	36105.5	36007.5	36037.6	3866.0

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

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