PREVIEW / futures_1hour / 2016-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-31.parquet
  size:    54 KB
  rows:    1,634

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-03-31 00:00:00	ES	Futures	2216.81	2218.16	2216.54	2217.35	3231.0
2016-03-31 01:00:00	ES	Futures	2217.62	2218.7	2215.73	2216.0	5449.0
2016-03-31 02:00:00	ES	Futures	2216.0	2216.81	2214.65	2216.0	10110.0
2016-03-31 03:00:00	ES	Futures	2216.0	2217.89	2212.22	2212.76	39801.0
2016-03-31 04:00:00	ES	Futures	2212.76	2217.08	2210.87	2216.27	26707.0
2016-03-31 05:00:00	ES	Futures	2216.27	2216.81	2214.11	2215.73	19562.0
2016-03-31 06:00:00	ES	Futures	2215.73	2218.43	2213.84	2217.89	21064.0
2016-03-31 07:00:00	ES	Futures	2217.62	2221.94	2217.62	2219.78	36618.0
2016-03-31 08:00:00	ES	Futures	2219.78	2221.4	2217.89	2219.24	41083.0
2016-03-31 09:00:00	ES	Futures	2219.24	2223.02	2217.08	2219.78	205077.0
2016-03-31 10:00:00	ES	Futures	2219.78	2223.83	2218.7	2221.4	228648.0
2016-03-31 11:00:00	ES	Futures	2221.13	2224.1	2220.05	2223.56	155591.0
2016-03-31 12:00:00	ES	Futures	2223.56	2224.37	2221.67	2221.67	82636.0
2016-03-31 13:00:00	ES	Futures	2221.94	2222.21	2216.54	2217.89	106515.0
2016-03-31 14:00:00	ES	Futures	2217.89	2218.16	2212.49	2214.38	171790.0
2016-03-31 15:00:00	ES	Futures	2214.38	2220.05	2213.3	2214.92	419509.0
2016-03-31 16:00:00	ES	Futures	2214.92	2218.16	2214.11	2216.27	110490.0
2016-03-31 18:00:00	ES	Futures	2216.81	2218.16	2215.46	2217.62	6053.0
2016-03-31 19:00:00	ES	Futures	2217.89	2217.89	2216.27	2216.81	3988.0
2016-03-31 20:00:00	ES	Futures	2216.81	2217.62	2213.84	2217.08	13592.0
2016-03-31 21:00:00	ES	Futures	2217.08	2220.32	2212.49	2213.84	18394.0
2016-03-31 22:00:00	ES	Futures	2213.84	2213.84	2211.41	2212.49	7558.0
2016-03-31 23:00:00	ES	Futures	2212.22	2212.49	2209.79	2210.87	8008.0
2016-03-31 00:00:00	NQ	Futures	5322.51	5325.48	5322.51	5323.7	582.0
2016-03-31 01:00:00	NQ	Futures	5323.4	5327.57	5320.13	5320.72	579.0
2016-03-31 02:00:00	NQ	Futures	5320.43	5322.21	5316.56	5320.72	888.0
2016-03-31 03:00:00	NQ	Futures	5320.72	5325.48	5311.8	5316.26	4325.0
2016-03-31 04:00:00	NQ	Futures	5315.96	5327.27	5310.61	5324.29	2736.0
2016-03-31 05:00:00	NQ	Futures	5324.89	5328.16	5319.53	5324.89	1631.0
2016-03-31 06:00:00	NQ	Futures	5324.89	5331.43	5321.62	5329.95	2340.0
2016-03-31 07:00:00	NQ	Futures	5329.65	5337.98	5329.05	5333.22	2732.0
2016-03-31 08:00:00	NQ	Futures	5333.52	5335.9	5329.65	5333.52	3067.0
2016-03-31 09:00:00	NQ	Futures	5333.52	5340.06	5324.0	5331.43	30294.0
2016-03-31 10:00:00	NQ	Futures	5331.73	5349.29	5328.76	5345.42	29498.0
2016-03-31 11:00:00	NQ	Futures	5345.42	5349.88	5337.39	5346.01	20258.0
2016-03-31 12:00:00	NQ	Futures	5346.31	5350.18	5343.04	5343.63	9857.0
2016-03-31 13:00:00	NQ	Futures	5343.34	5343.63	5327.57	5330.24	12223.0
2016-03-31 14:00:00	NQ	Futures	5329.95	5329.95	5318.64	5325.78	21260.0
2016-03-31 15:00:00	NQ	Futures	5325.78	5337.68	5322.51	5326.38	35078.0
2016-03-31 16:00:00	NQ	Futures	5326.67	5331.73	5324.0	5325.78	6596.0
2016-03-31 18:00:00	NQ	Futures	5329.05	5331.14	5324.89	5330.54	413.0
2016-03-31 19:00:00	NQ	Futures	5330.54	5332.03	5327.86	5329.95	856.0
2016-03-31 20:00:00	NQ	Futures	5329.35	5329.35	5319.53	5328.76	1554.0
2016-03-31 21:00:00	NQ	Futures	5328.16	5335.9	5314.48	5317.75	2372.0
2016-03-31 22:00:00	NQ	Futures	5317.45	5317.75	5311.8	5313.29	1479.0
2016-03-31 23:00:00	NQ	Futures	5312.99	5313.88	5306.74	5309.42	1030.0
2016-03-31 00:00:00	YM	Futures	18843.1	18852.8	18842.1	18847.4	572.0
2016-03-31 01:00:00	YM	Futures	18846.4	18854.9	18834.6	18835.7	1180.0
2016-03-31 02:00:00	YM	Futures	18836.7	18847.4	18824.9	18842.1	1537.0
2016-03-31 03:00:00	YM	Futures	18841.0	18852.8	18808.9	18816.4	3653.0

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

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