PREVIEW / etf_1hour / 2003-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-17.parquet
  size:    19 KB
  rows:    505

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-17 08:00:00	SPY	ETF	108.09	108.16	108.09	108.1	13000.0
2003-12-17 09:00:00	SPY	ETF	108.09	108.13	107.8	107.95	2808500.0
2003-12-17 10:00:00	SPY	ETF	107.94	108.15	107.86	108.08	3770600.0
2003-12-17 11:00:00	SPY	ETF	108.08	108.2	108.0	108.04	2332400.0
2003-12-17 12:00:00	SPY	ETF	108.04	108.14	107.88	107.92	1830400.0
2003-12-17 13:00:00	SPY	ETF	107.92	108.0	107.8	107.88	1650200.0
2003-12-17 14:00:00	SPY	ETF	107.88	108.25	107.87	108.08	4552600.0
2003-12-17 15:00:00	SPY	ETF	108.09	108.38	107.94	108.34	4062800.0
2003-12-17 16:00:00	SPY	ETF	108.34	108.55	108.33	108.45	899700.0
2003-12-17 17:00:00	SPY	ETF	108.45	108.48	108.41	108.42	127700.0
2003-12-17 18:00:00	SPY	ETF	108.42	108.48	108.42	108.47	4300.0
2003-12-17 19:00:00	SPY	ETF	108.47	108.48	108.47	108.48	900.0
2003-12-17 08:00:00	QQQ	ETF	34.84	34.9	34.81	34.86	120900.0
2003-12-17 09:00:00	QQQ	ETF	34.85	34.86	34.627	34.727	11828200.0
2003-12-17 10:00:00	QQQ	ETF	34.73	34.91	34.62	34.87	12967700.0
2003-12-17 11:00:00	QQQ	ETF	34.87	35.0	34.747	34.803	8139900.0
2003-12-17 12:00:00	QQQ	ETF	34.81	34.84	34.64	34.69	6281900.0
2003-12-17 13:00:00	QQQ	ETF	34.66	34.72	34.574	34.608	5692600.0
2003-12-17 14:00:00	QQQ	ETF	34.61	34.85	34.6	34.7	9286000.0
2003-12-17 15:00:00	QQQ	ETF	34.7	34.86	34.63	34.8	8215600.0
2003-12-17 16:00:00	QQQ	ETF	34.8	34.94	34.79	34.91	1990000.0
2003-12-17 17:00:00	QQQ	ETF	34.91	34.92	34.81	34.88	2222800.0
2003-12-17 18:00:00	QQQ	ETF	34.87	34.9	34.87	34.9	28900.0
2003-12-17 19:00:00	QQQ	ETF	34.91	34.92	34.91	34.92	4300.0
2003-12-17 09:00:00	IWM	ETF	53.6	53.6	53.015	53.095	1065000.0
2003-12-17 10:00:00	IWM	ETF	53.095	53.409	53.06	53.355	1145400.0
2003-12-17 11:00:00	IWM	ETF	53.37	53.465	53.275	53.39	534800.0
2003-12-17 12:00:00	IWM	ETF	53.39	53.39	53.18	53.255	336200.0
2003-12-17 13:00:00	IWM	ETF	53.255	53.255	53.08	53.1845	816400.0
2003-12-17 14:00:00	IWM	ETF	53.175	53.455	53.175	53.37	553600.0
2003-12-17 15:00:00	IWM	ETF	53.395	53.655	53.318	53.5	1464000.0
2003-12-17 16:00:00	IWM	ETF	53.495	53.615	53.495	53.56	672400.0
2003-12-17 17:00:00	IWM	ETF	53.725	53.725	53.725	53.725	200.0
2003-12-17 08:00:00	DIA	ETF	101.32	101.4	101.26	101.35	3100.0
2003-12-17 09:00:00	DIA	ETF	101.35	101.35	101.11	101.24	684500.0
2003-12-17 10:00:00	DIA	ETF	101.24	101.45	101.2	101.35	1017700.0
2003-12-17 11:00:00	DIA	ETF	101.38	101.49	101.3	101.39	601900.0
2003-12-17 12:00:00	DIA	ETF	101.39	101.43	101.2	101.249	437100.0
2003-12-17 13:00:00	DIA	ETF	101.28	101.32	101.12	101.22	213900.0
2003-12-17 14:00:00	DIA	ETF	101.23	101.58	101.23	101.42	548700.0
2003-12-17 15:00:00	DIA	ETF	101.46	101.69	101.3	101.64	782700.0
2003-12-17 16:00:00	DIA	ETF	101.626	101.86	101.62	101.83	289700.0
2003-12-17 17:00:00	DIA	ETF	101.85	101.85	101.8	101.82	1600.0
2003-12-17 18:00:00	DIA	ETF	101.83	101.84	101.83	101.84	400.0
2003-12-17 19:00:00	DIA	ETF	101.77	101.77	101.77	101.77	1100.0
2003-12-17 09:00:00	TLT	ETF	86.2	86.48	86.2	86.3	108600.0
2003-12-17 10:00:00	TLT	ETF	86.32	86.39	86.23	86.36	50800.0
2003-12-17 11:00:00	TLT	ETF	86.31	86.37	86.26	86.34	33200.0
2003-12-17 12:00:00	TLT	ETF	86.34	86.56	86.33	86.53	109200.0
2003-12-17 13:00:00	TLT	ETF	86.54	86.65	86.48	86.48	37400.0

> showing 50 of 505 rows — these rows as CSV

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