PREVIEW / etf_1hour / 2003-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-06.parquet
  size:    18 KB
  rows:    454

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-06 08:00:00	SPY	ETF	105.7	105.9	105.5	105.72	192500.0
2003-11-06 09:00:00	SPY	ETF	105.7	105.79	105.25	105.4	3272400.0
2003-11-06 10:00:00	SPY	ETF	105.37	105.55	105.17	105.3	3710000.0
2003-11-06 11:00:00	SPY	ETF	105.3	105.43	105.12	105.39	2085600.0
2003-11-06 12:00:00	SPY	ETF	105.41	105.74	105.31	105.66	3066500.0
2003-11-06 13:00:00	SPY	ETF	105.64	105.79	105.58	105.79	2223400.0
2003-11-06 14:00:00	SPY	ETF	105.78	105.93	105.64	105.76	3116400.0
2003-11-06 15:00:00	SPY	ETF	105.75	106.39	105.73	106.26	5409400.0
2003-11-06 16:00:00	SPY	ETF	106.26	106.49	106.22	106.42	1572400.0
2003-11-06 17:00:00	SPY	ETF	106.4146	106.43	106.37	106.43	16500.0
2003-11-06 18:00:00	SPY	ETF	106.43	106.47	106.43	106.46	5500.0
2003-11-06 19:00:00	SPY	ETF	106.43	106.48	106.43	106.43	3600.0
2003-11-06 08:00:00	QQQ	ETF	35.79	35.9	35.68	35.81	438300.0
2003-11-06 09:00:00	QQQ	ETF	35.82	35.87	35.48	35.58	14883900.0
2003-11-06 10:00:00	QQQ	ETF	35.57	35.63	35.37	35.429	11502400.0
2003-11-06 11:00:00	QQQ	ETF	35.42	35.54	35.34	35.53	7533200.0
2003-11-06 12:00:00	QQQ	ETF	35.52	35.69	35.47	35.65	6479200.0
2003-11-06 13:00:00	QQQ	ETF	35.65	35.73	35.59	35.71	7714800.0
2003-11-06 14:00:00	QQQ	ETF	35.716	35.78	35.59	35.639	8057300.0
2003-11-06 15:00:00	QQQ	ETF	35.639	35.9	35.63	35.819	18972300.0
2003-11-06 16:00:00	QQQ	ETF	35.82	35.99	35.79	35.941	3808900.0
2003-11-06 17:00:00	QQQ	ETF	35.94	35.96	35.91	35.93	74900.0
2003-11-06 18:00:00	QQQ	ETF	35.93	35.95	35.93	35.95	26800.0
2003-11-06 19:00:00	QQQ	ETF	35.95	35.96	35.91	35.92	19800.0
2003-11-06 09:00:00	IWM	ETF	54.02	54.075	53.585	53.73	1211600.0
2003-11-06 10:00:00	IWM	ETF	53.747	53.86	53.59	53.65	717200.0
2003-11-06 11:00:00	IWM	ETF	53.625	53.78	53.545	53.765	824000.0
2003-11-06 12:00:00	IWM	ETF	53.755	53.875	53.725	53.855	217200.0
2003-11-06 13:00:00	IWM	ETF	53.86	53.94	53.805	53.94	277400.0
2003-11-06 14:00:00	IWM	ETF	53.95	54.035	53.835	53.865	1252400.0
2003-11-06 15:00:00	IWM	ETF	53.885	54.23	53.88	54.205	1385400.0
2003-11-06 16:00:00	IWM	ETF	54.25	54.41	53.86	54.285	251400.0
2003-11-06 08:00:00	DIA	ETF	98.26	98.53	98.26	98.42	18100.0
2003-11-06 09:00:00	DIA	ETF	98.4	98.44	97.98	98.13	575100.0
2003-11-06 10:00:00	DIA	ETF	98.13	98.35	98.001	98.1	694600.0
2003-11-06 11:00:00	DIA	ETF	98.1	98.184	97.95	98.14	453900.0
2003-11-06 12:00:00	DIA	ETF	98.14	98.43	98.06	98.32	252000.0
2003-11-06 13:00:00	DIA	ETF	98.3	98.46	98.21	98.43	475600.0
2003-11-06 14:00:00	DIA	ETF	98.46	98.55	98.27	98.36	675800.0
2003-11-06 15:00:00	DIA	ETF	98.38	98.96	98.38	98.78	1499700.0
2003-11-06 16:00:00	DIA	ETF	98.79	98.94	98.77	98.91	120200.0
2003-11-06 17:00:00	DIA	ETF	98.95	99.02	98.88	98.88	1800.0
2003-11-06 09:00:00	TLT	ETF	83.77	83.9	83.77	83.85	300400.0
2003-11-06 10:00:00	TLT	ETF	83.85	83.92	83.74	83.84	90200.0
2003-11-06 11:00:00	TLT	ETF	83.82	83.92	83.55	83.58	161400.0
2003-11-06 12:00:00	TLT	ETF	83.58	83.7	83.56	83.6	47000.0
2003-11-06 13:00:00	TLT	ETF	83.63	83.68	83.56	83.6	117400.0
2003-11-06 14:00:00	TLT	ETF	83.57	83.63	83.5	83.62	34500.0
2003-11-06 15:00:00	TLT	ETF	83.6	83.64	83.5	83.5	79100.0
2003-11-06 16:00:00	TLT	ETF	83.52	83.55	83.52	83.55	4400.0

> showing 50 of 454 rows — these rows as CSV

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