PREVIEW / futures_1hour / 2016-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-08.parquet
  size:    45 KB
  rows:    1,320

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-08 00:00:00	ES	Futures	2199.53	2204.93	2199.26	2203.58	10077.0
2016-04-08 01:00:00	ES	Futures	2203.31	2208.17	2203.04	2203.85	13380.0
2016-04-08 02:00:00	ES	Futures	2203.85	2207.09	2203.85	2205.74	15970.0
2016-04-08 03:00:00	ES	Futures	2205.74	2212.76	2205.47	2211.14	52775.0
2016-04-08 04:00:00	ES	Futures	2210.87	2212.76	2208.71	2210.06	26857.0
2016-04-08 05:00:00	ES	Futures	2210.06	2211.14	2206.82	2210.33	21471.0
2016-04-08 06:00:00	ES	Futures	2210.06	2212.49	2208.71	2210.6	21199.0
2016-04-08 07:00:00	ES	Futures	2210.33	2211.68	2208.44	2209.52	25100.0
2016-04-08 08:00:00	ES	Futures	2209.52	2217.08	2208.71	2216.0	68132.0
2016-04-08 09:00:00	ES	Futures	2215.73	2216.54	2209.52	2215.19	251730.0
2016-04-08 10:00:00	ES	Futures	2215.19	2218.43	2211.41	2211.68	241358.0
2016-04-08 11:00:00	ES	Futures	2211.95	2214.65	2203.04	2206.28	233338.0
2016-04-08 12:00:00	ES	Futures	2206.28	2207.63	2201.42	2206.28	148935.0
2016-04-08 13:00:00	ES	Futures	2206.01	2207.9	2200.88	2207.9	119378.0
2016-04-08 14:00:00	ES	Futures	2207.9	2209.79	2200.88	2202.77	130999.0
2016-04-08 15:00:00	ES	Futures	2202.77	2204.12	2196.56	2203.85	264692.0
2016-04-08 16:00:00	ES	Futures	2203.85	2205.2	2202.77	2204.93	67574.0
2016-04-08 00:00:00	NQ	Futures	5326.38	5339.47	5326.38	5336.79	1820.0
2016-04-08 01:00:00	NQ	Futures	5335.9	5349.58	5335.9	5338.87	2713.0
2016-04-08 02:00:00	NQ	Futures	5339.17	5346.31	5339.17	5343.34	1434.0
2016-04-08 03:00:00	NQ	Futures	5343.34	5360.0	5343.04	5357.32	5625.0
2016-04-08 04:00:00	NQ	Futures	5357.02	5361.19	5348.99	5353.15	2820.0
2016-04-08 05:00:00	NQ	Futures	5353.45	5355.83	5343.04	5354.34	2174.0
2016-04-08 06:00:00	NQ	Futures	5354.05	5358.51	5348.99	5353.15	2251.0
2016-04-08 07:00:00	NQ	Futures	5353.15	5355.83	5347.5	5350.18	2560.0
2016-04-08 08:00:00	NQ	Futures	5350.18	5365.06	5348.39	5362.97	7165.0
2016-04-08 09:00:00	NQ	Futures	5363.27	5365.65	5337.39	5357.91	35951.0
2016-04-08 10:00:00	NQ	Futures	5358.21	5367.14	5336.49	5337.39	33401.0
2016-04-08 11:00:00	NQ	Futures	5337.68	5347.8	5308.52	5320.13	31655.0
2016-04-08 12:00:00	NQ	Futures	5320.43	5323.1	5297.81	5316.86	23798.0
2016-04-08 13:00:00	NQ	Futures	5316.86	5323.4	5300.79	5323.4	17005.0
2016-04-08 14:00:00	NQ	Futures	5323.1	5333.22	5310.01	5315.37	18887.0
2016-04-08 15:00:00	NQ	Futures	5315.67	5317.75	5298.71	5316.86	30848.0
2016-04-08 16:00:00	NQ	Futures	5316.86	5319.83	5315.07	5319.24	4409.0
2016-04-08 00:00:00	YM	Futures	18701.9	18747.9	18701.9	18736.1	2208.0
2016-04-08 01:00:00	YM	Futures	18736.1	18772.5	18732.9	18739.3	2473.0
2016-04-08 02:00:00	YM	Futures	18739.3	18761.8	18738.2	18749.0	1661.0
2016-04-08 03:00:00	YM	Futures	18749.0	18800.3	18749.0	18787.5	6660.0
2016-04-08 04:00:00	YM	Futures	18787.5	18801.4	18770.4	18778.9	2708.0
2016-04-08 05:00:00	YM	Futures	18781.1	18787.5	18752.2	18782.1	2149.0
2016-04-08 06:00:00	YM	Futures	18778.9	18795.0	18763.9	18781.1	2718.0
2016-04-08 07:00:00	YM	Futures	18781.1	18792.8	18763.9	18777.9	2087.0
2016-04-08 08:00:00	YM	Futures	18777.9	18830.3	18769.3	18816.4	7338.0
2016-04-08 09:00:00	YM	Futures	18816.4	18824.9	18776.8	18821.7	24939.0
2016-04-08 10:00:00	YM	Futures	18823.9	18848.5	18792.8	18795.0	21579.0
2016-04-08 11:00:00	YM	Futures	18795.0	18814.2	18723.3	18749.0	20330.0
2016-04-08 12:00:00	YM	Futures	18750.0	18758.6	18704.0	18744.7	14164.0
2016-04-08 13:00:00	YM	Futures	18743.6	18753.2	18708.3	18753.2	9457.0
2016-04-08 14:00:00	YM	Futures	18753.2	18768.2	18706.1	18722.2	10225.0
2016-04-08 15:00:00	YM	Futures	18722.2	18725.4	18665.5	18723.3	16911.0

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

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