PREVIEW / etf_1hour / 2013-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-28.parquet
  size:    199 KB
  rows:    6,353

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
2013-01-28 04:00:00	SPY	ETF	150.03	150.03	149.99	150.0	5857.0
2013-01-28 05:00:00	SPY	ETF	150.03	150.08	150.03	150.05	6350.0
2013-01-28 06:00:00	SPY	ETF	149.97	150.02	149.97	149.99	22430.0
2013-01-28 07:00:00	SPY	ETF	150.04	150.2	149.99	150.17	150932.0
2013-01-28 08:00:00	SPY	ETF	150.19	150.36	149.965	150.31	1098116.0
2013-01-28 09:00:00	SPY	ETF	150.33	150.34	149.92	149.93	11290324.0
2013-01-28 10:00:00	SPY	ETF	149.92	150.1896	149.51	149.91	17569436.0
2013-01-28 11:00:00	SPY	ETF	149.905	150.19	149.82	150.13	11061382.0
2013-01-28 12:00:00	SPY	ETF	150.138	150.18	149.94	149.99	8405406.0
2013-01-28 13:00:00	SPY	ETF	149.99	150.05	149.78	150.01	7345868.0
2013-01-28 14:00:00	SPY	ETF	150.0	150.1896	149.99	150.13	6908475.0
2013-01-28 15:00:00	SPY	ETF	150.13	150.21	149.89	150.04	28272595.0
2013-01-28 16:00:00	SPY	ETF	150.03	150.19	149.9019	149.95	20022233.0
2013-01-28 17:00:00	SPY	ETF	149.95	150.02	149.85	149.9	477153.0
2013-01-28 18:00:00	SPY	ETF	149.91	149.94	149.85	149.88	86929.0
2013-01-28 19:00:00	SPY	ETF	149.9	149.92	149.85	149.86	23804.0
2013-01-28 04:00:00	QQQ	ETF	66.97	66.97	66.9	66.9	4200.0
2013-01-28 06:00:00	QQQ	ETF	66.94	66.95	66.94	66.95	5968.0
2013-01-28 07:00:00	QQQ	ETF	66.95	67.03	66.95	67.03	13973.0
2013-01-28 08:00:00	QQQ	ETF	67.04	67.05	66.93	67.04	213594.0
2013-01-28 09:00:00	QQQ	ETF	67.04	67.22	66.97	67.179	3770310.0
2013-01-28 10:00:00	QQQ	ETF	67.17	67.26	66.93	67.21	6463624.0
2013-01-28 11:00:00	QQQ	ETF	67.22	67.38	67.15	67.35	2214098.0
2013-01-28 12:00:00	QQQ	ETF	67.35	67.37	67.21	67.21	1510348.0
2013-01-28 13:00:00	QQQ	ETF	67.21	67.22	67.02	67.17	2312092.0
2013-01-28 14:00:00	QQQ	ETF	67.17	67.31	67.15	67.26	1682121.0
2013-01-28 15:00:00	QQQ	ETF	67.26	67.33	67.1	67.14	6012032.0
2013-01-28 16:00:00	QQQ	ETF	67.14	67.34	66.94	67.04	2528355.0
2013-01-28 17:00:00	QQQ	ETF	67.05	67.09	66.9807	67.05	3180292.0
2013-01-28 18:00:00	QQQ	ETF	67.05	67.06	67.04	67.04	5739.0
2013-01-28 19:00:00	QQQ	ETF	67.06	67.08	67.03	67.03	2730.0
2013-01-28 07:00:00	IWM	ETF	89.95	90.0	89.95	89.97	75600.0
2013-01-28 08:00:00	IWM	ETF	89.98	90.06	89.91	90.05	219567.0
2013-01-28 09:00:00	IWM	ETF	90.04	90.04	89.8	89.81	2655668.0
2013-01-28 10:00:00	IWM	ETF	89.82	89.88	89.38	89.58	5038276.0
2013-01-28 11:00:00	IWM	ETF	89.59	89.97	89.58	89.94	3496038.0
2013-01-28 12:00:00	IWM	ETF	89.95	90.07	89.89	89.99	2837447.0
2013-01-28 13:00:00	IWM	ETF	89.99	90.02	89.81	90.01	2163399.0
2013-01-28 14:00:00	IWM	ETF	90.01	90.16	89.99	90.13	2832986.0
2013-01-28 15:00:00	IWM	ETF	90.14	90.23	89.905	90.0199	7990472.0
2013-01-28 16:00:00	IWM	ETF	90.01	90.09	89.45	89.91	5281707.0
2013-01-28 17:00:00	IWM	ETF	89.91	90.0	89.89	90.0	33000.0
2013-01-28 18:00:00	IWM	ETF	89.98	89.98	89.98	89.98	2000.0
2013-01-28 19:00:00	IWM	ETF	89.94	89.95	89.94	89.94	10900.0
2013-01-28 07:00:00	DIA	ETF	138.5	138.54	138.42	138.54	1900.0
2013-01-28 08:00:00	DIA	ETF	138.59	138.8	138.4	138.76	111911.0
2013-01-28 09:00:00	DIA	ETF	138.75	138.88	138.59	138.59	364051.0
2013-01-28 10:00:00	DIA	ETF	138.58	138.5801	138.3	138.54	513522.0
2013-01-28 11:00:00	DIA	ETF	138.54	138.68	138.43	138.63	333363.0
2013-01-28 12:00:00	DIA	ETF	138.6501	138.71	138.44	138.53	272221.0

> showing 50 of 6,353 rows — these rows as CSV

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