PREVIEW / etf_1hour / 2004-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-26.parquet
  size:    24 KB
  rows:    649

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-01-26 08:00:00	SPY	ETF	114.31	114.35	114.27	114.29	22400.0
2004-01-26 09:00:00	SPY	ETF	114.31	114.78	114.31	114.67	4419800.0
2004-01-26 10:00:00	SPY	ETF	114.67	114.8	114.43	114.7	4085200.0
2004-01-26 11:00:00	SPY	ETF	114.71	114.79	114.4	114.61	4108600.0
2004-01-26 12:00:00	SPY	ETF	114.61	114.75	114.47	114.67	1074500.0
2004-01-26 13:00:00	SPY	ETF	114.67	114.87	114.61	114.69	1930800.0
2004-01-26 14:00:00	SPY	ETF	114.69	115.32	114.68	115.32	3730200.0
2004-01-26 15:00:00	SPY	ETF	115.32	115.91	115.28	115.8	7239000.0
2004-01-26 16:00:00	SPY	ETF	115.81	115.94	115.68	115.74	1551700.0
2004-01-26 17:00:00	SPY	ETF	115.71	115.76	115.7	115.73	16900.0
2004-01-26 18:00:00	SPY	ETF	115.74	115.8	115.74	115.8	4100.0
2004-01-26 08:00:00	QQQ	ETF	37.97	37.98	37.91	37.94	99200.0
2004-01-26 09:00:00	QQQ	ETF	37.94	38.14	37.93	38.05	12430900.0
2004-01-26 10:00:00	QQQ	ETF	38.05	38.08	37.84	37.99	14235200.0
2004-01-26 11:00:00	QQQ	ETF	37.99	38.051	37.9	37.97	7351700.0
2004-01-26 12:00:00	QQQ	ETF	37.96	38.04	37.9	37.989	4818200.0
2004-01-26 13:00:00	QQQ	ETF	38.0	38.1	37.96	38.04	6800600.0
2004-01-26 14:00:00	QQQ	ETF	38.04	38.36	38.04	38.34	13058400.0
2004-01-26 15:00:00	QQQ	ETF	38.35	38.61	38.34	38.57	15896400.0
2004-01-26 16:00:00	QQQ	ETF	38.56	38.66	38.4	38.435	5055200.0
2004-01-26 17:00:00	QQQ	ETF	38.43	38.44	38.388	38.44	775100.0
2004-01-26 18:00:00	QQQ	ETF	38.44	38.49	38.43	38.48	62700.0
2004-01-26 19:00:00	QQQ	ETF	38.48	38.49	38.47	38.49	23500.0
2004-01-26 09:00:00	IWM	ETF	59.35	59.45	59.2175	59.275	445800.0
2004-01-26 10:00:00	IWM	ETF	59.3	59.33	58.955	59.15	817400.0
2004-01-26 11:00:00	IWM	ETF	59.125	59.175	59.015	59.125	702000.0
2004-01-26 12:00:00	IWM	ETF	59.125	59.295	59.125	59.21	187200.0
2004-01-26 13:00:00	IWM	ETF	59.22	59.245	59.13	59.13	315200.0
2004-01-26 14:00:00	IWM	ETF	59.115	59.575	59.115	59.5	778600.0
2004-01-26 15:00:00	IWM	ETF	59.49	59.935	59.485	59.935	1438400.0
2004-01-26 16:00:00	IWM	ETF	59.9555	60.04	59.935	59.95	188000.0
2004-01-26 17:00:00	IWM	ETF	59.9	59.9	59.845	59.845	15800.0
2004-01-26 08:00:00	DIA	ETF	105.8	105.83	105.76	105.76	6200.0
2004-01-26 09:00:00	DIA	ETF	105.73	106.09	105.72	106.0	968800.0
2004-01-26 10:00:00	DIA	ETF	106.0	106.27	105.8	106.243	951100.0
2004-01-26 11:00:00	DIA	ETF	106.25	106.27	105.94	106.13	586200.0
2004-01-26 12:00:00	DIA	ETF	106.14	106.2	105.98	106.12	220300.0
2004-01-26 13:00:00	DIA	ETF	106.15	106.25	106.07	106.15	250400.0
2004-01-26 14:00:00	DIA	ETF	106.14	106.76	106.14	106.73	1396700.0
2004-01-26 15:00:00	DIA	ETF	106.81	107.2	106.68	107.13	1846300.0
2004-01-26 16:00:00	DIA	ETF	107.13	107.23	107.063	107.063	705100.0
2004-01-26 17:00:00	DIA	ETF	107.09	107.09	107.02	107.03	6600.0
2004-01-26 18:00:00	DIA	ETF	107.05	107.05	106.98	107.03	3600.0
2004-01-26 09:00:00	TLT	ETF	87.3	87.36	87.23	87.28	38400.0
2004-01-26 10:00:00	TLT	ETF	87.21	87.36	87.12	87.12	87800.0
2004-01-26 11:00:00	TLT	ETF	87.1	87.19	87.0	87.15	114800.0
2004-01-26 12:00:00	TLT	ETF	87.15	87.19	87.02	87.16	35200.0
2004-01-26 13:00:00	TLT	ETF	87.19	87.19	86.76	86.86	94800.0
2004-01-26 14:00:00	TLT	ETF	86.84	86.88	86.67	86.75	58800.0
2004-01-26 15:00:00	TLT	ETF	86.75	86.9	86.74	86.79	203500.0

> showing 50 of 649 rows — these rows as CSV

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