PREVIEW / futures_1hour / 2016-12-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-30.parquet
  size:    43 KB
  rows:    1,277

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-12-30 00:00:00	ES	Futures	2454.65	2457.92	2454.1	2456.28	7455.0
2016-12-30 01:00:00	ES	Futures	2456.28	2457.1	2455.74	2455.74	2739.0
2016-12-30 02:00:00	ES	Futures	2456.01	2456.01	2454.65	2454.92	2846.0
2016-12-30 03:00:00	ES	Futures	2454.65	2456.83	2453.01	2454.1	8914.0
2016-12-30 04:00:00	ES	Futures	2454.37	2455.19	2453.83	2455.19	4626.0
2016-12-30 05:00:00	ES	Futures	2455.19	2455.74	2454.1	2454.92	5674.0
2016-12-30 06:00:00	ES	Futures	2454.92	2455.19	2453.56	2454.92	5275.0
2016-12-30 07:00:00	ES	Futures	2455.19	2456.83	2452.47	2456.28	9827.0
2016-12-30 08:00:00	ES	Futures	2456.56	2456.83	2454.37	2454.37	13693.0
2016-12-30 09:00:00	ES	Futures	2454.65	2455.47	2442.1	2442.65	200631.0
2016-12-30 10:00:00	ES	Futures	2442.65	2444.28	2440.46	2444.01	132019.0
2016-12-30 11:00:00	ES	Futures	2443.74	2447.28	2442.1	2444.83	77303.0
2016-12-30 12:00:00	ES	Futures	2445.1	2445.37	2438.55	2440.19	83848.0
2016-12-30 13:00:00	ES	Futures	2440.19	2442.65	2438.55	2438.83	63274.0
2016-12-30 14:00:00	ES	Futures	2438.83	2439.37	2430.92	2432.83	107180.0
2016-12-30 15:00:00	ES	Futures	2432.83	2441.01	2431.74	2440.46	384557.0
2016-12-30 16:00:00	ES	Futures	2440.74	2441.28	2436.37	2436.92	122095.0
2016-12-30 00:00:00	NQ	Futures	5886.45	5894.8	5886.15	5888.83	1531.0
2016-12-30 01:00:00	NQ	Futures	5888.83	5889.13	5886.15	5886.15	562.0
2016-12-30 02:00:00	NQ	Futures	5885.85	5887.34	5884.66	5884.66	1009.0
2016-12-30 03:00:00	NQ	Futures	5884.66	5887.64	5879.59	5883.46	1828.0
2016-12-30 04:00:00	NQ	Futures	5883.46	5884.66	5881.67	5883.46	710.0
2016-12-30 05:00:00	NQ	Futures	5883.76	5884.36	5880.78	5882.57	698.0
2016-12-30 06:00:00	NQ	Futures	5882.27	5882.57	5879.59	5882.27	675.0
2016-12-30 07:00:00	NQ	Futures	5882.27	5886.45	5876.3	5884.96	2278.0
2016-12-30 08:00:00	NQ	Futures	5884.96	5886.15	5879.29	5879.29	1701.0
2016-12-30 09:00:00	NQ	Futures	5878.99	5879.59	5823.2	5824.4	36419.0
2016-12-30 10:00:00	NQ	Futures	5824.4	5830.36	5811.57	5823.8	35288.0
2016-12-30 11:00:00	NQ	Futures	5823.5	5828.87	5815.45	5820.82	14484.0
2016-12-30 12:00:00	NQ	Futures	5820.22	5821.41	5796.95	5805.3	21058.0
2016-12-30 13:00:00	NQ	Futures	5805.6	5811.87	5796.95	5798.14	11621.0
2016-12-30 14:00:00	NQ	Futures	5798.14	5801.43	5787.4	5792.18	14507.0
2016-12-30 15:00:00	NQ	Futures	5791.88	5807.09	5788.0	5806.5	28145.0
2016-12-30 16:00:00	NQ	Futures	5806.5	5807.99	5799.34	5802.02	8788.0
2016-12-30 00:00:00	YM	Futures	21471.9	21496.8	21470.8	21484.9	1739.0
2016-12-30 01:00:00	YM	Futures	21483.8	21489.2	21480.5	21480.5	625.0
2016-12-30 02:00:00	YM	Futures	21480.5	21486.0	21474.0	21479.4	1067.0
2016-12-30 03:00:00	YM	Futures	21479.4	21486.0	21461.0	21466.4	2591.0
2016-12-30 04:00:00	YM	Futures	21466.4	21474.0	21463.2	21474.0	999.0
2016-12-30 05:00:00	YM	Futures	21474.0	21476.2	21463.2	21469.7	1182.0
2016-12-30 06:00:00	YM	Futures	21470.8	21471.9	21462.1	21470.8	798.0
2016-12-30 07:00:00	YM	Futures	21470.8	21487.0	21457.8	21482.7	1880.0
2016-12-30 08:00:00	YM	Futures	21482.7	21487.0	21472.9	21474.0	1575.0
2016-12-30 09:00:00	YM	Futures	21475.1	21477.3	21401.3	21405.7	20523.0
2016-12-30 10:00:00	YM	Futures	21403.5	21418.7	21395.9	21412.2	13177.0
2016-12-30 11:00:00	YM	Futures	21412.2	21443.7	21402.4	21430.6	7313.0
2016-12-30 12:00:00	YM	Futures	21429.6	21436.1	21394.8	21404.6	8732.0
2016-12-30 13:00:00	YM	Futures	21404.6	21417.6	21390.5	21394.8	5699.0
2016-12-30 14:00:00	YM	Futures	21393.8	21398.1	21327.6	21343.9	11605.0
2016-12-30 15:00:00	YM	Futures	21342.8	21398.1	21334.1	21397.0	20062.0

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

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