PREVIEW / etf_1hour / 2013-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-02.parquet
  size:    200 KB
  rows:    6,229

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-05-02 04:00:00	SPY	ETF	158.73	158.73	158.55	158.55	7174.0
2013-05-02 05:00:00	SPY	ETF	158.56	158.56	158.43	158.5	6450.0
2013-05-02 06:00:00	SPY	ETF	158.49	158.67	158.49	158.67	54598.0
2013-05-02 07:00:00	SPY	ETF	158.68	159.0	158.56	158.86	790047.0
2013-05-02 08:00:00	SPY	ETF	158.86	159.35	158.61	158.82	3453338.0
2013-05-02 09:00:00	SPY	ETF	158.83	159.03	158.47	158.775	15639412.0
2013-05-02 10:00:00	SPY	ETF	158.77	159.3	158.76	159.19	14249761.0
2013-05-02 11:00:00	SPY	ETF	159.181	159.78	159.16	159.72	14428579.0
2013-05-02 12:00:00	SPY	ETF	159.71	159.81	159.52	159.66	6968046.0
2013-05-02 13:00:00	SPY	ETF	159.67	159.89	159.64	159.825	8268623.0
2013-05-02 14:00:00	SPY	ETF	159.82	159.88	159.67	159.8	10069042.0
2013-05-02 15:00:00	SPY	ETF	159.79	159.84	159.65	159.72	15120494.0
2013-05-02 16:00:00	SPY	ETF	159.72	159.8254	159.5045	159.73	6081594.0
2013-05-02 17:00:00	SPY	ETF	159.73	159.75	159.7	159.75	92752.0
2013-05-02 18:00:00	SPY	ETF	159.72	159.72	159.65	159.68	25212.0
2013-05-02 19:00:00	SPY	ETF	159.66	159.77	159.66	159.7	48534.0
2013-05-02 04:00:00	QQQ	ETF	70.51	70.51	70.45	70.45	5500.0
2013-05-02 06:00:00	QQQ	ETF	70.49	70.49	70.49	70.49	400.0
2013-05-02 07:00:00	QQQ	ETF	70.51	70.65	70.44	70.61	19222.0
2013-05-02 08:00:00	QQQ	ETF	70.49	70.84	70.49	70.62	437656.0
2013-05-02 09:00:00	QQQ	ETF	70.63	70.84	70.45	70.74	3423975.0
2013-05-02 10:00:00	QQQ	ETF	70.74	71.03	70.72	71.0075	4609655.0
2013-05-02 11:00:00	QQQ	ETF	71.01	71.3	70.98	71.24	4587262.0
2013-05-02 12:00:00	QQQ	ETF	71.2475	71.31	71.155	71.27	1722765.0
2013-05-02 13:00:00	QQQ	ETF	71.28	71.43	71.28	71.4	2387113.0
2013-05-02 14:00:00	QQQ	ETF	71.39	71.42	71.31	71.37	2003355.0
2013-05-02 15:00:00	QQQ	ETF	71.36	71.39	71.27	71.27	5976242.0
2013-05-02 16:00:00	QQQ	ETF	71.27	71.37	70.3725	71.24	4380042.0
2013-05-02 17:00:00	QQQ	ETF	71.25	71.26	71.24	71.24	4239.0
2013-05-02 18:00:00	QQQ	ETF	71.22	71.23	71.21	71.21	3952.0
2013-05-02 19:00:00	QQQ	ETF	71.23	71.28	71.21	71.27	23765.0
2013-05-02 06:00:00	IWM	ETF	91.99	92.04	91.99	92.04	1500.0
2013-05-02 07:00:00	IWM	ETF	92.14	92.31	92.06	92.29	149243.0
2013-05-02 08:00:00	IWM	ETF	92.29	92.66	92.07	92.4	851051.0
2013-05-02 09:00:00	IWM	ETF	92.34	92.515	92.1	92.25	6104925.0
2013-05-02 10:00:00	IWM	ETF	92.26	92.97	92.2	92.93	7552229.0
2013-05-02 11:00:00	IWM	ETF	92.93	93.42	92.89	93.34	6489439.0
2013-05-02 12:00:00	IWM	ETF	93.33	93.37	93.08	93.25	1886877.0
2013-05-02 13:00:00	IWM	ETF	93.25	93.47	93.25	93.39	1693221.0
2013-05-02 14:00:00	IWM	ETF	93.39	93.435	93.27	93.38	1812462.0
2013-05-02 15:00:00	IWM	ETF	93.38	93.445	93.26	93.29	7528916.0
2013-05-02 16:00:00	IWM	ETF	93.3	93.3219	92.7382	93.28	2627579.0
2013-05-02 17:00:00	IWM	ETF	93.29	93.3	93.19	93.24	34500.0
2013-05-02 18:00:00	IWM	ETF	93.26	93.26	93.17	93.24	1551.0
2013-05-02 19:00:00	IWM	ETF	93.24	93.25	93.21	93.21	5200.0
2013-05-02 05:00:00	DIA	ETF	146.87	146.87	146.87	146.87	200.0
2013-05-02 06:00:00	DIA	ETF	147.09	147.09	147.09	147.09	100.0
2013-05-02 07:00:00	DIA	ETF	147.1	147.31	147.03	147.31	7500.0
2013-05-02 08:00:00	DIA	ETF	147.32	147.6	147.19	147.26	12586.0
2013-05-02 09:00:00	DIA	ETF	147.22	147.33	146.91	147.1001	487836.0

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

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