PREVIEW / etf_1hour / 2012-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-06.parquet
  size:    180 KB
  rows:    5,637

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
2012-08-06 04:00:00	SPY	ETF	139.42	139.65	139.38	139.65	1540.0
2012-08-06 05:00:00	SPY	ETF	139.75	139.77	139.75	139.75	2100.0
2012-08-06 06:00:00	SPY	ETF	139.8	139.8	139.7	139.75	6200.0
2012-08-06 07:00:00	SPY	ETF	139.75	139.89	139.73	139.87	176310.0
2012-08-06 08:00:00	SPY	ETF	139.87	139.89	139.72	139.78	943422.0
2012-08-06 09:00:00	SPY	ETF	139.77	140.13	139.58	139.97	13904319.0
2012-08-06 10:00:00	SPY	ETF	139.98	140.17	139.89	139.991	14926829.0
2012-08-06 11:00:00	SPY	ETF	140.002	140.1	139.83	139.99	9012845.0
2012-08-06 12:00:00	SPY	ETF	139.99	140.15	139.87	140.11	6000556.0
2012-08-06 13:00:00	SPY	ETF	140.12	140.17	139.94	139.999	6149186.0
2012-08-06 14:00:00	SPY	ETF	139.99	140.13	139.97	140.06	5086662.0
2012-08-06 15:00:00	SPY	ETF	140.06	140.1667	139.56	139.63	19245727.0
2012-08-06 16:00:00	SPY	ETF	139.64	140.0	139.47	139.48	4436503.0
2012-08-06 17:00:00	SPY	ETF	139.5	139.56	139.4	139.5	155817.0
2012-08-06 18:00:00	SPY	ETF	139.5	139.56	139.5	139.56	56830.0
2012-08-06 19:00:00	SPY	ETF	139.56	139.57	139.49	139.49	24900.0
2012-08-06 20:00:00	SPY	ETF	139.49	139.49	139.49	139.49	1000.0
2012-08-06 05:00:00	QQQ	ETF	65.9	65.9	65.9	65.9	100.0
2012-08-06 06:00:00	QQQ	ETF	65.94	65.94	65.92	65.92	600.0
2012-08-06 07:00:00	QQQ	ETF	65.94	65.96	65.9	65.96	34564.0
2012-08-06 08:00:00	QQQ	ETF	65.94	65.95	65.87	65.92	172485.0
2012-08-06 09:00:00	QQQ	ETF	65.91	66.12	65.8	66.0	3835346.0
2012-08-06 10:00:00	QQQ	ETF	66.008	66.18	66.0	66.12	4442965.0
2012-08-06 11:00:00	QQQ	ETF	66.12	66.27	66.07	66.26	2486828.0
2012-08-06 12:00:00	QQQ	ETF	66.26	66.39	66.2	66.37	2709803.0
2012-08-06 13:00:00	QQQ	ETF	66.365	66.39	66.24	66.29	2503700.0
2012-08-06 14:00:00	QQQ	ETF	66.28	66.35	66.26	66.31	1356885.0
2012-08-06 15:00:00	QQQ	ETF	66.301	66.33	66.05	66.09	5082258.0
2012-08-06 16:00:00	QQQ	ETF	66.09	66.267	66.0181	66.07	636522.0
2012-08-06 17:00:00	QQQ	ETF	66.08	66.08	65.92	65.92	17857.0
2012-08-06 18:00:00	QQQ	ETF	66.06	66.08	66.05	66.07	19568.0
2012-08-06 19:00:00	QQQ	ETF	66.08	66.1	66.05	66.05	5434.0
2012-08-06 07:00:00	IWM	ETF	78.82	78.94	78.82	78.92	48727.0
2012-08-06 08:00:00	IWM	ETF	78.94	78.94	78.73	78.78	29446.0
2012-08-06 09:00:00	IWM	ETF	78.78	79.33	78.59	79.22	4994192.0
2012-08-06 10:00:00	IWM	ETF	79.22	79.6	79.22	79.43	5621949.0
2012-08-06 11:00:00	IWM	ETF	79.44	79.52	79.27	79.45	2883268.0
2012-08-06 12:00:00	IWM	ETF	79.45	79.59	79.36	79.57	2335575.0
2012-08-06 13:00:00	IWM	ETF	79.56	79.6315	79.42	79.48	1893661.0
2012-08-06 14:00:00	IWM	ETF	79.48	79.62	79.46	79.52	1843656.0
2012-08-06 15:00:00	IWM	ETF	79.52	79.565	79.15	79.21	6949711.0
2012-08-06 16:00:00	IWM	ETF	79.19	79.27	79.08	79.09	845924.0
2012-08-06 17:00:00	IWM	ETF	79.07	79.13	79.06	79.06	17960.0
2012-08-06 19:00:00	IWM	ETF	79.1	79.14	79.1	79.12	2674.0
2012-08-06 07:00:00	DIA	ETF	130.76	130.85	130.76	130.85	2000.0
2012-08-06 08:00:00	DIA	ETF	130.35	130.97	130.35	130.89	1237181.0
2012-08-06 09:00:00	DIA	ETF	130.91	131.49	130.9	131.38	916631.0
2012-08-06 10:00:00	DIA	ETF	131.38	131.61	131.32	131.46	657720.0
2012-08-06 11:00:00	DIA	ETF	131.47	131.54	131.33	131.44	376277.0
2012-08-06 12:00:00	DIA	ETF	131.45	131.54	131.338	131.53	136093.0

> showing 50 of 5,637 rows — these rows as CSV

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