PREVIEW / futures_1hour / 2020-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-19.parquet
  size:    60 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-10-19 00:00:00	ES	Futures	3903.68	3906.48	3902.84	3904.8	3595.0
2020-10-19 01:00:00	ES	Futures	3904.8	3907.6	3903.12	3905.92	6737.0
2020-10-19 02:00:00	ES	Futures	3906.2	3906.76	3902.28	3905.92	5545.0
2020-10-19 03:00:00	ES	Futures	3905.92	3917.4	3905.64	3909.28	26904.0
2020-10-19 04:00:00	ES	Futures	3909.0	3914.04	3905.36	3913.2	10872.0
2020-10-19 05:00:00	ES	Futures	3913.2	3916.84	3908.72	3912.08	11150.0
2020-10-19 06:00:00	ES	Futures	3912.08	3913.76	3906.48	3913.2	14975.0
2020-10-19 07:00:00	ES	Futures	3913.2	3914.32	3909.28	3909.28	11861.0
2020-10-19 08:00:00	ES	Futures	3909.28	3909.84	3903.96	3905.36	22730.0
2020-10-19 09:00:00	ES	Futures	3905.64	3914.32	3904.52	3904.8	119347.0
2020-10-19 10:00:00	ES	Futures	3905.08	3905.08	3880.99	3889.95	275034.0
2020-10-19 11:00:00	ES	Futures	3889.67	3892.75	3872.31	3879.87	166856.0
2020-10-19 12:00:00	ES	Futures	3879.87	3884.63	3872.31	3878.75	116848.0
2020-10-19 13:00:00	ES	Futures	3878.75	3881.27	3860.54	3863.9	101846.0
2020-10-19 14:00:00	ES	Futures	3863.62	3867.82	3833.93	3834.77	223211.0
2020-10-19 15:00:00	ES	Futures	3834.77	3840.1	3821.33	3832.81	366709.0
2020-10-19 16:00:00	ES	Futures	3833.09	3848.5	3832.53	3847.1	79345.0
2020-10-19 18:00:00	ES	Futures	3849.62	3856.06	3847.66	3852.42	12717.0
2020-10-19 19:00:00	ES	Futures	3852.98	3854.66	3851.86	3853.82	4824.0
2020-10-19 20:00:00	ES	Futures	3853.82	3860.26	3853.26	3855.5	9644.0
2020-10-19 21:00:00	ES	Futures	3855.5	3857.46	3842.06	3845.7	17075.0
2020-10-19 22:00:00	ES	Futures	3845.42	3850.74	3840.94	3845.7	8377.0
2020-10-19 23:00:00	ES	Futures	3845.42	3855.22	3844.58	3851.58	9269.0
2020-10-19 00:00:00	NQ	Futures	13763.66	13777.84	13756.71	13769.16	3093.0
2020-10-19 01:00:00	NQ	Futures	13769.16	13788.26	13763.95	13778.71	3421.0
2020-10-19 02:00:00	NQ	Futures	13778.42	13780.16	13751.5	13769.16	3092.0
2020-10-19 03:00:00	NQ	Futures	13769.45	13824.74	13768.0	13792.6	8338.0
2020-10-19 04:00:00	NQ	Futures	13792.03	13823.87	13770.03	13814.6	6182.0
2020-10-19 05:00:00	NQ	Futures	13814.6	13835.74	13799.55	13810.84	5222.0
2020-10-19 06:00:00	NQ	Futures	13811.13	13816.63	13784.79	13814.31	5162.0
2020-10-19 07:00:00	NQ	Futures	13812.87	13814.03	13787.97	13801.0	4970.0
2020-10-19 08:00:00	NQ	Futures	13800.71	13805.63	13771.18	13777.26	12472.0
2020-10-19 09:00:00	NQ	Futures	13777.84	13837.18	13746.0	13748.89	63296.0
2020-10-19 10:00:00	NQ	Futures	13748.61	13751.5	13610.82	13661.76	112082.0
2020-10-19 11:00:00	NQ	Futures	13662.63	13708.66	13625.0	13643.53	68566.0
2020-10-19 12:00:00	NQ	Futures	13643.53	13671.9	13599.53	13649.9	57158.0
2020-10-19 13:00:00	NQ	Futures	13649.61	13667.55	13567.69	13597.5	45239.0
2020-10-19 14:00:00	NQ	Futures	13596.92	13620.66	13489.24	13492.43	69918.0
2020-10-19 15:00:00	NQ	Futures	13492.72	13498.21	13421.22	13466.08	105478.0
2020-10-19 16:00:00	NQ	Futures	13466.66	13545.69	13465.5	13541.64	15533.0
2020-10-19 18:00:00	NQ	Futures	13544.24	13568.85	13539.9	13558.42	6959.0
2020-10-19 19:00:00	NQ	Futures	13557.27	13572.9	13551.77	13564.5	3416.0
2020-10-19 20:00:00	NQ	Futures	13563.92	13603.58	13563.92	13574.35	5647.0
2020-10-19 21:00:00	NQ	Futures	13574.92	13576.95	13508.93	13531.5	9231.0
2020-10-19 22:00:00	NQ	Futures	13531.21	13555.24	13518.19	13532.66	5246.0
2020-10-19 23:00:00	NQ	Futures	13533.53	13585.63	13528.03	13565.95	5651.0
2020-10-19 00:00:00	YM	Futures	31593.1	31608.6	31582.0	31597.5	698.0
2020-10-19 01:00:00	YM	Futures	31597.5	31629.6	31587.5	31607.4	1667.0
2020-10-19 02:00:00	YM	Futures	31606.3	31615.2	31578.7	31603.0	1604.0
2020-10-19 03:00:00	YM	Futures	31601.9	31697.0	31598.6	31631.8	5247.0

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

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