PREVIEW / etf_1hour / 2007-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-17.parquet
  size:    70 KB
  rows:    2,235

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
2007-04-17 06:00:00	SPY	ETF	146.35	146.4	146.32	146.4	64200.0
2007-04-17 07:00:00	SPY	ETF	146.38	146.48	146.37	146.45	121500.0
2007-04-17 08:00:00	SPY	ETF	146.45	147.16	146.25	147.04	7141600.0
2007-04-17 09:00:00	SPY	ETF	147.05	147.16	146.32	146.9	17723059.0
2007-04-17 10:00:00	SPY	ETF	146.9	147.36	146.89	147.22	25691123.0
2007-04-17 11:00:00	SPY	ETF	147.22	147.4	147.18	147.27	11672766.0
2007-04-17 12:00:00	SPY	ETF	147.27	147.33	146.98	147.02	7698512.0
2007-04-17 13:00:00	SPY	ETF	147.01	147.09	146.81	146.95	10445927.0
2007-04-17 14:00:00	SPY	ETF	146.95	147.27	146.92	147.18	10288816.0
2007-04-17 15:00:00	SPY	ETF	147.17	147.21	146.92	147.07	10539370.0
2007-04-17 16:00:00	SPY	ETF	147.08	147.15	146.76	146.86	2790400.0
2007-04-17 17:00:00	SPY	ETF	146.87	147.13	146.73	146.8	1573300.0
2007-04-17 18:00:00	SPY	ETF	146.83	146.85	146.82	146.83	6200.0
2007-04-17 19:00:00	SPY	ETF	146.82	146.83	146.82	146.83	3100.0
2007-04-17 06:00:00	QQQ	ETF	44.96	44.96	44.96	44.96	10000.0
2007-04-17 07:00:00	QQQ	ETF	44.96	45.01	44.96	44.99	392980.0
2007-04-17 08:00:00	QQQ	ETF	44.99	45.26	44.96	45.22	5654154.0
2007-04-17 09:00:00	QQQ	ETF	45.23	45.23	44.96	45.06	16492403.0
2007-04-17 10:00:00	QQQ	ETF	45.06	45.2	45.05	45.13	13740000.0
2007-04-17 11:00:00	QQQ	ETF	45.14	45.19	45.11	45.13	7232700.0
2007-04-17 12:00:00	QQQ	ETF	45.14	45.15	45.01	45.04	5984600.0
2007-04-17 13:00:00	QQQ	ETF	45.04	45.07	44.97	45.04	7211900.0
2007-04-17 14:00:00	QQQ	ETF	45.04	45.17	45.03	45.14	8185500.0
2007-04-17 15:00:00	QQQ	ETF	45.13	45.15	45.07	45.1	8221000.0
2007-04-17 16:00:00	QQQ	ETF	45.11	45.31	45.05	45.07	7646270.0
2007-04-17 17:00:00	QQQ	ETF	45.06	45.07	45.01	45.03	1075648.0
2007-04-17 18:00:00	QQQ	ETF	45.04	45.05	45.02	45.02	23295.0
2007-04-17 19:00:00	QQQ	ETF	45.03	45.05	45.02	45.03	5987.0
2007-04-17 07:00:00	IWM	ETF	82.25	82.29	82.25	82.29	9000.0
2007-04-17 08:00:00	IWM	ETF	82.25	82.71	82.21	82.61	1920900.0
2007-04-17 09:00:00	IWM	ETF	82.62	82.68	82.19	82.37	6678069.0
2007-04-17 10:00:00	IWM	ETF	82.36	82.61	82.28	82.5	9531105.0
2007-04-17 11:00:00	IWM	ETF	82.5	82.53	82.35	82.4174	3125720.0
2007-04-17 12:00:00	IWM	ETF	82.42	82.44	82.13	82.23	7634082.0
2007-04-17 13:00:00	IWM	ETF	82.22	82.28	81.94	82.13	7573815.0
2007-04-17 14:00:00	IWM	ETF	82.13	82.41	82.09	82.32	6738801.0
2007-04-17 15:00:00	IWM	ETF	82.32	82.35	82.1	82.29	5042072.0
2007-04-17 16:00:00	IWM	ETF	82.27	82.28	82.03	82.12	2191900.0
2007-04-17 17:00:00	IWM	ETF	82.12	82.23	82.0	82.23	5012100.0
2007-04-17 19:00:00	IWM	ETF	82.07	82.11	82.07	82.11	2000.0
2007-04-17 07:00:00	DIA	ETF	126.88	126.95	126.85	126.95	4200.0
2007-04-17 08:00:00	DIA	ETF	126.96	127.42	126.92	127.4	85100.0
2007-04-17 09:00:00	DIA	ETF	127.4	127.42	127.04	127.28	870600.0
2007-04-17 10:00:00	DIA	ETF	127.3	127.78	127.29	127.68	1733786.0
2007-04-17 11:00:00	DIA	ETF	127.68	127.87	127.64	127.79	880825.0
2007-04-17 12:00:00	DIA	ETF	127.79	127.82	127.6	127.65	969025.0
2007-04-17 13:00:00	DIA	ETF	127.64	127.7	127.43	127.58	964750.0
2007-04-17 14:00:00	DIA	ETF	127.58	127.82	127.55	127.769	756990.0
2007-04-17 15:00:00	DIA	ETF	127.77	127.8	127.57	127.65	1427750.0
2007-04-17 16:00:00	DIA	ETF	127.64	127.71	127.49	127.52	90800.0

> showing 50 of 2,235 rows — these rows as CSV

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