PREVIEW / etf_1hour / 2012-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-09.parquet
  size:    185 KB
  rows:    5,792

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-04-09 04:00:00	SPY	ETF	138.23	138.42	138.15	138.16	7268.0
2012-04-09 05:00:00	SPY	ETF	138.2	138.35	138.02	138.04	72588.0
2012-04-09 06:00:00	SPY	ETF	138.03	138.07	137.97	138.0	109904.0
2012-04-09 07:00:00	SPY	ETF	138.02	138.19	137.96	138.02	256488.0
2012-04-09 08:00:00	SPY	ETF	138.03	139.79	137.94	138.07	1166472.0
2012-04-09 09:00:00	SPY	ETF	138.08	138.27	137.84	137.95	18731103.0
2012-04-09 10:00:00	SPY	ETF	137.95	138.3701	137.94	138.28	18271278.0
2012-04-09 11:00:00	SPY	ETF	138.28	139.8444	137.92	138.149	16597233.0
2012-04-09 12:00:00	SPY	ETF	138.14	138.5	138.08	138.44	8479923.0
2012-04-09 13:00:00	SPY	ETF	138.45	138.63	138.27	138.62	7864986.0
2012-04-09 14:00:00	SPY	ETF	138.62	139.8444	138.44	138.68	11275123.0
2012-04-09 15:00:00	SPY	ETF	138.68	139.8444	138.24	138.25	23884194.0
2012-04-09 16:00:00	SPY	ETF	138.24	138.3774	137.93	138.03	14871287.0
2012-04-09 17:00:00	SPY	ETF	138.03	139.8444	137.99	138.05	759024.0
2012-04-09 18:00:00	SPY	ETF	138.06	138.14	138.06	138.11	43825.0
2012-04-09 19:00:00	SPY	ETF	138.11	138.14	138.04	138.08	73393.0
2012-04-09 05:00:00	QQQ	ETF	67.0	67.0	66.75	66.75	800.0
2012-04-09 06:00:00	QQQ	ETF	67.56	67.56	66.9	66.91	2000.0
2012-04-09 07:00:00	QQQ	ETF	66.9	66.95	66.88	66.92	85450.0
2012-04-09 08:00:00	QQQ	ETF	66.92	66.97	66.85	66.96	225479.0
2012-04-09 09:00:00	QQQ	ETF	66.95	67.06	66.76	66.8187	4990215.0
2012-04-09 10:00:00	QQQ	ETF	66.81	67.34	66.81	67.34	8686766.0
2012-04-09 11:00:00	QQQ	ETF	67.335	67.34	67.06	67.23	5010961.0
2012-04-09 12:00:00	QQQ	ETF	67.22	67.41	67.1614	67.38	2956980.0
2012-04-09 13:00:00	QQQ	ETF	67.38	67.41	67.25	67.4	2455436.0
2012-04-09 14:00:00	QQQ	ETF	67.3999	67.48	67.3	67.42	3127218.0
2012-04-09 15:00:00	QQQ	ETF	67.425	67.47	67.19	67.2	6217080.0
2012-04-09 16:00:00	QQQ	ETF	67.2	67.22	67.0	67.05	1115187.0
2012-04-09 17:00:00	QQQ	ETF	67.05	67.07	67.03	67.05	13050.0
2012-04-09 18:00:00	QQQ	ETF	67.06	67.11	67.06	67.1	15898.0
2012-04-09 19:00:00	QQQ	ETF	67.11	67.11	67.01	67.07	29645.0
2012-04-09 04:00:00	IWM	ETF	80.38	80.38	80.19	80.19	5405.0
2012-04-09 05:00:00	IWM	ETF	80.3	80.3	80.28	80.28	5200.0
2012-04-09 06:00:00	IWM	ETF	80.13	80.15	80.1	80.11	17022.0
2012-04-09 07:00:00	IWM	ETF	80.13	80.29	80.11	80.14	60688.0
2012-04-09 08:00:00	IWM	ETF	80.12	80.18	80.04	80.15	297952.0
2012-04-09 09:00:00	IWM	ETF	80.16	80.39	80.01	80.13	7024336.0
2012-04-09 10:00:00	IWM	ETF	80.13	80.43	80.01	80.31	6806344.0
2012-04-09 11:00:00	IWM	ETF	80.31	80.31	79.85	80.0599	6762681.0
2012-04-09 12:00:00	IWM	ETF	80.05	80.34	79.96	80.16	3564117.0
2012-04-09 13:00:00	IWM	ETF	80.16	80.325	80.04	80.31	2830196.0
2012-04-09 14:00:00	IWM	ETF	80.31	80.57	80.155	80.49	3642247.0
2012-04-09 15:00:00	IWM	ETF	80.5	80.54	80.17	80.29	7154499.0
2012-04-09 16:00:00	IWM	ETF	80.28	80.34	79.97	80.02	1455573.0
2012-04-09 17:00:00	IWM	ETF	80.03	80.03	80.01	80.01	8855.0
2012-04-09 18:00:00	IWM	ETF	80.07	80.13	80.05	80.05	3654.0
2012-04-09 19:00:00	IWM	ETF	80.06	80.06	80.06	80.06	1000.0
2012-04-09 07:00:00	DIA	ETF	129.09	129.14	129.02	129.02	2160.0
2012-04-09 08:00:00	DIA	ETF	129.01	129.07	128.97	128.98	7397.0
2012-04-09 09:00:00	DIA	ETF	129.08	129.22	128.84	128.9401	733411.0

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

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