PREVIEW / etf_1hour / 2003-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-02.parquet
  size:    17 KB
  rows:    395

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-01-02 08:00:00	SPY	ETF	88.88	89.06	88.66	88.95	21900.0
2003-01-02 09:00:00	SPY	ETF	88.95	89.4	88.55	88.7	4041900.0
2003-01-02 10:00:00	SPY	ETF	88.7	90.44	88.58	90.35	12879300.0
2003-01-02 11:00:00	SPY	ETF	90.35	90.48	90.04	90.36	3600200.0
2003-01-02 12:00:00	SPY	ETF	90.36	90.7	90.33	90.53	2568400.0
2003-01-02 13:00:00	SPY	ETF	90.55	90.69	90.32	90.49	3062400.0
2003-01-02 14:00:00	SPY	ETF	90.51	90.81	90.48	90.66	2813000.0
2003-01-02 15:00:00	SPY	ETF	90.64	91.15	90.62	91.11	5402300.0
2003-01-02 16:00:00	SPY	ETF	91.1	91.3	90.96	91.02	2389900.0
2003-01-02 17:00:00	SPY	ETF	90.98	91.0	90.79	90.96	199100.0
2003-01-02 18:00:00	SPY	ETF	90.99	91.1	90.99	91.1	9700.0
2003-01-02 19:00:00	SPY	ETF	91.07	91.07	91.07	91.07	2000.0
2003-01-02 08:00:00	QQQ	ETF	24.74	24.77	24.68	24.76	134800.0
2003-01-02 09:00:00	QQQ	ETF	24.75	24.87	24.45	24.57	7589500.0
2003-01-02 10:00:00	QQQ	ETF	24.57	25.27	24.54	25.24	17767100.0
2003-01-02 11:00:00	QQQ	ETF	25.24	25.29	25.07	25.28	6201100.0
2003-01-02 12:00:00	QQQ	ETF	25.24	25.39	25.23	25.32	5508700.0
2003-01-02 13:00:00	QQQ	ETF	25.34	25.4	25.25	25.29	4967200.0
2003-01-02 14:00:00	QQQ	ETF	25.31	25.5	25.29	25.4	5707100.0
2003-01-02 15:00:00	QQQ	ETF	25.43	25.55	25.38	25.5	8172100.0
2003-01-02 16:00:00	QQQ	ETF	25.52	25.53	25.39	25.45	2752300.0
2003-01-02 17:00:00	QQQ	ETF	25.43	25.48	25.29	25.44	797800.0
2003-01-02 18:00:00	QQQ	ETF	25.43	25.44	25.4	25.42	39300.0
2003-01-02 19:00:00	QQQ	ETF	25.4	25.44	25.4	25.44	7800.0
2003-01-02 09:00:00	IWM	ETF	38.25	38.44	38.035	38.12	225800.0
2003-01-02 10:00:00	IWM	ETF	38.17	38.625	38.17	38.625	690800.0
2003-01-02 11:00:00	IWM	ETF	38.645	38.66	38.51	38.6	633600.0
2003-01-02 12:00:00	IWM	ETF	38.59	38.745	38.565	38.745	133400.0
2003-01-02 13:00:00	IWM	ETF	38.745	38.825	38.735	38.75	284600.0
2003-01-02 14:00:00	IWM	ETF	38.785	38.915	38.75	38.85	774000.0
2003-01-02 15:00:00	IWM	ETF	38.865	39.025	38.865	38.97	540600.0
2003-01-02 16:00:00	IWM	ETF	39.005	39.06	38.925	39.06	519600.0
2003-01-02 08:00:00	DIA	ETF	84.17	84.28	83.94	84.22	7800.0
2003-01-02 09:00:00	DIA	ETF	84.18	84.6	83.97	84.01	1077900.0
2003-01-02 10:00:00	DIA	ETF	83.99	85.78	83.95	85.62	2383900.0
2003-01-02 11:00:00	DIA	ETF	85.63	85.73	85.32	85.64	830200.0
2003-01-02 12:00:00	DIA	ETF	85.63	85.84	85.58	85.69	645900.0
2003-01-02 13:00:00	DIA	ETF	85.73	85.81	85.5	85.62	457100.0
2003-01-02 14:00:00	DIA	ETF	85.6	85.89	85.6	85.8	307200.0
2003-01-02 15:00:00	DIA	ETF	85.76	86.24	85.76	86.15	952800.0
2003-01-02 16:00:00	DIA	ETF	86.17	86.33	86.11	86.15	149800.0
2003-01-02 17:00:00	DIA	ETF	86.12	86.16	85.88	86.09	31000.0
2003-01-02 18:00:00	DIA	ETF	86.08	86.23	85.9	85.9	3400.0
2003-01-02 09:00:00	TLT	ETF	87.7	87.9	87.65	87.9	32900.0
2003-01-02 10:00:00	TLT	ETF	87.7	87.7	86.37	86.43	97900.0
2003-01-02 11:00:00	TLT	ETF	86.5	86.6	86.42	86.5	3200.0
2003-01-02 12:00:00	TLT	ETF	86.45	86.52	86.38	86.38	3800.0
2003-01-02 13:00:00	TLT	ETF	86.35	86.46	86.33	86.4	11900.0
2003-01-02 14:00:00	TLT	ETF	86.4	86.4	86.3	86.3	24800.0
2003-01-02 15:00:00	TLT	ETF	86.4	86.4	86.21	86.27	8200.0

> showing 50 of 395 rows — these rows as CSV

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