PREVIEW / futures_1hour / 2017-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-20.parquet
  size:    38 KB
  rows:    1,159

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
2017-02-20 00:00:00	ES	Futures	2563.21	2564.03	2562.94	2563.76	1067.0
2017-02-20 01:00:00	ES	Futures	2563.76	2569.21	2563.76	2567.85	10036.0
2017-02-20 02:00:00	ES	Futures	2567.85	2571.39	2567.03	2568.67	12711.0
2017-02-20 03:00:00	ES	Futures	2568.67	2568.94	2565.39	2566.48	12386.0
2017-02-20 04:00:00	ES	Futures	2566.76	2567.03	2563.48	2565.12	6768.0
2017-02-20 05:00:00	ES	Futures	2565.12	2566.21	2564.57	2565.39	3989.0
2017-02-20 06:00:00	ES	Futures	2565.39	2565.66	2564.57	2565.12	3521.0
2017-02-20 07:00:00	ES	Futures	2565.12	2565.12	2563.76	2564.3	5889.0
2017-02-20 08:00:00	ES	Futures	2564.57	2565.12	2563.48	2564.57	6329.0
2017-02-20 09:00:00	ES	Futures	2564.3	2568.39	2564.3	2565.94	19417.0
2017-02-20 10:00:00	ES	Futures	2565.94	2567.03	2565.39	2566.21	8370.0
2017-02-20 11:00:00	ES	Futures	2566.21	2568.39	2565.94	2567.85	10150.0
2017-02-20 12:00:00	ES	Futures	2567.85	2568.94	2566.76	2567.03	7398.0
2017-02-20 18:00:00	ES	Futures	2567.03	2568.67	2566.76	2567.57	3891.0
2017-02-20 19:00:00	ES	Futures	2567.85	2568.39	2567.03	2567.3	2023.0
2017-02-20 20:00:00	ES	Futures	2567.03	2568.39	2565.66	2566.21	4012.0
2017-02-20 21:00:00	ES	Futures	2566.21	2567.03	2566.21	2566.21	2422.0
2017-02-20 22:00:00	ES	Futures	2565.94	2567.03	2565.94	2567.03	2021.0
2017-02-20 23:00:00	ES	Futures	2567.03	2567.3	2566.48	2567.03	817.0
2017-02-20 00:00:00	NQ	Futures	6356.0	6358.69	6355.41	6358.09	300.0
2017-02-20 01:00:00	NQ	Futures	6358.09	6372.41	6357.79	6371.51	2284.0
2017-02-20 02:00:00	NQ	Futures	6371.22	6378.67	6368.23	6373.01	3121.0
2017-02-20 03:00:00	NQ	Futures	6373.6	6374.5	6363.16	6366.15	3548.0
2017-02-20 04:00:00	NQ	Futures	6366.44	6367.64	6357.49	6361.37	1547.0
2017-02-20 05:00:00	NQ	Futures	6361.07	6363.16	6360.78	6361.97	729.0
2017-02-20 06:00:00	NQ	Futures	6361.67	6362.27	6359.58	6361.97	428.0
2017-02-20 07:00:00	NQ	Futures	6361.97	6362.27	6358.99	6361.37	787.0
2017-02-20 08:00:00	NQ	Futures	6361.67	6361.97	6359.28	6360.18	727.0
2017-02-20 09:00:00	NQ	Futures	6360.18	6367.34	6356.9	6362.27	3429.0
2017-02-20 10:00:00	NQ	Futures	6362.57	6367.04	6362.27	6366.44	2085.0
2017-02-20 11:00:00	NQ	Futures	6366.44	6373.9	6366.15	6372.41	2390.0
2017-02-20 12:00:00	NQ	Futures	6372.71	6377.18	6372.71	6372.71	1320.0
2017-02-20 18:00:00	NQ	Futures	6371.51	6372.71	6369.43	6370.32	790.0
2017-02-20 19:00:00	NQ	Futures	6370.32	6371.22	6368.23	6368.83	747.0
2017-02-20 20:00:00	NQ	Futures	6368.83	6373.9	6367.64	6368.23	1501.0
2017-02-20 21:00:00	NQ	Futures	6368.53	6370.92	6368.53	6369.13	682.0
2017-02-20 22:00:00	NQ	Futures	6369.13	6372.11	6368.53	6371.51	736.0
2017-02-20 23:00:00	NQ	Futures	6371.51	6372.11	6370.92	6371.51	329.0
2017-02-20 00:00:00	YM	Futures	22347.3	22353.8	22341.8	22352.7	533.0
2017-02-20 01:00:00	YM	Futures	22352.7	22396.1	22351.6	22386.3	3113.0
2017-02-20 02:00:00	YM	Futures	22386.3	22423.2	22377.6	22403.7	3948.0
2017-02-20 03:00:00	YM	Futures	22403.7	22404.8	22375.5	22385.2	3058.0
2017-02-20 04:00:00	YM	Futures	22386.3	22391.7	22360.3	22370.0	1938.0
2017-02-20 05:00:00	YM	Futures	22370.0	22390.7	22367.9	22379.8	1555.0
2017-02-20 06:00:00	YM	Futures	22378.7	22380.9	22371.1	22376.6	815.0
2017-02-20 07:00:00	YM	Futures	22376.6	22377.6	22367.9	22374.4	1189.0
2017-02-20 08:00:00	YM	Futures	22374.4	22379.8	22365.7	22375.5	866.0
2017-02-20 09:00:00	YM	Futures	22375.5	22401.5	22361.4	22372.2	3245.0
2017-02-20 10:00:00	YM	Futures	22372.2	22387.4	22366.8	22376.6	2271.0
2017-02-20 11:00:00	YM	Futures	22377.6	22393.9	22376.6	22387.4	1100.0

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

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