PREVIEW / etf_1hour / 2004-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-22.parquet
  size:    25 KB
  rows:    701

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-22 08:00:00	SPY	ETF	112.73	112.75	112.48	112.5	246100.0
2004-09-22 09:00:00	SPY	ETF	112.49	112.53	112.18	112.31	8117400.0
2004-09-22 10:00:00	SPY	ETF	112.33	112.33	111.86	111.89	10500800.0
2004-09-22 11:00:00	SPY	ETF	111.88	111.95	111.71	111.76	4962700.0
2004-09-22 12:00:00	SPY	ETF	111.74	111.97	111.73	111.88	4335500.0
2004-09-22 13:00:00	SPY	ETF	111.88	112.02	111.69	111.71	2924200.0
2004-09-22 14:00:00	SPY	ETF	111.72	111.88	111.58	111.73	5173000.0
2004-09-22 15:00:00	SPY	ETF	111.74	111.78	111.5	111.63	8697800.0
2004-09-22 16:00:00	SPY	ETF	111.63	111.63	111.48	111.55	2264600.0
2004-09-22 17:00:00	SPY	ETF	111.55	111.62	111.5	111.55	142200.0
2004-09-22 18:00:00	SPY	ETF	111.53	111.53	111.52	111.52	7200.0
2004-09-22 19:00:00	SPY	ETF	111.51	111.51	111.51	111.51	800.0
2004-09-22 08:00:00	QQQ	ETF	35.51	35.52	35.4	35.4	282000.0
2004-09-22 09:00:00	QQQ	ETF	35.4	35.46	35.27	35.38	14751200.0
2004-09-22 10:00:00	QQQ	ETF	35.369	35.38	35.04	35.07	25866400.0
2004-09-22 11:00:00	QQQ	ETF	35.07	35.12	35.015	35.03	10828100.0
2004-09-22 12:00:00	QQQ	ETF	35.03	35.11	35.03	35.052	6025100.0
2004-09-22 13:00:00	QQQ	ETF	35.05	35.16	35.01	35.02	8690600.0
2004-09-22 14:00:00	QQQ	ETF	35.02	35.05	34.92	35.0	13024300.0
2004-09-22 15:00:00	QQQ	ETF	35.0	35.03	34.87	34.95	16172500.0
2004-09-22 16:00:00	QQQ	ETF	34.941	34.98	34.92	34.97	3955700.0
2004-09-22 17:00:00	QQQ	ETF	34.96	34.98	34.95	34.98	109300.0
2004-09-22 18:00:00	QQQ	ETF	34.97	34.97	34.93	34.94	38400.0
2004-09-22 19:00:00	QQQ	ETF	34.94	34.96	34.93	34.94	41000.0
2004-09-22 08:00:00	IWM	ETF	57.06	57.06	57.06	57.06	1000.0
2004-09-22 09:00:00	IWM	ETF	57.12	57.12	56.77	56.895	2422600.0
2004-09-22 10:00:00	IWM	ETF	56.92	56.925	56.525	56.57	3176000.0
2004-09-22 11:00:00	IWM	ETF	56.57	56.68	56.525	56.575	1457400.0
2004-09-22 12:00:00	IWM	ETF	56.575	56.66	56.56	56.62	521400.0
2004-09-22 13:00:00	IWM	ETF	56.615	56.735	56.56	56.57	699000.0
2004-09-22 14:00:00	IWM	ETF	56.565	56.635	56.4	56.585	2629200.0
2004-09-22 15:00:00	IWM	ETF	56.59	56.66	56.39	56.455	2126800.0
2004-09-22 16:00:00	IWM	ETF	56.465	56.47	56.39	56.41	1203800.0
2004-09-22 17:00:00	IWM	ETF	56.43	56.45	56.43	56.45	2000.0
2004-09-22 08:00:00	DIA	ETF	102.23	102.24	102.0	102.0	51300.0
2004-09-22 09:00:00	DIA	ETF	102.0	102.05	101.8	101.92	1121100.0
2004-09-22 10:00:00	DIA	ETF	101.91	101.91	101.49	101.5	1754200.0
2004-09-22 11:00:00	DIA	ETF	101.5	101.53	101.33	101.35	1371400.0
2004-09-22 12:00:00	DIA	ETF	101.34	101.49	101.34	101.44	501500.0
2004-09-22 13:00:00	DIA	ETF	101.41	101.55	101.21	101.24	696600.0
2004-09-22 14:00:00	DIA	ETF	101.22	101.38	101.14	101.28	988300.0
2004-09-22 15:00:00	DIA	ETF	101.27	101.33	101.08	101.19	1313700.0
2004-09-22 16:00:00	DIA	ETF	101.16	101.19	101.09	101.09	503200.0
2004-09-22 17:00:00	DIA	ETF	101.13	101.13	101.13	101.13	100.0
2004-09-22 18:00:00	DIA	ETF	101.16	101.16	101.16	101.16	200.0
2004-09-22 08:00:00	TLT	ETF	88.91	88.97	88.75	88.75	7300.0
2004-09-22 09:00:00	TLT	ETF	88.83	88.83	88.65	88.7	285000.0
2004-09-22 10:00:00	TLT	ETF	88.7	88.99	88.7	88.99	129600.0
2004-09-22 11:00:00	TLT	ETF	89.0	89.36	88.99	89.32	445700.0
2004-09-22 12:00:00	TLT	ETF	89.33	89.33	89.18	89.29	416400.0

> showing 50 of 701 rows — these rows as CSV

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