PREVIEW / etf_1hour / 2013-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-07.parquet
  size:    195 KB
  rows:    6,233

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-03-07 04:00:00	SPY	ETF	154.54	154.6	154.54	154.58	450.0
2013-03-07 05:00:00	SPY	ETF	154.66	154.66	154.57	154.57	3600.0
2013-03-07 06:00:00	SPY	ETF	154.55	154.65	154.52	154.62	2800.0
2013-03-07 07:00:00	SPY	ETF	154.59	154.6	154.34	154.5	768310.0
2013-03-07 08:00:00	SPY	ETF	154.5	154.88	154.4	154.74	2405763.0
2013-03-07 09:00:00	SPY	ETF	154.74	154.91	154.49	154.77	10354473.0
2013-03-07 10:00:00	SPY	ETF	154.77	154.87	154.59	154.71	10461158.0
2013-03-07 11:00:00	SPY	ETF	154.7	154.98	154.68	154.85	8315056.0
2013-03-07 12:00:00	SPY	ETF	154.845	154.91	154.75	154.88	5430896.0
2013-03-07 13:00:00	SPY	ETF	154.88	154.91	154.66	154.77	4864030.0
2013-03-07 14:00:00	SPY	ETF	154.77	154.84	154.52	154.77	7307527.0
2013-03-07 15:00:00	SPY	ETF	154.775	154.95	154.75	154.79	17450743.0
2013-03-07 16:00:00	SPY	ETF	154.8	154.8959	154.5194	154.85	12577438.0
2013-03-07 17:00:00	SPY	ETF	154.85	154.89	154.77	154.77	272940.0
2013-03-07 18:00:00	SPY	ETF	154.76	154.76	154.61	154.65	334423.0
2013-03-07 19:00:00	SPY	ETF	154.63	154.63	154.49	154.58	83354.0
2013-03-07 05:00:00	QQQ	ETF	68.6	68.6	68.6	68.6	200.0
2013-03-07 06:00:00	QQQ	ETF	68.55	68.55	68.55	68.55	200.0
2013-03-07 07:00:00	QQQ	ETF	68.55	68.55	68.48	68.5	17600.0
2013-03-07 08:00:00	QQQ	ETF	68.5	68.64	68.48	68.58	757961.0
2013-03-07 09:00:00	QQQ	ETF	68.59	68.65	68.51	68.59	2566908.0
2013-03-07 10:00:00	QQQ	ETF	68.59	68.62	68.45	68.534	2096341.0
2013-03-07 11:00:00	QQQ	ETF	68.5315	68.8	68.52	68.69	4184610.0
2013-03-07 12:00:00	QQQ	ETF	68.6899	68.72	68.59	68.7	1895365.0
2013-03-07 13:00:00	QQQ	ETF	68.7	68.7224	68.52	68.61	866597.0
2013-03-07 14:00:00	QQQ	ETF	68.62	68.68	68.468	68.67	1659770.0
2013-03-07 15:00:00	QQQ	ETF	68.67	68.78	68.63	68.7	4515377.0
2013-03-07 16:00:00	QQQ	ETF	68.69	68.7591	68.5084	68.67	1553621.0
2013-03-07 17:00:00	QQQ	ETF	68.74	68.74	68.72	68.72	550.0
2013-03-07 18:00:00	QQQ	ETF	68.67	68.67	68.62	68.62	7750.0
2013-03-07 19:00:00	QQQ	ETF	68.63	68.63	68.57	68.6	51907.0
2013-03-07 07:00:00	IWM	ETF	92.35	92.35	92.26	92.27	128100.0
2013-03-07 08:00:00	IWM	ETF	92.29	92.57	92.25	92.52	744238.0
2013-03-07 09:00:00	IWM	ETF	92.52	92.645	92.32	92.64	3598270.0
2013-03-07 10:00:00	IWM	ETF	92.64	92.71	92.448	92.6	2754342.0
2013-03-07 11:00:00	IWM	ETF	92.6	92.795	92.58	92.6396	3167457.0
2013-03-07 12:00:00	IWM	ETF	92.63	92.72	92.54	92.69	1042935.0
2013-03-07 13:00:00	IWM	ETF	92.69	92.72	92.55	92.678	1071264.0
2013-03-07 14:00:00	IWM	ETF	92.68	92.72	92.5	92.68	2377595.0
2013-03-07 15:00:00	IWM	ETF	92.69	92.94	92.66	92.89	5386232.0
2013-03-07 16:00:00	IWM	ETF	92.89	93.04	92.375	93.0	1084736.0
2013-03-07 17:00:00	IWM	ETF	93.0	93.01	92.9	92.9	11075.0
2013-03-07 18:00:00	IWM	ETF	92.88	92.88	92.86	92.86	850.0
2013-03-07 19:00:00	IWM	ETF	92.85	92.85	92.85	92.85	450.0
2013-03-07 04:00:00	DIA	ETF	142.83	142.9	142.83	142.9	300.0
2013-03-07 06:00:00	DIA	ETF	142.9	142.9	142.88	142.9	1300.0
2013-03-07 07:00:00	DIA	ETF	142.91	142.92	142.8	142.8	1800.0
2013-03-07 08:00:00	DIA	ETF	142.8	143.05	142.8	143.0	13641.0
2013-03-07 09:00:00	DIA	ETF	143.03	143.29	142.84	143.27	678866.0
2013-03-07 10:00:00	DIA	ETF	143.28	143.35	143.12	143.26	779132.0

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

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