PREVIEW / etf_1hour / 2013-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-05.parquet
  size:    208 KB
  rows:    6,548

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-05 04:00:00	SPY	ETF	179.8	179.8	179.67	179.8	13239.0
2013-12-05 05:00:00	SPY	ETF	179.72	179.73	179.65	179.66	7066.0
2013-12-05 06:00:00	SPY	ETF	179.69	179.77	179.61	179.63	55767.0
2013-12-05 07:00:00	SPY	ETF	179.66	179.84	179.66	179.78	163227.0
2013-12-05 08:00:00	SPY	ETF	179.75	179.98	179.46	179.48	1806418.0
2013-12-05 09:00:00	SPY	ETF	179.48	179.62	179.07	179.365	12876744.0
2013-12-05 10:00:00	SPY	ETF	179.36	179.74	178.98	179.0901	16361812.0
2013-12-05 11:00:00	SPY	ETF	179.09	179.32	178.91	179.27	10920980.0
2013-12-05 12:00:00	SPY	ETF	179.27	179.555	179.26	179.41	7938296.0
2013-12-05 13:00:00	SPY	ETF	179.41	179.46	179.04	179.14	7363031.0
2013-12-05 14:00:00	SPY	ETF	179.14	179.34	178.79	178.87	8979960.0
2013-12-05 15:00:00	SPY	ETF	178.87	179.32	178.7701	178.99	25855799.0
2013-12-05 16:00:00	SPY	ETF	178.98	179.3801	178.86	178.94	7712872.0
2013-12-05 17:00:00	SPY	ETF	178.91	179.02	178.89	179.01	784462.0
2013-12-05 18:00:00	SPY	ETF	179.03	179.14	178.98	179.01	299096.0
2013-12-05 19:00:00	SPY	ETF	179.03	179.17	179.03	179.15	242320.0
2013-12-05 04:00:00	QQQ	ETF	85.6	85.63	85.58	85.63	8800.0
2013-12-05 05:00:00	QQQ	ETF	85.64	85.64	85.57	85.59	4600.0
2013-12-05 06:00:00	QQQ	ETF	85.6	85.65	85.57	85.57	7400.0
2013-12-05 07:00:00	QQQ	ETF	85.6	85.68	85.6	85.61	18948.0
2013-12-05 08:00:00	QQQ	ETF	85.6	85.72	85.52	85.58	256645.0
2013-12-05 09:00:00	QQQ	ETF	85.54	85.66	85.34	85.495	5011960.0
2013-12-05 10:00:00	QQQ	ETF	85.51	85.64	85.31	85.37	9212169.0
2013-12-05 11:00:00	QQQ	ETF	85.37	85.44	85.2	85.33	4929772.0
2013-12-05 12:00:00	QQQ	ETF	85.33	85.57	85.3201	85.5	3204076.0
2013-12-05 13:00:00	QQQ	ETF	85.5	85.52	85.34	85.4	2017688.0
2013-12-05 14:00:00	QQQ	ETF	85.39	85.49	85.17	85.21	2108715.0
2013-12-05 15:00:00	QQQ	ETF	85.2	85.585	85.17	85.4	7662061.0
2013-12-05 16:00:00	QQQ	ETF	85.4	85.5885	85.2418	85.38	1619386.0
2013-12-05 17:00:00	QQQ	ETF	85.36	85.36	85.36	85.36	1826.0
2013-12-05 18:00:00	QQQ	ETF	85.39	85.43	85.36	85.36	78674.0
2013-12-05 19:00:00	QQQ	ETF	85.38	85.5	85.38	85.47	105088.0
2013-12-05 06:00:00	IWM	ETF	111.53	111.53	111.53	111.53	100.0
2013-12-05 07:00:00	IWM	ETF	111.56	111.68	111.56	111.57	3300.0
2013-12-05 08:00:00	IWM	ETF	111.57	111.98	111.42	111.5	382479.0
2013-12-05 09:00:00	IWM	ETF	111.51	111.67	111.15	111.56	3596926.0
2013-12-05 10:00:00	IWM	ETF	111.57	111.895	111.38	111.41	6118557.0
2013-12-05 11:00:00	IWM	ETF	111.42	111.7299	111.26	111.555	3836710.0
2013-12-05 12:00:00	IWM	ETF	111.56	112.02	111.56	111.96	3985482.0
2013-12-05 13:00:00	IWM	ETF	111.955	111.99	111.6	111.81	2872207.0
2013-12-05 14:00:00	IWM	ETF	111.8101	111.99	111.4375	111.5	3332445.0
2013-12-05 15:00:00	IWM	ETF	111.495	111.815	111.42	111.65	7672207.0
2013-12-05 16:00:00	IWM	ETF	111.64	111.8437	111.5	111.5	1921343.0
2013-12-05 17:00:00	IWM	ETF	111.51	111.57	111.5	111.52	10280.0
2013-12-05 19:00:00	IWM	ETF	111.58	111.58	111.51	111.51	800.0
2013-12-05 07:00:00	DIA	ETF	158.77	158.8	158.77	158.8	700.0
2013-12-05 08:00:00	DIA	ETF	158.9	158.95	158.54	158.64	21188.0
2013-12-05 09:00:00	DIA	ETF	158.57	158.68	158.26	158.53	833827.0
2013-12-05 10:00:00	DIA	ETF	158.48	158.89	158.14	158.27	1378547.0
2013-12-05 11:00:00	DIA	ETF	158.28	158.49	158.15	158.46	795078.0

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

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