PREVIEW / etf_1hour / 2003-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-15.parquet
  size:    19 KB
  rows:    470

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-10-15 08:00:00	SPY	ETF	105.7	106.05	105.68	105.9	189500.0
2003-10-15 09:00:00	SPY	ETF	105.9	105.92	105.4	105.54	7762800.0
2003-10-15 10:00:00	SPY	ETF	105.54	105.56	104.91	105.22	7844100.0
2003-10-15 11:00:00	SPY	ETF	105.2	105.3	105.05	105.12	2185100.0
2003-10-15 12:00:00	SPY	ETF	105.14	105.46	105.12	105.37	2468800.0
2003-10-15 13:00:00	SPY	ETF	105.37	105.37	105.17	105.31	2198900.0
2003-10-15 14:00:00	SPY	ETF	105.3	105.35	104.64	104.76	6420600.0
2003-10-15 15:00:00	SPY	ETF	104.76	105.2	104.67	105.01	5115600.0
2003-10-15 16:00:00	SPY	ETF	105.02	105.5	104.59	104.81	2545700.0
2003-10-15 17:00:00	SPY	ETF	104.78	104.79	104.52	104.67	180200.0
2003-10-15 18:00:00	SPY	ETF	104.65	104.67	104.6	104.67	9200.0
2003-10-15 19:00:00	SPY	ETF	104.66	104.81	104.66	104.76	12000.0
2003-10-15 08:00:00	QQQ	ETF	35.63	35.87	35.61	35.78	850000.0
2003-10-15 09:00:00	QQQ	ETF	35.79	35.85	35.48	35.6	18386600.0
2003-10-15 10:00:00	QQQ	ETF	35.61	35.62	35.23	35.418	20362400.0
2003-10-15 11:00:00	QQQ	ETF	35.419	35.45	35.32	35.37	7251600.0
2003-10-15 12:00:00	QQQ	ETF	35.37	35.515	35.37	35.48	5881800.0
2003-10-15 13:00:00	QQQ	ETF	35.47	35.48	35.35	35.438	5104700.0
2003-10-15 14:00:00	QQQ	ETF	35.44	35.48	35.03	35.12	13583200.0
2003-10-15 15:00:00	QQQ	ETF	35.12	35.31	35.09	35.21	14542300.0
2003-10-15 16:00:00	QQQ	ETF	35.21	35.81	35.01	35.08	4249100.0
2003-10-15 17:00:00	QQQ	ETF	35.08	35.08	34.87	34.96	654700.0
2003-10-15 18:00:00	QQQ	ETF	34.96	34.97	34.91	34.95	305900.0
2003-10-15 19:00:00	QQQ	ETF	34.97	35.0	34.95	34.97	17700.0
2003-10-15 08:00:00	IWM	ETF	53.4	53.44	53.4	53.44	4000.0
2003-10-15 09:00:00	IWM	ETF	53.31	53.4	52.87	52.98	1961600.0
2003-10-15 10:00:00	IWM	ETF	52.98	52.98	52.4	52.695	1899200.0
2003-10-15 11:00:00	IWM	ETF	52.7	52.875	52.695	52.765	626800.0
2003-10-15 12:00:00	IWM	ETF	52.755	53.055	52.75	53.02	990600.0
2003-10-15 13:00:00	IWM	ETF	53.025	53.025	52.9	52.955	193000.0
2003-10-15 14:00:00	IWM	ETF	52.925	53.05	52.505	52.645	957200.0
2003-10-15 15:00:00	IWM	ETF	52.65	52.725	52.505	52.527	603000.0
2003-10-15 16:00:00	IWM	ETF	52.505	52.59	52.35	52.59	542600.0
2003-10-15 08:00:00	DIA	ETF	98.68	98.97	98.65	98.83	11900.0
2003-10-15 09:00:00	DIA	ETF	98.85	98.87	98.42	98.5	639200.0
2003-10-15 10:00:00	DIA	ETF	98.49	98.5	98.01	98.23	1017500.0
2003-10-15 11:00:00	DIA	ETF	98.25	98.36	98.17	98.275	444100.0
2003-10-15 12:00:00	DIA	ETF	98.24	98.54	98.24	98.47	454000.0
2003-10-15 13:00:00	DIA	ETF	98.46	98.47	98.3	98.37	229700.0
2003-10-15 14:00:00	DIA	ETF	98.41	98.47	97.85	97.97	873200.0
2003-10-15 15:00:00	DIA	ETF	97.949	98.36	97.91	98.23	593500.0
2003-10-15 16:00:00	DIA	ETF	98.24	98.37	97.92	98.03	472400.0
2003-10-15 17:00:00	DIA	ETF	98.0	98.05	97.85	97.85	5300.0
2003-10-15 19:00:00	DIA	ETF	97.85	97.99	97.85	97.99	400.0
2003-10-15 09:00:00	TLT	ETF	83.16	83.26	83.03	83.2	33500.0
2003-10-15 10:00:00	TLT	ETF	83.18	83.29	83.01	83.12	76100.0
2003-10-15 11:00:00	TLT	ETF	83.01	83.13	82.91	83.12	63700.0
2003-10-15 12:00:00	TLT	ETF	83.03	83.14	82.85	82.86	104600.0
2003-10-15 13:00:00	TLT	ETF	82.92	83.05	82.9	83.02	33300.0
2003-10-15 14:00:00	TLT	ETF	83.02	83.3	82.95	83.2	74100.0

> showing 50 of 470 rows — these rows as CSV

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