PREVIEW / etf_1hour / 2007-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-20.parquet
  size:    65 KB
  rows:    2,075

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-02-20 04:00:00	SPY	ETF	145.73	145.73	145.73	145.73	200.0
2007-02-20 06:00:00	SPY	ETF	145.7	145.7	145.57	145.57	10100.0
2007-02-20 07:00:00	SPY	ETF	145.58	145.67	145.56	145.64	115300.0
2007-02-20 08:00:00	SPY	ETF	145.64	145.65	145.51	145.53	614500.0
2007-02-20 09:00:00	SPY	ETF	145.53	145.62	145.16	145.24	7909200.0
2007-02-20 10:00:00	SPY	ETF	145.25	145.5	144.06	145.41	8262500.0
2007-02-20 11:00:00	SPY	ETF	145.42	146.02	145.41	145.96	12592000.0
2007-02-20 12:00:00	SPY	ETF	145.96	146.07	145.83	145.94	6392400.0
2007-02-20 13:00:00	SPY	ETF	145.93	146.01	145.79	145.989	5074200.0
2007-02-20 14:00:00	SPY	ETF	145.98	146.12	145.9	146.1	3530200.0
2007-02-20 15:00:00	SPY	ETF	146.11	146.2	146.05	146.1	7289800.0
2007-02-20 16:00:00	SPY	ETF	146.1	146.11	145.96	146.0	1169400.0
2007-02-20 17:00:00	SPY	ETF	146.0	146.04	145.95	146.03	508900.0
2007-02-20 18:00:00	SPY	ETF	145.96	145.99	145.95	145.98	12100.0
2007-02-20 19:00:00	SPY	ETF	145.95	145.99	145.95	145.99	600.0
2007-02-20 04:00:00	QQQ	ETF	44.76	44.76	44.76	44.76	100.0
2007-02-20 06:00:00	QQQ	ETF	44.68	44.68	44.68	44.68	900.0
2007-02-20 07:00:00	QQQ	ETF	44.69	44.73	44.68	44.73	375600.0
2007-02-20 08:00:00	QQQ	ETF	44.72	44.72	44.69	44.7	1183870.0
2007-02-20 09:00:00	QQQ	ETF	44.69	44.71	44.53	44.61	14052765.0
2007-02-20 10:00:00	QQQ	ETF	44.6	44.72	44.43	44.68	20048700.0
2007-02-20 11:00:00	QQQ	ETF	44.68	45.05	44.68	44.99	16877100.0
2007-02-20 12:00:00	QQQ	ETF	44.99	45.09	44.95	44.98	6981700.0
2007-02-20 13:00:00	QQQ	ETF	44.99	45.05	44.91	45.02	6204400.0
2007-02-20 14:00:00	QQQ	ETF	45.02	45.11	44.97	45.09	6026300.0
2007-02-20 15:00:00	QQQ	ETF	45.08	45.12	45.03	45.05	8615300.0
2007-02-20 16:00:00	QQQ	ETF	45.05	45.09	45.01	45.07	3188781.0
2007-02-20 17:00:00	QQQ	ETF	45.07	45.15	45.06	45.07	488533.0
2007-02-20 18:00:00	QQQ	ETF	45.07	45.07	45.04	45.05	41230.0
2007-02-20 19:00:00	QQQ	ETF	45.04	45.07	45.04	45.05	6500.0
2007-02-20 07:00:00	IWM	ETF	81.1	81.1	81.1	81.1	100.0
2007-02-20 08:00:00	IWM	ETF	81.1	81.13	81.06	81.06	38000.0
2007-02-20 09:00:00	IWM	ETF	81.06	81.08	80.7	80.74	5067400.0
2007-02-20 10:00:00	IWM	ETF	80.75	81.12	80.1	81.08	11215300.0
2007-02-20 11:00:00	IWM	ETF	81.08	81.77	81.08	81.65	13716200.0
2007-02-20 12:00:00	IWM	ETF	81.66	81.92	81.63	81.79	8137400.0
2007-02-20 13:00:00	IWM	ETF	81.8	81.85	81.65	81.82	1817000.0
2007-02-20 14:00:00	IWM	ETF	81.82	82.14	81.68	82.13	7550700.0
2007-02-20 15:00:00	IWM	ETF	82.14	82.16	81.91	82.01	8681400.0
2007-02-20 16:00:00	IWM	ETF	82.01	82.01	81.87	81.92	398200.0
2007-02-20 17:00:00	IWM	ETF	81.92	81.93	81.9	81.93	30700.0
2007-02-20 18:00:00	IWM	ETF	81.91	81.91	81.91	81.91	100.0
2007-02-20 19:00:00	IWM	ETF	81.93	81.93	81.93	81.93	200.0
2007-02-20 07:00:00	DIA	ETF	127.46	127.46	127.46	127.46	1000.0
2007-02-20 08:00:00	DIA	ETF	127.5	127.55	127.45	127.45	11900.0
2007-02-20 09:00:00	DIA	ETF	127.45	127.53	127.16	127.27	1029400.0
2007-02-20 10:00:00	DIA	ETF	127.27	127.28	126.92	127.22	1154100.0
2007-02-20 11:00:00	DIA	ETF	127.22	127.74	127.22	127.68	1283800.0
2007-02-20 12:00:00	DIA	ETF	127.68	127.76	127.61	127.68	386400.0
2007-02-20 13:00:00	DIA	ETF	127.69	127.71	127.52	127.68	480200.0

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

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