PREVIEW / etf_1hour / 2007-02-15

all etf 1-hour files

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

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-15 05:00:00	SPY	ETF	145.56	145.56	145.56	145.56	100.0
2007-02-15 07:00:00	SPY	ETF	145.68	145.68	145.61	145.62	68900.0
2007-02-15 08:00:00	SPY	ETF	145.62	145.73	145.45	145.71	388400.0
2007-02-15 09:00:00	SPY	ETF	145.71	145.79	145.48	145.68	4035500.0
2007-02-15 10:00:00	SPY	ETF	145.68	145.85	145.43	145.48	7715600.0
2007-02-15 11:00:00	SPY	ETF	145.48	145.78	145.46	145.78	4337300.0
2007-02-15 12:00:00	SPY	ETF	145.77	145.79	145.52	145.69	3844900.0
2007-02-15 13:00:00	SPY	ETF	145.69	145.81	145.64	145.79	2671300.0
2007-02-15 14:00:00	SPY	ETF	145.79	145.91	145.73	145.84	3986500.0
2007-02-15 15:00:00	SPY	ETF	145.84	145.95	145.71	145.83	8829500.0
2007-02-15 16:00:00	SPY	ETF	145.83	145.85	145.54	145.62	1066700.0
2007-02-15 17:00:00	SPY	ETF	145.67	145.72	145.6	145.68	550700.0
2007-02-15 18:00:00	SPY	ETF	145.68	145.68	145.67	145.67	10500.0
2007-02-15 19:00:00	SPY	ETF	145.61	145.61	145.55	145.55	5100.0
2007-02-15 04:00:00	QQQ	ETF	44.61	44.61	44.61	44.61	200.0
2007-02-15 06:00:00	QQQ	ETF	44.57	44.57	44.57	44.57	1000.0
2007-02-15 07:00:00	QQQ	ETF	44.57	44.61	44.57	44.6	568772.0
2007-02-15 08:00:00	QQQ	ETF	44.59	44.64	44.53	44.63	1546154.0
2007-02-15 09:00:00	QQQ	ETF	44.63	44.72	44.55	44.71	12249129.0
2007-02-15 10:00:00	QQQ	ETF	44.72	44.84	44.6	44.62	24670200.0
2007-02-15 11:00:00	QQQ	ETF	44.62	44.74	44.61	44.73	10608500.0
2007-02-15 12:00:00	QQQ	ETF	44.73	44.77	44.6	44.68	12503300.0
2007-02-15 13:00:00	QQQ	ETF	44.69	44.72	44.67	44.71	5425500.0
2007-02-15 14:00:00	QQQ	ETF	44.72	44.81	44.68	44.79	8689800.0
2007-02-15 15:00:00	QQQ	ETF	44.79	44.85	44.73	44.81	13394100.0
2007-02-15 16:00:00	QQQ	ETF	44.81	44.86	44.7	44.76	5194308.0
2007-02-15 17:00:00	QQQ	ETF	44.77	44.8	44.76	44.77	1195158.0
2007-02-15 18:00:00	QQQ	ETF	44.78	44.79	44.76	44.76	35077.0
2007-02-15 19:00:00	QQQ	ETF	44.78	44.79	44.75	44.75	16514.0
2007-02-15 08:00:00	IWM	ETF	80.73	80.76	80.6	80.76	207300.0
2007-02-15 09:00:00	IWM	ETF	80.75	80.84	80.56	80.75	4306400.0
2007-02-15 10:00:00	IWM	ETF	80.74	80.85	80.61	80.65	6962200.0
2007-02-15 11:00:00	IWM	ETF	80.64	80.98	80.61	80.96	4644100.0
2007-02-15 12:00:00	IWM	ETF	80.96	81.06	80.8	81.04	3153600.0
2007-02-15 13:00:00	IWM	ETF	81.04	81.09	80.95	81.08	2038600.0
2007-02-15 14:00:00	IWM	ETF	81.08	81.19	81.01	81.08	2422600.0
2007-02-15 15:00:00	IWM	ETF	81.08	81.11	80.89	80.89	15647900.0
2007-02-15 16:00:00	IWM	ETF	80.89	80.89	80.67	80.76	814000.0
2007-02-15 17:00:00	IWM	ETF	80.74	80.75	80.72	80.72	6100.0
2007-02-15 18:00:00	IWM	ETF	80.71	80.71	80.69	80.7	15000.0
2007-02-15 19:00:00	IWM	ETF	80.7	80.7	80.62	80.62	1300.0
2007-02-15 07:00:00	DIA	ETF	127.57	127.57	127.57	127.57	200.0
2007-02-15 08:00:00	DIA	ETF	127.59	127.7	127.56	127.68	24900.0
2007-02-15 09:00:00	DIA	ETF	127.68	127.7	127.53	127.7	477300.0
2007-02-15 10:00:00	DIA	ETF	127.71	127.79	127.49	127.52	1100800.0
2007-02-15 11:00:00	DIA	ETF	127.5	127.76	127.5	127.75	578100.0
2007-02-15 12:00:00	DIA	ETF	127.75	127.76	127.53	127.73	1219400.0
2007-02-15 13:00:00	DIA	ETF	127.74	127.82	127.64	127.78	842300.0
2007-02-15 14:00:00	DIA	ETF	127.78	127.9	127.75	127.81	897300.0
2007-02-15 15:00:00	DIA	ETF	127.82	127.86	127.69	127.77	689100.0

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

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