PREVIEW / etf_1hour / 2012-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-03.parquet
  size:    181 KB
  rows:    5,593

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-03 04:00:00	SPY	ETF	141.72	141.72	141.47	141.47	940.0
2012-04-03 05:00:00	SPY	ETF	141.44	141.62	141.41	141.41	22150.0
2012-04-03 06:00:00	SPY	ETF	141.42	141.49	141.39	141.45	28845.0
2012-04-03 07:00:00	SPY	ETF	141.49	141.56	141.25	141.33	337886.0
2012-04-03 08:00:00	SPY	ETF	141.33	141.51	141.29	141.49	1099669.0
2012-04-03 09:00:00	SPY	ETF	141.48	141.78	141.45	141.63	14471997.0
2012-04-03 10:00:00	SPY	ETF	141.62	141.88	141.36	141.76	19991546.0
2012-04-03 11:00:00	SPY	ETF	141.76	141.77	141.22	141.35	14087624.0
2012-04-03 12:00:00	SPY	ETF	141.35	141.8826	141.01	141.289	13169519.0
2012-04-03 13:00:00	SPY	ETF	141.29	141.42	141.15	141.37	7345936.0
2012-04-03 14:00:00	SPY	ETF	141.36	141.37	140.43	140.72	39057511.0
2012-04-03 15:00:00	SPY	ETF	140.72	141.32	140.67	141.28	30659052.0
2012-04-03 16:00:00	SPY	ETF	141.29	141.8826	141.2208	141.27	14949363.0
2012-04-03 17:00:00	SPY	ETF	141.27	141.3	141.24	141.26	55412.0
2012-04-03 18:00:00	SPY	ETF	141.26	141.29	141.16	141.16	50790.0
2012-04-03 19:00:00	SPY	ETF	141.18	141.22	141.16	141.17	38435.0
2012-04-03 04:00:00	QQQ	ETF	68.18	68.18	68.18	68.18	200.0
2012-04-03 05:00:00	QQQ	ETF	68.15	68.15	68.15	68.15	100.0
2012-04-03 06:00:00	QQQ	ETF	68.15	68.15	68.14	68.14	7000.0
2012-04-03 07:00:00	QQQ	ETF	68.13	68.18	68.07	68.11	105800.0
2012-04-03 08:00:00	QQQ	ETF	68.12	68.25	68.12	68.25	520703.0
2012-04-03 09:00:00	QQQ	ETF	68.25	68.46	68.24	68.42	8347868.0
2012-04-03 10:00:00	QQQ	ETF	68.412	68.55	68.28	68.53	6637116.0
2012-04-03 11:00:00	QQQ	ETF	68.54	68.55	68.2	68.229	5298024.0
2012-04-03 12:00:00	QQQ	ETF	68.23	68.25	67.98	68.21	4207668.0
2012-04-03 13:00:00	QQQ	ETF	68.21	68.29	68.13	68.27	3528079.0
2012-04-03 14:00:00	QQQ	ETF	68.27	68.27	67.85	67.98	8025356.0
2012-04-03 15:00:00	QQQ	ETF	67.99	68.24	67.91	68.23	7582926.0
2012-04-03 16:00:00	QQQ	ETF	68.24	68.29	67.9551	68.2	750801.0
2012-04-03 17:00:00	QQQ	ETF	68.2	68.23	68.18	68.22	29867.0
2012-04-03 18:00:00	QQQ	ETF	68.22	68.22	68.16	68.16	21788.0
2012-04-03 19:00:00	QQQ	ETF	68.16	68.18	68.15	68.15	10320.0
2012-04-03 05:00:00	IWM	ETF	83.74	83.74	83.74	83.74	2000.0
2012-04-03 06:00:00	IWM	ETF	83.68	83.68	83.68	83.68	1100.0
2012-04-03 07:00:00	IWM	ETF	83.7	83.78	83.58	83.59	54750.0
2012-04-03 08:00:00	IWM	ETF	83.59	83.7	83.55	83.62	110528.0
2012-04-03 09:00:00	IWM	ETF	83.64	84.0	83.61	83.74	4405378.0
2012-04-03 10:00:00	IWM	ETF	83.75	83.97	83.53	83.83	6366196.0
2012-04-03 11:00:00	IWM	ETF	83.83	83.85	83.46	83.66	4172432.0
2012-04-03 12:00:00	IWM	ETF	83.66	83.75	83.43	83.6899	5377066.0
2012-04-03 13:00:00	IWM	ETF	83.68	83.74	83.53	83.69	2186841.0
2012-04-03 14:00:00	IWM	ETF	83.68	83.68	82.93	83.05	10549346.0
2012-04-03 15:00:00	IWM	ETF	83.05	83.37	82.94	83.32	10394968.0
2012-04-03 16:00:00	IWM	ETF	83.31	83.8819	83.2	83.2	1502958.0
2012-04-03 17:00:00	IWM	ETF	83.2	83.27	83.16	83.27	89370.0
2012-04-03 18:00:00	IWM	ETF	83.19	83.27	83.19	83.27	2100.0
2012-04-03 19:00:00	IWM	ETF	83.17	83.17	83.17	83.17	100.0
2012-04-03 06:00:00	DIA	ETF	132.08	132.08	132.03	132.04	4000.0
2012-04-03 07:00:00	DIA	ETF	132.03	132.03	131.91	131.91	14200.0
2012-04-03 08:00:00	DIA	ETF	132.02	132.05	131.89	131.96	11450.0

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

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