PREVIEW / etf_1hour / 2004-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-21.parquet
  size:    24 KB
  rows:    682

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-21 08:00:00	SPY	ETF	113.9	113.94	113.85	113.9	195000.0
2004-06-21 09:00:00	SPY	ETF	113.85	113.95	113.6	113.94	3478100.0
2004-06-21 10:00:00	SPY	ETF	113.92	114.14	113.78	113.91	4203400.0
2004-06-21 11:00:00	SPY	ETF	113.9	114.0	113.74	113.94	1872300.0
2004-06-21 12:00:00	SPY	ETF	113.95	113.97	113.83	113.85	1163700.0
2004-06-21 13:00:00	SPY	ETF	113.85	114.01	113.78	113.99	1344300.0
2004-06-21 14:00:00	SPY	ETF	113.99	114.02	113.66	113.75	1628700.0
2004-06-21 15:00:00	SPY	ETF	113.75	113.84	113.18	113.31	7798300.0
2004-06-21 16:00:00	SPY	ETF	113.31	113.33	113.12	113.28	1822700.0
2004-06-21 17:00:00	SPY	ETF	113.27	113.28	113.2	113.23	603700.0
2004-06-21 18:00:00	SPY	ETF	113.25	113.3	113.25	113.3	3700.0
2004-06-21 19:00:00	SPY	ETF	113.3	113.3	113.2	113.29	2600.0
2004-06-21 08:00:00	QQQ	ETF	36.56	36.58	36.53	36.54	150000.0
2004-06-21 09:00:00	QQQ	ETF	36.55	36.57	36.41	36.55	12258500.0
2004-06-21 10:00:00	QQQ	ETF	36.55	36.63	36.45	36.522	9528800.0
2004-06-21 11:00:00	QQQ	ETF	36.521	36.57	36.45	36.535	5665200.0
2004-06-21 12:00:00	QQQ	ETF	36.53	36.541	36.48	36.49	4232900.0
2004-06-21 13:00:00	QQQ	ETF	36.484	36.55	36.46	36.53	3710900.0
2004-06-21 14:00:00	QQQ	ETF	36.54	36.55	36.36	36.38	5908100.0
2004-06-21 15:00:00	QQQ	ETF	36.38	36.44	36.06	36.15	19734400.0
2004-06-21 16:00:00	QQQ	ETF	36.142	36.18	36.1	36.18	1494800.0
2004-06-21 17:00:00	QQQ	ETF	36.18	36.19	36.14	36.19	62200.0
2004-06-21 18:00:00	QQQ	ETF	36.18	36.19	36.17	36.17	43200.0
2004-06-21 19:00:00	QQQ	ETF	36.17	36.2	36.17	36.2	14000.0
2004-06-21 08:00:00	IWM	ETF	57.05	57.055	57.05	57.055	3000.0
2004-06-21 09:00:00	IWM	ETF	56.93	57.015	56.65	56.9	929600.0
2004-06-21 10:00:00	IWM	ETF	56.895	57.02	56.815	56.87	1382200.0
2004-06-21 11:00:00	IWM	ETF	56.88	57.075	56.81	57.045	539400.0
2004-06-21 12:00:00	IWM	ETF	57.045	57.13	57.025	57.05	492800.0
2004-06-21 13:00:00	IWM	ETF	57.05	57.18	57.0	57.18	527400.0
2004-06-21 14:00:00	IWM	ETF	57.18	57.195	56.945	56.995	524800.0
2004-06-21 15:00:00	IWM	ETF	56.985	57.055	56.685	56.725	1216400.0
2004-06-21 16:00:00	IWM	ETF	56.745	56.8	56.685	56.74	362800.0
2004-06-21 17:00:00	IWM	ETF	56.72	56.72	56.72	56.72	2400.0
2004-06-21 18:00:00	IWM	ETF	56.72	56.72	56.72	56.72	400.0
2004-06-21 08:00:00	DIA	ETF	104.46	104.46	104.35	104.4	6800.0
2004-06-21 09:00:00	DIA	ETF	104.35	104.35	103.98	104.34	561200.0
2004-06-21 10:00:00	DIA	ETF	104.36	104.53	104.27	104.4	850800.0
2004-06-21 11:00:00	DIA	ETF	104.38	104.42	104.22	104.38	290200.0
2004-06-21 12:00:00	DIA	ETF	104.38	104.42	104.27	104.3	136700.0
2004-06-21 13:00:00	DIA	ETF	104.29	104.44	104.23	104.44	129100.0
2004-06-21 14:00:00	DIA	ETF	104.45	104.47	104.19	104.22	382800.0
2004-06-21 15:00:00	DIA	ETF	104.24	104.32	103.75	103.85	1267700.0
2004-06-21 16:00:00	DIA	ETF	103.86	103.89	103.7	103.8	101200.0
2004-06-21 17:00:00	DIA	ETF	103.89	103.98	103.89	103.98	400.0
2004-06-21 09:00:00	TLT	ETF	82.63	82.63	82.54	82.54	49900.0
2004-06-21 10:00:00	TLT	ETF	82.52	82.6	82.49	82.58	92100.0
2004-06-21 11:00:00	TLT	ETF	82.57	82.68	82.51	82.61	85700.0
2004-06-21 12:00:00	TLT	ETF	82.6	82.74	82.59	82.74	51500.0
2004-06-21 13:00:00	TLT	ETF	82.74	82.75	82.65	82.73	89300.0

> showing 50 of 682 rows — these rows as CSV

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