PREVIEW / etf_1hour / 2012-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-30.parquet
  size:    181 KB
  rows:    5,650

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-30 04:00:00	SPY	ETF	138.41	138.41	138.24	138.24	1000.0
2012-07-30 05:00:00	SPY	ETF	138.25	138.51	138.25	138.51	15200.0
2012-07-30 06:00:00	SPY	ETF	138.59	138.59	138.41	138.45	28304.0
2012-07-30 07:00:00	SPY	ETF	138.49	138.58	138.41	138.47	185786.0
2012-07-30 08:00:00	SPY	ETF	138.47	138.58	138.3	138.49	850188.0
2012-07-30 09:00:00	SPY	ETF	138.49	138.98	138.44	138.96	12867818.0
2012-07-30 10:00:00	SPY	ETF	138.965	139.339	138.69	138.71	21363414.0
2012-07-30 11:00:00	SPY	ETF	138.71	138.94	138.27	138.46	16719891.0
2012-07-30 12:00:00	SPY	ETF	138.46	138.65	138.27	138.53	10611990.0
2012-07-30 13:00:00	SPY	ETF	138.53	138.75	138.4	138.47	7726538.0
2012-07-30 14:00:00	SPY	ETF	138.46	138.76	138.32	138.69	8848409.0
2012-07-30 15:00:00	SPY	ETF	138.68	138.77	138.37	138.67	17957246.0
2012-07-30 16:00:00	SPY	ETF	138.67	138.8161	138.52	138.61	5063042.0
2012-07-30 17:00:00	SPY	ETF	138.61	138.68	138.28	138.64	2097815.0
2012-07-30 18:00:00	SPY	ETF	138.64	138.72	138.64	138.69	45852.0
2012-07-30 19:00:00	SPY	ETF	138.67	138.72	138.52	138.6	20672.0
2012-07-30 04:00:00	QQQ	ETF	64.69	64.78	64.69	64.78	300.0
2012-07-30 05:00:00	QQQ	ETF	64.87	64.96	64.84	64.96	700.0
2012-07-30 06:00:00	QQQ	ETF	64.92	64.92	64.92	64.92	500.0
2012-07-30 07:00:00	QQQ	ETF	64.91	64.96	64.91	64.95	37268.0
2012-07-30 08:00:00	QQQ	ETF	64.91	65.02	64.91	65.01	170461.0
2012-07-30 09:00:00	QQQ	ETF	65.01	65.31	64.98	65.2595	4577740.0
2012-07-30 10:00:00	QQQ	ETF	65.26	65.31	64.85	64.87	8640911.0
2012-07-30 11:00:00	QQQ	ETF	64.875	65.02	64.68	64.8011	5148800.0
2012-07-30 12:00:00	QQQ	ETF	64.8	64.89	64.67	64.76	3642790.0
2012-07-30 13:00:00	QQQ	ETF	64.76	64.9	64.7	64.751	1707238.0
2012-07-30 14:00:00	QQQ	ETF	64.75	64.89	64.69	64.845	2908222.0
2012-07-30 15:00:00	QQQ	ETF	64.84	64.87	64.6	64.8	4787146.0
2012-07-30 16:00:00	QQQ	ETF	64.79	65.1792	64.77	64.82	516204.0
2012-07-30 17:00:00	QQQ	ETF	64.83	64.86	64.82	64.82	2150.0
2012-07-30 18:00:00	QQQ	ETF	64.86	64.87	64.85	64.87	2200.0
2012-07-30 19:00:00	QQQ	ETF	64.86	64.87	64.8	64.8	10620.0
2012-07-30 07:00:00	IWM	ETF	79.38	79.56	79.38	79.47	38000.0
2012-07-30 08:00:00	IWM	ETF	79.48	79.52	79.36	79.48	203796.0
2012-07-30 09:00:00	IWM	ETF	79.48	79.91	79.34	79.695	5335454.0
2012-07-30 10:00:00	IWM	ETF	79.7	79.71	79.04	79.07	6125330.0
2012-07-30 11:00:00	IWM	ETF	79.06	79.23	78.74	78.8789	5988361.0
2012-07-30 12:00:00	IWM	ETF	78.88	79.01	78.75	78.87	3403354.0
2012-07-30 13:00:00	IWM	ETF	78.86	79.09	78.79	78.9	2161971.0
2012-07-30 14:00:00	IWM	ETF	78.9	79.12	78.78	79.0801	2652727.0
2012-07-30 15:00:00	IWM	ETF	79.0801	79.12	78.85	79.05	5164494.0
2012-07-30 16:00:00	IWM	ETF	79.05	79.1	78.88	78.95	1627591.0
2012-07-30 17:00:00	IWM	ETF	78.93	78.93	78.93	78.93	300.0
2012-07-30 18:00:00	IWM	ETF	78.89	78.89	78.89	78.89	400.0
2012-07-30 04:00:00	DIA	ETF	129.76	129.76	129.76	129.76	100.0
2012-07-30 08:00:00	DIA	ETF	130.41	130.65	130.23	130.34	14285.0
2012-07-30 09:00:00	DIA	ETF	130.33	130.72	130.3	130.68	1101956.0
2012-07-30 10:00:00	DIA	ETF	130.69	130.992	130.59	130.6	814769.0
2012-07-30 11:00:00	DIA	ETF	130.597	130.76	130.135	130.29	669300.0
2012-07-30 12:00:00	DIA	ETF	130.29	130.5	130.12	130.388	281080.0

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

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