PREVIEW / etf_1hour / 2013-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-21.parquet
  size:    209 KB
  rows:    6,543

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-21 04:00:00	SPY	ETF	178.47	178.8	178.34	178.71	152961.0
2013-11-21 05:00:00	SPY	ETF	178.69	178.89	178.66	178.89	31592.0
2013-11-21 06:00:00	SPY	ETF	178.84	178.89	178.68	178.75	29240.0
2013-11-21 07:00:00	SPY	ETF	178.76	178.96	178.7	178.88	113280.0
2013-11-21 08:00:00	SPY	ETF	178.88	179.11	178.81	178.82	837243.0
2013-11-21 09:00:00	SPY	ETF	178.82	179.36	178.81	179.27	9554508.0
2013-11-21 10:00:00	SPY	ETF	179.26	179.68	179.07	179.57	12897777.0
2013-11-21 11:00:00	SPY	ETF	179.561	179.71	179.43	179.62	7574439.0
2013-11-21 12:00:00	SPY	ETF	179.62	179.641	179.36	179.38	6177789.0
2013-11-21 13:00:00	SPY	ETF	179.38	179.89	179.38	179.84	8388198.0
2013-11-21 14:00:00	SPY	ETF	179.845	179.965	179.71	179.87	7085061.0
2013-11-21 15:00:00	SPY	ETF	179.87	180.05	179.76	179.88	20148683.0
2013-11-21 16:00:00	SPY	ETF	179.93	179.97	178.4463	179.91	10088433.0
2013-11-21 17:00:00	SPY	ETF	179.91	179.94	178.4463	179.87	653056.0
2013-11-21 18:00:00	SPY	ETF	179.86	180.02	179.83	179.98	1015238.0
2013-11-21 19:00:00	SPY	ETF	179.97	180.01	179.93	180.0	34119.0
2013-11-21 04:00:00	QQQ	ETF	82.61	82.81	82.58	82.81	7100.0
2013-11-21 05:00:00	QQQ	ETF	82.82	82.91	82.79	82.91	12100.0
2013-11-21 06:00:00	QQQ	ETF	82.92	82.92	82.82	82.86	22767.0
2013-11-21 07:00:00	QQQ	ETF	82.84	82.94	82.83	82.94	37811.0
2013-11-21 08:00:00	QQQ	ETF	82.9	83.01	82.9	82.93	164948.0
2013-11-21 09:00:00	QQQ	ETF	82.92	83.34	82.92	83.28	4630579.0
2013-11-21 10:00:00	QQQ	ETF	83.28	83.37	83.2	83.29	4258931.0
2013-11-21 11:00:00	QQQ	ETF	83.29	83.34	83.18	83.26	1965933.0
2013-11-21 12:00:00	QQQ	ETF	83.26	83.29	83.1	83.119	1162632.0
2013-11-21 13:00:00	QQQ	ETF	83.115	83.42	83.11	83.4099	2276007.0
2013-11-21 14:00:00	QQQ	ETF	83.4	83.61	83.37	83.53	2309611.0
2013-11-21 15:00:00	QQQ	ETF	83.53	83.61	83.46	83.53	4127314.0
2013-11-21 16:00:00	QQQ	ETF	83.53	83.55	82.6721	83.53	2799931.0
2013-11-21 17:00:00	QQQ	ETF	83.55	83.55	83.53	83.53	7300.0
2013-11-21 18:00:00	QQQ	ETF	83.53	83.59	83.51	83.59	11103.0
2013-11-21 19:00:00	QQQ	ETF	83.55	83.59	83.55	83.58	3328.0
2013-11-21 06:00:00	IWM	ETF	109.67	109.68	109.6	109.65	12260.0
2013-11-21 07:00:00	IWM	ETF	109.66	109.78	109.63	109.78	106500.0
2013-11-21 08:00:00	IWM	ETF	109.8	109.92	109.73	109.73	300080.0
2013-11-21 09:00:00	IWM	ETF	109.73	110.16	109.68	110.1299	3442663.0
2013-11-21 10:00:00	IWM	ETF	110.13	111.0	110.13	110.91	9279314.0
2013-11-21 11:00:00	IWM	ETF	110.91	111.12	110.74	111.11	4727909.0
2013-11-21 12:00:00	IWM	ETF	111.11	111.15	110.79	110.845	4174736.0
2013-11-21 13:00:00	IWM	ETF	110.845	111.305	110.83	111.25	3024864.0
2013-11-21 14:00:00	IWM	ETF	111.26	111.36	111.16	111.22	2723449.0
2013-11-21 15:00:00	IWM	ETF	111.21	111.36	111.09	111.32	5347133.0
2013-11-21 16:00:00	IWM	ETF	111.33	111.35	109.3158	111.32	5103994.0
2013-11-21 17:00:00	IWM	ETF	111.32	111.32	111.26	111.29	50600.0
2013-11-21 18:00:00	IWM	ETF	111.3	111.3	111.3	111.3	1176.0
2013-11-21 07:00:00	DIA	ETF	159.1	159.1	159.1	159.1	3000.0
2013-11-21 08:00:00	DIA	ETF	159.09	159.35	159.09	159.2	7191.0
2013-11-21 09:00:00	DIA	ETF	159.15	159.47	159.15	159.41	686949.0
2013-11-21 10:00:00	DIA	ETF	159.42	159.63	159.25	159.6	930462.0
2013-11-21 11:00:00	DIA	ETF	159.6	159.73	159.54	159.69	387075.0

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

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