PREVIEW / etf_1hour / 2012-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-23.parquet
  size:    115 KB
  rows:    3,398

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-11-23 04:00:00	SPY	ETF	139.49	139.59	139.49	139.59	300.0
2012-11-23 05:00:00	SPY	ETF	139.8	139.8	139.55	139.55	19300.0
2012-11-23 06:00:00	SPY	ETF	139.56	139.74	139.5	139.74	7529.0
2012-11-23 07:00:00	SPY	ETF	139.7	139.83	139.69	139.8	38091.0
2012-11-23 08:00:00	SPY	ETF	139.82	140.0	139.82	139.92	520131.0
2012-11-23 09:00:00	SPY	ETF	139.92	140.32	139.92	140.28	12654093.0
2012-11-23 10:00:00	SPY	ETF	140.28	140.875	140.28	140.738	13927450.0
2012-11-23 11:00:00	SPY	ETF	140.74	140.87	140.64	140.68	7174571.0
2012-11-23 12:00:00	SPY	ETF	140.68	141.4	140.57	141.35	21440548.0
2012-11-23 13:00:00	SPY	ETF	141.33	141.35	141.1	141.15	6278069.0
2012-11-23 14:00:00	SPY	ETF	141.15	141.18	141.07	141.15	191815.0
2012-11-23 15:00:00	SPY	ETF	141.17	141.2	141.1	141.16	30084.0
2012-11-23 16:00:00	SPY	ETF	141.13	141.17	141.12	141.14	10049.0
2012-11-23 04:00:00	QQQ	ETF	64.06	64.06	64.06	64.06	200.0
2012-11-23 05:00:00	QQQ	ETF	64.03	64.03	64.03	64.03	533.0
2012-11-23 06:00:00	QQQ	ETF	64.06	64.06	64.06	64.06	300.0
2012-11-23 07:00:00	QQQ	ETF	64.08	64.11	64.08	64.1	32240.0
2012-11-23 08:00:00	QQQ	ETF	64.13	64.22	64.12	64.17	65595.0
2012-11-23 09:00:00	QQQ	ETF	64.16	64.45	64.16	64.36	2923272.0
2012-11-23 10:00:00	QQQ	ETF	64.36	64.69	64.35	64.6695	4622533.0
2012-11-23 11:00:00	QQQ	ETF	64.661	64.78	64.65	64.7199	2244473.0
2012-11-23 12:00:00	QQQ	ETF	64.719	64.92	64.58	64.9	4453263.0
2012-11-23 13:00:00	QQQ	ETF	64.89	64.91	64.6671	64.7801	1435493.0
2012-11-23 14:00:00	QQQ	ETF	64.8	64.87	64.79	64.87	8656.0
2012-11-23 15:00:00	QQQ	ETF	64.84	64.84	64.79	64.82	3745.0
2012-11-23 16:00:00	QQQ	ETF	64.84	64.85	64.84	64.84	1600.0
2012-11-23 07:00:00	IWM	ETF	79.7	79.72	79.65	79.72	1839.0
2012-11-23 08:00:00	IWM	ETF	79.73	79.84	79.73	79.78	63416.0
2012-11-23 09:00:00	IWM	ETF	79.78	80.14	79.73	80.04	4439356.0
2012-11-23 10:00:00	IWM	ETF	80.05	80.5	80.05	80.32	4392262.0
2012-11-23 11:00:00	IWM	ETF	80.3215	80.4101	80.19	80.25	3235089.0
2012-11-23 12:00:00	IWM	ETF	80.25	80.56	80.03	80.55	4587835.0
2012-11-23 13:00:00	IWM	ETF	80.54	80.7	80.15	80.5	1280331.0
2012-11-23 14:00:00	IWM	ETF	80.5	80.5	80.49	80.5	1525.0
2012-11-23 15:00:00	IWM	ETF	80.54	80.54	80.54	80.54	400.0
2012-11-23 16:00:00	IWM	ETF	80.43	80.43	80.43	80.43	200.0
2012-11-23 06:00:00	DIA	ETF	127.8	127.8	127.8	127.8	1000.0
2012-11-23 07:00:00	DIA	ETF	128.35	128.35	128.35	128.35	1000.0
2012-11-23 08:00:00	DIA	ETF	128.37	128.5	128.37	128.5	7684.0
2012-11-23 09:00:00	DIA	ETF	128.5	128.87	128.1354	128.85	798753.0
2012-11-23 10:00:00	DIA	ETF	128.88	129.44	128.88	129.27	844073.0
2012-11-23 11:00:00	DIA	ETF	129.28	129.41	129.16	129.198	445521.0
2012-11-23 12:00:00	DIA	ETF	129.19	129.91	129.14	129.86	1068633.0
2012-11-23 13:00:00	DIA	ETF	129.83	129.9	129.33	129.48	78536.0
2012-11-23 14:00:00	DIA	ETF	129.51	129.55	129.51	129.55	300.0
2012-11-23 15:00:00	DIA	ETF	129.78	130.23	129.7	129.7	705.0
2012-11-23 16:00:00	DIA	ETF	129.84	129.84	129.7	129.7	1584.0
2012-11-23 04:00:00	GLD	ETF	168.23	168.23	168.23	168.23	100.0
2012-11-23 07:00:00	GLD	ETF	167.9	168.01	167.9	167.98	1950.0
2012-11-23 08:00:00	GLD	ETF	168.03	168.05	167.79	167.84	12240.0

> showing 50 of 3,398 rows — these rows as CSV

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