PREVIEW / futures_1hour / 2017-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-05.parquet
  size:    53 KB
  rows:    1,601

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-09-05 00:00:00	ES	Futures	2697.31	2698.95	2696.76	2698.95	4886.0
2017-09-05 01:00:00	ES	Futures	2698.95	2700.59	2697.58	2698.4	9588.0
2017-09-05 02:00:00	ES	Futures	2698.4	2700.87	2698.13	2700.04	6239.0
2017-09-05 03:00:00	ES	Futures	2700.04	2701.41	2698.4	2699.5	16202.0
2017-09-05 04:00:00	ES	Futures	2699.77	2701.41	2698.95	2699.22	10580.0
2017-09-05 05:00:00	ES	Futures	2699.22	2700.59	2697.86	2698.13	8616.0
2017-09-05 06:00:00	ES	Futures	2698.13	2698.95	2695.4	2696.76	17306.0
2017-09-05 07:00:00	ES	Futures	2696.49	2699.77	2696.22	2699.77	16539.0
2017-09-05 08:00:00	ES	Futures	2699.5	2700.87	2698.13	2698.95	29246.0
2017-09-05 09:00:00	ES	Futures	2698.68	2701.96	2695.67	2700.32	175798.0
2017-09-05 10:00:00	ES	Futures	2700.32	2701.69	2692.12	2694.58	218727.0
2017-09-05 11:00:00	ES	Futures	2694.58	2695.12	2690.48	2693.76	154069.0
2017-09-05 12:00:00	ES	Futures	2693.76	2693.76	2677.36	2680.64	341378.0
2017-09-05 13:00:00	ES	Futures	2680.36	2682.82	2673.8	2682.55	230834.0
2017-09-05 14:00:00	ES	Futures	2682.28	2686.92	2680.91	2683.37	163363.0
2017-09-05 15:00:00	ES	Futures	2683.37	2688.02	2680.64	2686.38	306945.0
2017-09-05 16:00:00	ES	Futures	2686.38	2690.48	2686.38	2689.66	98942.0
2017-09-05 18:00:00	ES	Futures	2689.93	2690.2	2686.65	2687.74	8343.0
2017-09-05 19:00:00	ES	Futures	2687.74	2688.56	2687.2	2687.74	3687.0
2017-09-05 20:00:00	ES	Futures	2687.47	2688.29	2685.83	2688.02	8372.0
2017-09-05 21:00:00	ES	Futures	2688.02	2690.48	2687.74	2689.11	8111.0
2017-09-05 22:00:00	ES	Futures	2689.11	2689.66	2687.74	2688.29	3953.0
2017-09-05 23:00:00	ES	Futures	2688.29	2689.93	2687.47	2689.93	3746.0
2017-09-05 00:00:00	NQ	Futures	7113.87	7118.64	7111.49	7118.04	950.0
2017-09-05 01:00:00	NQ	Futures	7118.04	7121.61	7111.79	7115.06	1513.0
2017-09-05 02:00:00	NQ	Futures	7114.17	7120.42	7113.28	7118.04	1838.0
2017-09-05 03:00:00	NQ	Futures	7117.45	7126.68	7115.06	7121.32	2461.0
2017-09-05 04:00:00	NQ	Futures	7121.32	7127.87	7119.83	7124.0	1679.0
2017-09-05 05:00:00	NQ	Futures	7124.0	7127.57	7118.04	7118.64	1513.0
2017-09-05 06:00:00	NQ	Futures	7118.64	7121.32	7111.79	7116.25	4679.0
2017-09-05 07:00:00	NQ	Futures	7116.25	7123.4	7115.06	7121.61	3838.0
2017-09-05 08:00:00	NQ	Futures	7121.32	7124.29	7114.17	7115.66	5199.0
2017-09-05 09:00:00	NQ	Futures	7115.66	7124.29	7087.37	7119.53	48219.0
2017-09-05 10:00:00	NQ	Futures	7119.83	7126.97	7091.54	7101.37	51879.0
2017-09-05 11:00:00	NQ	Futures	7101.37	7101.37	7078.14	7087.67	40942.0
2017-09-05 12:00:00	NQ	Futures	7087.67	7087.97	7021.87	7037.95	86997.0
2017-09-05 13:00:00	NQ	Futures	7037.35	7052.54	7014.42	7052.24	60246.0
2017-09-05 14:00:00	NQ	Futures	7051.64	7065.04	7043.9	7056.41	38728.0
2017-09-05 15:00:00	NQ	Futures	7056.11	7072.19	7050.75	7067.42	50914.0
2017-09-05 16:00:00	NQ	Futures	7067.13	7080.23	7066.53	7076.06	8428.0
2017-09-05 18:00:00	NQ	Futures	7078.74	7079.33	7065.93	7070.7	1429.0
2017-09-05 19:00:00	NQ	Futures	7070.4	7073.38	7067.13	7068.61	1086.0
2017-09-05 20:00:00	NQ	Futures	7068.02	7071.59	7063.55	7069.81	3719.0
2017-09-05 21:00:00	NQ	Futures	7070.4	7080.23	7070.4	7075.17	6591.0
2017-09-05 22:00:00	NQ	Futures	7075.46	7077.25	7070.1	7072.49	1269.0
2017-09-05 23:00:00	NQ	Futures	7072.49	7079.04	7069.21	7078.14	1198.0
2017-09-05 00:00:00	YM	Futures	23863.9	23875.9	23860.6	23874.8	835.0
2017-09-05 01:00:00	YM	Futures	23873.7	23881.3	23865.0	23870.4	1465.0
2017-09-05 02:00:00	YM	Futures	23870.4	23886.7	23868.2	23876.9	1361.0
2017-09-05 03:00:00	YM	Futures	23875.9	23888.9	23868.2	23876.9	1898.0

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

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