PREVIEW / futures_1hour / 2016-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-17.parquet
  size:    53 KB
  rows:    1,616

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-08-17 00:00:00	ES	Futures	2363.12	2363.66	2362.85	2363.39	1578.0
2016-08-17 01:00:00	ES	Futures	2363.39	2363.93	2363.12	2363.66	2249.0
2016-08-17 02:00:00	ES	Futures	2363.66	2365.56	2363.66	2364.75	6902.0
2016-08-17 03:00:00	ES	Futures	2364.75	2365.83	2359.59	2359.86	31069.0
2016-08-17 04:00:00	ES	Futures	2360.14	2360.68	2357.69	2359.59	21852.0
2016-08-17 05:00:00	ES	Futures	2359.86	2362.03	2359.59	2361.49	10148.0
2016-08-17 06:00:00	ES	Futures	2361.49	2362.03	2359.86	2360.14	9267.0
2016-08-17 07:00:00	ES	Futures	2360.41	2362.58	2359.32	2361.49	17142.0
2016-08-17 08:00:00	ES	Futures	2361.76	2362.3	2360.68	2361.76	19227.0
2016-08-17 09:00:00	ES	Futures	2361.49	2362.03	2352.81	2352.81	238108.0
2016-08-17 10:00:00	ES	Futures	2353.08	2355.25	2352.27	2353.63	242728.0
2016-08-17 11:00:00	ES	Futures	2353.36	2354.71	2349.02	2349.83	159395.0
2016-08-17 12:00:00	ES	Futures	2349.83	2358.51	2349.56	2357.42	139688.0
2016-08-17 13:00:00	ES	Futures	2357.42	2361.22	2356.07	2357.15	124002.0
2016-08-17 14:00:00	ES	Futures	2357.15	2364.47	2353.08	2362.03	305956.0
2016-08-17 15:00:00	ES	Futures	2362.03	2365.83	2359.32	2363.93	264740.0
2016-08-17 16:00:00	ES	Futures	2363.66	2366.92	2363.39	2365.56	69871.0
2016-08-17 18:00:00	ES	Futures	2365.56	2366.64	2364.75	2365.02	3258.0
2016-08-17 19:00:00	ES	Futures	2365.02	2365.56	2363.39	2364.75	4420.0
2016-08-17 20:00:00	ES	Futures	2364.75	2365.29	2363.66	2365.02	6404.0
2016-08-17 21:00:00	ES	Futures	2365.29	2367.19	2365.02	2367.19	6241.0
2016-08-17 22:00:00	ES	Futures	2366.92	2367.46	2366.64	2367.19	4841.0
2016-08-17 23:00:00	ES	Futures	2367.19	2367.46	2366.64	2366.64	2350.0
2016-08-17 00:00:00	NQ	Futures	5726.76	5727.36	5725.57	5727.06	195.0
2016-08-17 01:00:00	NQ	Futures	5726.76	5729.45	5726.76	5728.85	406.0
2016-08-17 02:00:00	NQ	Futures	5728.85	5733.62	5728.25	5730.64	1128.0
2016-08-17 03:00:00	NQ	Futures	5730.64	5734.21	5716.03	5716.33	4145.0
2016-08-17 04:00:00	NQ	Futures	5716.63	5721.7	5710.07	5718.42	4806.0
2016-08-17 05:00:00	NQ	Futures	5718.42	5724.97	5717.52	5723.78	1615.0
2016-08-17 06:00:00	NQ	Futures	5723.78	5724.38	5719.01	5719.61	1029.0
2016-08-17 07:00:00	NQ	Futures	5719.61	5730.04	5718.12	5727.66	3777.0
2016-08-17 08:00:00	NQ	Futures	5727.66	5729.15	5724.68	5727.06	1885.0
2016-08-17 09:00:00	NQ	Futures	5727.06	5727.66	5701.13	5704.71	33814.0
2016-08-17 10:00:00	NQ	Futures	5704.41	5707.69	5697.26	5702.02	27354.0
2016-08-17 11:00:00	NQ	Futures	5702.02	5706.5	5689.21	5689.8	16933.0
2016-08-17 12:00:00	NQ	Futures	5689.8	5718.42	5689.51	5716.03	18952.0
2016-08-17 13:00:00	NQ	Futures	5716.03	5725.57	5711.86	5713.65	15938.0
2016-08-17 14:00:00	NQ	Futures	5713.35	5732.13	5699.94	5724.97	32299.0
2016-08-17 15:00:00	NQ	Futures	5724.68	5731.23	5714.84	5728.55	21765.0
2016-08-17 16:00:00	NQ	Futures	5728.55	5733.62	5725.87	5731.23	5816.0
2016-08-17 18:00:00	NQ	Futures	5732.43	5733.02	5727.95	5729.15	743.0
2016-08-17 19:00:00	NQ	Futures	5729.45	5730.94	5727.06	5730.64	764.0
2016-08-17 20:00:00	NQ	Futures	5730.34	5730.34	5725.27	5729.45	931.0
2016-08-17 21:00:00	NQ	Futures	5729.45	5735.11	5728.85	5735.11	986.0
2016-08-17 22:00:00	NQ	Futures	5735.11	5738.98	5734.81	5738.39	1102.0
2016-08-17 23:00:00	NQ	Futures	5738.68	5739.28	5736.0	5736.0	420.0
2016-08-17 00:00:00	YM	Futures	19956.1	19957.1	19949.6	19950.7	407.0
2016-08-17 01:00:00	YM	Futures	19952.8	19960.4	19951.8	19958.2	378.0
2016-08-17 02:00:00	YM	Futures	19957.1	19972.2	19956.1	19961.5	870.0
2016-08-17 03:00:00	YM	Futures	19961.5	19972.2	19920.6	19924.9	3614.0

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

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