PREVIEW / futures_1hour / 2020-02-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-17.parquet
  size:    44 KB
  rows:    1,383

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-17 00:00:00	ES	Futures	3671.9	3674.6	3671.4	3674.1	5864.0
2020-02-17 01:00:00	ES	Futures	3674.1	3677.3	3673.0	3674.1	7069.0
2020-02-17 02:00:00	ES	Futures	3674.1	3674.4	3672.5	3673.8	6441.0
2020-02-17 03:00:00	ES	Futures	3673.5	3675.7	3671.1	3672.7	13052.0
2020-02-17 04:00:00	ES	Futures	3672.7	3674.6	3672.2	3674.1	5101.0
2020-02-17 05:00:00	ES	Futures	3674.1	3675.2	3673.0	3673.5	4640.0
2020-02-17 06:00:00	ES	Futures	3673.3	3674.6	3672.7	3674.6	4297.0
2020-02-17 07:00:00	ES	Futures	3674.6	3674.9	3670.0	3672.7	9270.0
2020-02-17 08:00:00	ES	Futures	3672.7	3673.3	3670.6	3671.4	5662.0
2020-02-17 09:00:00	ES	Futures	3671.4	3671.6	3670.0	3671.1	8604.0
2020-02-17 10:00:00	ES	Futures	3671.1	3673.0	3670.3	3672.7	6657.0
2020-02-17 11:00:00	ES	Futures	3672.5	3673.8	3672.2	3673.8	7243.0
2020-02-17 12:00:00	ES	Futures	3673.8	3674.4	3671.9	3672.5	5246.0
2020-02-17 18:00:00	ES	Futures	3661.9	3662.7	3655.1	3659.5	29888.0
2020-02-17 19:00:00	ES	Futures	3659.5	3659.7	3655.4	3656.2	15336.0
2020-02-17 20:00:00	ES	Futures	3656.2	3657.6	3653.8	3656.2	18048.0
2020-02-17 21:00:00	ES	Futures	3655.9	3657.3	3650.0	3651.3	19809.0
2020-02-17 22:00:00	ES	Futures	3651.6	3654.3	3651.1	3652.7	11120.0
2020-02-17 23:00:00	ES	Futures	3652.7	3655.9	3651.6	3655.7	8731.0
2020-02-17 00:00:00	NQ	Futures	11186.38	11196.5	11184.64	11193.61	3062.0
2020-02-17 01:00:00	NQ	Futures	11193.61	11205.46	11188.4	11191.29	5318.0
2020-02-17 02:00:00	NQ	Futures	11191.29	11192.74	11183.2	11190.14	4804.0
2020-02-17 03:00:00	NQ	Futures	11190.14	11198.23	11181.17	11186.96	8054.0
2020-02-17 04:00:00	NQ	Futures	11187.25	11191.87	11183.49	11190.14	2693.0
2020-02-17 05:00:00	NQ	Futures	11189.85	11194.19	11186.38	11188.4	2243.0
2020-02-17 06:00:00	NQ	Futures	11188.69	11191.87	11184.93	11189.85	1855.0
2020-02-17 07:00:00	NQ	Futures	11190.14	11191.58	11174.81	11183.2	5779.0
2020-02-17 08:00:00	NQ	Futures	11183.2	11183.49	11168.45	11172.21	4688.0
2020-02-17 09:00:00	NQ	Futures	11172.21	11178.86	11168.45	11175.39	6988.0
2020-02-17 10:00:00	NQ	Futures	11175.1	11181.17	11171.34	11178.86	4408.0
2020-02-17 11:00:00	NQ	Futures	11178.57	11183.2	11176.26	11181.46	3371.0
2020-02-17 12:00:00	NQ	Futures	11181.75	11184.35	11175.97	11181.17	2919.0
2020-02-17 18:00:00	NQ	Futures	11130.86	11130.86	11080.54	11107.72	18309.0
2020-02-17 19:00:00	NQ	Futures	11107.15	11108.01	11089.79	11093.27	10455.0
2020-02-17 20:00:00	NQ	Futures	11093.27	11099.63	11079.38	11089.51	12239.0
2020-02-17 21:00:00	NQ	Futures	11089.22	11096.45	11063.48	11069.26	10568.0
2020-02-17 22:00:00	NQ	Futures	11069.26	11078.52	11067.53	11073.6	5562.0
2020-02-17 23:00:00	NQ	Futures	11073.31	11080.54	11066.66	11079.67	3747.0
2020-02-17 00:00:00	YM	Futures	32045.0	32068.9	32042.8	32062.4	1348.0
2020-02-17 01:00:00	YM	Futures	32062.4	32091.8	32051.5	32072.2	2424.0
2020-02-17 02:00:00	YM	Futures	32072.2	32077.6	32059.1	32067.8	2016.0
2020-02-17 03:00:00	YM	Futures	32068.9	32083.1	32033.0	32049.3	3699.0
2020-02-17 04:00:00	YM	Futures	32050.4	32059.1	32040.6	32058.0	1327.0
2020-02-17 05:00:00	YM	Futures	32055.8	32065.6	32047.1	32048.2	1073.0
2020-02-17 06:00:00	YM	Futures	32049.3	32060.2	32039.5	32056.9	1244.0
2020-02-17 07:00:00	YM	Futures	32055.8	32059.1	32025.4	32048.2	2877.0
2020-02-17 08:00:00	YM	Futures	32049.3	32052.6	32036.2	32043.9	2024.0
2020-02-17 09:00:00	YM	Futures	32046.0	32054.8	32033.0	32045.0	3418.0
2020-02-17 10:00:00	YM	Futures	32043.9	32080.9	32037.3	32070.0	2719.0
2020-02-17 11:00:00	YM	Futures	32070.0	32082.0	32066.7	32072.2	2021.0

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

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