PREVIEW / futures_1hour / 2014-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-29.parquet
  size:    49 KB
  rows:    1,523

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
2014-12-29 00:00:00	ES	Futures	2195.74	2196.27	2194.42	2195.48	2152.0
2014-12-29 01:00:00	ES	Futures	2195.48	2196.27	2194.95	2196.0	691.0
2014-12-29 02:00:00	ES	Futures	2196.27	2196.53	2194.42	2194.69	3078.0
2014-12-29 03:00:00	ES	Futures	2194.69	2195.48	2193.37	2193.9	8533.0
2014-12-29 04:00:00	ES	Futures	2194.16	2194.16	2188.63	2190.74	15815.0
2014-12-29 05:00:00	ES	Futures	2190.74	2191.79	2185.21	2188.63	17896.0
2014-12-29 06:00:00	ES	Futures	2188.9	2191.79	2188.11	2191.53	11742.0
2014-12-29 07:00:00	ES	Futures	2191.27	2192.05	2187.32	2187.84	11038.0
2014-12-29 08:00:00	ES	Futures	2187.84	2191.79	2186.79	2191.0	16411.0
2014-12-29 09:00:00	ES	Futures	2191.27	2197.32	2189.69	2196.79	109099.0
2014-12-29 10:00:00	ES	Futures	2196.79	2198.63	2195.74	2198.11	86690.0
2014-12-29 11:00:00	ES	Futures	2197.84	2198.63	2196.79	2197.32	66092.0
2014-12-29 12:00:00	ES	Futures	2197.32	2198.63	2194.69	2194.95	54605.0
2014-12-29 13:00:00	ES	Futures	2194.95	2197.58	2194.16	2195.74	51430.0
2014-12-29 14:00:00	ES	Futures	2195.48	2196.79	2194.69	2196.79	39104.0
2014-12-29 15:00:00	ES	Futures	2196.53	2197.32	2194.16	2195.48	85933.0
2014-12-29 16:00:00	ES	Futures	2195.74	2197.84	2195.21	2197.84	39537.0
2014-12-29 17:00:00	ES	Futures	2197.58	2197.58	2197.05	2197.05	898.0
2014-12-29 18:00:00	ES	Futures	2197.32	2197.84	2196.79	2197.32	1638.0
2014-12-29 19:00:00	ES	Futures	2197.32	2198.11	2197.05	2198.11	2054.0
2014-12-29 20:00:00	ES	Futures	2197.84	2198.11	2197.05	2197.32	1664.0
2014-12-29 21:00:00	ES	Futures	2197.58	2197.84	2197.05	2197.58	1069.0
2014-12-29 22:00:00	ES	Futures	2197.58	2198.11	2197.32	2197.58	952.0
2014-12-29 23:00:00	ES	Futures	2197.32	2198.37	2197.32	2197.84	1519.0
2014-12-29 00:00:00	NQ	Futures	5073.76	5074.94	5071.41	5072.29	427.0
2014-12-29 01:00:00	NQ	Futures	5072.88	5073.76	5071.7	5073.76	129.0
2014-12-29 02:00:00	NQ	Futures	5073.47	5074.64	5072.59	5073.17	706.0
2014-12-29 03:00:00	NQ	Futures	5073.47	5074.94	5067.89	5069.06	1455.0
2014-12-29 04:00:00	NQ	Futures	5068.77	5069.36	5058.49	5062.6	2331.0
2014-12-29 05:00:00	NQ	Futures	5062.89	5065.54	5049.38	5054.96	3678.0
2014-12-29 06:00:00	NQ	Futures	5055.26	5061.43	5054.67	5061.13	2050.0
2014-12-29 07:00:00	NQ	Futures	5061.13	5062.31	5050.56	5052.91	2221.0
2014-12-29 08:00:00	NQ	Futures	5052.91	5059.96	5049.97	5058.49	3413.0
2014-12-29 09:00:00	NQ	Futures	5058.2	5070.82	5055.85	5066.42	23758.0
2014-12-29 10:00:00	NQ	Futures	5066.42	5070.53	5059.37	5069.06	15062.0
2014-12-29 11:00:00	NQ	Futures	5069.06	5074.64	5067.01	5071.12	9185.0
2014-12-29 12:00:00	NQ	Futures	5070.82	5072.88	5066.71	5067.01	5044.0
2014-12-29 13:00:00	NQ	Futures	5066.71	5071.12	5061.43	5063.48	7376.0
2014-12-29 14:00:00	NQ	Futures	5063.48	5067.89	5060.54	5066.71	5166.0
2014-12-29 15:00:00	NQ	Futures	5066.71	5068.77	5061.13	5062.89	12442.0
2014-12-29 16:00:00	NQ	Futures	5063.19	5071.7	5062.01	5071.7	5475.0
2014-12-29 17:00:00	NQ	Futures	5071.12	5071.7	5070.24	5070.82	98.0
2014-12-29 18:00:00	NQ	Futures	5070.53	5071.7	5069.36	5069.36	98.0
2014-12-29 19:00:00	NQ	Futures	5069.65	5070.82	5069.06	5070.82	264.0
2014-12-29 20:00:00	NQ	Futures	5071.12	5071.41	5069.65	5069.94	180.0
2014-12-29 21:00:00	NQ	Futures	5070.24	5071.41	5069.94	5071.12	166.0
2014-12-29 22:00:00	NQ	Futures	5071.12	5072.29	5070.53	5071.41	215.0
2014-12-29 23:00:00	NQ	Futures	5071.12	5072.59	5070.82	5071.7	183.0
2014-12-29 00:00:00	YM	Futures	18812.8	18820.1	18806.5	18813.8	425.0
2014-12-29 01:00:00	YM	Futures	18813.8	18818.0	18808.6	18818.0	148.0

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

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