PREVIEW / etf_1hour / 2013-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-17.parquet
  size:    211 KB
  rows:    6,672

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
2013-12-17 04:00:00	SPY	ETF	179.11	179.11	178.97	179.1	13029.0
2013-12-17 05:00:00	SPY	ETF	179.1	179.17	179.02	179.17	43293.0
2013-12-17 06:00:00	SPY	ETF	179.17	179.17	179.08	179.15	8777.0
2013-12-17 07:00:00	SPY	ETF	179.15	179.38	179.15	179.34	140122.0
2013-12-17 08:00:00	SPY	ETF	179.32	179.46	179.22	179.33	2321746.0
2013-12-17 09:00:00	SPY	ETF	179.32	179.41	178.62	178.98	11052013.0
2013-12-17 10:00:00	SPY	ETF	178.98	179.0875	178.37	178.48	14570968.0
2013-12-17 11:00:00	SPY	ETF	178.47	179.2163	178.25	178.5	12101520.0
2013-12-17 12:00:00	SPY	ETF	178.5	178.77	178.4	178.7195	7713414.0
2013-12-17 13:00:00	SPY	ETF	178.72	178.81	178.56	178.689	6861296.0
2013-12-17 14:00:00	SPY	ETF	178.689	179.12	178.66	178.81	11704747.0
2013-12-17 15:00:00	SPY	ETF	178.805	179.01	178.62	178.63	13266640.0
2013-12-17 16:00:00	SPY	ETF	178.61	178.7823	178.37	178.42	4957833.0
2013-12-17 17:00:00	SPY	ETF	178.41	178.46	178.39	178.41	2569169.0
2013-12-17 18:00:00	SPY	ETF	178.45	178.59	178.45	178.58	192576.0
2013-12-17 19:00:00	SPY	ETF	178.58	178.83	178.58	178.74	327188.0
2013-12-17 04:00:00	QQQ	ETF	85.14	85.2	85.14	85.2	1600.0
2013-12-17 05:00:00	QQQ	ETF	85.22	85.28	85.2	85.28	4200.0
2013-12-17 06:00:00	QQQ	ETF	85.26	85.28	85.26	85.28	2420.0
2013-12-17 07:00:00	QQQ	ETF	85.3	85.39	85.3	85.37	37853.0
2013-12-17 08:00:00	QQQ	ETF	85.35	85.42	85.35	85.35	127196.0
2013-12-17 09:00:00	QQQ	ETF	85.35	85.36	85.05	85.21	3755176.0
2013-12-17 10:00:00	QQQ	ETF	85.21	85.34	85.04	85.0871	4639997.0
2013-12-17 11:00:00	QQQ	ETF	85.09	85.18	84.99	85.13	2910607.0
2013-12-17 12:00:00	QQQ	ETF	85.13	85.33	85.08	85.27	3286196.0
2013-12-17 13:00:00	QQQ	ETF	85.28	85.37	85.22	85.26	1793586.0
2013-12-17 14:00:00	QQQ	ETF	85.261	85.53	85.26	85.34	2482855.0
2013-12-17 15:00:00	QQQ	ETF	85.34	85.44	85.18	85.18	3599134.0
2013-12-17 16:00:00	QQQ	ETF	85.18	85.18	85.05	85.05	833589.0
2013-12-17 17:00:00	QQQ	ETF	85.05	85.08	85.05	85.08	63306.0
2013-12-17 18:00:00	QQQ	ETF	85.07	85.13	85.07	85.13	2830.0
2013-12-17 19:00:00	QQQ	ETF	85.12	85.2	85.12	85.2	3800.0
2013-12-17 04:00:00	IWM	ETF	111.38	111.38	111.38	111.38	100.0
2013-12-17 05:00:00	IWM	ETF	111.38	111.38	111.38	111.38	5000.0
2013-12-17 07:00:00	IWM	ETF	111.42	111.63	111.42	111.56	163070.0
2013-12-17 08:00:00	IWM	ETF	111.63	111.63	111.41	111.46	1784348.0
2013-12-17 09:00:00	IWM	ETF	111.45	111.47	110.815	111.11	4316144.0
2013-12-17 10:00:00	IWM	ETF	111.12	111.37	110.72	110.82	4555483.0
2013-12-17 11:00:00	IWM	ETF	110.83	110.975	110.615	110.88	2090877.0
2013-12-17 12:00:00	IWM	ETF	110.87	111.17	110.84	111.131	1804176.0
2013-12-17 13:00:00	IWM	ETF	111.15	111.39	111.13	111.21	2288108.0
2013-12-17 14:00:00	IWM	ETF	111.22	111.525	111.19	111.32	2037316.0
2013-12-17 15:00:00	IWM	ETF	111.32	111.54	111.285	111.35	6551518.0
2013-12-17 16:00:00	IWM	ETF	111.34	111.38	110.506	111.18	824746.0
2013-12-17 17:00:00	IWM	ETF	111.19	111.3	111.19	111.3	1400.0
2013-12-17 18:00:00	IWM	ETF	111.31	111.31	111.31	111.31	100.0
2013-12-17 19:00:00	IWM	ETF	111.32	111.32	111.32	111.32	100.0
2013-12-17 08:00:00	DIA	ETF	159.01	159.27	159.01	159.18	6110.0
2013-12-17 09:00:00	DIA	ETF	159.16	159.29	158.73	158.98	1208511.0
2013-12-17 10:00:00	DIA	ETF	158.97	159.12	158.57	158.6401	901501.0

> showing 50 of 6,672 rows — these rows as CSV

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