PREVIEW / etf_1hour / 2013-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-27.parquet
  size:    207 KB
  rows:    6,525

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-11-27 04:00:00	SPY	ETF	180.72	180.92	180.72	180.92	5997.0
2013-11-27 05:00:00	SPY	ETF	180.93	180.93	180.85	180.85	44307.0
2013-11-27 06:00:00	SPY	ETF	180.85	180.93	180.8	180.88	36779.0
2013-11-27 07:00:00	SPY	ETF	180.9	180.94	180.83	180.84	71792.0
2013-11-27 08:00:00	SPY	ETF	180.87	180.95	180.74	180.88	344439.0
2013-11-27 09:00:00	SPY	ETF	180.92	181.24	180.75	181.11	9263954.0
2013-11-27 10:00:00	SPY	ETF	181.12	181.215	181.0	181.0605	8692080.0
2013-11-27 11:00:00	SPY	ETF	181.07	181.23	181.03	181.09	6328991.0
2013-11-27 12:00:00	SPY	ETF	181.085	181.09	180.68	180.691	6515918.0
2013-11-27 13:00:00	SPY	ETF	180.69	180.92	180.65	180.8699	4797980.0
2013-11-27 14:00:00	SPY	ETF	180.86	181.16	180.84	181.11	6094545.0
2013-11-27 15:00:00	SPY	ETF	181.11	181.21	181.04	181.14	10620116.0
2013-11-27 16:00:00	SPY	ETF	181.12	181.14	180.6674	180.96	3739593.0
2013-11-27 17:00:00	SPY	ETF	180.96	181.12	180.9	180.98	890609.0
2013-11-27 18:00:00	SPY	ETF	180.98	181.23	180.98	181.12	184121.0
2013-11-27 19:00:00	SPY	ETF	181.12	181.14	181.07	181.08	377589.0
2013-11-27 04:00:00	QQQ	ETF	84.67	84.76	84.67	84.76	7500.0
2013-11-27 05:00:00	QQQ	ETF	84.73	84.74	84.73	84.74	16400.0
2013-11-27 06:00:00	QQQ	ETF	84.74	84.76	84.7	84.76	6000.0
2013-11-27 07:00:00	QQQ	ETF	84.75	84.76	84.72	84.75	51995.0
2013-11-27 08:00:00	QQQ	ETF	84.75	84.78	84.7	84.78	149660.0
2013-11-27 09:00:00	QQQ	ETF	84.78	85.13	84.73	85.06	4037259.0
2013-11-27 10:00:00	QQQ	ETF	85.06	85.13	84.97	85.0201	3223261.0
2013-11-27 11:00:00	QQQ	ETF	85.03	85.16	85.0	85.09	2280196.0
2013-11-27 12:00:00	QQQ	ETF	85.09	85.1	84.9699	84.975	1497747.0
2013-11-27 13:00:00	QQQ	ETF	84.97	85.05	84.94	85.01	1831135.0
2013-11-27 14:00:00	QQQ	ETF	85.01	85.159	85.0	85.15	1678649.0
2013-11-27 15:00:00	QQQ	ETF	85.15	85.24	85.1	85.22	4888747.0
2013-11-27 16:00:00	QQQ	ETF	85.22	85.2302	84.836	85.17	1810158.0
2013-11-27 17:00:00	QQQ	ETF	85.19	85.22	85.19	85.22	400.0
2013-11-27 18:00:00	QQQ	ETF	85.2	85.26	85.2	85.24	3900.0
2013-11-27 19:00:00	QQQ	ETF	85.22	85.25	85.22	85.22	17850.0
2013-11-27 06:00:00	IWM	ETF	112.81	112.88	112.81	112.88	560.0
2013-11-27 07:00:00	IWM	ETF	112.9	112.97	112.86	112.89	64300.0
2013-11-27 08:00:00	IWM	ETF	112.92	112.92	112.83	112.9	22170.0
2013-11-27 09:00:00	IWM	ETF	112.9	113.02	112.64	112.94	2984542.0
2013-11-27 10:00:00	IWM	ETF	112.95	113.25	112.83	113.21	3827452.0
2013-11-27 11:00:00	IWM	ETF	113.21	113.31	113.16	113.21	2659512.0
2013-11-27 12:00:00	IWM	ETF	113.2	113.24	113.05	113.0601	2003720.0
2013-11-27 13:00:00	IWM	ETF	113.0601	113.24	113.05	113.205	1608275.0
2013-11-27 14:00:00	IWM	ETF	113.21	113.49	113.17	113.42	2049343.0
2013-11-27 15:00:00	IWM	ETF	113.43	113.57	113.37	113.52	5356431.0
2013-11-27 16:00:00	IWM	ETF	113.52	113.52	112.8028	113.45	5329629.0
2013-11-27 17:00:00	IWM	ETF	113.45	113.47	113.43	113.43	4300.0
2013-11-27 18:00:00	IWM	ETF	113.7	113.7	113.7	113.7	200.0
2013-11-27 07:00:00	DIA	ETF	160.74	160.74	160.74	160.74	2500.0
2013-11-27 08:00:00	DIA	ETF	160.74	160.82	160.7	160.82	9322.0
2013-11-27 09:00:00	DIA	ETF	160.82	160.92	160.57	160.8	342728.0
2013-11-27 10:00:00	DIA	ETF	160.79	160.92	160.72	160.79	1127615.0
2013-11-27 11:00:00	DIA	ETF	160.79	160.94	160.78	160.86	1296458.0

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

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