PREVIEW / etf_1hour / 2012-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-24.parquet
  size:    182 KB
  rows:    5,580

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-24 04:00:00	SPY	ETF	140.38	140.6	140.38	140.5	900.0
2012-08-24 05:00:00	SPY	ETF	140.71	140.71	140.66	140.66	1150.0
2012-08-24 06:00:00	SPY	ETF	140.64	140.64	140.48	140.54	1875.0
2012-08-24 07:00:00	SPY	ETF	140.5	140.59	140.27	140.39	259263.0
2012-08-24 08:00:00	SPY	ETF	140.41	140.6	140.17	140.24	1398833.0
2012-08-24 09:00:00	SPY	ETF	140.24	140.495	140.22	140.2699	9722719.0
2012-08-24 10:00:00	SPY	ETF	140.261	140.97	140.23	140.85	15401455.0
2012-08-24 11:00:00	SPY	ETF	140.859	141.43	140.84	141.2	18139583.0
2012-08-24 12:00:00	SPY	ETF	141.2	141.49	141.16	141.44	5949494.0
2012-08-24 13:00:00	SPY	ETF	141.4466	141.72	141.35	141.58	8412620.0
2012-08-24 14:00:00	SPY	ETF	141.58	141.6	141.34	141.38	6067066.0
2012-08-24 15:00:00	SPY	ETF	141.38	141.83	141.3	141.52	21572180.0
2012-08-24 16:00:00	SPY	ETF	141.53	141.7	140.6481	141.55	8401600.0
2012-08-24 17:00:00	SPY	ETF	141.58	141.59	141.52	141.55	35334.0
2012-08-24 18:00:00	SPY	ETF	141.57	141.63	141.52	141.63	35670.0
2012-08-24 19:00:00	SPY	ETF	141.63	141.66	141.59	141.66	29126.0
2012-08-24 05:00:00	QQQ	ETF	67.93	67.93	67.93	67.93	120.0
2012-08-24 06:00:00	QQQ	ETF	67.89	67.89	67.87	67.87	2400.0
2012-08-24 07:00:00	QQQ	ETF	67.82	67.9	67.76	67.76	40000.0
2012-08-24 08:00:00	QQQ	ETF	67.8	67.92	67.69	67.72	358675.0
2012-08-24 09:00:00	QQQ	ETF	67.73	67.81	67.6	67.65	3235468.0
2012-08-24 10:00:00	QQQ	ETF	67.65	68.15	67.64	68.0801	5580873.0
2012-08-24 11:00:00	QQQ	ETF	68.09	68.33	68.04	68.19	5279715.0
2012-08-24 12:00:00	QQQ	ETF	68.19	68.35	68.15	68.34	2638906.0
2012-08-24 13:00:00	QQQ	ETF	68.34	68.45	68.24	68.3427	1771749.0
2012-08-24 14:00:00	QQQ	ETF	68.35	68.36	68.23	68.25	2002284.0
2012-08-24 15:00:00	QQQ	ETF	68.26	68.39	68.16	68.28	7933900.0
2012-08-24 16:00:00	QQQ	ETF	68.29	68.325	67.8703	68.22	4188445.0
2012-08-24 17:00:00	QQQ	ETF	68.22	68.23	68.19	68.22	8300.0
2012-08-24 18:00:00	QQQ	ETF	68.22	68.4	68.22	68.34	13058.0
2012-08-24 19:00:00	QQQ	ETF	68.34	68.49	68.29	68.44	32378.0
2012-08-24 07:00:00	IWM	ETF	80.37	80.4	80.31	80.38	5520.0
2012-08-24 08:00:00	IWM	ETF	80.42	80.56	80.26	80.28	125319.0
2012-08-24 09:00:00	IWM	ETF	80.31	80.47	80.11	80.15	2145037.0
2012-08-24 10:00:00	IWM	ETF	80.15	80.7	80.11	80.61	4565270.0
2012-08-24 11:00:00	IWM	ETF	80.61	81.07	80.61	80.6355	4619016.0
2012-08-24 12:00:00	IWM	ETF	80.64	80.89	80.56	80.81	1580567.0
2012-08-24 13:00:00	IWM	ETF	80.811	81.03	80.73	80.88	2113134.0
2012-08-24 14:00:00	IWM	ETF	80.88	80.92	80.72	80.77	1715773.0
2012-08-24 15:00:00	IWM	ETF	80.77	81.04	80.6799	80.71	6814022.0
2012-08-24 16:00:00	IWM	ETF	80.71	80.85	80.67	80.74	993564.0
2012-08-24 17:00:00	IWM	ETF	80.71	80.71	80.7	80.7	10623.0
2012-08-24 18:00:00	IWM	ETF	80.62	80.62	80.62	80.62	200.0
2012-08-24 19:00:00	IWM	ETF	80.72	80.81	80.72	80.81	3000.0
2012-08-24 08:00:00	DIA	ETF	130.28	130.34	130.08	130.1	15500.0
2012-08-24 09:00:00	DIA	ETF	130.19	130.33	130.06	130.09	403412.0
2012-08-24 10:00:00	DIA	ETF	130.09	130.74	130.0702	130.64	727013.0
2012-08-24 11:00:00	DIA	ETF	130.65	131.25	130.635	131.0	632333.0
2012-08-24 12:00:00	DIA	ETF	131.0	131.22	130.96	131.15	243907.0
2012-08-24 13:00:00	DIA	ETF	131.14	131.42	131.06	131.3193	281979.0

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

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