PREVIEW / futures_1hour / 2020-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-09.parquet
  size:    61 KB
  rows:    1,851

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-09 00:00:00	ES	Futures	3729.86	3736.28	3727.9	3735.16	8212.0
2020-09-09 01:00:00	ES	Futures	3735.44	3746.33	3734.6	3735.44	12501.0
2020-09-09 02:00:00	ES	Futures	3735.72	3739.07	3710.03	3723.71	30529.0
2020-09-09 03:00:00	ES	Futures	3723.71	3752.75	3723.43	3746.89	50003.0
2020-09-09 04:00:00	ES	Futures	3746.89	3761.97	3745.21	3749.4	39450.0
2020-09-09 05:00:00	ES	Futures	3749.4	3762.53	3742.42	3761.13	19457.0
2020-09-09 06:00:00	ES	Futures	3761.13	3764.2	3748.56	3752.2	20681.0
2020-09-09 07:00:00	ES	Futures	3751.92	3758.06	3742.42	3755.83	29524.0
2020-09-09 08:00:00	ES	Futures	3755.83	3764.2	3753.59	3756.38	44156.0
2020-09-09 09:00:00	ES	Futures	3756.1	3776.21	3754.99	3776.21	224035.0
2020-09-09 10:00:00	ES	Futures	3776.21	3795.48	3775.37	3789.61	281373.0
2020-09-09 11:00:00	ES	Futures	3789.89	3803.02	3784.31	3799.67	160038.0
2020-09-09 12:00:00	ES	Futures	3799.95	3812.51	3797.99	3810.0	107913.0
2020-09-09 13:00:00	ES	Futures	3810.0	3822.01	3808.32	3809.72	147952.0
2020-09-09 14:00:00	ES	Futures	3809.72	3819.21	3804.13	3815.3	114082.0
2020-09-09 15:00:00	ES	Futures	3815.02	3824.52	3792.69	3793.8	419984.0
2020-09-09 16:00:00	ES	Futures	3793.8	3799.11	3785.43	3792.41	84116.0
2020-09-09 18:00:00	ES	Futures	3793.24	3809.16	3793.24	3806.93	11226.0
2020-09-09 19:00:00	ES	Futures	3806.65	3810.56	3803.58	3808.32	7977.0
2020-09-09 20:00:00	ES	Futures	3808.32	3808.32	3791.29	3794.64	13123.0
2020-09-09 21:00:00	ES	Futures	3794.64	3795.76	3784.87	3788.5	14607.0
2020-09-09 22:00:00	ES	Futures	3788.5	3794.92	3780.12	3792.96	14987.0
2020-09-09 23:00:00	ES	Futures	3792.96	3793.8	3784.87	3785.7	6884.0
2020-09-09 00:00:00	NQ	Futures	12884.64	12910.38	12877.12	12908.06	6511.0
2020-09-09 01:00:00	NQ	Futures	12908.35	12954.04	12904.3	12915.58	8105.0
2020-09-09 02:00:00	NQ	Futures	12914.42	12930.62	12787.76	12849.07	18155.0
2020-09-09 03:00:00	NQ	Futures	12848.78	12998.0	12848.49	12955.2	18811.0
2020-09-09 04:00:00	NQ	Futures	12954.33	13031.25	12950.86	13005.52	14143.0
2020-09-09 05:00:00	NQ	Futures	13004.65	13058.15	12967.92	13054.39	9633.0
2020-09-09 06:00:00	NQ	Futures	13054.68	13066.53	13002.33	13026.63	10599.0
2020-09-09 07:00:00	NQ	Futures	13026.63	13026.91	12940.16	12999.44	17640.0
2020-09-09 08:00:00	NQ	Futures	12998.29	13024.02	12946.81	12954.33	23150.0
2020-09-09 09:00:00	NQ	Futures	12953.46	13077.23	12941.61	13026.05	88177.0
2020-09-09 10:00:00	NQ	Futures	13024.31	13167.46	12992.21	13151.26	95863.0
2020-09-09 11:00:00	NQ	Futures	13151.55	13196.37	13084.75	13166.88	72441.0
2020-09-09 12:00:00	NQ	Futures	13166.3	13241.49	13156.47	13238.88	44094.0
2020-09-09 13:00:00	NQ	Futures	13239.46	13277.63	13161.96	13170.06	63648.0
2020-09-09 14:00:00	NQ	Futures	13170.35	13234.83	13149.24	13214.59	46576.0
2020-09-09 15:00:00	NQ	Futures	13213.72	13273.87	13166.59	13168.9	79877.0
2020-09-09 16:00:00	NQ	Futures	13169.48	13182.49	13128.99	13152.13	18410.0
2020-09-09 18:00:00	NQ	Futures	13160.8	13235.41	13160.8	13228.18	5107.0
2020-09-09 19:00:00	NQ	Futures	13228.18	13242.06	13216.91	13237.15	3857.0
2020-09-09 20:00:00	NQ	Futures	13236.86	13237.73	13156.76	13177.29	7895.0
2020-09-09 21:00:00	NQ	Futures	13178.16	13178.16	13117.72	13142.01	6297.0
2020-09-09 22:00:00	NQ	Futures	13144.9	13183.94	13103.84	13172.66	5821.0
2020-09-09 23:00:00	NQ	Futures	13172.66	13178.16	13130.44	13134.49	3373.0
2020-09-09 00:00:00	YM	Futures	30290.2	30358.4	30274.7	30338.6	2377.0
2020-09-09 01:00:00	YM	Futures	30340.8	30427.8	30327.6	30330.9	3016.0
2020-09-09 02:00:00	YM	Futures	30332.0	30365.0	30128.3	30246.1	6704.0
2020-09-09 03:00:00	YM	Futures	30242.8	30479.6	30242.8	30452.0	8352.0

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

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