PREVIEW / futures_1hour / 2016-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-12.parquet
  size:    54 KB
  rows:    1,623

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-12 00:00:00	ES	Futures	2197.91	2200.07	2197.64	2199.26	4136.0
2016-04-12 01:00:00	ES	Futures	2199.53	2201.42	2198.72	2200.07	5501.0
2016-04-12 02:00:00	ES	Futures	2200.07	2203.58	2198.18	2203.04	15195.0
2016-04-12 03:00:00	ES	Futures	2203.04	2204.12	2196.83	2199.26	38669.0
2016-04-12 04:00:00	ES	Futures	2199.26	2201.96	2194.94	2200.61	26937.0
2016-04-12 05:00:00	ES	Futures	2200.61	2205.2	2200.34	2204.12	20992.0
2016-04-12 06:00:00	ES	Futures	2204.12	2206.28	2203.31	2204.93	16680.0
2016-04-12 07:00:00	ES	Futures	2204.66	2206.01	2200.88	2203.04	27123.0
2016-04-12 08:00:00	ES	Futures	2203.04	2204.66	2200.07	2201.15	36297.0
2016-04-12 09:00:00	ES	Futures	2200.88	2206.82	2198.72	2203.58	237431.0
2016-04-12 10:00:00	ES	Futures	2203.31	2210.06	2194.94	2208.98	431453.0
2016-04-12 11:00:00	ES	Futures	2209.25	2215.19	2207.63	2212.49	219210.0
2016-04-12 12:00:00	ES	Futures	2212.49	2217.08	2210.87	2215.73	113442.0
2016-04-12 13:00:00	ES	Futures	2216.0	2216.81	2212.49	2216.54	110733.0
2016-04-12 14:00:00	ES	Futures	2216.54	2220.32	2215.19	2219.51	123420.0
2016-04-12 15:00:00	ES	Futures	2219.78	2223.02	2216.0	2219.51	274948.0
2016-04-12 16:00:00	ES	Futures	2219.51	2220.86	2217.35	2219.78	74622.0
2016-04-12 18:00:00	ES	Futures	2219.51	2219.78	2218.16	2219.51	2756.0
2016-04-12 19:00:00	ES	Futures	2219.78	2221.13	2218.7	2220.59	3734.0
2016-04-12 20:00:00	ES	Futures	2220.32	2221.94	2219.24	2219.78	5173.0
2016-04-12 21:00:00	ES	Futures	2219.51	2223.83	2219.24	2223.02	7015.0
2016-04-12 22:00:00	ES	Futures	2223.02	2226.25	2222.75	2223.56	12542.0
2016-04-12 23:00:00	ES	Futures	2223.56	2225.98	2223.29	2225.72	5107.0
2016-04-12 00:00:00	NQ	Futures	5296.92	5305.25	5296.92	5304.06	1117.0
2016-04-12 01:00:00	NQ	Futures	5304.06	5310.61	5301.68	5305.55	860.0
2016-04-12 02:00:00	NQ	Futures	5306.14	5316.56	5301.68	5314.77	1686.0
2016-04-12 03:00:00	NQ	Futures	5315.07	5318.05	5296.03	5300.79	5001.0
2016-04-12 04:00:00	NQ	Futures	5301.09	5307.04	5287.7	5302.87	3351.0
2016-04-12 05:00:00	NQ	Futures	5303.17	5320.43	5301.09	5317.45	2752.0
2016-04-12 06:00:00	NQ	Futures	5318.05	5323.1	5313.88	5318.34	3164.0
2016-04-12 07:00:00	NQ	Futures	5318.64	5320.72	5307.33	5310.91	2505.0
2016-04-12 08:00:00	NQ	Futures	5311.5	5315.07	5302.87	5304.95	3735.0
2016-04-12 09:00:00	NQ	Futures	5304.95	5307.93	5288.0	5292.16	34003.0
2016-04-12 10:00:00	NQ	Futures	5291.57	5313.88	5268.06	5312.69	61758.0
2016-04-12 11:00:00	NQ	Futures	5312.39	5330.24	5307.93	5314.77	29755.0
2016-04-12 12:00:00	NQ	Futures	5314.77	5332.33	5313.58	5326.38	15178.0
2016-04-12 13:00:00	NQ	Futures	5326.67	5331.73	5314.18	5330.54	15589.0
2016-04-12 14:00:00	NQ	Futures	5330.54	5343.63	5326.38	5340.66	20183.0
2016-04-12 15:00:00	NQ	Futures	5340.66	5352.56	5334.11	5342.15	35808.0
2016-04-12 16:00:00	NQ	Futures	5342.15	5344.53	5337.39	5343.04	6390.0
2016-04-12 18:00:00	NQ	Futures	5342.44	5344.23	5339.77	5343.93	380.0
2016-04-12 19:00:00	NQ	Futures	5343.63	5347.5	5341.25	5345.72	423.0
2016-04-12 20:00:00	NQ	Futures	5346.01	5350.48	5342.15	5343.63	749.0
2016-04-12 21:00:00	NQ	Futures	5343.93	5355.53	5341.85	5353.75	904.0
2016-04-12 22:00:00	NQ	Futures	5354.64	5363.57	5353.15	5357.32	1715.0
2016-04-12 23:00:00	NQ	Futures	5357.62	5365.35	5356.13	5364.16	1629.0
2016-04-12 00:00:00	YM	Futures	18708.3	18724.3	18708.3	18716.8	447.0
2016-04-12 01:00:00	YM	Futures	18717.9	18734.0	18712.6	18719.0	889.0
2016-04-12 02:00:00	YM	Futures	18721.1	18744.7	18704.0	18739.3	1536.0
2016-04-12 03:00:00	YM	Futures	18740.4	18747.9	18686.9	18707.2	4896.0

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

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