PREVIEW / etf_1hour / 2003-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-09.parquet
  size:    17 KB
  rows:    446

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
2003-06-09 08:00:00	SPY	ETF	99.39	99.39	98.74	98.78	102600.0
2003-06-09 09:00:00	SPY	ETF	98.72	99.08	98.59	99.02	6182000.0
2003-06-09 10:00:00	SPY	ETF	98.95	99.1	98.07	98.31	8582500.0
2003-06-09 11:00:00	SPY	ETF	98.31	98.57	98.25	98.34	2933300.0
2003-06-09 12:00:00	SPY	ETF	98.36	98.69	98.26	98.33	2357800.0
2003-06-09 13:00:00	SPY	ETF	98.33	98.4	98.11	98.28	2125600.0
2003-06-09 14:00:00	SPY	ETF	98.28	98.42	97.88	97.93	3700400.0
2003-06-09 15:00:00	SPY	ETF	97.94	98.16	97.77	98.11	6738800.0
2003-06-09 16:00:00	SPY	ETF	98.11	98.29	98.09	98.26	1299000.0
2003-06-09 17:00:00	SPY	ETF	98.26	98.27	98.2	98.27	740100.0
2003-06-09 18:00:00	SPY	ETF	98.27	98.33	98.27	98.28	3800.0
2003-06-09 19:00:00	SPY	ETF	98.28	98.28	98.23	98.24	10700.0
2003-06-09 08:00:00	QQQ	ETF	30.18	30.18	29.94	29.98	183700.0
2003-06-09 09:00:00	QQQ	ETF	29.99	30.18	29.85	30.11	14662900.0
2003-06-09 10:00:00	QQQ	ETF	30.12	30.22	29.56	29.73	23591600.0
2003-06-09 11:00:00	QQQ	ETF	29.72	29.88	29.66	29.77	5802300.0
2003-06-09 12:00:00	QQQ	ETF	29.77	29.89	29.67	29.72	5220300.0
2003-06-09 13:00:00	QQQ	ETF	29.71	29.79	29.61	29.74	5238400.0
2003-06-09 14:00:00	QQQ	ETF	29.74	29.83	29.57	29.61	9659200.0
2003-06-09 15:00:00	QQQ	ETF	29.62	29.75	29.53	29.7	10711400.0
2003-06-09 16:00:00	QQQ	ETF	29.72	29.76	29.7	29.74	4084100.0
2003-06-09 17:00:00	QQQ	ETF	29.76	29.79	29.74	29.75	596200.0
2003-06-09 18:00:00	QQQ	ETF	29.77	29.79	29.76	29.79	10500.0
2003-06-09 19:00:00	QQQ	ETF	29.79	29.8	29.78	29.79	8500.0
2003-06-09 09:00:00	IWM	ETF	45.1	45.2	44.905	45.055	473800.0
2003-06-09 10:00:00	IWM	ETF	44.985	45.075	44.505	44.67	684000.0
2003-06-09 11:00:00	IWM	ETF	44.67	44.895	44.6	44.69	374000.0
2003-06-09 12:00:00	IWM	ETF	44.68	44.76	44.63	44.65	241000.0
2003-06-09 13:00:00	IWM	ETF	44.65	44.67	44.55	44.635	246400.0
2003-06-09 14:00:00	IWM	ETF	44.635	44.67	44.445	44.455	454000.0
2003-06-09 15:00:00	IWM	ETF	44.465	44.495	44.355	44.45	594200.0
2003-06-09 16:00:00	IWM	ETF	44.35	44.45	44.34	44.36	142800.0
2003-06-09 08:00:00	DIA	ETF	90.84	90.84	90.55	90.55	14900.0
2003-06-09 09:00:00	DIA	ETF	90.44	90.92	90.4	90.85	1105100.0
2003-06-09 10:00:00	DIA	ETF	90.8	90.94	90.1	90.34	1818000.0
2003-06-09 11:00:00	DIA	ETF	90.36	90.55	90.27	90.34	645500.0
2003-06-09 12:00:00	DIA	ETF	90.35	90.67	90.21	90.21	683000.0
2003-06-09 13:00:00	DIA	ETF	90.2	90.36	90.06	90.19	711300.0
2003-06-09 14:00:00	DIA	ETF	90.16	90.34	89.75	89.85	1114800.0
2003-06-09 15:00:00	DIA	ETF	89.81	90.13	89.7	90.08	953300.0
2003-06-09 16:00:00	DIA	ETF	90.08	90.44	90.07	90.25	99300.0
2003-06-09 17:00:00	DIA	ETF	90.22	90.22	90.22	90.22	2400.0
2003-06-09 18:00:00	DIA	ETF	90.22	90.25	90.22	90.25	700.0
2003-06-09 19:00:00	DIA	ETF	90.23	90.25	90.23	90.25	1200.0
2003-06-09 09:00:00	TLT	ETF	94.7	94.71	94.49	94.55	34100.0
2003-06-09 10:00:00	TLT	ETF	94.58	94.76	94.55	94.62	31700.0
2003-06-09 11:00:00	TLT	ETF	94.65	94.68	94.6	94.61	17400.0
2003-06-09 12:00:00	TLT	ETF	94.62	94.67	94.6	94.63	41900.0
2003-06-09 13:00:00	TLT	ETF	94.7	94.82	94.68	94.78	16400.0
2003-06-09 14:00:00	TLT	ETF	94.79	94.8	94.73	94.75	12200.0

> showing 50 of 446 rows — these rows as CSV

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