PREVIEW / etf_1hour / 2004-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-28.parquet
  size:    26 KB
  rows:    748

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-10-28 08:00:00	SPY	ETF	112.63	112.77	112.52	112.75	502800.0
2004-10-28 09:00:00	SPY	ETF	112.72	112.9	112.52	112.81	6436700.0
2004-10-28 10:00:00	SPY	ETF	112.8	112.93	112.49	112.86	9985900.0
2004-10-28 11:00:00	SPY	ETF	112.86	113.18	112.67	112.97	9482500.0
2004-10-28 12:00:00	SPY	ETF	112.99	113.1	112.8	113.07	3570800.0
2004-10-28 13:00:00	SPY	ETF	113.07	113.3	112.96	113.24	4519900.0
2004-10-28 14:00:00	SPY	ETF	113.25	113.56	113.18	113.26	7469100.0
2004-10-28 15:00:00	SPY	ETF	113.26	113.33	112.91	113.17	8936800.0
2004-10-28 16:00:00	SPY	ETF	113.17	113.25	113.15	113.22	1911500.0
2004-10-28 17:00:00	SPY	ETF	113.22	113.22	113.15	113.16	35500.0
2004-10-28 18:00:00	SPY	ETF	113.2	113.21	113.2	113.2	12500.0
2004-10-28 19:00:00	SPY	ETF	113.18	113.18	113.18	113.18	1000.0
2004-10-28 08:00:00	QQQ	ETF	36.6	36.71	36.6	36.69	565500.0
2004-10-28 09:00:00	QQQ	ETF	36.69	36.83	36.57	36.807	17602300.0
2004-10-28 10:00:00	QQQ	ETF	36.8	36.84	36.6	36.84	16671600.0
2004-10-28 11:00:00	QQQ	ETF	36.835	36.94	36.7	36.76	15833900.0
2004-10-28 12:00:00	QQQ	ETF	36.76	36.82	36.63	36.808	7904900.0
2004-10-28 13:00:00	QQQ	ETF	36.808	36.92	36.74	36.89	10623200.0
2004-10-28 14:00:00	QQQ	ETF	36.9	37.12	36.87	36.971	16142300.0
2004-10-28 15:00:00	QQQ	ETF	36.97	37.0	36.78	36.93	20034600.0
2004-10-28 16:00:00	QQQ	ETF	36.93	36.98	36.89	36.96	2690500.0
2004-10-28 17:00:00	QQQ	ETF	36.97	36.98	36.95	36.98	30800.0
2004-10-28 18:00:00	QQQ	ETF	36.98	36.98	36.96	36.97	30300.0
2004-10-28 19:00:00	QQQ	ETF	36.97	36.98	36.96	36.96	12100.0
2004-10-28 08:00:00	IWM	ETF	58.21	58.21	58.2	58.2	2800.0
2004-10-28 09:00:00	IWM	ETF	58.25	58.485	58.22	58.275	1952000.0
2004-10-28 10:00:00	IWM	ETF	58.26	58.375	57.925	58.18	1854000.0
2004-10-28 11:00:00	IWM	ETF	58.175	58.285	58.0	58.175	740800.0
2004-10-28 12:00:00	IWM	ETF	58.2	58.29	58.11	58.26	974200.0
2004-10-28 13:00:00	IWM	ETF	58.255	58.46	58.175	58.375	870600.0
2004-10-28 14:00:00	IWM	ETF	58.37	58.54	58.275	58.37	1454400.0
2004-10-28 15:00:00	IWM	ETF	58.38	58.475	58.1	58.32	2089000.0
2004-10-28 16:00:00	IWM	ETF	58.32	58.32	58.2	58.26	482600.0
2004-10-28 18:00:00	IWM	ETF	58.225	58.225	58.225	58.225	2000.0
2004-10-28 08:00:00	DIA	ETF	99.96	100.02	99.86	99.96	14900.0
2004-10-28 09:00:00	DIA	ETF	99.96	100.03	99.75	99.91	966900.0
2004-10-28 10:00:00	DIA	ETF	99.9	100.04	99.73	100.04	1173400.0
2004-10-28 11:00:00	DIA	ETF	100.02	100.28	99.86	100.17	1250000.0
2004-10-28 12:00:00	DIA	ETF	100.17	100.25	100.06	100.21	611300.0
2004-10-28 13:00:00	DIA	ETF	100.21	100.41	100.16	100.36	634700.0
2004-10-28 14:00:00	DIA	ETF	100.36	100.65	100.32	100.41	1011000.0
2004-10-28 15:00:00	DIA	ETF	100.42	100.45	100.04	100.22	1925100.0
2004-10-28 16:00:00	DIA	ETF	100.22	100.29	100.22	100.27	69500.0
2004-10-28 19:00:00	DIA	ETF	100.15	100.15	100.15	100.15	500.0
2004-10-28 08:00:00	TLT	ETF	88.56	88.6	88.55	88.6	68300.0
2004-10-28 09:00:00	TLT	ETF	88.52	88.78	88.52	88.62	58300.0
2004-10-28 10:00:00	TLT	ETF	88.64	88.85	88.52	88.79	149500.0
2004-10-28 11:00:00	TLT	ETF	88.79	88.95	88.78	88.93	34300.0
2004-10-28 12:00:00	TLT	ETF	88.93	89.16	88.93	89.08	286100.0
2004-10-28 13:00:00	TLT	ETF	89.07	89.08	88.85	88.86	31600.0

> showing 50 of 748 rows — these rows as CSV

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