PREVIEW / futures_1hour / 2020-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-02.parquet
  size:    60 KB
  rows:    1,857

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-09-02 00:00:00	ES	Futures	3949.34	3953.53	3949.06	3949.9	6195.0
2020-09-02 01:00:00	ES	Futures	3949.9	3955.21	3948.5	3953.81	8509.0
2020-09-02 02:00:00	ES	Futures	3953.81	3958.28	3951.58	3953.81	13917.0
2020-09-02 03:00:00	ES	Futures	3953.81	3962.19	3951.58	3959.67	28472.0
2020-09-02 04:00:00	ES	Futures	3959.39	3968.05	3958.56	3967.49	35450.0
2020-09-02 05:00:00	ES	Futures	3967.49	3970.84	3964.42	3970.28	23377.0
2020-09-02 06:00:00	ES	Futures	3970.28	3972.24	3963.86	3964.7	20547.0
2020-09-02 07:00:00	ES	Futures	3964.98	3966.37	3960.79	3960.79	19015.0
2020-09-02 08:00:00	ES	Futures	3961.07	3964.14	3959.39	3961.07	28244.0
2020-09-02 09:00:00	ES	Futures	3961.07	3963.86	3948.5	3950.46	215707.0
2020-09-02 10:00:00	ES	Futures	3950.74	3968.33	3947.11	3963.58	283100.0
2020-09-02 11:00:00	ES	Futures	3963.58	3965.82	3949.62	3962.47	281323.0
2020-09-02 12:00:00	ES	Futures	3962.47	3973.64	3959.39	3971.12	133547.0
2020-09-02 13:00:00	ES	Futures	3971.4	3984.25	3969.17	3980.9	124083.0
2020-09-02 14:00:00	ES	Futures	3981.17	3986.48	3973.64	3984.25	114950.0
2020-09-02 15:00:00	ES	Futures	3984.25	4006.59	3983.41	3994.86	307032.0
2020-09-02 16:00:00	ES	Futures	3994.86	3998.77	3994.3	3995.7	70199.0
2020-09-02 18:00:00	ES	Futures	3997.37	4000.44	3992.62	3999.6	7108.0
2020-09-02 19:00:00	ES	Futures	3999.88	4006.03	3999.05	4002.68	10023.0
2020-09-02 20:00:00	ES	Futures	4002.96	4002.96	3990.67	3991.23	15223.0
2020-09-02 21:00:00	ES	Futures	3991.51	3999.6	3987.88	3999.05	16671.0
2020-09-02 22:00:00	ES	Futures	3999.33	4002.12	3995.42	3997.37	12312.0
2020-09-02 23:00:00	ES	Futures	3997.37	3997.65	3992.07	3995.7	8193.0
2020-09-02 00:00:00	NQ	Futures	14320.99	14328.8	14311.45	14312.02	1802.0
2020-09-02 01:00:00	NQ	Futures	14312.02	14331.69	14306.82	14326.77	3317.0
2020-09-02 02:00:00	NQ	Futures	14325.9	14360.61	14324.46	14343.54	6354.0
2020-09-02 03:00:00	NQ	Futures	14343.83	14389.23	14332.27	14369.28	11035.0
2020-09-02 04:00:00	NQ	Futures	14368.99	14400.51	14366.39	14399.93	7454.0
2020-09-02 05:00:00	NQ	Futures	14399.36	14418.73	14380.27	14410.63	8231.0
2020-09-02 06:00:00	NQ	Futures	14410.63	14415.84	14366.68	14380.27	7170.0
2020-09-02 07:00:00	NQ	Futures	14380.56	14391.84	14368.12	14369.28	6049.0
2020-09-02 08:00:00	NQ	Futures	14369.28	14399.65	14369.28	14384.9	9845.0
2020-09-02 09:00:00	NQ	Futures	14384.03	14394.44	14161.07	14171.48	123939.0
2020-09-02 10:00:00	NQ	Futures	14171.48	14290.62	14168.59	14252.74	126273.0
2020-09-02 11:00:00	NQ	Futures	14252.74	14259.39	14079.81	14184.79	128847.0
2020-09-02 12:00:00	NQ	Futures	14184.5	14276.17	14169.75	14260.55	65743.0
2020-09-02 13:00:00	NQ	Futures	14260.84	14340.36	14246.67	14312.31	54145.0
2020-09-02 14:00:00	NQ	Futures	14313.18	14345.57	14279.06	14317.23	46014.0
2020-09-02 15:00:00	NQ	Futures	14317.81	14384.9	14312.31	14355.11	67845.0
2020-09-02 16:00:00	NQ	Futures	14355.69	14366.68	14340.94	14353.09	12025.0
2020-09-02 18:00:00	NQ	Futures	14353.09	14369.57	14343.26	14366.68	2340.0
2020-09-02 19:00:00	NQ	Futures	14366.68	14388.08	14361.76	14368.41	3988.0
2020-09-02 20:00:00	NQ	Futures	14368.12	14368.41	14313.18	14318.39	6063.0
2020-09-02 21:00:00	NQ	Futures	14318.68	14353.09	14296.99	14351.06	7370.0
2020-09-02 22:00:00	NQ	Futures	14350.77	14366.1	14331.98	14341.81	4850.0
2020-09-02 23:00:00	NQ	Futures	14342.1	14342.68	14313.76	14336.32	3883.0
2020-09-02 00:00:00	YM	Futures	31591.7	31638.0	31588.4	31599.4	1399.0
2020-09-02 01:00:00	YM	Futures	31599.4	31651.2	31589.5	31636.9	1655.0
2020-09-02 02:00:00	YM	Futures	31636.9	31672.1	31608.2	31620.3	2928.0
2020-09-02 03:00:00	YM	Futures	31622.5	31689.7	31606.0	31667.7	4936.0

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

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