PREVIEW / etf_1hour / 2003-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-29.parquet
  size:    16 KB
  rows:    408

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-04-29 08:00:00	SPY	ETF	92.1	92.15	91.87	92.1	36900.0
2003-04-29 09:00:00	SPY	ETF	92.07	92.4	91.94	92.32	5171300.0
2003-04-29 10:00:00	SPY	ETF	92.32	92.8	91.4	91.61	16118500.0
2003-04-29 11:00:00	SPY	ETF	91.59	92.02	91.44	91.94	4554300.0
2003-04-29 12:00:00	SPY	ETF	91.94	92.04	91.68	91.86	2592000.0
2003-04-29 13:00:00	SPY	ETF	91.89	92.15	91.51	91.67	4605900.0
2003-04-29 14:00:00	SPY	ETF	91.67	92.1	91.55	92.04	3419700.0
2003-04-29 15:00:00	SPY	ETF	92.03	92.48	92.0	92.1	7100900.0
2003-04-29 16:00:00	SPY	ETF	92.11	92.21	92.0	92.0	3464100.0
2003-04-29 17:00:00	SPY	ETF	92.01	92.06	91.96	91.96	425700.0
2003-04-29 18:00:00	SPY	ETF	91.98	92.02	91.96	91.99	10600.0
2003-04-29 19:00:00	SPY	ETF	92.0	92.07	91.98	92.0	4200.0
2003-04-29 08:00:00	QQQ	ETF	27.58	27.64	27.54	27.61	92900.0
2003-04-29 09:00:00	QQQ	ETF	27.62	27.86	27.61	27.83	10879600.0
2003-04-29 10:00:00	QQQ	ETF	27.84	28.06	27.42	27.53	24275500.0
2003-04-29 11:00:00	QQQ	ETF	27.53	27.73	27.45	27.69	7554000.0
2003-04-29 12:00:00	QQQ	ETF	27.69	27.74	27.57	27.67	4433300.0
2003-04-29 13:00:00	QQQ	ETF	27.66	27.73	27.51	27.59	4963900.0
2003-04-29 14:00:00	QQQ	ETF	27.58	27.77	27.55	27.75	5695000.0
2003-04-29 15:00:00	QQQ	ETF	27.75	27.93	27.7	27.75	11795800.0
2003-04-29 16:00:00	QQQ	ETF	27.74	27.76	27.68	27.74	5930500.0
2003-04-29 17:00:00	QQQ	ETF	27.74	27.76	27.71	27.74	101000.0
2003-04-29 18:00:00	QQQ	ETF	27.74	27.78	27.74	27.77	13000.0
2003-04-29 19:00:00	QQQ	ETF	27.77	27.78	27.74	27.74	19400.0
2003-04-29 09:00:00	IWM	ETF	39.43	39.66	39.375	39.635	409200.0
2003-04-29 10:00:00	IWM	ETF	39.675	39.775	39.375	39.42	761000.0
2003-04-29 11:00:00	IWM	ETF	39.42	39.6	39.385	39.585	186800.0
2003-04-29 12:00:00	IWM	ETF	39.595	39.62	39.505	39.525	206800.0
2003-04-29 13:00:00	IWM	ETF	39.51	39.58	39.435	39.49	484800.0
2003-04-29 14:00:00	IWM	ETF	39.48	39.56	39.435	39.56	306200.0
2003-04-29 15:00:00	IWM	ETF	39.555	39.7	39.465	39.56	549200.0
2003-04-29 16:00:00	IWM	ETF	39.555	39.575	39.2	39.2	87000.0
2003-04-29 08:00:00	DIA	ETF	85.05	85.13	84.83	85.09	20100.0
2003-04-29 09:00:00	DIA	ETF	85.11	85.34	84.94	85.22	1095000.0
2003-04-29 10:00:00	DIA	ETF	85.23	85.7	84.47	84.63	4038900.0
2003-04-29 11:00:00	DIA	ETF	84.64	84.98	84.5	84.89	1302100.0
2003-04-29 12:00:00	DIA	ETF	84.91	85.0	84.67	84.85	583200.0
2003-04-29 13:00:00	DIA	ETF	84.88	85.06	84.53	84.65	752800.0
2003-04-29 14:00:00	DIA	ETF	84.64	85.08	84.55	85.08	780600.0
2003-04-29 15:00:00	DIA	ETF	85.06	85.46	84.97	85.14	1804000.0
2003-04-29 16:00:00	DIA	ETF	85.1	85.16	85.05	85.05	89100.0
2003-04-29 17:00:00	DIA	ETF	85.08	85.08	85.03	85.03	5300.0
2003-04-29 18:00:00	DIA	ETF	85.0	85.08	85.0	85.08	1200.0
2003-04-29 19:00:00	DIA	ETF	85.1	85.12	85.1	85.11	5800.0
2003-04-29 09:00:00	TLT	ETF	88.53	88.66	88.5	88.5	4800.0
2003-04-29 10:00:00	TLT	ETF	88.45	88.67	88.32	88.63	131500.0
2003-04-29 11:00:00	TLT	ETF	88.64	88.7	88.53	88.61	18700.0
2003-04-29 12:00:00	TLT	ETF	88.69	88.77	88.66	88.66	5100.0
2003-04-29 14:00:00	TLT	ETF	88.73	88.73	88.56	88.56	8100.0
2003-04-29 15:00:00	TLT	ETF	88.56	88.67	88.54	88.63	9300.0

> showing 50 of 408 rows — these rows as CSV

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