PREVIEW / futures_1hour / 2020-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-14.parquet
  size:    49 KB
  rows:    1,499

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-02-14 00:00:00	ES	Futures	3668.7	3670.0	3666.5	3667.9	6565.0
2020-02-14 01:00:00	ES	Futures	3667.9	3668.1	3665.1	3667.0	5629.0
2020-02-14 02:00:00	ES	Futures	3667.0	3670.0	3666.2	3667.9	8442.0
2020-02-14 03:00:00	ES	Futures	3667.9	3668.7	3664.6	3665.1	17534.0
2020-02-14 04:00:00	ES	Futures	3665.1	3666.2	3661.9	3665.1	15866.0
2020-02-14 05:00:00	ES	Futures	3665.1	3668.1	3664.6	3667.3	11225.0
2020-02-14 06:00:00	ES	Futures	3667.3	3667.9	3664.6	3666.5	11895.0
2020-02-14 07:00:00	ES	Futures	3666.8	3670.8	3666.5	3669.2	21771.0
2020-02-14 08:00:00	ES	Futures	3669.2	3669.5	3659.2	3662.2	42510.0
2020-02-14 09:00:00	ES	Futures	3662.2	3664.3	3655.7	3657.0	163829.0
2020-02-14 10:00:00	ES	Futures	3657.0	3662.4	3653.2	3662.2	180074.0
2020-02-14 11:00:00	ES	Futures	3662.4	3664.6	3659.2	3659.7	96821.0
2020-02-14 12:00:00	ES	Futures	3660.0	3660.8	3652.9	3654.6	93947.0
2020-02-14 13:00:00	ES	Futures	3654.6	3656.7	3651.1	3652.1	109900.0
2020-02-14 14:00:00	ES	Futures	3652.1	3659.5	3647.8	3655.7	132658.0
2020-02-14 15:00:00	ES	Futures	3655.4	3663.2	3651.6	3663.2	191116.0
2020-02-14 16:00:00	ES	Futures	3663.0	3666.2	3662.4	3664.3	78389.0
2020-02-14 00:00:00	NQ	Futures	11157.17	11162.09	11147.92	11152.26	3723.0
2020-02-14 01:00:00	NQ	Futures	11152.26	11153.12	11140.69	11148.5	4676.0
2020-02-14 02:00:00	NQ	Futures	11148.5	11159.77	11144.45	11151.97	7251.0
2020-02-14 03:00:00	NQ	Futures	11152.26	11155.73	11140.69	11142.42	7483.0
2020-02-14 04:00:00	NQ	Futures	11142.42	11147.05	11133.46	11144.74	6884.0
2020-02-14 05:00:00	NQ	Futures	11144.74	11153.41	11143.0	11151.39	4537.0
2020-02-14 06:00:00	NQ	Futures	11151.39	11153.12	11140.69	11149.36	5572.0
2020-02-14 07:00:00	NQ	Futures	11149.65	11161.51	11149.08	11158.91	7428.0
2020-02-14 08:00:00	NQ	Futures	11158.62	11159.49	11121.03	11131.15	17484.0
2020-02-14 09:00:00	NQ	Futures	11130.86	11150.52	11106.86	11116.11	69035.0
2020-02-14 10:00:00	NQ	Futures	11115.53	11148.21	11096.45	11146.76	71094.0
2020-02-14 11:00:00	NQ	Futures	11146.76	11153.12	11129.12	11132.3	39490.0
2020-02-14 12:00:00	NQ	Futures	11132.01	11136.35	11099.63	11107.72	41160.0
2020-02-14 13:00:00	NQ	Futures	11107.72	11119.0	11098.18	11103.1	39053.0
2020-02-14 14:00:00	NQ	Futures	11103.39	11131.15	11090.37	11119.58	47056.0
2020-02-14 15:00:00	NQ	Futures	11119.58	11138.95	11104.25	11138.38	50234.0
2020-02-14 16:00:00	NQ	Futures	11138.09	11145.89	11134.91	11139.24	11208.0
2020-02-14 00:00:00	YM	Futures	32097.2	32114.6	32077.6	32087.4	2603.0
2020-02-14 01:00:00	YM	Futures	32087.4	32088.5	32064.6	32082.0	1482.0
2020-02-14 02:00:00	YM	Futures	32082.0	32104.8	32072.2	32091.8	1877.0
2020-02-14 03:00:00	YM	Futures	32092.9	32097.2	32056.9	32062.4	4216.0
2020-02-14 04:00:00	YM	Futures	32063.5	32071.1	32027.5	32060.2	4301.0
2020-02-14 05:00:00	YM	Futures	32060.2	32087.4	32054.8	32073.3	2687.0
2020-02-14 06:00:00	YM	Futures	32074.4	32086.3	32048.2	32068.9	2869.0
2020-02-14 07:00:00	YM	Futures	32070.0	32102.7	32064.6	32090.7	3742.0
2020-02-14 08:00:00	YM	Futures	32090.7	32091.8	32000.3	32034.1	7830.0
2020-02-14 09:00:00	YM	Futures	32033.0	32056.9	31978.5	31989.4	22599.0
2020-02-14 10:00:00	YM	Futures	31989.4	32029.7	31952.4	32015.6	23189.0
2020-02-14 11:00:00	YM	Futures	32015.6	32025.4	31978.5	31992.7	12097.0
2020-02-14 12:00:00	YM	Futures	31990.5	31999.2	31928.5	31940.4	12630.0
2020-02-14 13:00:00	YM	Futures	31939.3	31952.4	31879.5	31891.4	14712.0
2020-02-14 14:00:00	YM	Futures	31892.5	31967.7	31864.2	31925.2	20283.0
2020-02-14 15:00:00	YM	Futures	31924.1	31994.9	31888.2	31988.3	17176.0

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

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