PREVIEW / etf_1hour / 2012-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-18.parquet
  size:    182 KB
  rows:    5,618

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-07-18 04:00:00	SPY	ETF	136.04	136.3	136.04	136.29	6876.0
2012-07-18 05:00:00	SPY	ETF	136.23	136.23	135.98	135.99	6382.0
2012-07-18 06:00:00	SPY	ETF	135.95	136.06	135.94	136.0	8095.0
2012-07-18 07:00:00	SPY	ETF	136.03	136.11	135.91	136.03	259963.0
2012-07-18 08:00:00	SPY	ETF	136.03	136.23	135.88	135.96	1209176.0
2012-07-18 09:00:00	SPY	ETF	135.95	136.93	135.87	136.79	16174749.0
2012-07-18 10:00:00	SPY	ETF	136.7999	137.28	136.75	137.23	17463477.0
2012-07-18 11:00:00	SPY	ETF	137.23	137.34	137.04	137.25	11703441.0
2012-07-18 12:00:00	SPY	ETF	137.25	137.64	137.24	137.52	13031021.0
2012-07-18 13:00:00	SPY	ETF	137.53	137.561	137.22	137.32	10374981.0
2012-07-18 14:00:00	SPY	ETF	137.32	137.45	136.95	137.11	11741075.0
2012-07-18 15:00:00	SPY	ETF	137.12	137.47	137.12	137.35	21595087.0
2012-07-18 16:00:00	SPY	ETF	137.35	137.64	136.0414	137.6	7474335.0
2012-07-18 17:00:00	SPY	ETF	137.62	137.75	137.6	137.68	409522.0
2012-07-18 18:00:00	SPY	ETF	137.69	137.75	137.53	137.57	91706.0
2012-07-18 19:00:00	SPY	ETF	137.55	137.57	137.5	137.57	36553.0
2012-07-18 05:00:00	QQQ	ETF	63.44	63.44	63.44	63.44	400.0
2012-07-18 07:00:00	QQQ	ETF	63.39	63.41	63.36	63.39	218459.0
2012-07-18 08:00:00	QQQ	ETF	63.38	63.48	63.33	63.37	184024.0
2012-07-18 09:00:00	QQQ	ETF	63.39	64.1	63.34	64.05	5847835.0
2012-07-18 10:00:00	QQQ	ETF	64.05	64.26	64.02	64.22	7387956.0
2012-07-18 11:00:00	QQQ	ETF	64.222	64.4	64.15	64.3625	3711985.0
2012-07-18 12:00:00	QQQ	ETF	64.37	64.58	64.36	64.51	4910031.0
2012-07-18 13:00:00	QQQ	ETF	64.51	64.54	64.32	64.37	2723051.0
2012-07-18 14:00:00	QQQ	ETF	64.37	64.44	64.16	64.25	3034341.0
2012-07-18 15:00:00	QQQ	ETF	64.25	64.45	64.25	64.4	6197725.0
2012-07-18 16:00:00	QQQ	ETF	64.4	64.63	63.5574	64.63	3237628.0
2012-07-18 17:00:00	QQQ	ETF	64.63	64.72	64.6	64.68	421156.0
2012-07-18 18:00:00	QQQ	ETF	64.69	64.69	64.62	64.62	38887.0
2012-07-18 19:00:00	QQQ	ETF	64.62	64.62	64.58	64.62	16365.0
2012-07-18 07:00:00	IWM	ETF	79.55	79.65	79.55	79.65	16300.0
2012-07-18 08:00:00	IWM	ETF	79.63	79.65	79.51	79.57	129285.0
2012-07-18 09:00:00	IWM	ETF	79.56	80.42	79.53	80.25	8070736.0
2012-07-18 10:00:00	IWM	ETF	80.26	80.55	80.17	80.49	6002400.0
2012-07-18 11:00:00	IWM	ETF	80.5	80.6	80.37	80.5486	2949709.0
2012-07-18 12:00:00	IWM	ETF	80.54	80.7082	80.54	80.62	3149135.0
2012-07-18 13:00:00	IWM	ETF	80.63	80.69	80.36	80.42	2658198.0
2012-07-18 14:00:00	IWM	ETF	80.43	80.53	79.99	80.13	4171555.0
2012-07-18 15:00:00	IWM	ETF	80.14	80.33	80.12	80.21	6208134.0
2012-07-18 16:00:00	IWM	ETF	80.21	80.35	80.18	80.35	4026691.0
2012-07-18 17:00:00	IWM	ETF	80.38	80.5	80.38	80.46	21397.0
2012-07-18 18:00:00	IWM	ETF	80.51	80.53	80.51	80.53	4999.0
2012-07-18 19:00:00	IWM	ETF	80.35	80.35	80.35	80.35	300.0
2012-07-18 08:00:00	DIA	ETF	127.5	127.78	127.4	127.4	5050.0
2012-07-18 09:00:00	DIA	ETF	127.49	128.2095	127.43	128.14	222130.0
2012-07-18 10:00:00	DIA	ETF	128.15	128.78	128.12	128.74	569938.0
2012-07-18 11:00:00	DIA	ETF	128.74	128.87	128.52	128.74	419941.0
2012-07-18 12:00:00	DIA	ETF	128.7252	129.15	128.7252	129.03	446067.0
2012-07-18 13:00:00	DIA	ETF	129.05	129.0795	128.8	128.86	289428.0
2012-07-18 14:00:00	DIA	ETF	128.87	129.02	128.63	128.79	299603.0

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

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