PREVIEW / etf_1hour / 2003-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-15.parquet
  size:    20 KB
  rows:    516

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-12-15 08:00:00	SPY	ETF	109.23	109.39	109.09	109.31	503100.0
2003-12-15 09:00:00	SPY	ETF	109.3	109.31	108.58	108.67	8249800.0
2003-12-15 10:00:00	SPY	ETF	108.66	108.84	108.51	108.61	4745900.0
2003-12-15 11:00:00	SPY	ETF	108.61	108.76	108.41	108.7	3878900.0
2003-12-15 12:00:00	SPY	ETF	108.72	108.72	108.36	108.53	1926700.0
2003-12-15 13:00:00	SPY	ETF	108.53	108.6	108.18	108.22	2851000.0
2003-12-15 14:00:00	SPY	ETF	108.21	108.51	107.95	107.95	4515400.0
2003-12-15 15:00:00	SPY	ETF	107.97	108.08	107.48	107.53	7085900.0
2003-12-15 16:00:00	SPY	ETF	107.53	107.64	107.48	107.53	1295100.0
2003-12-15 17:00:00	SPY	ETF	107.54	107.57	107.48	107.5	14500.0
2003-12-15 18:00:00	SPY	ETF	107.54	107.54	107.46	107.46	2200.0
2003-12-15 08:00:00	QQQ	ETF	35.85	35.97	35.82	35.93	1070800.0
2003-12-15 09:00:00	QQQ	ETF	35.94	35.99	35.54	35.6	20022300.0
2003-12-15 10:00:00	QQQ	ETF	35.63	35.7	35.5	35.54	12801700.0
2003-12-15 11:00:00	QQQ	ETF	35.523	35.56	35.36	35.51	10972500.0
2003-12-15 12:00:00	QQQ	ETF	35.5	35.54	35.23	35.31	8779000.0
2003-12-15 13:00:00	QQQ	ETF	35.32	35.352	35.07	35.148	10869600.0
2003-12-15 14:00:00	QQQ	ETF	35.15	35.361	35.11	35.12	9803700.0
2003-12-15 15:00:00	QQQ	ETF	35.13	35.242	34.7	34.75	19151900.0
2003-12-15 16:00:00	QQQ	ETF	34.75	34.9	34.65	34.74	5371200.0
2003-12-15 17:00:00	QQQ	ETF	34.74	34.75	34.7	34.7	161300.0
2003-12-15 18:00:00	QQQ	ETF	34.69	34.73	34.68	34.7	40500.0
2003-12-15 19:00:00	QQQ	ETF	34.72	34.75	34.7	34.72	18700.0
2003-12-15 08:00:00	IWM	ETF	55.375	55.5	55.25	55.335	20600.0
2003-12-15 09:00:00	IWM	ETF	55.425	55.45	54.8205	54.85	1533800.0
2003-12-15 10:00:00	IWM	ETF	54.83	54.91	54.592	54.66	972000.0
2003-12-15 11:00:00	IWM	ETF	54.66	54.66	54.385	54.61	839400.0
2003-12-15 12:00:00	IWM	ETF	54.61	54.635	54.435	54.5	219800.0
2003-12-15 13:00:00	IWM	ETF	54.46	54.515	54.105	54.135	390800.0
2003-12-15 14:00:00	IWM	ETF	54.14	54.2255	53.945	53.97	989200.0
2003-12-15 15:00:00	IWM	ETF	53.92	53.96	53.3	53.31	1771800.0
2003-12-15 16:00:00	IWM	ETF	53.35	53.355	53.115	53.215	247000.0
2003-12-15 17:00:00	IWM	ETF	53.185	53.185	53.115	53.165	1200.0
2003-12-15 08:00:00	DIA	ETF	101.64	101.99	101.54	101.73	59100.0
2003-12-15 09:00:00	DIA	ETF	101.7	101.78	101.18	101.26	2014000.0
2003-12-15 10:00:00	DIA	ETF	101.23	101.4	101.1	101.29	790200.0
2003-12-15 11:00:00	DIA	ETF	101.26	101.37	101.15	101.37	612400.0
2003-12-15 12:00:00	DIA	ETF	101.35	101.36	101.07	101.25	458200.0
2003-12-15 13:00:00	DIA	ETF	101.23	101.27	100.92	101.01	738700.0
2003-12-15 14:00:00	DIA	ETF	101.01	101.23	100.8	100.83	937300.0
2003-12-15 15:00:00	DIA	ETF	100.84	100.9	100.39	100.43	1351000.0
2003-12-15 16:00:00	DIA	ETF	100.44	100.5	100.38	100.41	218500.0
2003-12-15 17:00:00	DIA	ETF	100.47	100.5	100.31	100.5	1400.0
2003-12-15 18:00:00	DIA	ETF	100.28	100.28	100.28	100.28	50000.0
2003-12-15 09:00:00	TLT	ETF	85.5	85.5	85.35	85.42	62900.0
2003-12-15 10:00:00	TLT	ETF	85.51	85.51	85.3	85.34	44700.0
2003-12-15 11:00:00	TLT	ETF	85.42	85.6	85.39	85.52	51800.0
2003-12-15 12:00:00	TLT	ETF	85.52	85.88	85.42	85.79	91200.0
2003-12-15 13:00:00	TLT	ETF	85.83	85.83	85.21	85.21	301200.0
2003-12-15 14:00:00	TLT	ETF	85.38	85.38	85.18	85.34	68000.0

> showing 50 of 516 rows — these rows as CSV

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