PREVIEW / etf_1hour / 2014-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-29.parquet
  size:    232 KB
  rows:    7,345

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-10-29 04:00:00	SPY	ETF	198.44	198.58	198.24	198.42	13731.0
2014-10-29 05:00:00	SPY	ETF	198.35	198.72	198.34	198.57	21520.0
2014-10-29 06:00:00	SPY	ETF	198.54	198.54	198.21	198.21	163544.0
2014-10-29 07:00:00	SPY	ETF	198.27	198.32	198.08	198.3	245765.0
2014-10-29 08:00:00	SPY	ETF	198.29	198.46	198.11	198.39	675105.0
2014-10-29 09:00:00	SPY	ETF	198.4	199.12	198.14	199.09	12232425.0
2014-10-29 10:00:00	SPY	ETF	199.085	199.12	198.22	198.35	19775584.0
2014-10-29 11:00:00	SPY	ETF	198.35	198.66	198.26	198.47	9991682.0
2014-10-29 12:00:00	SPY	ETF	198.46	198.47	197.96	198.1	10432903.0
2014-10-29 13:00:00	SPY	ETF	198.109	198.17	197.72	198.09	10784266.0
2014-10-29 14:00:00	SPY	ETF	198.07	198.085	196.8	197.71	41896224.0
2014-10-29 15:00:00	SPY	ETF	197.71	198.42	196.98	198.14	26147321.0
2014-10-29 16:00:00	SPY	ETF	198.13	198.189	197.73	197.76	9069603.0
2014-10-29 17:00:00	SPY	ETF	197.76	198.1797	197.69	197.74	254929.0
2014-10-29 18:00:00	SPY	ETF	197.75	197.94	197.62	197.9	141262.0
2014-10-29 19:00:00	SPY	ETF	197.86	197.87	197.64	197.65	60496.0
2014-10-29 04:00:00	QQQ	ETF	99.81	99.87	99.74	99.74	27200.0
2014-10-29 05:00:00	QQQ	ETF	99.81	99.99	99.81	99.99	14400.0
2014-10-29 06:00:00	QQQ	ETF	99.98	99.98	99.81	99.81	12727.0
2014-10-29 07:00:00	QQQ	ETF	99.83	99.86	99.72	99.79	34293.0
2014-10-29 08:00:00	QQQ	ETF	99.81	100.01	99.78	99.86	290078.0
2014-10-29 09:00:00	QQQ	ETF	99.85	100.12	99.75	100.065	4368116.0
2014-10-29 10:00:00	QQQ	ETF	100.065	100.09	99.71	99.789	5289096.0
2014-10-29 11:00:00	QQQ	ETF	99.79	99.97	99.73	99.81	2003517.0
2014-10-29 12:00:00	QQQ	ETF	99.815	99.83	99.555	99.62	2530490.0
2014-10-29 13:00:00	QQQ	ETF	99.63	99.71	99.48	99.66	1976559.0
2014-10-29 14:00:00	QQQ	ETF	99.61	99.72	99.1	99.62	10447050.0
2014-10-29 15:00:00	QQQ	ETF	99.63	99.89	99.26	99.8	8384044.0
2014-10-29 16:00:00	QQQ	ETF	99.81	100.1775	99.47	99.53	2322257.0
2014-10-29 17:00:00	QQQ	ETF	99.53	99.6	99.5	99.53	18425.0
2014-10-29 18:00:00	QQQ	ETF	99.54	99.61	99.46	99.6	10296.0
2014-10-29 19:00:00	QQQ	ETF	99.6	99.6	99.47	99.47	21200.0
2014-10-29 04:00:00	IWM	ETF	114.13	114.13	114.13	114.13	115.0
2014-10-29 05:00:00	IWM	ETF	114.13	114.3	114.13	114.3	200.0
2014-10-29 06:00:00	IWM	ETF	114.3	114.3	114.3	114.3	100.0
2014-10-29 07:00:00	IWM	ETF	114.16	114.24	114.01	114.21	63116.0
2014-10-29 08:00:00	IWM	ETF	114.21	114.24	114.05	114.21	111359.0
2014-10-29 09:00:00	IWM	ETF	114.22	114.89	113.96	114.71	7586848.0
2014-10-29 10:00:00	IWM	ETF	114.71	114.765	113.46	113.56	8348320.0
2014-10-29 11:00:00	IWM	ETF	113.57	113.92	113.5	113.69	3539470.0
2014-10-29 12:00:00	IWM	ETF	113.69	113.7	113.299	113.57	4183475.0
2014-10-29 13:00:00	IWM	ETF	113.57	113.91	113.3	113.66	5673301.0
2014-10-29 14:00:00	IWM	ETF	113.66	114.01	112.98	113.86	15385718.0
2014-10-29 15:00:00	IWM	ETF	113.86	114.21	113.41	113.909	9938951.0
2014-10-29 16:00:00	IWM	ETF	113.9	113.94	113.58	113.62	1221420.0
2014-10-29 17:00:00	IWM	ETF	113.61	113.65	113.55	113.55	12900.0
2014-10-29 19:00:00	IWM	ETF	113.72	113.79	113.67	113.67	2012.0
2014-10-29 06:00:00	DIA	ETF	169.86	169.86	169.86	169.86	200.0
2014-10-29 08:00:00	DIA	ETF	169.76	169.92	169.76	169.92	3100.0
2014-10-29 09:00:00	DIA	ETF	169.93	170.34	169.92	170.28	859246.0

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

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