PREVIEW / etf_1hour / 2012-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-22.parquet
  size:    181 KB
  rows:    5,671

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-02-22 04:00:00	SPY	ETF	136.5	136.5	136.35	136.47	27380.0
2012-02-22 05:00:00	SPY	ETF	136.34	136.42	136.34	136.42	15340.0
2012-02-22 06:00:00	SPY	ETF	136.35	136.35	136.14	136.17	151875.0
2012-02-22 07:00:00	SPY	ETF	136.17	136.45	136.15	136.33	266730.0
2012-02-22 08:00:00	SPY	ETF	136.33	136.4716	136.12	136.38	1413582.0
2012-02-22 09:00:00	SPY	ETF	136.37	136.46	136.17	136.34	17895887.0
2012-02-22 10:00:00	SPY	ETF	136.34	136.55	136.07	136.3	28911532.0
2012-02-22 11:00:00	SPY	ETF	136.31	136.46	135.85	135.95	19448723.0
2012-02-22 12:00:00	SPY	ETF	135.95	136.04	135.79	135.9901	9292728.0
2012-02-22 13:00:00	SPY	ETF	135.995	136.35	135.97	136.29	9665468.0
2012-02-22 14:00:00	SPY	ETF	136.29	136.37	136.06	136.06	9010236.0
2012-02-22 15:00:00	SPY	ETF	136.06	136.29	135.92	136.02	21993800.0
2012-02-22 16:00:00	SPY	ETF	136.01	136.3664	135.95	136.15	5167592.0
2012-02-22 17:00:00	SPY	ETF	136.15	136.15	135.96	136.0	370918.0
2012-02-22 18:00:00	SPY	ETF	136.0	136.05	135.96	136.03	213514.0
2012-02-22 19:00:00	SPY	ETF	136.04	136.04	135.83	135.85	245666.0
2012-02-22 20:00:00	SPY	ETF	135.85	135.85	135.85	135.85	500.0
2012-02-22 04:00:00	QQQ	ETF	63.64	63.68	63.64	63.68	700.0
2012-02-22 05:00:00	QQQ	ETF	63.58	63.62	63.58	63.6	2200.0
2012-02-22 06:00:00	QQQ	ETF	63.54	63.55	63.52	63.52	8100.0
2012-02-22 07:00:00	QQQ	ETF	63.51	63.61	63.51	63.55	76950.0
2012-02-22 08:00:00	QQQ	ETF	63.56	63.6	63.47	63.56	247253.0
2012-02-22 09:00:00	QQQ	ETF	63.57	63.59	63.36	63.55	7234016.0
2012-02-22 10:00:00	QQQ	ETF	63.54	63.68	63.37	63.5	10349105.0
2012-02-22 11:00:00	QQQ	ETF	63.51	63.5883	63.26	63.34	6691399.0
2012-02-22 12:00:00	QQQ	ETF	63.345	63.35	63.23	63.31	3189184.0
2012-02-22 13:00:00	QQQ	ETF	63.31	63.54	63.2798	63.52	4172818.0
2012-02-22 14:00:00	QQQ	ETF	63.52	63.55	63.34	63.34	3384192.0
2012-02-22 15:00:00	QQQ	ETF	63.345	63.47	63.25	63.34	5026067.0
2012-02-22 16:00:00	QQQ	ETF	63.33	63.41	63.3	63.37	519508.0
2012-02-22 17:00:00	QQQ	ETF	63.36	63.36	63.33	63.33	6400.0
2012-02-22 18:00:00	QQQ	ETF	63.34	63.36	63.31	63.36	11980.0
2012-02-22 19:00:00	QQQ	ETF	63.34	63.35	63.25	63.28	16585.0
2012-02-22 06:00:00	IWM	ETF	82.02	82.02	82.02	82.02	500.0
2012-02-22 07:00:00	IWM	ETF	81.86	82.17	81.86	82.06	236440.0
2012-02-22 08:00:00	IWM	ETF	82.07	82.11	81.86	82.11	203913.0
2012-02-22 09:00:00	IWM	ETF	82.1	82.33	81.93	82.15	6400349.0
2012-02-22 10:00:00	IWM	ETF	82.15	82.36	81.89	82.01	8072336.0
2012-02-22 11:00:00	IWM	ETF	82.02	82.15	81.56	81.61	6405407.0
2012-02-22 12:00:00	IWM	ETF	81.61	81.72	81.5	81.685	2936222.0
2012-02-22 13:00:00	IWM	ETF	81.68	81.93	81.64	81.9	3010683.0
2012-02-22 14:00:00	IWM	ETF	81.9	81.97	81.65	81.65	2186552.0
2012-02-22 15:00:00	IWM	ETF	81.6425	81.8	81.51	81.59	6517563.0
2012-02-22 16:00:00	IWM	ETF	81.58	81.895	81.55	81.8803	909148.0
2012-02-22 17:00:00	IWM	ETF	81.64	81.64	81.55	81.55	32605.0
2012-02-22 18:00:00	IWM	ETF	81.55	81.6	81.55	81.6	1300.0
2012-02-22 19:00:00	IWM	ETF	81.6	81.6	81.5	81.53	15190.0
2012-02-22 07:00:00	DIA	ETF	129.2	129.33	129.2	129.33	400.0
2012-02-22 08:00:00	DIA	ETF	129.19	129.3	129.19	129.3	2100.0
2012-02-22 09:00:00	DIA	ETF	129.35	129.47	129.17	129.37	767325.0

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

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