PREVIEW / etf_1hour / 2014-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-15.parquet
  size:    221 KB
  rows:    7,033

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-09-15 04:00:00	SPY	ETF	198.52	198.76	198.52	198.65	15062.0
2014-09-15 05:00:00	SPY	ETF	198.74	198.74	198.57	198.69	10108.0
2014-09-15 06:00:00	SPY	ETF	198.67	198.8	198.67	198.73	72252.0
2014-09-15 07:00:00	SPY	ETF	198.77	199.07	198.75	198.86	277074.0
2014-09-15 08:00:00	SPY	ETF	198.88	199.09	198.48	199.06	558039.0
2014-09-15 09:00:00	SPY	ETF	199.06	199.21	198.44	198.615	11689355.0
2014-09-15 10:00:00	SPY	ETF	198.61	199.08	198.38	198.9	11421804.0
2014-09-15 11:00:00	SPY	ETF	198.9	198.967	198.52	198.55	8452740.0
2014-09-15 12:00:00	SPY	ETF	198.5534	199.07	198.47	198.93	7687056.0
2014-09-15 13:00:00	SPY	ETF	198.92	199.04	198.6	198.635	6261740.0
2014-09-15 14:00:00	SPY	ETF	198.64	199.32	198.59	199.03	9528494.0
2014-09-15 15:00:00	SPY	ETF	199.03	199.175	198.9	198.99	12147120.0
2014-09-15 16:00:00	SPY	ETF	199.01	199.06	198.97	199.04	6055194.0
2014-09-15 17:00:00	SPY	ETF	199.05	199.07	199.05	199.05	48843.0
2014-09-15 18:00:00	SPY	ETF	199.03	199.03	198.97	199.0	22967.0
2014-09-15 19:00:00	SPY	ETF	199.02	199.02	198.98	198.99	19165.0
2014-09-15 04:00:00	QQQ	ETF	99.22	99.35	99.22	99.29	6637.0
2014-09-15 05:00:00	QQQ	ETF	99.27	99.27	99.27	99.27	500.0
2014-09-15 06:00:00	QQQ	ETF	99.32	99.34	99.31	99.34	3000.0
2014-09-15 07:00:00	QQQ	ETF	99.4	99.5	99.4	99.4	26000.0
2014-09-15 08:00:00	QQQ	ETF	99.41	99.56	99.41	99.52	167448.0
2014-09-15 09:00:00	QQQ	ETF	99.52	99.63	98.6	98.721	6389175.0
2014-09-15 10:00:00	QQQ	ETF	98.721	98.846	98.5	98.62	5124672.0
2014-09-15 11:00:00	QQQ	ETF	98.61	98.66	98.38	98.42	4209131.0
2014-09-15 12:00:00	QQQ	ETF	98.43	98.63	98.38	98.62	2500600.0
2014-09-15 13:00:00	QQQ	ETF	98.62	98.659	98.24	98.265	2665728.0
2014-09-15 14:00:00	QQQ	ETF	98.26	98.69	98.215	98.529	3685086.0
2014-09-15 15:00:00	QQQ	ETF	98.53	98.63	98.42	98.51	5438046.0
2014-09-15 16:00:00	QQQ	ETF	98.51	98.6211	98.4536	98.59	1229146.0
2014-09-15 17:00:00	QQQ	ETF	98.59	98.61	98.59	98.6	25355.0
2014-09-15 18:00:00	QQQ	ETF	98.59	98.62	98.59	98.6	786.0
2014-09-15 19:00:00	QQQ	ETF	98.58	98.61	98.58	98.59	13470.0
2014-09-15 04:00:00	IWM	ETF	114.94	114.94	114.94	114.94	287.0
2014-09-15 07:00:00	IWM	ETF	115.1	115.26	115.1	115.17	10508.0
2014-09-15 08:00:00	IWM	ETF	115.15	115.43	115.15	115.4	219398.0
2014-09-15 09:00:00	IWM	ETF	115.4	115.46	114.02	114.21	5963642.0
2014-09-15 10:00:00	IWM	ETF	114.21	114.64	114.02	114.385	6558083.0
2014-09-15 11:00:00	IWM	ETF	114.38	114.38	113.81	113.87	4176770.0
2014-09-15 12:00:00	IWM	ETF	113.88	114.229	113.81	114.205	4200142.0
2014-09-15 13:00:00	IWM	ETF	114.205	114.28	113.79	113.825	3159551.0
2014-09-15 14:00:00	IWM	ETF	113.82	114.38	113.705	114.19	3594224.0
2014-09-15 15:00:00	IWM	ETF	114.19	114.37	113.97	114.07	5097628.0
2014-09-15 16:00:00	IWM	ETF	114.08	115.4253	114.0212	114.1	2997924.0
2014-09-15 17:00:00	IWM	ETF	114.13	114.15	114.1	114.14	10296.0
2014-09-15 18:00:00	IWM	ETF	114.08	114.17	113.95	114.1	2300.0
2014-09-15 19:00:00	IWM	ETF	114.08	114.16	114.08	114.16	928.0
2014-09-15 05:00:00	DIA	ETF	169.69	169.69	169.69	169.69	1000.0
2014-09-15 08:00:00	DIA	ETF	169.99	169.99	169.99	169.99	300.0
2014-09-15 09:00:00	DIA	ETF	170.07	170.14	169.6	169.72	928907.0
2014-09-15 10:00:00	DIA	ETF	169.72	170.12	169.55	170.09	954230.0

> showing 50 of 7,033 rows — these rows as CSV

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