PREVIEW / etf_1hour / 2004-09-23

all etf 1-hour files

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

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-23 08:00:00	SPY	ETF	111.53	111.53	111.43	111.5	143600.0
2004-09-23 09:00:00	SPY	ETF	111.52	111.7	111.3	111.34	6585100.0
2004-09-23 10:00:00	SPY	ETF	111.32	111.62	111.19	111.56	11280000.0
2004-09-23 11:00:00	SPY	ETF	111.55	111.59	111.31	111.35	3960700.0
2004-09-23 12:00:00	SPY	ETF	111.35	111.49	111.04	111.1	5499900.0
2004-09-23 13:00:00	SPY	ETF	111.1	111.3	111.07	111.2	2347700.0
2004-09-23 14:00:00	SPY	ETF	111.2	111.55	111.17	111.37	5001200.0
2004-09-23 15:00:00	SPY	ETF	111.37	111.5	111.12	111.14	4437300.0
2004-09-23 16:00:00	SPY	ETF	111.15	111.18	110.95	111.05	3037500.0
2004-09-23 17:00:00	SPY	ETF	111.05	111.08	111.0	111.0	31200.0
2004-09-23 18:00:00	SPY	ETF	111.02	111.1	111.02	111.02	14100.0
2004-09-23 19:00:00	SPY	ETF	111.11	111.15	111.11	111.14	10600.0
2004-09-23 08:00:00	QQQ	ETF	34.93	34.96	34.9	34.93	204700.0
2004-09-23 09:00:00	QQQ	ETF	34.94	35.03	34.877	34.95	13733600.0
2004-09-23 10:00:00	QQQ	ETF	34.95	35.13	34.88	35.11	21071100.0
2004-09-23 11:00:00	QQQ	ETF	35.11	35.14	34.977	35.02	7515600.0
2004-09-23 12:00:00	QQQ	ETF	35.02	35.096	34.882	34.96	10238600.0
2004-09-23 13:00:00	QQQ	ETF	34.96	35.05	34.89	34.97	8229600.0
2004-09-23 14:00:00	QQQ	ETF	34.973	35.15	34.97	35.08	13152800.0
2004-09-23 15:00:00	QQQ	ETF	35.08	35.15	34.98	35.0	13329900.0
2004-09-23 16:00:00	QQQ	ETF	34.991	35.01	34.9	34.93	2999400.0
2004-09-23 17:00:00	QQQ	ETF	34.95	34.95	34.92	34.92	55000.0
2004-09-23 18:00:00	QQQ	ETF	34.93	34.94	34.9	34.9	50300.0
2004-09-23 19:00:00	QQQ	ETF	34.93	34.95	34.93	34.95	16100.0
2004-09-23 09:00:00	IWM	ETF	56.46	56.6	56.3	56.375	1220600.0
2004-09-23 10:00:00	IWM	ETF	56.375	56.71	56.295	56.59	2434200.0
2004-09-23 11:00:00	IWM	ETF	56.59	56.605	56.41	56.49	568800.0
2004-09-23 12:00:00	IWM	ETF	56.49	56.565	56.34	56.37	1001800.0
2004-09-23 13:00:00	IWM	ETF	56.395	56.45	56.295	56.39	1010800.0
2004-09-23 14:00:00	IWM	ETF	56.395	56.685	56.395	56.6	1636000.0
2004-09-23 15:00:00	IWM	ETF	56.6	56.68	56.49	56.495	985400.0
2004-09-23 16:00:00	IWM	ETF	56.485	56.495	56.345	56.395	213000.0
2004-09-23 08:00:00	DIA	ETF	101.0	101.03	101.0	101.03	3800.0
2004-09-23 09:00:00	DIA	ETF	101.03	101.22	100.8	100.86	837300.0
2004-09-23 10:00:00	DIA	ETF	100.84	101.06	100.65	100.9	2203300.0
2004-09-23 11:00:00	DIA	ETF	100.92	100.94	100.73	100.78	197700.0
2004-09-23 12:00:00	DIA	ETF	100.75	100.86	100.46	100.49	939500.0
2004-09-23 13:00:00	DIA	ETF	100.51	100.63	100.45	100.54	454600.0
2004-09-23 14:00:00	DIA	ETF	100.52	100.86	100.52	100.73	1024200.0
2004-09-23 15:00:00	DIA	ETF	100.71	100.84	100.53	100.54	811600.0
2004-09-23 16:00:00	DIA	ETF	100.56	100.58	100.4	100.49	304900.0
2004-09-23 17:00:00	DIA	ETF	100.41	100.49	100.41	100.44	15200.0
2004-09-23 18:00:00	DIA	ETF	100.45	100.45	100.45	100.45	2200.0
2004-09-23 08:00:00	TLT	ETF	89.7	89.75	89.7	89.75	5500.0
2004-09-23 09:00:00	TLT	ETF	89.67	89.85	89.59	89.8	378700.0
2004-09-23 10:00:00	TLT	ETF	89.8	89.85	89.51	89.55	269900.0
2004-09-23 11:00:00	TLT	ETF	89.55	89.68	89.42	89.44	91900.0
2004-09-23 12:00:00	TLT	ETF	89.46	89.64	89.46	89.63	151900.0
2004-09-23 13:00:00	TLT	ETF	89.63	89.88	89.63	89.72	126400.0
2004-09-23 14:00:00	TLT	ETF	89.7	89.7	89.32	89.33	612900.0

> showing 50 of 665 rows — these rows as CSV

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