PREVIEW / futures_1hour / 2016-04-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-22.parquet
  size:    46 KB
  rows:    1,348

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-04-22 00:00:00	ES	Futures	2249.2	2253.25	2248.66	2252.44	10138.0
2016-04-22 01:00:00	ES	Futures	2252.44	2252.98	2250.82	2252.71	8294.0
2016-04-22 02:00:00	ES	Futures	2252.71	2255.95	2252.17	2252.98	14639.0
2016-04-22 03:00:00	ES	Futures	2252.98	2253.79	2249.2	2251.09	35644.0
2016-04-22 04:00:00	ES	Futures	2251.09	2252.44	2246.5	2246.5	22987.0
2016-04-22 05:00:00	ES	Futures	2246.5	2250.55	2245.69	2247.85	22139.0
2016-04-22 06:00:00	ES	Futures	2248.12	2254.33	2247.85	2252.71	25398.0
2016-04-22 07:00:00	ES	Futures	2252.98	2254.6	2251.09	2251.9	21605.0
2016-04-22 08:00:00	ES	Futures	2251.9	2252.71	2248.12	2249.74	30754.0
2016-04-22 09:00:00	ES	Futures	2249.74	2254.87	2247.04	2254.06	223701.0
2016-04-22 10:00:00	ES	Futures	2254.06	2255.95	2240.83	2242.18	261590.0
2016-04-22 11:00:00	ES	Futures	2242.18	2247.31	2241.64	2246.77	162071.0
2016-04-22 12:00:00	ES	Futures	2246.77	2247.04	2241.91	2242.99	94357.0
2016-04-22 13:00:00	ES	Futures	2243.26	2251.36	2242.45	2249.47	116876.0
2016-04-22 14:00:00	ES	Futures	2249.47	2253.52	2248.39	2252.71	109679.0
2016-04-22 15:00:00	ES	Futures	2252.71	2253.52	2248.93	2252.71	229491.0
2016-04-22 16:00:00	ES	Futures	2252.44	2253.79	2251.36	2252.71	60496.0
2016-04-22 00:00:00	NQ	Futures	5341.85	5353.15	5340.36	5349.88	1493.0
2016-04-22 01:00:00	NQ	Futures	5349.88	5351.67	5345.12	5350.77	1040.0
2016-04-22 02:00:00	NQ	Futures	5350.48	5357.62	5348.69	5350.48	2314.0
2016-04-22 03:00:00	NQ	Futures	5350.18	5354.34	5340.66	5347.2	5022.0
2016-04-22 04:00:00	NQ	Futures	5347.5	5352.26	5336.49	5336.79	2808.0
2016-04-22 05:00:00	NQ	Futures	5337.09	5347.2	5334.41	5341.25	1839.0
2016-04-22 06:00:00	NQ	Futures	5340.96	5354.64	5340.96	5350.18	2568.0
2016-04-22 07:00:00	NQ	Futures	5350.77	5356.43	5346.91	5348.39	2636.0
2016-04-22 08:00:00	NQ	Futures	5348.69	5350.48	5341.25	5342.44	4144.0
2016-04-22 09:00:00	NQ	Futures	5342.44	5351.96	5321.62	5336.49	49574.0
2016-04-22 10:00:00	NQ	Futures	5336.79	5340.06	5273.42	5281.75	65235.0
2016-04-22 11:00:00	NQ	Futures	5282.04	5295.43	5276.09	5295.14	36957.0
2016-04-22 12:00:00	NQ	Futures	5295.14	5296.03	5276.69	5282.34	20819.0
2016-04-22 13:00:00	NQ	Futures	5282.34	5309.42	5282.34	5301.98	18593.0
2016-04-22 14:00:00	NQ	Futures	5301.68	5320.43	5297.52	5317.75	17382.0
2016-04-22 15:00:00	NQ	Futures	5317.75	5321.32	5307.63	5315.96	31151.0
2016-04-22 16:00:00	NQ	Futures	5315.67	5317.15	5312.1	5315.96	5566.0
2016-04-22 00:00:00	YM	Futures	19149.3	19199.6	19145.0	19192.1	5349.0
2016-04-22 01:00:00	YM	Futures	19192.1	19196.4	19176.0	19182.5	1883.0
2016-04-22 02:00:00	YM	Futures	19184.6	19204.9	19180.3	19183.5	1611.0
2016-04-22 03:00:00	YM	Futures	19182.5	19190.0	19149.3	19164.3	3683.0
2016-04-22 04:00:00	YM	Futures	19165.3	19175.0	19128.9	19128.9	2069.0
2016-04-22 05:00:00	YM	Futures	19128.9	19154.6	19120.4	19134.3	2062.0
2016-04-22 06:00:00	YM	Futures	19134.3	19181.4	19134.3	19170.7	2145.0
2016-04-22 07:00:00	YM	Futures	19170.7	19183.5	19151.4	19169.6	3982.0
2016-04-22 08:00:00	YM	Futures	19168.5	19178.2	19145.0	19160.0	3707.0
2016-04-22 09:00:00	YM	Futures	19160.0	19214.6	19149.3	19199.6	24312.0
2016-04-22 10:00:00	YM	Futures	19199.6	19214.6	19081.8	19090.4	23489.0
2016-04-22 11:00:00	YM	Futures	19090.4	19156.8	19090.4	19146.1	15429.0
2016-04-22 12:00:00	YM	Futures	19146.1	19148.2	19102.2	19115.0	8347.0
2016-04-22 13:00:00	YM	Futures	19115.0	19184.6	19111.8	19170.7	10285.0
2016-04-22 14:00:00	YM	Futures	19170.7	19198.5	19163.2	19191.0	8589.0
2016-04-22 15:00:00	YM	Futures	19191.0	19197.4	19163.2	19186.7	14373.0

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

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