PREVIEW / etf_1hour / 2012-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-07.parquet
  size:    185 KB
  rows:    5,798

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-05-07 04:00:00	SPY	ETF	135.5	135.87	135.5	135.85	5252.0
2012-05-07 05:00:00	SPY	ETF	135.75	136.05	135.68	136.05	46376.0
2012-05-07 06:00:00	SPY	ETF	136.07	136.2	136.0	136.13	303400.0
2012-05-07 07:00:00	SPY	ETF	136.1	136.35	136.0	136.15	981248.0
2012-05-07 08:00:00	SPY	ETF	136.15	137.0467	135.38	136.38	3512975.0
2012-05-07 09:00:00	SPY	ETF	136.38	137.18	136.36	136.93	25422227.0
2012-05-07 10:00:00	SPY	ETF	136.93	137.15	136.53	136.81	20741272.0
2012-05-07 11:00:00	SPY	ETF	136.81	137.12	136.8	136.97	12509671.0
2012-05-07 12:00:00	SPY	ETF	136.97	137.35	136.94	137.24	12282086.0
2012-05-07 13:00:00	SPY	ETF	137.24	137.56	137.18	137.46	13371867.0
2012-05-07 14:00:00	SPY	ETF	137.46	137.55	137.28	137.425	9313945.0
2012-05-07 15:00:00	SPY	ETF	137.425	137.47	136.99	137.12	18826323.0
2012-05-07 16:00:00	SPY	ETF	137.1	137.25	136.96	137.18	6925256.0
2012-05-07 17:00:00	SPY	ETF	137.18	137.24	137.09	137.19	216938.0
2012-05-07 18:00:00	SPY	ETF	137.17	137.25	137.15	137.17	32205.0
2012-05-07 19:00:00	SPY	ETF	137.21	137.34	137.15	137.28	72381.0
2012-05-07 04:00:00	QQQ	ETF	64.18	64.18	63.99	64.04	5252.0
2012-05-07 05:00:00	QQQ	ETF	64.0	64.16	64.0	64.16	3500.0
2012-05-07 06:00:00	QQQ	ETF	64.17	64.22	64.17	64.18	4600.0
2012-05-07 07:00:00	QQQ	ETF	64.17	64.26	64.14	64.17	122726.0
2012-05-07 08:00:00	QQQ	ETF	64.17	64.43	64.16	64.31	218960.0
2012-05-07 09:00:00	QQQ	ETF	64.3	64.79	64.29	64.72	9485920.0
2012-05-07 10:00:00	QQQ	ETF	64.71	64.85	64.43	64.7708	9505748.0
2012-05-07 11:00:00	QQQ	ETF	64.77	64.9	64.62	64.6809	4639349.0
2012-05-07 12:00:00	QQQ	ETF	64.685	64.919	64.6301	64.8491	3984955.0
2012-05-07 13:00:00	QQQ	ETF	64.8416	65.06	64.79	65.01	5068437.0
2012-05-07 14:00:00	QQQ	ETF	65.01	65.07	64.875	64.961	3199424.0
2012-05-07 15:00:00	QQQ	ETF	64.97	65.01	64.71	64.76	6372314.0
2012-05-07 16:00:00	QQQ	ETF	64.77	64.86	64.71	64.86	2375914.0
2012-05-07 17:00:00	QQQ	ETF	64.86	64.88	64.82	64.84	16214.0
2012-05-07 18:00:00	QQQ	ETF	64.85	64.86	64.81	64.85	18667.0
2012-05-07 19:00:00	QQQ	ETF	64.84	64.91	64.82	64.89	12900.0
2012-05-07 04:00:00	IWM	ETF	78.13	78.18	78.13	78.18	1236.0
2012-05-07 05:00:00	IWM	ETF	78.15	78.41	78.05	78.41	1550.0
2012-05-07 06:00:00	IWM	ETF	78.45	78.5	78.42	78.5	3800.0
2012-05-07 07:00:00	IWM	ETF	78.49	78.64	78.42	78.47	42814.0
2012-05-07 08:00:00	IWM	ETF	78.51	78.71	78.47	78.68	249482.0
2012-05-07 09:00:00	IWM	ETF	78.67	79.24	78.62	79.12	9008244.0
2012-05-07 10:00:00	IWM	ETF	79.12	79.22	78.67	78.95	8390045.0
2012-05-07 11:00:00	IWM	ETF	78.949	79.26	78.91	78.99	5052536.0
2012-05-07 12:00:00	IWM	ETF	79.0	79.39	78.93	79.25	4390998.0
2012-05-07 13:00:00	IWM	ETF	79.26	79.6	79.19	79.51	4343706.0
2012-05-07 14:00:00	IWM	ETF	79.5023	79.57	79.28	79.4	2900263.0
2012-05-07 15:00:00	IWM	ETF	79.4	79.44	79.11	79.35	7086469.0
2012-05-07 16:00:00	IWM	ETF	79.34	79.44	79.24	79.43	779639.0
2012-05-07 17:00:00	IWM	ETF	79.43	79.46	79.43	79.43	4136.0
2012-05-07 18:00:00	IWM	ETF	79.45	79.45	79.45	79.45	700.0
2012-05-07 19:00:00	IWM	ETF	79.5	79.5	79.5	79.5	500.0
2012-05-07 06:00:00	DIA	ETF	129.26	129.26	129.26	129.26	100.0
2012-05-07 07:00:00	DIA	ETF	129.28	129.45	129.22	129.3	4730.0

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

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