PREVIEW / etf_1hour / 2004-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-13.parquet
  size:    24 KB
  rows:    675

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-08-13 08:00:00	SPY	ETF	107.22	107.35	106.93	106.99	136400.0
2004-08-13 09:00:00	SPY	ETF	107.08	107.34	106.99	107.21	5750200.0
2004-08-13 10:00:00	SPY	ETF	107.21	107.28	106.77	107.08	10161400.0
2004-08-13 11:00:00	SPY	ETF	107.07	107.35	107.06	107.16	3520500.0
2004-08-13 12:00:00	SPY	ETF	107.16	107.19	106.72	106.87	3494400.0
2004-08-13 13:00:00	SPY	ETF	106.87	107.18	106.85	107.09	1770100.0
2004-08-13 14:00:00	SPY	ETF	107.09	107.12	106.74	106.74	3865500.0
2004-08-13 15:00:00	SPY	ETF	106.76	107.08	106.59	107.07	7463000.0
2004-08-13 16:00:00	SPY	ETF	107.07	107.24	107.0	107.02	2028300.0
2004-08-13 17:00:00	SPY	ETF	107.05	107.05	106.97	107.0	22900.0
2004-08-13 18:00:00	SPY	ETF	107.0	107.0	107.0	107.0	1700.0
2004-08-13 08:00:00	QQQ	ETF	32.69	32.72	32.58	32.63	344900.0
2004-08-13 09:00:00	QQQ	ETF	32.63	32.74	32.59	32.63	15085200.0
2004-08-13 10:00:00	QQQ	ETF	32.63	32.6375	32.45	32.53	18052900.0
2004-08-13 11:00:00	QQQ	ETF	32.539	32.65	32.53	32.611	8850000.0
2004-08-13 12:00:00	QQQ	ETF	32.61	32.62	32.35	32.45	13810200.0
2004-08-13 13:00:00	QQQ	ETF	32.45	32.56	32.43	32.52	5627500.0
2004-08-13 14:00:00	QQQ	ETF	32.52	32.543	32.416	32.43	8745000.0
2004-08-13 15:00:00	QQQ	ETF	32.43	32.56	32.36	32.53	15199500.0
2004-08-13 16:00:00	QQQ	ETF	32.537	32.573	32.45	32.47	2888700.0
2004-08-13 17:00:00	QQQ	ETF	32.49	32.52	32.48	32.52	20200.0
2004-08-13 18:00:00	QQQ	ETF	32.51	32.52	32.51	32.51	8700.0
2004-08-13 19:00:00	QQQ	ETF	32.51	32.52	32.5	32.52	3900.0
2004-08-13 08:00:00	IWM	ETF	51.8	51.875	51.675	51.675	7800.0
2004-08-13 09:00:00	IWM	ETF	51.77	52.04	51.77	51.935	1261800.0
2004-08-13 10:00:00	IWM	ETF	51.93	51.98	51.61	51.72	1554600.0
2004-08-13 11:00:00	IWM	ETF	51.75	51.915	51.725	51.83	542400.0
2004-08-13 12:00:00	IWM	ETF	51.845	51.845	51.5	51.585	772400.0
2004-08-13 13:00:00	IWM	ETF	51.575	51.75	51.575	51.72	296000.0
2004-08-13 14:00:00	IWM	ETF	51.69	51.755	51.42	51.42	1380200.0
2004-08-13 15:00:00	IWM	ETF	51.42	51.67	51.335	51.595	2371200.0
2004-08-13 16:00:00	IWM	ETF	51.59	51.795	51.105	51.615	930000.0
2004-08-13 17:00:00	IWM	ETF	51.825	51.825	51.825	51.825	400.0
2004-08-13 08:00:00	DIA	ETF	98.8	98.85	98.61	98.61	13800.0
2004-08-13 09:00:00	DIA	ETF	98.64	98.9	98.58	98.79	586200.0
2004-08-13 10:00:00	DIA	ETF	98.7984	98.85	98.4	98.73	852900.0
2004-08-13 11:00:00	DIA	ETF	98.64	98.85	98.61	98.67	399300.0
2004-08-13 12:00:00	DIA	ETF	98.68	98.68	98.28	98.44	445400.0
2004-08-13 13:00:00	DIA	ETF	98.39	98.63	98.35	98.56	213300.0
2004-08-13 14:00:00	DIA	ETF	98.55	98.62	98.28	98.37	426000.0
2004-08-13 15:00:00	DIA	ETF	98.34	98.63	98.17	98.61	840400.0
2004-08-13 16:00:00	DIA	ETF	98.63	98.73	98.59	98.64	162100.0
2004-08-13 08:00:00	TLT	ETF	86.35	86.69	86.35	86.69	4600.0
2004-08-13 09:00:00	TLT	ETF	86.68	86.76	86.66	86.75	27800.0
2004-08-13 10:00:00	TLT	ETF	86.71	86.74	86.53	86.56	90000.0
2004-08-13 11:00:00	TLT	ETF	86.55	86.7	86.52	86.7	12900.0
2004-08-13 12:00:00	TLT	ETF	86.7	86.85	86.7	86.81	411700.0
2004-08-13 13:00:00	TLT	ETF	86.81	86.9	86.81	86.87	40600.0
2004-08-13 14:00:00	TLT	ETF	86.86	86.87	86.78	86.78	12200.0
2004-08-13 15:00:00	TLT	ETF	86.8	86.8	86.58	86.67	34200.0

> showing 50 of 675 rows — these rows as CSV

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