PREVIEW / etf_1hour / 2003-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-14.parquet
  size:    18 KB
  rows:    456

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-10-14 08:00:00	SPY	ETF	105.07	105.13	104.9	104.97	29300.0
2003-10-14 09:00:00	SPY	ETF	104.97	104.97	104.36	104.6	4141800.0
2003-10-14 10:00:00	SPY	ETF	104.59	104.83	104.48	104.79	3842300.0
2003-10-14 11:00:00	SPY	ETF	104.78	104.84	104.52	104.56	5308000.0
2003-10-14 12:00:00	SPY	ETF	104.58	104.9	104.46	104.67	2613700.0
2003-10-14 13:00:00	SPY	ETF	104.66	105.16	104.63	105.06	2522800.0
2003-10-14 14:00:00	SPY	ETF	105.02	105.17	104.94	105.0	2676000.0
2003-10-14 15:00:00	SPY	ETF	105.01	105.36	104.96	105.29	5264300.0
2003-10-14 16:00:00	SPY	ETF	105.32	105.44	105.19	105.3	3102200.0
2003-10-14 17:00:00	SPY	ETF	105.28	105.43	105.28	105.4	27800.0
2003-10-14 18:00:00	SPY	ETF	105.37	105.41	105.35	105.41	3300.0
2003-10-14 19:00:00	SPY	ETF	105.4	105.49	105.4	105.49	1400.0
2003-10-14 08:00:00	QQQ	ETF	35.2	35.24	35.15	35.2	176500.0
2003-10-14 09:00:00	QQQ	ETF	35.19	35.19	34.96	35.05	8328900.0
2003-10-14 10:00:00	QQQ	ETF	35.07	35.16	34.99	35.15	8959600.0
2003-10-14 11:00:00	QQQ	ETF	35.15	35.193	35.05	35.07	4890300.0
2003-10-14 12:00:00	QQQ	ETF	35.07	35.16	35.02	35.07	5329000.0
2003-10-14 13:00:00	QQQ	ETF	35.077	35.3	35.06	35.24	6943200.0
2003-10-14 14:00:00	QQQ	ETF	35.24	35.29	35.15	35.19	6632400.0
2003-10-14 15:00:00	QQQ	ETF	35.196	35.35	35.17	35.31	10689500.0
2003-10-14 16:00:00	QQQ	ETF	35.31	35.48	35.2	35.45	6376100.0
2003-10-14 17:00:00	QQQ	ETF	35.45	35.5	35.39	35.5	1914800.0
2003-10-14 18:00:00	QQQ	ETF	35.47	35.51	35.448	35.5	180800.0
2003-10-14 19:00:00	QQQ	ETF	35.5	35.53	35.49	35.51	43900.0
2003-10-14 09:00:00	IWM	ETF	52.675	52.8	52.44	52.78	875400.0
2003-10-14 10:00:00	IWM	ETF	52.775	52.92	52.585	52.76	2057800.0
2003-10-14 11:00:00	IWM	ETF	52.76	52.895	52.7	52.725	551000.0
2003-10-14 12:00:00	IWM	ETF	52.695	52.85	52.672	52.765	465000.0
2003-10-14 13:00:00	IWM	ETF	52.76	53.03	52.755	52.94	1492000.0
2003-10-14 14:00:00	IWM	ETF	52.95	53.03	52.92	52.95	501600.0
2003-10-14 15:00:00	IWM	ETF	52.95	53.125	52.85	53.07	584800.0
2003-10-14 16:00:00	IWM	ETF	53.075	53.095	52.65	53.01	514600.0
2003-10-14 17:00:00	IWM	ETF	53.0	53.075	53.0	53.075	12000.0
2003-10-14 18:00:00	IWM	ETF	53.085	53.085	53.085	53.085	2000.0
2003-10-14 19:00:00	IWM	ETF	53.495	53.495	53.495	53.495	200.0
2003-10-14 08:00:00	DIA	ETF	97.92	98.1	97.92	97.96	5400.0
2003-10-14 09:00:00	DIA	ETF	98.0	98.0	97.538	97.69	278700.0
2003-10-14 10:00:00	DIA	ETF	97.67	97.87	97.59	97.81	633800.0
2003-10-14 11:00:00	DIA	ETF	97.8	97.87	97.628	97.65	406600.0
2003-10-14 12:00:00	DIA	ETF	97.66	97.87	97.54	97.77	415500.0
2003-10-14 13:00:00	DIA	ETF	97.76	98.18	97.7	98.08	475000.0
2003-10-14 14:00:00	DIA	ETF	98.11	98.21	97.95	98.05	610000.0
2003-10-14 15:00:00	DIA	ETF	98.06	98.33	98.01	98.28	1063500.0
2003-10-14 16:00:00	DIA	ETF	98.28	98.51	98.25	98.27	377100.0
2003-10-14 17:00:00	DIA	ETF	98.39	98.45	98.35	98.35	7500.0
2003-10-14 19:00:00	DIA	ETF	98.42	98.42	98.31	98.31	1200.0
2003-10-14 09:00:00	TLT	ETF	83.75	83.85	83.71	83.71	72200.0
2003-10-14 10:00:00	TLT	ETF	83.74	83.9	83.71	83.83	123300.0
2003-10-14 11:00:00	TLT	ETF	83.87	84.05	83.78	84.05	23000.0
2003-10-14 12:00:00	TLT	ETF	84.04	84.1	83.96	84.0	10600.0

> showing 50 of 456 rows — these rows as CSV

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