PREVIEW / etf_1hour / 2004-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-19.parquet
  size:    27 KB
  rows:    772

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-11-19 08:00:00	SPY	ETF	118.65	118.65	118.53	118.59	22100.0
2004-11-19 09:00:00	SPY	ETF	118.59	118.72	118.13	118.23	8143900.0
2004-11-19 10:00:00	SPY	ETF	118.23	118.28	117.43	117.61	11449800.0
2004-11-19 11:00:00	SPY	ETF	117.6	117.66	117.35	117.45	6798000.0
2004-11-19 12:00:00	SPY	ETF	117.46	117.55	117.31	117.48	3588700.0
2004-11-19 13:00:00	SPY	ETF	117.5	117.61	117.42	117.43	3269200.0
2004-11-19 14:00:00	SPY	ETF	117.43	117.55	117.31	117.37	3426500.0
2004-11-19 15:00:00	SPY	ETF	117.37	117.47	117.14	117.32	7840600.0
2004-11-19 16:00:00	SPY	ETF	117.34	117.51	117.26	117.42	2103000.0
2004-11-19 17:00:00	SPY	ETF	117.42	117.43	117.38	117.42	2100.0
2004-11-19 18:00:00	SPY	ETF	117.43	117.43	117.38	117.38	1800.0
2004-11-19 19:00:00	SPY	ETF	117.35	117.35	117.35	117.35	300.0
2004-11-19 08:00:00	QQQ	ETF	39.28	39.28	39.22	39.26	152600.0
2004-11-19 09:00:00	QQQ	ETF	39.26	39.29	39.02	39.107	14914800.0
2004-11-19 10:00:00	QQQ	ETF	39.106	39.11	38.86	38.882	24676100.0
2004-11-19 11:00:00	QQQ	ETF	38.882	38.89	38.7	38.791	17461800.0
2004-11-19 12:00:00	QQQ	ETF	38.8	38.8	38.7	38.73	10397800.0
2004-11-19 13:00:00	QQQ	ETF	38.738	38.81	38.71	38.717	9120100.0
2004-11-19 14:00:00	QQQ	ETF	38.71	38.73	38.59	38.68	14438000.0
2004-11-19 15:00:00	QQQ	ETF	38.68	38.721	38.59	38.66	18139600.0
2004-11-19 16:00:00	QQQ	ETF	38.66	38.739	38.61	38.68	4832900.0
2004-11-19 17:00:00	QQQ	ETF	38.66	38.68	38.63	38.63	81100.0
2004-11-19 18:00:00	QQQ	ETF	38.64	38.65	38.6	38.6	45200.0
2004-11-19 19:00:00	QQQ	ETF	38.62	38.65	38.62	38.65	3500.0
2004-11-19 08:00:00	IWM	ETF	62.04	62.04	61.995	61.995	1400.0
2004-11-19 09:00:00	IWM	ETF	61.895	61.975	61.555	61.63	1161400.0
2004-11-19 10:00:00	IWM	ETF	61.63	61.63	61.21	61.33	2116000.0
2004-11-19 11:00:00	IWM	ETF	61.335	61.365	61.145	61.31	1318800.0
2004-11-19 12:00:00	IWM	ETF	61.305	61.34	61.21	61.34	1340800.0
2004-11-19 13:00:00	IWM	ETF	61.34	61.425	61.28	61.32	951400.0
2004-11-19 14:00:00	IWM	ETF	61.325	61.45	61.245	61.34	932400.0
2004-11-19 15:00:00	IWM	ETF	61.34	61.395	61.06	61.165	2417800.0
2004-11-19 16:00:00	IWM	ETF	61.155	61.35	61.055	61.055	922000.0
2004-11-19 17:00:00	IWM	ETF	61.35	61.37	61.15	61.25	2000.0
2004-11-19 08:00:00	DIA	ETF	105.69	105.71	105.56	105.56	20400.0
2004-11-19 09:00:00	DIA	ETF	105.57	105.7	105.21	105.27	849500.0
2004-11-19 10:00:00	DIA	ETF	105.26	105.28	104.63	104.77	1824400.0
2004-11-19 11:00:00	DIA	ETF	104.78	104.8	104.55	104.66	919000.0
2004-11-19 12:00:00	DIA	ETF	104.66	104.67	104.43	104.59	1127400.0
2004-11-19 13:00:00	DIA	ETF	104.59	104.69	104.52	104.52	260400.0
2004-11-19 14:00:00	DIA	ETF	104.52	104.65	104.42	104.48	509500.0
2004-11-19 15:00:00	DIA	ETF	104.49	104.56	104.29	104.51	784100.0
2004-11-19 16:00:00	DIA	ETF	104.49	104.6	104.45	104.59	202600.0
2004-11-19 17:00:00	DIA	ETF	104.62	104.65	104.62	104.65	5000.0
2004-11-19 09:00:00	GLD	ETF	44.49	44.75	44.47	44.65	3534600.0
2004-11-19 10:00:00	GLD	ETF	44.66	44.72	44.58	44.7	1612700.0
2004-11-19 11:00:00	GLD	ETF	44.7	44.92	44.68	44.85	2096400.0
2004-11-19 12:00:00	GLD	ETF	44.85	44.86	44.76	44.82	1752900.0
2004-11-19 13:00:00	GLD	ETF	44.81	44.82	44.72	44.79	834100.0
2004-11-19 14:00:00	GLD	ETF	44.79	44.84	44.74	44.75	746700.0

> showing 50 of 772 rows — these rows as CSV

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