PREVIEW / futures_1hour / 2016-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-25.parquet
  size:    51 KB
  rows:    1,613

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-05-25 00:00:00	ES	Futures	2245.42	2246.5	2244.61	2245.69	4942.0
2016-05-25 01:00:00	ES	Futures	2245.69	2246.5	2244.07	2244.61	5017.0
2016-05-25 02:00:00	ES	Futures	2244.88	2251.09	2243.8	2247.31	26607.0
2016-05-25 03:00:00	ES	Futures	2247.58	2247.85	2244.61	2247.04	29780.0
2016-05-25 04:00:00	ES	Futures	2247.04	2250.82	2246.23	2250.01	24441.0
2016-05-25 05:00:00	ES	Futures	2250.01	2252.17	2249.47	2251.09	21221.0
2016-05-25 06:00:00	ES	Futures	2251.09	2251.36	2248.66	2249.2	15121.0
2016-05-25 07:00:00	ES	Futures	2249.47	2250.55	2247.58	2249.47	16569.0
2016-05-25 08:00:00	ES	Futures	2249.2	2251.09	2248.66	2249.74	21301.0
2016-05-25 09:00:00	ES	Futures	2249.47	2254.33	2246.5	2253.79	220246.0
2016-05-25 10:00:00	ES	Futures	2253.52	2259.19	2253.52	2255.68	276088.0
2016-05-25 11:00:00	ES	Futures	2255.95	2257.84	2252.98	2254.6	169111.0
2016-05-25 12:00:00	ES	Futures	2254.6	2255.41	2252.71	2254.87	89574.0
2016-05-25 13:00:00	ES	Futures	2254.87	2258.65	2254.6	2257.84	92238.0
2016-05-25 14:00:00	ES	Futures	2258.11	2259.19	2253.25	2253.79	116822.0
2016-05-25 15:00:00	ES	Futures	2253.79	2259.73	2252.98	2253.52	201542.0
2016-05-25 16:00:00	ES	Futures	2253.79	2255.68	2253.25	2255.68	64886.0
2016-05-25 18:00:00	ES	Futures	2255.68	2255.95	2253.52	2254.33	3159.0
2016-05-25 19:00:00	ES	Futures	2254.6	2254.6	2251.9	2252.98	3957.0
2016-05-25 20:00:00	ES	Futures	2252.71	2252.98	2249.74	2250.01	11524.0
2016-05-25 21:00:00	ES	Futures	2250.01	2251.63	2248.93	2249.74	6649.0
2016-05-25 22:00:00	ES	Futures	2250.01	2250.82	2248.93	2249.74	4115.0
2016-05-25 23:00:00	ES	Futures	2249.74	2251.63	2249.47	2250.01	3309.0
2016-05-25 00:00:00	NQ	Futures	5305.55	5308.82	5304.36	5306.74	795.0
2016-05-25 01:00:00	NQ	Futures	5306.74	5308.82	5300.79	5301.98	908.0
2016-05-25 02:00:00	NQ	Futures	5301.98	5318.64	5299.9	5310.01	3544.0
2016-05-25 03:00:00	NQ	Futures	5310.31	5312.39	5302.57	5310.31	3663.0
2016-05-25 04:00:00	NQ	Futures	5310.31	5318.05	5308.23	5317.15	2179.0
2016-05-25 05:00:00	NQ	Futures	5316.86	5323.1	5314.77	5319.83	1893.0
2016-05-25 06:00:00	NQ	Futures	5320.72	5320.72	5312.69	5313.58	1732.0
2016-05-25 07:00:00	NQ	Futures	5313.88	5317.15	5310.01	5314.18	2434.0
2016-05-25 08:00:00	NQ	Futures	5313.88	5318.34	5312.99	5314.18	3025.0
2016-05-25 09:00:00	NQ	Futures	5314.18	5323.4	5298.71	5320.72	39928.0
2016-05-25 10:00:00	NQ	Futures	5320.43	5331.14	5318.34	5325.19	43064.0
2016-05-25 11:00:00	NQ	Futures	5325.48	5330.54	5315.67	5323.7	27652.0
2016-05-25 12:00:00	NQ	Futures	5323.7	5327.86	5321.32	5327.57	18296.0
2016-05-25 13:00:00	NQ	Futures	5327.57	5343.04	5327.57	5338.58	26432.0
2016-05-25 14:00:00	NQ	Futures	5338.58	5339.17	5320.43	5320.72	19772.0
2016-05-25 15:00:00	NQ	Futures	5321.02	5335.9	5318.64	5326.08	27669.0
2016-05-25 16:00:00	NQ	Futures	5326.08	5329.35	5322.51	5327.57	6461.0
2016-05-25 18:00:00	NQ	Futures	5324.0	5329.35	5323.4	5326.08	331.0
2016-05-25 19:00:00	NQ	Futures	5326.08	5326.38	5321.62	5322.81	596.0
2016-05-25 20:00:00	NQ	Futures	5322.51	5323.7	5314.48	5315.37	970.0
2016-05-25 21:00:00	NQ	Futures	5315.37	5321.02	5312.1	5315.67	1090.0
2016-05-25 22:00:00	NQ	Futures	5315.07	5317.15	5312.99	5314.77	526.0
2016-05-25 23:00:00	NQ	Futures	5314.48	5320.13	5314.18	5317.15	743.0
2016-05-25 00:00:00	YM	Futures	18978.0	18985.5	18972.7	18978.0	631.0
2016-05-25 01:00:00	YM	Futures	18978.0	18984.4	18965.2	18968.4	846.0
2016-05-25 02:00:00	YM	Futures	18968.4	19014.4	18963.0	18994.1	2692.0
2016-05-25 03:00:00	YM	Futures	18995.1	18997.3	18972.7	18987.6	3223.0

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

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