PREVIEW / etf_1hour / 2003-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-21.parquet
  size:    18 KB
  rows:    467

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-11-21 08:00:00	SPY	ETF	104.07	104.2	104.06	104.1	72200.0
2003-11-21 09:00:00	SPY	ETF	104.14	104.31	104.03	104.11	3675600.0
2003-11-21 10:00:00	SPY	ETF	104.08	104.24	103.62	103.79	6276500.0
2003-11-21 11:00:00	SPY	ETF	103.78	104.2	103.78	104.01	3975900.0
2003-11-21 12:00:00	SPY	ETF	104.0	104.13	103.9	104.12	1708200.0
2003-11-21 13:00:00	SPY	ETF	104.11	104.33	104.05	104.09	3374800.0
2003-11-21 14:00:00	SPY	ETF	104.09	104.16	103.8	103.91	2621600.0
2003-11-21 15:00:00	SPY	ETF	103.92	104.22	103.82	104.04	4412000.0
2003-11-21 16:00:00	SPY	ETF	104.07	104.27	104.0	104.0	1584500.0
2003-11-21 17:00:00	SPY	ETF	104.05	104.14	104.0	104.12	9500.0
2003-11-21 18:00:00	SPY	ETF	104.12	104.12	104.12	104.12	1400.0
2003-11-21 19:00:00	SPY	ETF	104.12	104.12	104.12	104.12	1900.0
2003-11-21 08:00:00	QQQ	ETF	33.97	34.06	33.97	34.02	211900.0
2003-11-21 09:00:00	QQQ	ETF	34.03	34.13	33.95	34.0	10253000.0
2003-11-21 10:00:00	QQQ	ETF	34.0	34.07	33.73	33.85	18552800.0
2003-11-21 11:00:00	QQQ	ETF	33.85	34.18	33.84	34.09	11528900.0
2003-11-21 12:00:00	QQQ	ETF	34.07	34.13	33.994	34.09	3955200.0
2003-11-21 13:00:00	QQQ	ETF	34.09	34.25	34.06	34.07	5801200.0
2003-11-21 14:00:00	QQQ	ETF	34.06	34.12	33.93	33.941	7071800.0
2003-11-21 15:00:00	QQQ	ETF	33.99	34.23	33.96	34.15	12792000.0
2003-11-21 16:00:00	QQQ	ETF	34.15	34.265	34.11	34.22	4023900.0
2003-11-21 17:00:00	QQQ	ETF	34.212	34.239	34.16	34.22	47100.0
2003-11-21 18:00:00	QQQ	ETF	34.22	34.23	34.2	34.2	17000.0
2003-11-21 19:00:00	QQQ	ETF	34.19	34.23	34.19	34.2	6100.0
2003-11-21 09:00:00	IWM	ETF	52.425	52.65	52.365	52.43	786600.0
2003-11-21 10:00:00	IWM	ETF	52.45	52.55	52.15	52.25	2464200.0
2003-11-21 11:00:00	IWM	ETF	52.25	52.5	52.25	52.4	540600.0
2003-11-21 12:00:00	IWM	ETF	52.445	52.495	52.33	52.445	856800.0
2003-11-21 13:00:00	IWM	ETF	52.43	52.565	52.41	52.45	318000.0
2003-11-21 14:00:00	IWM	ETF	52.445	52.46	52.29	52.35	495800.0
2003-11-21 15:00:00	IWM	ETF	52.35	52.545	52.285	52.545	852600.0
2003-11-21 16:00:00	IWM	ETF	52.545	52.645	52.49	52.49	198200.0
2003-11-21 08:00:00	DIA	ETF	96.51	96.54	96.44	96.44	5900.0
2003-11-21 09:00:00	DIA	ETF	96.53	96.62	96.28	96.32	610700.0
2003-11-21 10:00:00	DIA	ETF	96.31	96.44	95.92	96.14	1241800.0
2003-11-21 11:00:00	DIA	ETF	96.138	96.5	96.11	96.37	962100.0
2003-11-21 12:00:00	DIA	ETF	96.35	96.45	96.25	96.41	229000.0
2003-11-21 13:00:00	DIA	ETF	96.41	96.58	96.28	96.37	206400.0
2003-11-21 14:00:00	DIA	ETF	96.39	96.45	96.14	96.29	736600.0
2003-11-21 15:00:00	DIA	ETF	96.29	96.55	96.19	96.4	659600.0
2003-11-21 16:00:00	DIA	ETF	96.44	96.61	96.38	96.45	81800.0
2003-11-21 08:00:00	TLT	ETF	86.6	86.6	86.6	86.6	500.0
2003-11-21 09:00:00	TLT	ETF	86.58	86.63	86.5	86.6	25100.0
2003-11-21 10:00:00	TLT	ETF	86.63	86.93	86.57	86.89	75500.0
2003-11-21 11:00:00	TLT	ETF	86.86	86.86	86.73	86.74	125500.0
2003-11-21 12:00:00	TLT	ETF	86.75	86.85	86.74	86.77	25200.0
2003-11-21 13:00:00	TLT	ETF	86.73	86.73	86.54	86.63	78100.0
2003-11-21 14:00:00	TLT	ETF	86.67	86.74	86.55	86.68	80900.0
2003-11-21 15:00:00	TLT	ETF	86.61	86.63	86.53	86.55	86300.0
2003-11-21 16:00:00	TLT	ETF	86.52	86.52	86.5	86.5	16800.0

> showing 50 of 467 rows — these rows as CSV

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