PREVIEW / futures_1hour / 2020-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-13.parquet
  size:    59 KB
  rows:    1,838

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
2020-10-13 00:00:00	ES	Futures	3942.89	3943.73	3939.81	3942.33	4666.0
2020-10-13 01:00:00	ES	Futures	3942.61	3954.65	3942.33	3952.41	20868.0
2020-10-13 02:00:00	ES	Futures	3952.41	3954.65	3936.73	3942.05	16801.0
2020-10-13 03:00:00	ES	Futures	3942.33	3942.89	3932.53	3936.17	26524.0
2020-10-13 04:00:00	ES	Futures	3936.17	3952.69	3936.17	3952.41	27449.0
2020-10-13 05:00:00	ES	Futures	3952.41	3956.61	3949.33	3954.65	21306.0
2020-10-13 06:00:00	ES	Futures	3954.37	3956.33	3944.85	3946.53	32141.0
2020-10-13 07:00:00	ES	Futures	3946.53	3957.46	3945.69	3953.53	31091.0
2020-10-13 08:00:00	ES	Futures	3953.53	3955.49	3942.89	3946.53	49460.0
2020-10-13 09:00:00	ES	Futures	3946.53	3949.05	3934.21	3942.89	203340.0
2020-10-13 10:00:00	ES	Futures	3942.61	3945.41	3928.61	3937.57	241477.0
2020-10-13 11:00:00	ES	Futures	3937.85	3943.45	3933.93	3938.69	150532.0
2020-10-13 12:00:00	ES	Futures	3938.41	3940.65	3929.17	3937.01	116464.0
2020-10-13 13:00:00	ES	Futures	3936.73	3940.09	3919.36	3921.6	171333.0
2020-10-13 14:00:00	ES	Futures	3921.88	3928.33	3911.8	3922.44	182303.0
2020-10-13 15:00:00	ES	Futures	3922.16	3938.97	3920.76	3923.56	182025.0
2020-10-13 16:00:00	ES	Futures	3923.84	3928.89	3921.6	3923.28	49227.0
2020-10-13 18:00:00	ES	Futures	3923.56	3931.97	3922.16	3929.73	6405.0
2020-10-13 19:00:00	ES	Futures	3930.01	3933.09	3928.33	3931.13	4420.0
2020-10-13 20:00:00	ES	Futures	3931.13	3936.45	3927.49	3932.25	9057.0
2020-10-13 21:00:00	ES	Futures	3932.25	3934.49	3924.12	3932.25	20291.0
2020-10-13 22:00:00	ES	Futures	3931.97	3937.85	3930.57	3935.33	9586.0
2020-10-13 23:00:00	ES	Futures	3935.33	3942.61	3935.33	3940.37	6804.0
2020-10-13 00:00:00	NQ	Futures	13966.86	13968.02	13954.71	13960.5	1785.0
2020-10-13 01:00:00	NQ	Futures	13960.5	14018.39	13960.5	14014.34	7143.0
2020-10-13 02:00:00	NQ	Futures	14013.18	14038.65	13921.13	13972.36	13530.0
2020-10-13 03:00:00	NQ	Futures	13971.79	13977.29	13938.5	13957.02	11730.0
2020-10-13 04:00:00	NQ	Futures	13956.73	14079.18	13956.73	14073.1	15933.0
2020-10-13 05:00:00	NQ	Futures	14073.39	14134.76	14055.73	14134.18	17582.0
2020-10-13 06:00:00	NQ	Futures	14133.6	14182.81	14087.28	14103.49	26270.0
2020-10-13 07:00:00	NQ	Futures	14102.92	14157.05	14075.99	14119.7	20266.0
2020-10-13 08:00:00	NQ	Futures	14118.84	14145.18	14064.13	14069.34	27191.0
2020-10-13 09:00:00	NQ	Futures	14069.34	14095.39	13931.55	14002.18	100761.0
2020-10-13 10:00:00	NQ	Futures	14002.18	14040.39	13932.71	14036.92	106697.0
2020-10-13 11:00:00	NQ	Futures	14037.21	14104.94	14015.5	14048.49	79036.0
2020-10-13 12:00:00	NQ	Futures	14048.49	14062.97	13978.44	14026.5	60125.0
2020-10-13 13:00:00	NQ	Futures	14026.5	14059.21	13926.92	13941.1	75065.0
2020-10-13 14:00:00	NQ	Futures	13940.81	13993.5	13916.5	13984.52	65428.0
2020-10-13 15:00:00	NQ	Futures	13984.81	14064.42	13976.42	13980.18	62844.0
2020-10-13 16:00:00	NQ	Futures	13980.76	14009.71	13973.81	13988.86	10940.0
2020-10-13 18:00:00	NQ	Futures	13986.84	14027.65	13983.65	14018.1	2983.0
2020-10-13 19:00:00	NQ	Futures	14019.55	14036.34	14012.31	14027.65	2340.0
2020-10-13 20:00:00	NQ	Futures	14027.65	14055.44	14009.71	14051.68	5225.0
2020-10-13 21:00:00	NQ	Futures	14051.39	14067.89	14024.18	14051.97	7276.0
2020-10-13 22:00:00	NQ	Futures	14050.23	14078.31	14047.05	14064.71	5351.0
2020-10-13 23:00:00	NQ	Futures	14065.57	14091.92	14065.57	14078.6	3380.0
2020-10-13 00:00:00	YM	Futures	31737.9	31743.4	31714.7	31737.9	964.0
2020-10-13 01:00:00	YM	Futures	31737.9	31825.3	31737.9	31802.0	4061.0
2020-10-13 02:00:00	YM	Futures	31800.9	31810.9	31693.7	31718.0	5353.0
2020-10-13 03:00:00	YM	Futures	31716.9	31724.6	31631.8	31666.0	7409.0

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

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