PREVIEW / etf_1hour / 2013-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-14.parquet
  size:    191 KB
  rows:    6,055

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-14 04:00:00	SPY	ETF	147.23	147.45	147.23	147.3	108514.0
2013-01-14 05:00:00	SPY	ETF	147.38	147.44	147.22	147.22	34600.0
2013-01-14 06:00:00	SPY	ETF	147.22	147.22	147.14	147.18	150630.0
2013-01-14 07:00:00	SPY	ETF	147.19	147.22	146.88	146.89	463663.0
2013-01-14 08:00:00	SPY	ETF	146.92	147.2	146.82	146.98	1886829.0
2013-01-14 09:00:00	SPY	ETF	147.0	147.07	146.56	146.661	17392714.0
2013-01-14 10:00:00	SPY	ETF	146.66	146.79	146.43	146.73	16288584.0
2013-01-14 11:00:00	SPY	ETF	146.73	146.85	146.59	146.79	7485046.0
2013-01-14 12:00:00	SPY	ETF	146.79	146.85	146.61	146.69	7169092.0
2013-01-14 13:00:00	SPY	ETF	146.69	146.85	146.57	146.72	5481735.0
2013-01-14 14:00:00	SPY	ETF	146.712	147.01	146.66	146.9	9023048.0
2013-01-14 15:00:00	SPY	ETF	146.91	147.0684	146.67	146.96	14872652.0
2013-01-14 16:00:00	SPY	ETF	146.96	147.02	146.5954	146.93	5903831.0
2013-01-14 17:00:00	SPY	ETF	146.86	146.89	146.85	146.88	131438.0
2013-01-14 18:00:00	SPY	ETF	146.86	146.9	146.83	146.86	33250.0
2013-01-14 19:00:00	SPY	ETF	146.88	146.9	146.78	146.79	38724.0
2013-01-14 04:00:00	QQQ	ETF	67.3	67.31	67.2	67.2	3200.0
2013-01-14 05:00:00	QQQ	ETF	67.16	67.16	67.06	67.06	5000.0
2013-01-14 06:00:00	QQQ	ETF	67.07	67.07	66.96	67.04	25198.0
2013-01-14 07:00:00	QQQ	ETF	67.01	67.02	66.88	66.88	91600.0
2013-01-14 08:00:00	QQQ	ETF	66.89	67.06	66.85	66.94	241390.0
2013-01-14 09:00:00	QQQ	ETF	66.94	67.15	66.79	66.84	9339164.0
2013-01-14 10:00:00	QQQ	ETF	66.83	66.87	66.67	66.8322	7379375.0
2013-01-14 11:00:00	QQQ	ETF	66.8399	66.9	66.75	66.84	3249586.0
2013-01-14 12:00:00	QQQ	ETF	66.85	66.865	66.7399	66.79	1559575.0
2013-01-14 13:00:00	QQQ	ETF	66.79	66.86	66.7	66.77	1280802.0
2013-01-14 14:00:00	QQQ	ETF	66.76	67.08	66.73	66.98	4748690.0
2013-01-14 15:00:00	QQQ	ETF	66.98	67.065	66.78	66.95	4888557.0
2013-01-14 16:00:00	QQQ	ETF	66.95	67.0179	66.9	66.97	1482697.0
2013-01-14 17:00:00	QQQ	ETF	66.97	66.98	66.95	66.95	19900.0
2013-01-14 18:00:00	QQQ	ETF	66.96	66.98	66.93	66.97	3256.0
2013-01-14 19:00:00	QQQ	ETF	66.96	66.98	66.94	66.95	8325.0
2013-01-14 04:00:00	IWM	ETF	87.43	87.55	87.43	87.55	500.0
2013-01-14 07:00:00	IWM	ETF	87.35	87.35	87.35	87.35	300.0
2013-01-14 08:00:00	IWM	ETF	87.21	87.22	87.12	87.15	138140.0
2013-01-14 09:00:00	IWM	ETF	87.14	87.52	87.07	87.24	4529299.0
2013-01-14 10:00:00	IWM	ETF	87.24	87.43	87.05	87.38	4710986.0
2013-01-14 11:00:00	IWM	ETF	87.37	87.45	87.21	87.34	1893224.0
2013-01-14 12:00:00	IWM	ETF	87.35	87.38	87.24	87.33	1000791.0
2013-01-14 13:00:00	IWM	ETF	87.32	87.37	87.2	87.24	553224.0
2013-01-14 14:00:00	IWM	ETF	87.24	87.36	87.14	87.22	2150305.0
2013-01-14 15:00:00	IWM	ETF	87.221	87.37	87.095	87.37	4792799.0
2013-01-14 16:00:00	IWM	ETF	87.36	87.4	87.27	87.29	609656.0
2013-01-14 17:00:00	IWM	ETF	87.28	87.29	87.26	87.28	8700.0
2013-01-14 18:00:00	IWM	ETF	87.31	87.31	87.28	87.29	1642.0
2013-01-14 19:00:00	IWM	ETF	87.35	87.35	87.28	87.28	1300.0
2013-01-14 04:00:00	DIA	ETF	134.83	134.83	134.83	134.83	100.0
2013-01-14 05:00:00	DIA	ETF	134.83	134.83	134.83	134.83	600.0
2013-01-14 07:00:00	DIA	ETF	134.7	134.7	134.65	134.65	600.0
2013-01-14 08:00:00	DIA	ETF	134.48	134.65	134.48	134.65	3577.0

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

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