PREVIEW / futures_1hour / 2016-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-22.parquet
  size:    53 KB
  rows:    1,623

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
2016-11-22 00:00:00	ES	Futures	2395.38	2396.47	2395.11	2395.66	4301.0
2016-11-22 01:00:00	ES	Futures	2395.66	2395.93	2394.84	2395.38	3270.0
2016-11-22 02:00:00	ES	Futures	2395.38	2396.47	2394.57	2395.93	7466.0
2016-11-22 03:00:00	ES	Futures	2395.93	2397.02	2394.84	2395.11	18142.0
2016-11-22 04:00:00	ES	Futures	2395.11	2395.38	2393.75	2394.57	10413.0
2016-11-22 05:00:00	ES	Futures	2394.3	2394.57	2392.66	2393.21	10677.0
2016-11-22 06:00:00	ES	Futures	2393.21	2393.75	2392.39	2393.21	6646.0
2016-11-22 07:00:00	ES	Futures	2393.48	2393.75	2392.12	2392.66	12598.0
2016-11-22 08:00:00	ES	Futures	2392.66	2392.93	2390.76	2391.57	27521.0
2016-11-22 09:00:00	ES	Futures	2391.57	2395.38	2391.57	2394.02	174700.0
2016-11-22 10:00:00	ES	Futures	2393.48	2395.38	2389.67	2390.49	175736.0
2016-11-22 11:00:00	ES	Futures	2390.21	2391.3	2385.32	2386.4	167767.0
2016-11-22 12:00:00	ES	Futures	2386.4	2389.4	2385.32	2388.85	87765.0
2016-11-22 13:00:00	ES	Futures	2388.85	2391.3	2388.85	2389.67	63804.0
2016-11-22 14:00:00	ES	Futures	2389.94	2393.75	2388.85	2392.12	136638.0
2016-11-22 15:00:00	ES	Futures	2392.12	2397.29	2392.12	2394.02	211841.0
2016-11-22 16:00:00	ES	Futures	2394.3	2396.47	2394.02	2395.93	71324.0
2016-11-22 18:00:00	ES	Futures	2395.66	2395.93	2394.02	2394.3	4077.0
2016-11-22 19:00:00	ES	Futures	2394.02	2395.11	2394.02	2394.57	2241.0
2016-11-22 20:00:00	ES	Futures	2394.57	2396.2	2394.3	2395.93	4086.0
2016-11-22 21:00:00	ES	Futures	2396.2	2397.29	2395.38	2396.74	3644.0
2016-11-22 22:00:00	ES	Futures	2396.74	2397.02	2395.38	2395.38	2395.0
2016-11-22 23:00:00	ES	Futures	2395.66	2395.66	2394.84	2394.84	2352.0
2016-11-22 00:00:00	NQ	Futures	5821.41	5823.5	5820.51	5821.71	596.0
2016-11-22 01:00:00	NQ	Futures	5821.71	5822.6	5820.81	5821.41	496.0
2016-11-22 02:00:00	NQ	Futures	5821.41	5823.5	5820.22	5822.6	1047.0
2016-11-22 03:00:00	NQ	Futures	5822.6	5824.99	5820.51	5821.71	1817.0
2016-11-22 04:00:00	NQ	Futures	5821.11	5821.71	5818.13	5819.62	1534.0
2016-11-22 05:00:00	NQ	Futures	5819.32	5821.11	5815.74	5817.23	1294.0
2016-11-22 06:00:00	NQ	Futures	5817.23	5817.83	5814.85	5817.83	761.0
2016-11-22 07:00:00	NQ	Futures	5817.83	5821.71	5815.74	5819.02	3001.0
2016-11-22 08:00:00	NQ	Futures	5818.72	5823.5	5811.27	5811.86	7109.0
2016-11-22 09:00:00	NQ	Futures	5811.86	5829.17	5811.56	5817.53	30107.0
2016-11-22 10:00:00	NQ	Futures	5817.53	5829.17	5805.0	5811.56	28890.0
2016-11-22 11:00:00	NQ	Futures	5811.86	5817.23	5799.93	5810.37	25456.0
2016-11-22 12:00:00	NQ	Futures	5810.37	5818.72	5805.6	5814.25	8972.0
2016-11-22 13:00:00	NQ	Futures	5814.55	5820.51	5812.16	5812.76	8119.0
2016-11-22 14:00:00	NQ	Futures	5812.46	5813.95	5804.11	5810.37	10365.0
2016-11-22 15:00:00	NQ	Futures	5810.67	5820.51	5808.88	5814.85	11919.0
2016-11-22 16:00:00	NQ	Futures	5814.55	5821.71	5814.55	5821.11	4418.0
2016-11-22 18:00:00	NQ	Futures	5820.22	5820.22	5816.64	5816.64	430.0
2016-11-22 19:00:00	NQ	Futures	5816.93	5820.22	5816.04	5819.32	445.0
2016-11-22 20:00:00	NQ	Futures	5819.02	5823.5	5818.13	5822.6	479.0
2016-11-22 21:00:00	NQ	Futures	5822.9	5826.48	5821.41	5824.99	504.0
2016-11-22 22:00:00	NQ	Futures	5825.29	5825.59	5821.71	5821.71	454.0
2016-11-22 23:00:00	NQ	Futures	5822.01	5822.01	5819.32	5820.22	445.0
2016-11-22 00:00:00	YM	Futures	20519.4	20524.8	20516.1	20519.4	687.0
2016-11-22 01:00:00	YM	Futures	20518.3	20519.4	20512.9	20516.1	717.0
2016-11-22 02:00:00	YM	Futures	20516.1	20522.6	20508.6	20519.4	1625.0
2016-11-22 03:00:00	YM	Futures	20520.4	20524.8	20510.7	20512.9	2406.0

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

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