PREVIEW / etf_1hour / 2004-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-02.parquet
  size:    25 KB
  rows:    695

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-06-02 08:00:00	SPY	ETF	113.1	113.2	113.05	113.17	58000.0
2004-06-02 09:00:00	SPY	ETF	113.15	113.15	112.73	112.87	3874000.0
2004-06-02 10:00:00	SPY	ETF	112.86	112.91	112.55	112.66	6442200.0
2004-06-02 11:00:00	SPY	ETF	112.66	112.72	112.46	112.53	4622800.0
2004-06-02 12:00:00	SPY	ETF	112.54	112.82	112.47	112.61	2293700.0
2004-06-02 13:00:00	SPY	ETF	112.61	112.91	112.59	112.88	2877700.0
2004-06-02 14:00:00	SPY	ETF	112.88	113.48	112.82	113.28	7439300.0
2004-06-02 15:00:00	SPY	ETF	113.28	113.38	113.05	113.12	6151400.0
2004-06-02 16:00:00	SPY	ETF	113.11	113.21	113.03	113.17	4454300.0
2004-06-02 17:00:00	SPY	ETF	113.18	113.2	113.16	113.17	16900.0
2004-06-02 18:00:00	SPY	ETF	113.17	113.17	113.13	113.13	4500.0
2004-06-02 19:00:00	SPY	ETF	113.06	113.06	113.05	113.05	1600.0
2004-06-02 08:00:00	QQQ	ETF	36.66	36.68	36.63	36.66	174800.0
2004-06-02 09:00:00	QQQ	ETF	36.66	36.66	36.34	36.39	14679300.0
2004-06-02 10:00:00	QQQ	ETF	36.39	36.44	36.21	36.28	15616200.0
2004-06-02 11:00:00	QQQ	ETF	36.28	36.29	36.17	36.2	7852100.0
2004-06-02 12:00:00	QQQ	ETF	36.21	36.38	36.18	36.288	7393400.0
2004-06-02 13:00:00	QQQ	ETF	36.29	36.45	36.28	36.41	8336400.0
2004-06-02 14:00:00	QQQ	ETF	36.41	36.66	36.33	36.561	21955400.0
2004-06-02 15:00:00	QQQ	ETF	36.56	36.6	36.38	36.39	17288200.0
2004-06-02 16:00:00	QQQ	ETF	36.4	36.63	36.36	36.43	2691400.0
2004-06-02 17:00:00	QQQ	ETF	36.44	36.44	36.42	36.42	33400.0
2004-06-02 18:00:00	QQQ	ETF	36.42	36.44	36.41	36.42	11800.0
2004-06-02 19:00:00	QQQ	ETF	36.43	36.44	36.42	36.42	14900.0
2004-06-02 08:00:00	IWM	ETF	57.46	57.47	57.4	57.46	9200.0
2004-06-02 09:00:00	IWM	ETF	57.46	57.46	57.115	57.23	1867200.0
2004-06-02 10:00:00	IWM	ETF	57.235	57.27	56.89	57.025	2308200.0
2004-06-02 11:00:00	IWM	ETF	57.03	57.035	56.885	56.915	801000.0
2004-06-02 12:00:00	IWM	ETF	56.925	57.105	56.89	56.985	387400.0
2004-06-02 13:00:00	IWM	ETF	56.97	57.135	56.965	57.12	643400.0
2004-06-02 14:00:00	IWM	ETF	57.11	57.375	57.085	57.265	1224400.0
2004-06-02 15:00:00	IWM	ETF	57.255	57.3	57.125	57.125	1616000.0
2004-06-02 16:00:00	IWM	ETF	57.13	57.275	57.1	57.1	2172000.0
2004-06-02 08:00:00	DIA	ETF	102.45	102.6	102.45	102.59	6200.0
2004-06-02 09:00:00	DIA	ETF	102.6	102.6	102.3	102.39	625000.0
2004-06-02 10:00:00	DIA	ETF	102.39	102.43	102.11	102.29	979100.0
2004-06-02 11:00:00	DIA	ETF	102.3	102.3	102.09	102.13	451900.0
2004-06-02 12:00:00	DIA	ETF	102.19	102.39	102.11	102.24	262300.0
2004-06-02 13:00:00	DIA	ETF	102.24	102.52	102.24	102.49	891600.0
2004-06-02 14:00:00	DIA	ETF	102.5	103.04	102.46	102.86	1103100.0
2004-06-02 15:00:00	DIA	ETF	102.88	102.94	102.65	102.77	911700.0
2004-06-02 16:00:00	DIA	ETF	102.77	102.85	102.63	102.85	148900.0
2004-06-02 17:00:00	DIA	ETF	102.85	102.89	102.85	102.86	5200.0
2004-06-02 19:00:00	DIA	ETF	102.81	102.81	102.81	102.81	200.0
2004-06-02 09:00:00	TLT	ETF	82.02	82.02	81.96	81.98	256400.0
2004-06-02 10:00:00	TLT	ETF	82.0	82.0	81.76	81.79	70100.0
2004-06-02 11:00:00	TLT	ETF	81.84	82.0	81.81	81.92	283400.0
2004-06-02 12:00:00	TLT	ETF	81.9	82.06	81.85	81.99	27600.0
2004-06-02 13:00:00	TLT	ETF	82.01	82.13	81.85	81.88	75200.0
2004-06-02 14:00:00	TLT	ETF	81.86	81.94	81.8	81.9	131900.0

> showing 50 of 695 rows — these rows as CSV

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