PREVIEW / futures_1hour / 2020-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-07.parquet
  size:    60 KB
  rows:    1,864

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-07 00:00:00	ES	Futures	3758.03	3761.67	3757.47	3761.39	3529.0
2020-10-07 01:00:00	ES	Futures	3761.11	3775.11	3759.71	3769.51	16130.0
2020-10-07 02:00:00	ES	Futures	3769.51	3774.83	3767.55	3774.27	16063.0
2020-10-07 03:00:00	ES	Futures	3774.27	3784.92	3771.75	3780.44	29231.0
2020-10-07 04:00:00	ES	Futures	3780.44	3781.0	3773.15	3778.75	16753.0
2020-10-07 05:00:00	ES	Futures	3778.75	3779.32	3772.59	3772.87	15109.0
2020-10-07 06:00:00	ES	Futures	3772.87	3781.84	3770.35	3781.0	19867.0
2020-10-07 07:00:00	ES	Futures	3781.0	3785.48	3777.07	3784.36	18110.0
2020-10-07 08:00:00	ES	Futures	3784.36	3792.2	3782.4	3786.04	49456.0
2020-10-07 09:00:00	ES	Futures	3786.04	3803.96	3783.24	3798.36	171558.0
2020-10-07 10:00:00	ES	Futures	3798.36	3806.76	3790.8	3803.4	200628.0
2020-10-07 11:00:00	ES	Futures	3803.4	3808.16	3800.04	3802.84	108683.0
2020-10-07 12:00:00	ES	Futures	3802.84	3805.64	3792.76	3804.8	104595.0
2020-10-07 13:00:00	ES	Futures	3804.8	3819.09	3804.52	3814.05	98439.0
2020-10-07 14:00:00	ES	Futures	3814.05	3825.25	3812.37	3823.29	120102.0
2020-10-07 15:00:00	ES	Futures	3823.57	3828.05	3816.57	3817.13	215849.0
2020-10-07 16:00:00	ES	Futures	3817.13	3819.65	3813.21	3817.97	59265.0
2020-10-07 18:00:00	ES	Futures	3816.29	3823.57	3815.45	3821.61	7735.0
2020-10-07 19:00:00	ES	Futures	3821.61	3826.65	3818.81	3824.97	6754.0
2020-10-07 20:00:00	ES	Futures	3824.97	3825.53	3817.97	3821.05	8927.0
2020-10-07 21:00:00	ES	Futures	3821.05	3833.37	3818.81	3830.57	13912.0
2020-10-07 22:00:00	ES	Futures	3830.57	3832.25	3824.41	3829.17	11176.0
2020-10-07 23:00:00	ES	Futures	3829.17	3830.57	3827.49	3828.33	5270.0
2020-10-07 00:00:00	NQ	Futures	13069.8	13077.04	13060.54	13070.96	2559.0
2020-10-07 01:00:00	NQ	Futures	13070.67	13120.17	13061.12	13101.93	8116.0
2020-10-07 02:00:00	NQ	Futures	13102.22	13118.43	13096.43	13114.38	6255.0
2020-10-07 03:00:00	NQ	Futures	13114.67	13151.14	13108.88	13141.01	9251.0
2020-10-07 04:00:00	NQ	Futures	13141.3	13145.64	13107.14	13118.72	6737.0
2020-10-07 05:00:00	NQ	Futures	13118.43	13139.56	13102.51	13103.96	5116.0
2020-10-07 06:00:00	NQ	Futures	13102.8	13130.01	13091.22	13122.2	6211.0
2020-10-07 07:00:00	NQ	Futures	13122.2	13158.38	13116.7	13152.88	6759.0
2020-10-07 08:00:00	NQ	Futures	13151.43	13187.33	13143.62	13169.09	16365.0
2020-10-07 09:00:00	NQ	Futures	13168.8	13243.48	13162.14	13211.93	55839.0
2020-10-07 10:00:00	NQ	Futures	13211.93	13224.67	13156.93	13216.85	72547.0
2020-10-07 11:00:00	NQ	Futures	13216.56	13251.01	13211.35	13232.77	39263.0
2020-10-07 12:00:00	NQ	Futures	13233.06	13268.96	13191.96	13264.61	41521.0
2020-10-07 13:00:00	NQ	Futures	13264.61	13313.24	13264.32	13291.53	32403.0
2020-10-07 14:00:00	NQ	Futures	13291.24	13318.74	13274.46	13307.46	36730.0
2020-10-07 15:00:00	NQ	Futures	13307.46	13323.09	13287.77	13292.4	40092.0
2020-10-07 16:00:00	NQ	Futures	13292.69	13296.74	13268.09	13286.03	10601.0
2020-10-07 18:00:00	NQ	Futures	13284.59	13314.69	13280.53	13301.96	5218.0
2020-10-07 19:00:00	NQ	Futures	13301.96	13320.48	13293.56	13316.43	3854.0
2020-10-07 20:00:00	NQ	Futures	13316.14	13319.03	13293.85	13302.53	4185.0
2020-10-07 21:00:00	NQ	Futures	13301.38	13337.85	13284.88	13330.61	5783.0
2020-10-07 22:00:00	NQ	Futures	13331.19	13339.88	13304.56	13329.45	5876.0
2020-10-07 23:00:00	NQ	Futures	13329.45	13336.69	13317.88	13321.06	3551.0
2020-10-07 00:00:00	YM	Futures	30643.3	30671.0	30632.3	30668.8	1547.0
2020-10-07 01:00:00	YM	Futures	30666.6	30787.1	30657.7	30741.7	4036.0
2020-10-07 02:00:00	YM	Futures	30744.0	30787.1	30724.1	30778.2	4051.0
2020-10-07 03:00:00	YM	Futures	30777.1	30864.5	30757.2	30829.1	7465.0

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

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