PREVIEW / etf_1hour / 2004-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-20.parquet
  size:    26 KB
  rows:    698

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-02-20 08:00:00	SPY	ETF	115.31	115.42	115.16	115.3	96900.0
2004-02-20 09:00:00	SPY	ETF	115.31	115.5	114.99	114.99	5829200.0
2004-02-20 10:00:00	SPY	ETF	115.05	115.28	114.5	114.65	7022500.0
2004-02-20 11:00:00	SPY	ETF	114.64	114.89	114.56	114.85	3613100.0
2004-02-20 12:00:00	SPY	ETF	114.79	114.88	114.32	114.4	3698000.0
2004-02-20 13:00:00	SPY	ETF	114.35	114.93	114.35	114.87	5551800.0
2004-02-20 14:00:00	SPY	ETF	114.89	115.48	114.81	115.1	8112100.0
2004-02-20 15:00:00	SPY	ETF	115.09	115.16	114.8	115.0	3961300.0
2004-02-20 16:00:00	SPY	ETF	115.0	115.04	114.74	114.84	2111300.0
2004-02-20 17:00:00	SPY	ETF	114.74	114.9	114.74	114.9	6800.0
2004-02-20 18:00:00	SPY	ETF	114.88	114.88	114.88	114.88	300.0
2004-02-20 19:00:00	SPY	ETF	114.88	114.88	114.88	114.88	400.0
2004-02-20 08:00:00	QQQ	ETF	36.99	37.04	36.92	36.99	227700.0
2004-02-20 09:00:00	QQQ	ETF	36.99	37.06	36.7	36.775	17733900.0
2004-02-20 10:00:00	QQQ	ETF	36.771	36.99	36.56	36.63	23631800.0
2004-02-20 11:00:00	QQQ	ETF	36.65	36.83	36.62	36.8	11456500.0
2004-02-20 12:00:00	QQQ	ETF	36.79	36.81	36.56	36.58	7247100.0
2004-02-20 13:00:00	QQQ	ETF	36.59	36.9	36.55	36.841	17216500.0
2004-02-20 14:00:00	QQQ	ETF	36.832	37.14	36.79	36.96	22831200.0
2004-02-20 15:00:00	QQQ	ETF	36.95	36.98	36.82	36.91	16886900.0
2004-02-20 16:00:00	QQQ	ETF	36.91	36.94	36.85	36.92	5108100.0
2004-02-20 17:00:00	QQQ	ETF	36.9	36.92	36.89	36.9	29600.0
2004-02-20 18:00:00	QQQ	ETF	36.91	36.93	36.87	36.88	22300.0
2004-02-20 19:00:00	QQQ	ETF	36.87	36.92	36.87	36.9	13100.0
2004-02-20 08:00:00	IWM	ETF	58.0	58.0	57.85	57.85	25200.0
2004-02-20 09:00:00	IWM	ETF	58.025	58.075	57.535	57.605	1006800.0
2004-02-20 10:00:00	IWM	ETF	57.56	57.825	57.3	57.3315	2140600.0
2004-02-20 11:00:00	IWM	ETF	57.325	57.725	57.3	57.685	698600.0
2004-02-20 12:00:00	IWM	ETF	57.66	57.71	57.2905	57.32	996400.0
2004-02-20 13:00:00	IWM	ETF	57.33	57.76	57.28	57.705	1216600.0
2004-02-20 14:00:00	IWM	ETF	57.7	58.25	57.7	58.045	1278200.0
2004-02-20 15:00:00	IWM	ETF	58.035	58.06	57.77	57.8	1705400.0
2004-02-20 16:00:00	IWM	ETF	57.795	57.8	57.665	57.665	999800.0
2004-02-20 08:00:00	DIA	ETF	106.95	107.16	106.75	106.89	18000.0
2004-02-20 09:00:00	DIA	ETF	106.86	107.0	106.64	106.69	947600.0
2004-02-20 10:00:00	DIA	ETF	106.703	106.83	106.149	106.26	1858900.0
2004-02-20 11:00:00	DIA	ETF	106.26	106.453	106.15	106.4	1272100.0
2004-02-20 12:00:00	DIA	ETF	106.4	106.4	105.95	106.0	643100.0
2004-02-20 13:00:00	DIA	ETF	105.99	106.39	105.94	106.34	591400.0
2004-02-20 14:00:00	DIA	ETF	106.35	106.83	106.27	106.54	770100.0
2004-02-20 15:00:00	DIA	ETF	106.53	106.58	106.285	106.4	1277400.0
2004-02-20 16:00:00	DIA	ETF	106.395	106.44	106.32	106.4	99900.0
2004-02-20 17:00:00	DIA	ETF	106.35	106.4	106.35	106.4	1100.0
2004-02-20 18:00:00	DIA	ETF	106.35	106.4	106.35	106.4	4000.0
2004-02-20 19:00:00	DIA	ETF	106.4	106.4	106.4	106.4	700.0
2004-02-20 09:00:00	TLT	ETF	87.75	87.83	87.53	87.55	53100.0
2004-02-20 10:00:00	TLT	ETF	87.55	87.57	87.22	87.34	387700.0
2004-02-20 11:00:00	TLT	ETF	87.37	87.43	87.29	87.43	79100.0
2004-02-20 12:00:00	TLT	ETF	87.44	87.45	87.33	87.33	22500.0
2004-02-20 13:00:00	TLT	ETF	87.32	87.4	87.2	87.21	43500.0

> showing 50 of 698 rows — these rows as CSV

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