PREVIEW / etf_1hour / 2011-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-21.parquet
  size:    182 KB
  rows:    5,531

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
2011-06-21 04:00:00	SPY	ETF	128.43	128.43	128.36	128.43	1100.0
2011-06-21 05:00:00	SPY	ETF	128.32	128.32	128.32	128.32	100.0
2011-06-21 06:00:00	SPY	ETF	128.27	128.54	128.24	128.41	28434.0
2011-06-21 07:00:00	SPY	ETF	128.46	128.63	128.27	128.53	603385.0
2011-06-21 08:00:00	SPY	ETF	128.51	128.57	128.34	128.4	1364718.0
2011-06-21 09:00:00	SPY	ETF	128.4	128.62	128.19	128.5499	20751457.0
2011-06-21 10:00:00	SPY	ETF	128.54	129.17	128.52	129.1	29515653.0
2011-06-21 11:00:00	SPY	ETF	129.11	129.55	129.02	129.4	26759054.0
2011-06-21 12:00:00	SPY	ETF	129.4	129.48	129.25	129.36	15102999.0
2011-06-21 13:00:00	SPY	ETF	129.35	129.37	129.08	129.2	21475401.0
2011-06-21 14:00:00	SPY	ETF	129.2	129.7	129.19	129.61	24262409.0
2011-06-21 15:00:00	SPY	ETF	129.615	129.65	129.27	129.45	38943643.0
2011-06-21 16:00:00	SPY	ETF	129.44	129.5	127.7548	129.31	8540041.0
2011-06-21 17:00:00	SPY	ETF	129.31	129.92	129.05	129.55	1579112.0
2011-06-21 18:00:00	SPY	ETF	129.5	129.53	129.04	129.24	1267515.0
2011-06-21 19:00:00	SPY	ETF	129.27	129.39	129.13	129.31	227717.0
2011-06-21 05:00:00	QQQ	ETF	54.3	54.3	54.17	54.17	1600.0
2011-06-21 07:00:00	QQQ	ETF	54.27	54.37	54.25	54.37	9038.0
2011-06-21 08:00:00	QQQ	ETF	54.35	54.36	54.25	54.29	204171.0
2011-06-21 09:00:00	QQQ	ETF	54.28	54.49	54.03	54.46	6701808.0
2011-06-21 10:00:00	QQQ	ETF	54.47	54.96	54.45	54.925	9061734.0
2011-06-21 11:00:00	QQQ	ETF	54.925	55.13	54.88	55.07	7153001.0
2011-06-21 12:00:00	QQQ	ETF	55.07	55.12	55.0	55.0948	4804016.0
2011-06-21 13:00:00	QQQ	ETF	55.091	55.1006	55.005	55.031	3057482.0
2011-06-21 14:00:00	QQQ	ETF	55.04	55.27	55.03	55.2397	5181504.0
2011-06-21 15:00:00	QQQ	ETF	55.24	55.29	55.1	55.225	10918228.0
2011-06-21 16:00:00	QQQ	ETF	55.23	55.24	55.08	55.14	3184922.0
2011-06-21 17:00:00	QQQ	ETF	55.14	55.25	55.06	55.2	280157.0
2011-06-21 18:00:00	QQQ	ETF	55.2	55.23	55.09	55.13	130592.0
2011-06-21 19:00:00	QQQ	ETF	55.1	55.24	55.09	55.24	14267.0
2011-06-21 04:00:00	IWM	ETF	79.51	79.56	79.51	79.56	374.0
2011-06-21 05:00:00	IWM	ETF	79.57	79.57	79.57	79.57	100.0
2011-06-21 06:00:00	IWM	ETF	79.46	79.65	79.46	79.63	5500.0
2011-06-21 07:00:00	IWM	ETF	79.63	79.77	79.5	79.77	48771.0
2011-06-21 08:00:00	IWM	ETF	79.71	79.76	79.55	79.62	435287.0
2011-06-21 09:00:00	IWM	ETF	79.6	80.11	79.42	80.08	11101292.0
2011-06-21 10:00:00	IWM	ETF	80.08	80.49	80.05	80.415	11817360.0
2011-06-21 11:00:00	IWM	ETF	80.42	80.63	80.32	80.4	10220919.0
2011-06-21 12:00:00	IWM	ETF	80.4	80.49	80.26	80.41	4892154.0
2011-06-21 13:00:00	IWM	ETF	80.41	80.42	80.13	80.24	4835158.0
2011-06-21 14:00:00	IWM	ETF	80.24	80.77	80.24	80.75	7247337.0
2011-06-21 15:00:00	IWM	ETF	80.75	80.76	80.48	80.65	11953618.0
2011-06-21 16:00:00	IWM	ETF	80.67	80.7	78.9089	80.51	3155070.0
2011-06-21 17:00:00	IWM	ETF	80.51	80.63	80.34	80.48	163895.0
2011-06-21 18:00:00	IWM	ETF	80.47	80.69	80.34	80.45	21587.0
2011-06-21 19:00:00	IWM	ETF	80.45	80.54	80.41	80.53	7900.0
2011-06-21 04:00:00	DIA	ETF	121.15	121.15	121.15	121.15	100.0
2011-06-21 05:00:00	DIA	ETF	121.0	121.0	120.95	120.97	1600.0
2011-06-21 06:00:00	DIA	ETF	120.99	121.09	120.99	121.09	6000.0
2011-06-21 07:00:00	DIA	ETF	121.09	121.15	121.0	121.15	2040.0

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

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