PREVIEW / etf_1hour / 2004-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-09.parquet
  size:    26 KB
  rows:    749

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-11-09 08:00:00	SPY	ETF	116.92	116.96	116.87	116.88	47000.0
2004-11-09 09:00:00	SPY	ETF	116.92	117.48	116.9	117.46	6041400.0
2004-11-09 10:00:00	SPY	ETF	117.47	117.5	116.97	117.04	6270700.0
2004-11-09 11:00:00	SPY	ETF	117.04	117.1	116.76	116.88	6457300.0
2004-11-09 12:00:00	SPY	ETF	116.89	117.02	116.81	116.97	3735900.0
2004-11-09 13:00:00	SPY	ETF	116.97	117.15	116.96	117.15	4064300.0
2004-11-09 14:00:00	SPY	ETF	117.14	117.44	117.12	117.25	7533400.0
2004-11-09 15:00:00	SPY	ETF	117.25	117.26	116.88	117.0	6156000.0
2004-11-09 16:00:00	SPY	ETF	116.99	117.05	116.82	117.04	1530400.0
2004-11-09 17:00:00	SPY	ETF	117.02	117.08	116.91	117.0	53300.0
2004-11-09 18:00:00	SPY	ETF	117.03	117.03	116.91	116.91	27800.0
2004-11-09 19:00:00	SPY	ETF	116.98	117.03	116.98	117.02	7600.0
2004-11-09 08:00:00	QQQ	ETF	37.93	37.94	37.92	37.92	76700.0
2004-11-09 09:00:00	QQQ	ETF	37.93	38.13	37.9	38.089	16395000.0
2004-11-09 10:00:00	QQQ	ETF	38.08	38.083	37.88	37.9	13030300.0
2004-11-09 11:00:00	QQQ	ETF	37.904	37.94	37.81	37.867	10454500.0
2004-11-09 12:00:00	QQQ	ETF	37.86	37.98	37.85	37.949	5050500.0
2004-11-09 13:00:00	QQQ	ETF	37.949	38.02	37.92	38.01	3913400.0
2004-11-09 14:00:00	QQQ	ETF	38.01	38.15	38.007	38.09	14157000.0
2004-11-09 15:00:00	QQQ	ETF	38.09	38.12	37.93	37.997	16450000.0
2004-11-09 16:00:00	QQQ	ETF	38.0	38.02	37.86	37.93	4486700.0
2004-11-09 17:00:00	QQQ	ETF	37.91	37.99	37.856	37.9	676600.0
2004-11-09 18:00:00	QQQ	ETF	37.9	37.9	37.88	37.89	25600.0
2004-11-09 19:00:00	QQQ	ETF	37.89	37.95	37.89	37.95	23000.0
2004-11-09 09:00:00	IWM	ETF	60.075	60.34	60.0	60.33	1364400.0
2004-11-09 10:00:00	IWM	ETF	60.315	60.315	60.055	60.115	1003800.0
2004-11-09 11:00:00	IWM	ETF	60.115	60.15	60.04	60.11	415800.0
2004-11-09 12:00:00	IWM	ETF	60.13	60.215	60.11	60.17	515000.0
2004-11-09 13:00:00	IWM	ETF	60.18	60.35	60.14	60.35	360800.0
2004-11-09 14:00:00	IWM	ETF	60.353	60.575	60.33	60.5	1171000.0
2004-11-09 15:00:00	IWM	ETF	60.49	60.525	60.33	60.455	1288400.0
2004-11-09 16:00:00	IWM	ETF	60.43	60.49	60.255	60.275	287200.0
2004-11-09 17:00:00	IWM	ETF	60.36	60.36	60.36	60.36	200.0
2004-11-09 08:00:00	DIA	ETF	104.11	104.12	104.07	104.07	5100.0
2004-11-09 09:00:00	DIA	ETF	104.04	104.58	104.04	104.55	1096500.0
2004-11-09 10:00:00	DIA	ETF	104.56	104.58	104.12	104.17	1147800.0
2004-11-09 11:00:00	DIA	ETF	104.18	104.21	103.97	104.06	742600.0
2004-11-09 12:00:00	DIA	ETF	104.07	104.18	104.0	104.14	341500.0
2004-11-09 13:00:00	DIA	ETF	104.15	104.27	104.12	104.27	185200.0
2004-11-09 14:00:00	DIA	ETF	104.27	104.57	104.27	104.41	1721200.0
2004-11-09 15:00:00	DIA	ETF	104.41	104.42	104.13	104.22	545300.0
2004-11-09 16:00:00	DIA	ETF	104.23	104.27	104.15	104.25	248700.0
2004-11-09 17:00:00	DIA	ETF	104.18	104.3	104.14	104.14	2000.0
2004-11-09 09:00:00	TLT	ETF	87.5	87.5	87.4	87.43	44700.0
2004-11-09 10:00:00	TLT	ETF	87.45	87.52	87.41	87.46	148100.0
2004-11-09 11:00:00	TLT	ETF	87.46	87.6	87.45	87.59	34500.0
2004-11-09 12:00:00	TLT	ETF	87.6	87.65	87.58	87.58	18000.0
2004-11-09 13:00:00	TLT	ETF	87.66	87.7285	87.51	87.51	10600.0
2004-11-09 14:00:00	TLT	ETF	87.5	87.54	87.42	87.42	11600.0
2004-11-09 15:00:00	TLT	ETF	87.42	87.5	87.42	87.42	73400.0

> showing 50 of 749 rows — these rows as CSV

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