PREVIEW / etf_1hour / 2003-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-25.parquet
  size:    18 KB
  rows:    431

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-09-25 08:00:00	SPY	ETF	101.33	101.53	101.25	101.51	347400.0
2003-09-25 09:00:00	SPY	ETF	101.5	101.53	101.15	101.27	6576000.0
2003-09-25 10:00:00	SPY	ETF	101.25	101.5	100.72	101.17	10236100.0
2003-09-25 11:00:00	SPY	ETF	101.18	101.71	101.14	101.622	5674100.0
2003-09-25 12:00:00	SPY	ETF	101.63	101.88	101.57	101.67	3715700.0
2003-09-25 13:00:00	SPY	ETF	101.65	101.66	101.11	101.23	3936800.0
2003-09-25 14:00:00	SPY	ETF	101.21	101.5	101.05	101.36	4266800.0
2003-09-25 15:00:00	SPY	ETF	101.37	101.59	100.54	100.59	6606000.0
2003-09-25 16:00:00	SPY	ETF	100.58	100.66	100.0	100.07	4404800.0
2003-09-25 17:00:00	SPY	ETF	100.077	100.24	100.07	100.11	569700.0
2003-09-25 18:00:00	SPY	ETF	100.21	100.21	100.13	100.16	5900.0
2003-09-25 19:00:00	SPY	ETF	100.24	100.26	100.1	100.1	10300.0
2003-09-25 08:00:00	QQQ	ETF	33.28	33.4	33.25	33.39	574800.0
2003-09-25 09:00:00	QQQ	ETF	33.39	33.47	33.2	33.341	14489200.0
2003-09-25 10:00:00	QQQ	ETF	33.34	33.48	33.09	33.34	21075500.0
2003-09-25 11:00:00	QQQ	ETF	33.37	33.676	33.34	33.63	12869300.0
2003-09-25 12:00:00	QQQ	ETF	33.64	33.74	33.54	33.58	9230200.0
2003-09-25 13:00:00	QQQ	ETF	33.61	33.61	33.29	33.36	10155200.0
2003-09-25 14:00:00	QQQ	ETF	33.36	33.59	33.27	33.49	9064300.0
2003-09-25 15:00:00	QQQ	ETF	33.49	33.61	32.96	32.979	16053600.0
2003-09-25 16:00:00	QQQ	ETF	32.99	33.01	32.63	32.64	7772500.0
2003-09-25 17:00:00	QQQ	ETF	32.65	33.65	32.64	32.692	2475900.0
2003-09-25 18:00:00	QQQ	ETF	32.69	32.71	32.65	32.69	106900.0
2003-09-25 19:00:00	QQQ	ETF	32.69	32.73	32.65	32.67	69400.0
2003-09-25 08:00:00	IWM	ETF	50.605	50.605	50.605	50.605	600.0
2003-09-25 09:00:00	IWM	ETF	50.665	50.85	50.47	50.5	632200.0
2003-09-25 10:00:00	IWM	ETF	50.505	50.58	49.79	50.015	2477000.0
2003-09-25 11:00:00	IWM	ETF	50.005	50.3	49.965	50.22	801600.0
2003-09-25 12:00:00	IWM	ETF	50.225	50.355	50.215	50.28	311800.0
2003-09-25 13:00:00	IWM	ETF	50.25	50.25	49.855	49.875	401800.0
2003-09-25 14:00:00	IWM	ETF	49.87	50.01	49.85	49.965	332600.0
2003-09-25 15:00:00	IWM	ETF	49.985	50.015	49.265	49.275	1600400.0
2003-09-25 16:00:00	IWM	ETF	49.345	49.38	49.14	49.14	326400.0
2003-09-25 08:00:00	DIA	ETF	94.57	94.68	94.49	94.68	17000.0
2003-09-25 09:00:00	DIA	ETF	94.64	94.67	94.12	94.18	643500.0
2003-09-25 10:00:00	DIA	ETF	94.18	94.37	93.72	94.02	1800200.0
2003-09-25 11:00:00	DIA	ETF	94.04	94.54	94.01	94.47	766900.0
2003-09-25 12:00:00	DIA	ETF	94.5	94.74	94.4	94.49	543100.0
2003-09-25 13:00:00	DIA	ETF	94.5	94.51	94.02	94.11	316100.0
2003-09-25 14:00:00	DIA	ETF	94.12	94.38	94.0	94.22	460400.0
2003-09-25 15:00:00	DIA	ETF	94.3	94.39	93.51	93.56	1067800.0
2003-09-25 16:00:00	DIA	ETF	93.55	93.59	93.06	93.11	476700.0
2003-09-25 17:00:00	DIA	ETF	93.08	93.28	93.08	93.27	4400.0
2003-09-25 18:00:00	DIA	ETF	93.27	93.27	93.27	93.27	200.0
2003-09-25 19:00:00	DIA	ETF	93.27	93.27	93.2	93.2	1700.0
2003-09-25 09:00:00	TLT	ETF	86.3	86.51	86.3	86.41	163600.0
2003-09-25 10:00:00	TLT	ETF	86.4	86.72	86.3	86.551	157100.0
2003-09-25 11:00:00	TLT	ETF	86.53	86.6	86.2	86.293	190800.0
2003-09-25 12:00:00	TLT	ETF	86.27	86.35	86.15	86.32	21100.0
2003-09-25 13:00:00	TLT	ETF	86.37	86.54	86.37	86.5	63700.0

> showing 50 of 431 rows — these rows as CSV

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