PREVIEW / etf_1hour / 2003-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-12.parquet
  size:    17 KB
  rows:    418

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-09-12 08:00:00	SPY	ETF	102.3	102.3	101.89	102.03	187200.0
2003-09-12 09:00:00	SPY	ETF	102.04	102.09	101.35	101.44	5931800.0
2003-09-12 10:00:00	SPY	ETF	101.43	101.75	101.37	101.57	6786100.0
2003-09-12 11:00:00	SPY	ETF	101.64	102.18	101.56	101.878	6060600.0
2003-09-12 12:00:00	SPY	ETF	101.88	101.9	101.55	101.78	2813100.0
2003-09-12 13:00:00	SPY	ETF	101.807	101.89	101.65	101.77	1555000.0
2003-09-12 14:00:00	SPY	ETF	101.77	102.48	101.76	102.38	6646300.0
2003-09-12 15:00:00	SPY	ETF	102.38	102.64	102.33	102.52	4094600.0
2003-09-12 16:00:00	SPY	ETF	102.52	102.58	101.6928	102.54	2027200.0
2003-09-12 17:00:00	SPY	ETF	102.54	102.62	102.54	102.61	13800.0
2003-09-12 18:00:00	SPY	ETF	102.61	102.66	102.61	102.66	5900.0
2003-09-12 08:00:00	QQQ	ETF	33.47	33.58	33.29	33.33	462400.0
2003-09-12 09:00:00	QQQ	ETF	33.33	33.4	33.05	33.11	13854200.0
2003-09-12 10:00:00	QQQ	ETF	33.11	33.37	33.08	33.29	17435600.0
2003-09-12 11:00:00	QQQ	ETF	33.29	33.48	33.22	33.304	11780300.0
2003-09-12 12:00:00	QQQ	ETF	33.31	33.33	33.14	33.29	10402400.0
2003-09-12 13:00:00	QQQ	ETF	33.27	33.34	33.2018	33.32	7319700.0
2003-09-12 14:00:00	QQQ	ETF	33.33	33.72	33.31	33.63	14764000.0
2003-09-12 15:00:00	QQQ	ETF	33.63	33.74	33.56	33.74	11625200.0
2003-09-12 16:00:00	QQQ	ETF	33.74	33.88	33.45	33.84	2019400.0
2003-09-12 17:00:00	QQQ	ETF	33.85	33.89	33.81	33.87	101800.0
2003-09-12 18:00:00	QQQ	ETF	33.82	33.85	33.81	33.83	22400.0
2003-09-12 19:00:00	QQQ	ETF	33.82	33.86	33.82	33.86	5900.0
2003-09-12 08:00:00	IWM	ETF	50.27	50.305	50.27	50.295	6600.0
2003-09-12 09:00:00	IWM	ETF	50.355	50.375	49.9	49.945	1049200.0
2003-09-12 10:00:00	IWM	ETF	49.945	50.255	49.9	50.195	825000.0
2003-09-12 11:00:00	IWM	ETF	50.185	50.425	50.175	50.375	393200.0
2003-09-12 12:00:00	IWM	ETF	50.375	50.45	50.365	50.445	513600.0
2003-09-12 13:00:00	IWM	ETF	50.445	50.49	50.435	50.48	225400.0
2003-09-12 14:00:00	IWM	ETF	50.495	50.865	50.495	50.84	1070000.0
2003-09-12 15:00:00	IWM	ETF	50.815	50.875	50.625	50.77	618400.0
2003-09-12 16:00:00	IWM	ETF	50.74	50.74	50.7	50.72	22400.0
2003-09-12 08:00:00	DIA	ETF	94.89	95.6	94.55	94.64	16600.0
2003-09-12 09:00:00	DIA	ETF	94.72	94.75	94.1	94.23	721300.0
2003-09-12 10:00:00	DIA	ETF	94.2	94.4	94.12	94.24	567400.0
2003-09-12 11:00:00	DIA	ETF	94.22	94.73	94.22	94.5	957100.0
2003-09-12 12:00:00	DIA	ETF	94.5	94.51	94.27	94.48	278800.0
2003-09-12 13:00:00	DIA	ETF	94.5	94.55	94.36	94.45	215600.0
2003-09-12 14:00:00	DIA	ETF	94.46	95.19	94.43	95.01	664400.0
2003-09-12 15:00:00	DIA	ETF	95.01	95.2	94.9	95.03	1047700.0
2003-09-12 16:00:00	DIA	ETF	95.046	95.1	94.99	95.1	82700.0
2003-09-12 17:00:00	DIA	ETF	95.09	95.1	95.08	95.08	2000.0
2003-09-12 18:00:00	DIA	ETF	95.1	95.14	95.1	95.14	700.0
2003-09-12 19:00:00	DIA	ETF	95.14	95.14	95.14	95.14	100.0
2003-09-12 09:00:00	TLT	ETF	85.02	85.34	84.97	85.27	404700.0
2003-09-12 10:00:00	TLT	ETF	85.26	85.38	85.12	85.23	337700.0
2003-09-12 11:00:00	TLT	ETF	85.21	85.3	85.01	85.15	129100.0
2003-09-12 12:00:00	TLT	ETF	85.14	85.2	85.07	85.14	75100.0
2003-09-12 13:00:00	TLT	ETF	85.08	85.15	85.0	85.06	100900.0
2003-09-12 14:00:00	TLT	ETF	85.01	85.04	84.5	84.61	47000.0

> showing 50 of 418 rows — these rows as CSV

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