PREVIEW / futures_1hour / 2016-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-23.parquet
  size:    43 KB
  rows:    1,300

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-09-23 00:00:00	ES	Futures	2359.2	2359.47	2358.92	2359.2	1699.0
2016-09-23 01:00:00	ES	Futures	2359.2	2359.47	2358.65	2359.2	2447.0
2016-09-23 02:00:00	ES	Futures	2358.92	2359.47	2358.11	2358.92	5103.0
2016-09-23 03:00:00	ES	Futures	2359.2	2361.1	2355.39	2357.02	23607.0
2016-09-23 04:00:00	ES	Futures	2356.75	2357.29	2354.3	2354.84	16571.0
2016-09-23 05:00:00	ES	Futures	2355.12	2358.11	2354.84	2356.48	13966.0
2016-09-23 06:00:00	ES	Futures	2356.2	2357.84	2355.12	2355.39	12473.0
2016-09-23 07:00:00	ES	Futures	2355.66	2356.75	2354.57	2355.39	14483.0
2016-09-23 08:00:00	ES	Futures	2355.39	2357.84	2355.12	2357.56	24359.0
2016-09-23 09:00:00	ES	Futures	2357.56	2358.38	2352.67	2354.03	201711.0
2016-09-23 10:00:00	ES	Futures	2354.03	2356.48	2352.67	2355.12	176629.0
2016-09-23 11:00:00	ES	Futures	2355.39	2356.75	2352.4	2353.21	165304.0
2016-09-23 12:00:00	ES	Futures	2353.21	2354.84	2352.4	2353.21	76409.0
2016-09-23 13:00:00	ES	Futures	2353.21	2353.48	2346.41	2347.23	165839.0
2016-09-23 14:00:00	ES	Futures	2346.95	2351.31	2346.68	2350.76	146477.0
2016-09-23 15:00:00	ES	Futures	2350.76	2354.03	2347.23	2347.77	269670.0
2016-09-23 16:00:00	ES	Futures	2347.77	2350.22	2347.5	2348.04	97396.0
2016-09-23 00:00:00	NQ	Futures	5830.06	5831.55	5830.06	5830.66	192.0
2016-09-23 01:00:00	NQ	Futures	5830.66	5832.15	5829.46	5830.36	483.0
2016-09-23 02:00:00	NQ	Futures	5830.36	5832.45	5828.57	5830.36	644.0
2016-09-23 03:00:00	NQ	Futures	5830.66	5835.13	5823.5	5827.67	3304.0
2016-09-23 04:00:00	NQ	Futures	5827.38	5827.67	5820.51	5821.71	2448.0
2016-09-23 05:00:00	NQ	Futures	5822.01	5828.57	5822.01	5823.2	2064.0
2016-09-23 06:00:00	NQ	Futures	5823.5	5826.48	5820.81	5821.71	1998.0
2016-09-23 07:00:00	NQ	Futures	5822.01	5824.09	5817.83	5819.62	2582.0
2016-09-23 08:00:00	NQ	Futures	5819.32	5826.18	5818.72	5825.29	3597.0
2016-09-23 09:00:00	NQ	Futures	5825.29	5827.67	5811.56	5811.86	31457.0
2016-09-23 10:00:00	NQ	Futures	5812.16	5815.74	5804.11	5811.27	27737.0
2016-09-23 11:00:00	NQ	Futures	5811.27	5819.62	5809.77	5813.06	18978.0
2016-09-23 12:00:00	NQ	Futures	5813.06	5820.22	5812.16	5816.34	9703.0
2016-09-23 13:00:00	NQ	Futures	5816.34	5816.93	5785.61	5790.68	23829.0
2016-09-23 14:00:00	NQ	Futures	5790.38	5803.21	5787.4	5800.53	24150.0
2016-09-23 15:00:00	NQ	Futures	5800.23	5809.18	5792.77	5793.96	27601.0
2016-09-23 16:00:00	NQ	Futures	5793.96	5797.84	5792.47	5796.35	5746.0
2016-09-23 00:00:00	YM	Futures	19773.6	19776.9	19772.6	19772.6	254.0
2016-09-23 01:00:00	YM	Futures	19772.6	19780.1	19770.4	19775.8	537.0
2016-09-23 02:00:00	YM	Futures	19774.7	19778.0	19768.2	19774.7	730.0
2016-09-23 03:00:00	YM	Futures	19774.7	19787.7	19742.3	19754.2	3189.0
2016-09-23 04:00:00	YM	Futures	19753.1	19756.3	19738.0	19743.4	1869.0
2016-09-23 05:00:00	YM	Futures	19743.4	19772.6	19743.4	19759.6	1946.0
2016-09-23 06:00:00	YM	Futures	19759.6	19770.4	19749.9	19753.1	1276.0
2016-09-23 07:00:00	YM	Futures	19753.1	19761.7	19742.3	19750.9	1521.0
2016-09-23 08:00:00	YM	Futures	19750.9	19772.6	19749.9	19769.3	2665.0
2016-09-23 09:00:00	YM	Futures	19770.4	19775.8	19730.4	19741.2	16477.0
2016-09-23 10:00:00	YM	Futures	19744.5	19745.5	19719.6	19728.2	13685.0
2016-09-23 11:00:00	YM	Futures	19728.2	19741.2	19709.9	19715.3	10274.0
2016-09-23 12:00:00	YM	Futures	19715.3	19718.5	19696.9	19705.5	6348.0
2016-09-23 13:00:00	YM	Futures	19705.5	19706.6	19632.1	19639.6	12910.0
2016-09-23 14:00:00	YM	Futures	19639.6	19680.7	19634.2	19676.4	10530.0
2016-09-23 15:00:00	YM	Futures	19676.4	19702.3	19643.9	19647.2	13734.0

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

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