PREVIEW / etf_1hour / 2004-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-24.parquet
  size:    23 KB
  rows:    652

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
2004-09-24 08:00:00	SPY	ETF	111.09	111.16	111.01	111.06	221100.0
2004-09-24 09:00:00	SPY	ETF	111.07	111.48	111.07	111.41	4499400.0
2004-09-24 10:00:00	SPY	ETF	111.4	111.52	111.27	111.5	4964500.0
2004-09-24 11:00:00	SPY	ETF	111.5	111.64	111.38	111.4	7454200.0
2004-09-24 12:00:00	SPY	ETF	111.4	111.46	111.26	111.42	3403300.0
2004-09-24 13:00:00	SPY	ETF	111.42	111.73	111.36	111.62	3548300.0
2004-09-24 14:00:00	SPY	ETF	111.62	111.72	111.33	111.4	3738000.0
2004-09-24 15:00:00	SPY	ETF	111.41	111.57	111.24	111.34	5237100.0
2004-09-24 16:00:00	SPY	ETF	111.35	111.52	111.3	111.42	1275400.0
2004-09-24 17:00:00	SPY	ETF	111.42	111.5	111.4	111.5	4500.0
2004-09-24 18:00:00	SPY	ETF	111.48	111.5	111.48	111.5	600.0
2004-09-24 19:00:00	SPY	ETF	111.48	111.48	111.48	111.48	200.0
2004-09-24 08:00:00	QQQ	ETF	34.92	34.96	34.9	34.92	218800.0
2004-09-24 09:00:00	QQQ	ETF	34.93	35.12	34.93	35.1	11326600.0
2004-09-24 10:00:00	QQQ	ETF	35.1	35.13	34.99	35.119	14487800.0
2004-09-24 11:00:00	QQQ	ETF	35.12	35.19	34.98	34.987	12221100.0
2004-09-24 12:00:00	QQQ	ETF	34.985	34.99	34.75	34.88	19117200.0
2004-09-24 13:00:00	QQQ	ETF	34.879	35.12	34.84	35.02	14904900.0
2004-09-24 14:00:00	QQQ	ETF	35.02	35.05	34.81	34.817	10820400.0
2004-09-24 15:00:00	QQQ	ETF	34.819	34.91	34.76	34.8	16725500.0
2004-09-24 16:00:00	QQQ	ETF	34.8	34.856	34.78	34.85	1797000.0
2004-09-24 17:00:00	QQQ	ETF	34.83	34.85	34.83	34.85	13800.0
2004-09-24 18:00:00	QQQ	ETF	34.84	34.85	34.84	34.85	12300.0
2004-09-24 19:00:00	QQQ	ETF	34.87	34.9	34.85	34.85	7600.0
2004-09-24 08:00:00	IWM	ETF	56.305	56.365	56.3	56.3	8200.0
2004-09-24 09:00:00	IWM	ETF	56.3	56.65	56.3	56.55	2246400.0
2004-09-24 10:00:00	IWM	ETF	56.55	56.6	56.41	56.6	1379400.0
2004-09-24 11:00:00	IWM	ETF	56.59	56.795	56.505	56.54	2117200.0
2004-09-24 12:00:00	IWM	ETF	56.54	56.565	56.415	56.47	1393000.0
2004-09-24 13:00:00	IWM	ETF	56.485	56.65	56.46	56.605	502000.0
2004-09-24 14:00:00	IWM	ETF	56.595	56.63	56.47	56.485	732000.0
2004-09-24 15:00:00	IWM	ETF	56.475	56.5	56.325	56.35	1505000.0
2004-09-24 16:00:00	IWM	ETF	56.35	56.475	56.29	56.475	331200.0
2004-09-24 08:00:00	DIA	ETF	100.5	100.51	100.42	100.44	9600.0
2004-09-24 09:00:00	DIA	ETF	100.46	100.77	100.45	100.71	757800.0
2004-09-24 10:00:00	DIA	ETF	100.7	100.77	100.55	100.77	504900.0
2004-09-24 11:00:00	DIA	ETF	100.77	100.84	100.64	100.65	575600.0
2004-09-24 12:00:00	DIA	ETF	100.65	100.76	100.59	100.7	607600.0
2004-09-24 13:00:00	DIA	ETF	100.71	100.94	100.67	100.88	771600.0
2004-09-24 14:00:00	DIA	ETF	100.88	100.94	100.6	100.65	905800.0
2004-09-24 15:00:00	DIA	ETF	100.65	100.81	100.53	100.61	1259600.0
2004-09-24 16:00:00	DIA	ETF	100.63	100.72	100.6	100.69	91100.0
2004-09-24 17:00:00	DIA	ETF	100.64	100.71	100.64	100.71	700.0
2004-09-24 19:00:00	DIA	ETF	100.7	100.7	100.7	100.7	600.0
2004-09-24 08:00:00	TLT	ETF	89.36	89.4	89.36	89.4	200.0
2004-09-24 09:00:00	TLT	ETF	89.35	89.35	89.16	89.19	442700.0
2004-09-24 10:00:00	TLT	ETF	89.2	89.35	89.1	89.11	242100.0
2004-09-24 11:00:00	TLT	ETF	89.11	89.24	89.11	89.2	595800.0
2004-09-24 12:00:00	TLT	ETF	89.25	89.3	89.18	89.22	231000.0
2004-09-24 13:00:00	TLT	ETF	89.28	89.49	89.27	89.3	128600.0

> showing 50 of 652 rows — these rows as CSV

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