PREVIEW / futures_1hour / 2020-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-23.parquet
  size:    62 KB
  rows:    1,885

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-23 00:00:00	ES	Futures	3695.57	3699.49	3692.21	3696.97	5600.0
2020-09-23 01:00:00	ES	Futures	3697.25	3707.05	3696.97	3706.21	8491.0
2020-09-23 02:00:00	ES	Futures	3706.49	3707.61	3698.09	3701.73	14339.0
2020-09-23 03:00:00	ES	Futures	3701.73	3708.45	3691.65	3705.65	28489.0
2020-09-23 04:00:00	ES	Futures	3705.65	3715.45	3704.25	3714.89	25664.0
2020-09-23 05:00:00	ES	Futures	3714.61	3719.09	3713.21	3718.53	19918.0
2020-09-23 06:00:00	ES	Futures	3718.25	3719.37	3711.81	3717.13	15121.0
2020-09-23 07:00:00	ES	Futures	3717.13	3717.69	3706.49	3707.33	22313.0
2020-09-23 08:00:00	ES	Futures	3707.33	3710.97	3702.29	3704.53	32520.0
2020-09-23 09:00:00	ES	Futures	3704.53	3711.25	3694.45	3695.85	192117.0
2020-09-23 10:00:00	ES	Futures	3695.85	3700.33	3680.72	3687.16	260097.0
2020-09-23 11:00:00	ES	Futures	3687.16	3693.61	3668.4	3669.24	199148.0
2020-09-23 12:00:00	ES	Futures	3669.24	3682.4	3665.04	3682.12	157730.0
2020-09-23 13:00:00	ES	Futures	3682.4	3682.96	3659.43	3663.64	121030.0
2020-09-23 14:00:00	ES	Futures	3663.36	3663.92	3623.3	3625.54	266830.0
2020-09-23 15:00:00	ES	Futures	3625.54	3630.02	3608.74	3615.18	437115.0
2020-09-23 16:00:00	ES	Futures	3615.18	3621.62	3613.22	3619.94	66899.0
2020-09-23 18:00:00	ES	Futures	3616.58	3624.42	3614.34	3616.3	11739.0
2020-09-23 19:00:00	ES	Futures	3616.3	3619.38	3596.41	3603.7	20902.0
2020-09-23 20:00:00	ES	Futures	3603.98	3623.86	3600.33	3623.3	23678.0
2020-09-23 21:00:00	ES	Futures	3623.58	3629.18	3613.22	3614.9	24335.0
2020-09-23 22:00:00	ES	Futures	3614.62	3627.22	3613.78	3619.66	15505.0
2020-09-23 23:00:00	ES	Futures	3619.38	3622.18	3614.62	3617.98	8118.0
2020-09-23 00:00:00	NQ	Futures	12859.94	12874.12	12835.62	12868.62	3489.0
2020-09-23 01:00:00	NQ	Futures	12868.91	12912.33	12868.62	12902.2	5467.0
2020-09-23 02:00:00	NQ	Futures	12903.94	12914.94	12866.88	12885.99	6863.0
2020-09-23 03:00:00	NQ	Futures	12886.28	12932.01	12860.23	12918.12	10566.0
2020-09-23 04:00:00	NQ	Futures	12917.83	12960.96	12910.88	12958.36	7685.0
2020-09-23 05:00:00	NQ	Futures	12958.36	12993.67	12955.75	12992.22	8321.0
2020-09-23 06:00:00	NQ	Futures	12991.93	12992.22	12940.12	12969.93	7728.0
2020-09-23 07:00:00	NQ	Futures	12968.78	12969.65	12881.65	12888.59	10838.0
2020-09-23 08:00:00	NQ	Futures	12888.3	12920.15	12869.78	12894.67	17820.0
2020-09-23 09:00:00	NQ	Futures	12894.67	12923.04	12821.15	12830.7	59315.0
2020-09-23 10:00:00	NQ	Futures	12830.99	12858.2	12773.67	12812.17	83889.0
2020-09-23 11:00:00	NQ	Futures	12812.17	12842.86	12716.94	12723.31	67299.0
2020-09-23 12:00:00	NQ	Futures	12723.02	12789.02	12703.33	12785.25	59474.0
2020-09-23 13:00:00	NQ	Futures	12785.83	12788.73	12684.81	12694.94	51914.0
2020-09-23 14:00:00	NQ	Futures	12694.94	12696.97	12542.39	12555.42	88989.0
2020-09-23 15:00:00	NQ	Futures	12555.42	12590.15	12488.84	12529.07	117479.0
2020-09-23 16:00:00	NQ	Futures	12529.65	12546.73	12514.6	12526.76	13118.0
2020-09-23 18:00:00	NQ	Futures	12509.1	12539.21	12489.42	12505.05	5501.0
2020-09-23 19:00:00	NQ	Futures	12506.78	12520.68	12418.21	12446.58	9246.0
2020-09-23 20:00:00	NQ	Futures	12446.86	12538.63	12432.68	12535.44	9461.0
2020-09-23 21:00:00	NQ	Futures	12535.44	12559.47	12495.78	12501.57	10102.0
2020-09-23 22:00:00	NQ	Futures	12501.0	12555.13	12495.5	12518.65	7908.0
2020-09-23 23:00:00	NQ	Futures	12519.81	12526.47	12494.92	12514.6	4721.0
2020-09-23 00:00:00	YM	Futures	30112.7	30148.0	30098.3	30125.9	2055.0
2020-09-23 01:00:00	YM	Futures	30124.8	30204.4	30124.8	30197.8	3085.0
2020-09-23 02:00:00	YM	Futures	30201.1	30204.4	30120.4	30160.2	3967.0
2020-09-23 03:00:00	YM	Futures	30161.3	30203.3	30055.2	30174.6	7608.0

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

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