PREVIEW / etf_1hour / 2003-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-18.parquet
  size:    20 KB
  rows:    521

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-18 08:00:00	SPY	ETF	108.53	108.64	108.5	108.55	46100.0
2003-12-18 09:00:00	SPY	ETF	108.56	108.98	108.39	108.96	3285400.0
2003-12-18 10:00:00	SPY	ETF	108.96	109.11	108.82	109.06	5011700.0
2003-12-18 11:00:00	SPY	ETF	109.07	109.13	108.92	109.03	2413600.0
2003-12-18 12:00:00	SPY	ETF	109.02	109.14	108.9	109.08	1917400.0
2003-12-18 13:00:00	SPY	ETF	109.07	109.23	109.06	109.13	3519800.0
2003-12-18 14:00:00	SPY	ETF	109.13	109.63	109.1	109.57	4454700.0
2003-12-18 15:00:00	SPY	ETF	109.57	109.72	109.48	109.6	4397000.0
2003-12-18 16:00:00	SPY	ETF	109.59	109.73	109.57	109.69	1687500.0
2003-12-18 17:00:00	SPY	ETF	109.577	109.7	109.57	109.63	589700.0
2003-12-18 18:00:00	SPY	ETF	109.63	109.67	107.64	109.64	181800.0
2003-12-18 19:00:00	SPY	ETF	109.6	109.63	109.6	109.62	1400.0
2003-12-18 08:00:00	QQQ	ETF	34.95	35.0	34.92	34.95	140700.0
2003-12-18 09:00:00	QQQ	ETF	34.96	35.3	34.94	35.26	14298300.0
2003-12-18 10:00:00	QQQ	ETF	35.26	35.4	35.18	35.375	15212600.0
2003-12-18 11:00:00	QQQ	ETF	35.375	35.42	35.3	35.37	10002200.0
2003-12-18 12:00:00	QQQ	ETF	35.39	35.43	35.3	35.36	6931400.0
2003-12-18 13:00:00	QQQ	ETF	35.38	35.5	35.37	35.4	8279600.0
2003-12-18 14:00:00	QQQ	ETF	35.4	35.59	35.39	35.56	12241900.0
2003-12-18 15:00:00	QQQ	ETF	35.56	35.64	35.47	35.57	14653100.0
2003-12-18 16:00:00	QQQ	ETF	35.56	35.6	35.52	35.55	2915200.0
2003-12-18 17:00:00	QQQ	ETF	35.558	35.56	35.49	35.52	221300.0
2003-12-18 18:00:00	QQQ	ETF	35.5	35.52	35.5	35.5	19200.0
2003-12-18 19:00:00	QQQ	ETF	35.53	35.55	35.53	35.54	7900.0
2003-12-18 09:00:00	IWM	ETF	53.525	54.07	53.46	54.05	1230400.0
2003-12-18 10:00:00	IWM	ETF	54.05	54.15	53.78	53.91	2066200.0
2003-12-18 11:00:00	IWM	ETF	53.925	53.995	53.81	53.9	839200.0
2003-12-18 12:00:00	IWM	ETF	53.9	53.935	53.815	53.915	456800.0
2003-12-18 13:00:00	IWM	ETF	53.905	54.075	53.895	53.955	382000.0
2003-12-18 14:00:00	IWM	ETF	53.955	54.35	53.92	54.31	1108800.0
2003-12-18 15:00:00	IWM	ETF	54.305	54.5	54.27	54.315	1675800.0
2003-12-18 16:00:00	IWM	ETF	54.2795	54.435	53.6056	53.6056	1300000.0
2003-12-18 17:00:00	IWM	ETF	54.32	54.435	54.32	54.435	36800.0
2003-12-18 08:00:00	DIA	ETF	101.87	101.98	101.87	101.92	2900.0
2003-12-18 09:00:00	DIA	ETF	101.89	102.14	101.7	102.12	1058100.0
2003-12-18 10:00:00	DIA	ETF	102.1	102.37	102.02	102.3	1824600.0
2003-12-18 11:00:00	DIA	ETF	102.31	102.37	102.21	102.26	790700.0
2003-12-18 12:00:00	DIA	ETF	102.32	102.37	102.189	102.29	578700.0
2003-12-18 13:00:00	DIA	ETF	102.29	102.4	102.28	102.3	511000.0
2003-12-18 14:00:00	DIA	ETF	102.3	102.65	102.25	102.59	3781200.0
2003-12-18 15:00:00	DIA	ETF	102.6	102.83	102.58	102.64	1652100.0
2003-12-18 16:00:00	DIA	ETF	102.65	102.81	102.61	102.77	164200.0
2003-12-18 17:00:00	DIA	ETF	102.77	102.8	102.64	102.64	9000.0
2003-12-18 18:00:00	DIA	ETF	102.64	102.64	102.64	102.64	200.0
2003-12-18 19:00:00	DIA	ETF	102.81	102.81	102.81	102.81	400.0
2003-12-18 09:00:00	TLT	ETF	86.3	86.61	86.3	86.61	69000.0
2003-12-18 10:00:00	TLT	ETF	86.55	86.64	86.55	86.55	42200.0
2003-12-18 11:00:00	TLT	ETF	86.55	86.7	86.43	86.45	103300.0
2003-12-18 12:00:00	TLT	ETF	86.44	86.75	86.38	86.68	89600.0
2003-12-18 13:00:00	TLT	ETF	86.64	86.76	86.52	86.63	81800.0

> showing 50 of 521 rows — these rows as CSV

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