PREVIEW / futures_1hour / 2015-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-28.parquet
  size:    50 KB
  rows:    1,537

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
2015-07-28 00:00:00	ES	Futures	2206.13	2209.06	2205.87	2208.26	8522.0
2015-07-28 01:00:00	ES	Futures	2208.26	2211.99	2206.93	2207.46	11295.0
2015-07-28 02:00:00	ES	Futures	2207.2	2209.33	2205.87	2209.06	8503.0
2015-07-28 03:00:00	ES	Futures	2208.8	2210.13	2205.6	2207.2	27964.0
2015-07-28 04:00:00	ES	Futures	2207.46	2211.46	2205.87	2211.19	18592.0
2015-07-28 05:00:00	ES	Futures	2211.19	2212.79	2210.13	2212.26	18033.0
2015-07-28 06:00:00	ES	Futures	2212.26	2213.32	2209.06	2209.33	15233.0
2015-07-28 07:00:00	ES	Futures	2209.59	2210.39	2208.53	2209.33	14595.0
2015-07-28 08:00:00	ES	Futures	2209.59	2211.46	2207.2	2208.53	47977.0
2015-07-28 09:00:00	ES	Futures	2208.8	2208.8	2197.08	2203.74	289007.0
2015-07-28 10:00:00	ES	Futures	2203.74	2206.13	2195.48	2205.87	325526.0
2015-07-28 11:00:00	ES	Futures	2205.87	2211.46	2205.07	2210.93	166926.0
2015-07-28 12:00:00	ES	Futures	2210.93	2215.72	2210.66	2214.65	129820.0
2015-07-28 13:00:00	ES	Futures	2214.92	2221.58	2214.39	2221.04	139221.0
2015-07-28 14:00:00	ES	Futures	2221.04	2224.77	2220.24	2223.97	191340.0
2015-07-28 15:00:00	ES	Futures	2223.71	2224.24	2220.24	2222.37	177993.0
2015-07-28 16:00:00	ES	Futures	2222.64	2224.5	2220.24	2223.97	85420.0
2015-07-28 17:00:00	ES	Futures	2223.97	2224.5	2223.71	2224.24	2136.0
2015-07-28 18:00:00	ES	Futures	2223.71	2224.77	2222.11	2224.24	4045.0
2015-07-28 19:00:00	ES	Futures	2224.24	2224.77	2223.44	2223.97	2795.0
2015-07-28 20:00:00	ES	Futures	2224.24	2224.5	2223.44	2223.71	2772.0
2015-07-28 21:00:00	ES	Futures	2223.71	2223.97	2222.11	2222.11	2242.0
2015-07-28 22:00:00	ES	Futures	2222.11	2222.91	2220.78	2221.04	2902.0
2015-07-28 23:00:00	ES	Futures	2221.04	2221.84	2219.98	2220.24	3793.0
2015-07-28 00:00:00	NQ	Futures	5368.28	5376.86	5367.69	5375.09	1198.0
2015-07-28 01:00:00	NQ	Futures	5374.79	5382.48	5369.47	5369.76	2129.0
2015-07-28 02:00:00	NQ	Futures	5369.76	5377.45	5367.1	5371.54	1679.0
2015-07-28 03:00:00	NQ	Futures	5371.83	5375.09	5362.66	5366.51	4223.0
2015-07-28 04:00:00	NQ	Futures	5366.21	5375.09	5362.07	5374.79	3215.0
2015-07-28 05:00:00	NQ	Futures	5374.49	5381.3	5372.72	5380.11	2792.0
2015-07-28 06:00:00	NQ	Futures	5380.41	5381.59	5372.13	5372.42	2019.0
2015-07-28 07:00:00	NQ	Futures	5372.72	5373.61	5369.17	5371.24	1815.0
2015-07-28 08:00:00	NQ	Futures	5370.65	5375.38	5366.8	5370.35	8309.0
2015-07-28 09:00:00	NQ	Futures	5370.35	5370.35	5325.69	5350.24	52962.0
2015-07-28 10:00:00	NQ	Futures	5350.24	5351.72	5320.66	5345.8	68516.0
2015-07-28 11:00:00	NQ	Futures	5345.51	5360.59	5341.37	5359.7	27111.0
2015-07-28 12:00:00	NQ	Futures	5359.7	5373.9	5359.41	5366.51	17665.0
2015-07-28 13:00:00	NQ	Futures	5366.51	5386.03	5364.44	5385.14	19071.0
2015-07-28 14:00:00	NQ	Futures	5385.44	5396.68	5382.78	5392.54	24588.0
2015-07-28 15:00:00	NQ	Futures	5392.83	5392.83	5379.52	5385.73	25898.0
2015-07-28 16:00:00	NQ	Futures	5385.73	5395.2	5383.96	5394.31	10029.0
2015-07-28 17:00:00	NQ	Futures	5394.31	5395.2	5393.42	5394.61	315.0
2015-07-28 18:00:00	NQ	Futures	5392.83	5394.9	5388.99	5393.42	536.0
2015-07-28 19:00:00	NQ	Futures	5393.42	5394.61	5391.65	5392.24	216.0
2015-07-28 20:00:00	NQ	Futures	5392.83	5394.02	5390.76	5390.76	320.0
2015-07-28 21:00:00	NQ	Futures	5391.06	5392.24	5387.51	5387.8	454.0
2015-07-28 22:00:00	NQ	Futures	5388.1	5388.99	5384.55	5385.14	500.0
2015-07-28 23:00:00	NQ	Futures	5385.14	5387.51	5382.48	5383.07	838.0
2015-07-28 00:00:00	YM	Futures	18378.7	18403.9	18378.7	18397.6	1129.0
2015-07-28 01:00:00	YM	Futures	18397.6	18424.0	18385.0	18387.1	2108.0

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

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