PREVIEW / etf_1hour / 2004-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-02.parquet
  size:    24 KB
  rows:    687

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-02 08:00:00	SPY	ETF	111.25	111.32	111.16	111.2	121800.0
2004-09-02 09:00:00	SPY	ETF	111.25	111.46	111.22	111.36	2866400.0
2004-09-02 10:00:00	SPY	ETF	111.36	111.58	111.36	111.55	5389900.0
2004-09-02 11:00:00	SPY	ETF	111.56	111.6	111.32	111.41	2934600.0
2004-09-02 12:00:00	SPY	ETF	111.4	111.49	111.35	111.43	1194400.0
2004-09-02 13:00:00	SPY	ETF	111.43	111.56	111.39	111.54	1111300.0
2004-09-02 14:00:00	SPY	ETF	111.55	112.26	111.51	112.25	9994100.0
2004-09-02 15:00:00	SPY	ETF	112.22	112.66	112.2	112.55	13539400.0
2004-09-02 16:00:00	SPY	ETF	112.52	112.68	112.05	112.28	3737200.0
2004-09-02 17:00:00	SPY	ETF	112.28	112.35	112.24	112.24	174200.0
2004-09-02 18:00:00	SPY	ETF	112.28	112.33	112.28	112.3	5600.0
2004-09-02 19:00:00	SPY	ETF	112.27	112.31	112.27	112.31	5700.0
2004-09-02 08:00:00	QQQ	ETF	34.25	34.25	34.17	34.19	106700.0
2004-09-02 09:00:00	QQQ	ETF	34.2	34.31	34.16	34.28	9946600.0
2004-09-02 10:00:00	QQQ	ETF	34.279	34.45	34.27	34.448	11826800.0
2004-09-02 11:00:00	QQQ	ETF	34.449	34.48	34.36	34.41	7782900.0
2004-09-02 12:00:00	QQQ	ETF	34.42	34.45	34.38	34.41	3908500.0
2004-09-02 13:00:00	QQQ	ETF	34.41	34.44	34.37	34.42	2986100.0
2004-09-02 14:00:00	QQQ	ETF	34.412	34.71	34.41	34.71	15033300.0
2004-09-02 15:00:00	QQQ	ETF	34.71	34.88	34.69	34.75	19372000.0
2004-09-02 16:00:00	QQQ	ETF	34.76	34.83	34.3	34.45	8647100.0
2004-09-02 17:00:00	QQQ	ETF	34.452	34.47	34.41	34.42	183700.0
2004-09-02 18:00:00	QQQ	ETF	34.42	34.48	34.42	34.46	127000.0
2004-09-02 19:00:00	QQQ	ETF	34.46	34.49	34.46	34.49	14400.0
2004-09-02 08:00:00	IWM	ETF	55.005	55.005	55.005	55.005	1000.0
2004-09-02 09:00:00	IWM	ETF	55.07	55.265	54.97	55.25	1096800.0
2004-09-02 10:00:00	IWM	ETF	55.235	55.295	55.16	55.26	1126800.0
2004-09-02 11:00:00	IWM	ETF	55.26	55.29	55.18	55.24	609400.0
2004-09-02 12:00:00	IWM	ETF	55.24	55.29	55.21	55.255	311800.0
2004-09-02 13:00:00	IWM	ETF	55.235	55.405	55.235	55.405	419200.0
2004-09-02 14:00:00	IWM	ETF	55.405	55.66	55.385	55.66	1762000.0
2004-09-02 15:00:00	IWM	ETF	55.655	55.915	55.625	55.88	2904800.0
2004-09-02 16:00:00	IWM	ETF	55.88	56.16	55.69	55.825	428200.0
2004-09-02 18:00:00	IWM	ETF	55.75	55.86	55.75	55.86	2200.0
2004-09-02 08:00:00	DIA	ETF	101.85	101.85	101.73	101.73	3900.0
2004-09-02 09:00:00	DIA	ETF	101.79	102.04	101.79	101.96	314900.0
2004-09-02 10:00:00	DIA	ETF	101.96	102.13	101.96	102.1	503800.0
2004-09-02 11:00:00	DIA	ETF	102.12	102.13	101.86	101.94	536100.0
2004-09-02 12:00:00	DIA	ETF	101.95	102.0	101.9	101.96	299900.0
2004-09-02 13:00:00	DIA	ETF	101.96	102.06	101.92	102.05	416800.0
2004-09-02 14:00:00	DIA	ETF	102.03	102.74	102.03	102.72	1047700.0
2004-09-02 15:00:00	DIA	ETF	102.71	103.21	102.7	103.08	1202000.0
2004-09-02 16:00:00	DIA	ETF	103.12	103.24	102.84	102.98	397800.0
2004-09-02 17:00:00	DIA	ETF	103.02	103.1	103.0	103.0	1100.0
2004-09-02 18:00:00	DIA	ETF	103.04	103.05	102.92	102.92	2000.0
2004-09-02 09:00:00	TLT	ETF	87.37	87.37	87.22	87.23	75000.0
2004-09-02 10:00:00	TLT	ETF	87.23	87.24	87.14	87.18	113700.0
2004-09-02 11:00:00	TLT	ETF	87.2	87.29	87.16	87.16	34800.0
2004-09-02 12:00:00	TLT	ETF	87.19	87.19	87.0	87.05	163900.0
2004-09-02 13:00:00	TLT	ETF	87.06	87.13	86.99	87.06	111100.0

> showing 50 of 687 rows — these rows as CSV

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