PREVIEW / etf_1hour / 2003-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-07.parquet
  size:    18 KB
  rows:    481

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-11-07 08:00:00	SPY	ETF	106.8	107.0	106.5	106.76	350500.0
2003-11-07 09:00:00	SPY	ETF	106.74	106.82	106.16	106.27	5960700.0
2003-11-07 10:00:00	SPY	ETF	106.27	106.6	106.15	106.38	3909200.0
2003-11-07 11:00:00	SPY	ETF	106.4	106.53	106.21	106.36	2222200.0
2003-11-07 12:00:00	SPY	ETF	106.35	106.4	106.0	106.18	2233000.0
2003-11-07 13:00:00	SPY	ETF	106.17	106.41	106.11	106.26	1918600.0
2003-11-07 14:00:00	SPY	ETF	106.26	106.54	106.09	106.2	2804800.0
2003-11-07 15:00:00	SPY	ETF	106.22	106.32	105.65	105.81	5964400.0
2003-11-07 16:00:00	SPY	ETF	105.81	105.9	105.57	105.61	2316400.0
2003-11-07 17:00:00	SPY	ETF	105.61	105.61	105.55	105.55	11000.0
2003-11-07 18:00:00	SPY	ETF	105.58	105.58	105.58	105.58	300.0
2003-11-07 19:00:00	SPY	ETF	105.55	105.6	105.55	105.6	600.0
2003-11-07 08:00:00	QQQ	ETF	36.07	36.26	36.04	36.13	630700.0
2003-11-07 09:00:00	QQQ	ETF	36.12	36.16	35.9	35.94	11194500.0
2003-11-07 10:00:00	QQQ	ETF	35.95	36.14	35.89	36.032	8802800.0
2003-11-07 11:00:00	QQQ	ETF	36.04	36.05	35.91	35.969	5250900.0
2003-11-07 12:00:00	QQQ	ETF	35.964	36.0	35.84	35.94	5373600.0
2003-11-07 13:00:00	QQQ	ETF	35.94	36.1	35.93	36.039	5491900.0
2003-11-07 14:00:00	QQQ	ETF	36.04	36.15	35.96	36.016	6200700.0
2003-11-07 15:00:00	QQQ	ETF	36.019	36.07	35.67	35.76	11089600.0
2003-11-07 16:00:00	QQQ	ETF	35.79	35.83	35.57	35.619	5150900.0
2003-11-07 17:00:00	QQQ	ETF	35.62	35.65	35.59	35.62	89400.0
2003-11-07 18:00:00	QQQ	ETF	35.639	35.639	35.61	35.63	32000.0
2003-11-07 19:00:00	QQQ	ETF	35.62	35.63	35.61	35.63	8200.0
2003-11-07 08:00:00	IWM	ETF	54.67	54.67	54.64	54.64	1800.0
2003-11-07 09:00:00	IWM	ETF	54.65	54.66	54.17	54.19	1993400.0
2003-11-07 10:00:00	IWM	ETF	54.215	54.5	54.185	54.44	487400.0
2003-11-07 11:00:00	IWM	ETF	54.475	54.475	54.285	54.39	229200.0
2003-11-07 12:00:00	IWM	ETF	54.39	54.41	54.27	54.365	286200.0
2003-11-07 13:00:00	IWM	ETF	54.345	54.475	54.345	54.405	292200.0
2003-11-07 14:00:00	IWM	ETF	54.425	54.595	54.35	54.435	786600.0
2003-11-07 15:00:00	IWM	ETF	54.45	54.475	54.065	54.1	784200.0
2003-11-07 16:00:00	IWM	ETF	54.115	54.175	53.995	53.995	294000.0
2003-11-07 08:00:00	DIA	ETF	99.18	99.51	99.08	99.33	25600.0
2003-11-07 09:00:00	DIA	ETF	99.28	99.35	98.84	98.95	759000.0
2003-11-07 10:00:00	DIA	ETF	98.91	99.15	98.82	98.97	691300.0
2003-11-07 11:00:00	DIA	ETF	98.97	99.06	98.8	98.91	358400.0
2003-11-07 12:00:00	DIA	ETF	98.92	98.92	98.56	98.68	393300.0
2003-11-07 13:00:00	DIA	ETF	98.7	98.98	98.66	98.78	540600.0
2003-11-07 14:00:00	DIA	ETF	98.81	98.99	98.66	98.69	505300.0
2003-11-07 15:00:00	DIA	ETF	98.73	98.79	98.13	98.3	838200.0
2003-11-07 16:00:00	DIA	ETF	98.3	98.39	98.11	98.19	80400.0
2003-11-07 17:00:00	DIA	ETF	98.14	98.14	98.1	98.1	1300.0
2003-11-07 18:00:00	DIA	ETF	98.1	98.1	98.1	98.1	1900.0
2003-11-07 19:00:00	DIA	ETF	98.1	98.1	98.1	98.1	300.0
2003-11-07 09:00:00	TLT	ETF	83.12	83.35	83.05	83.23	162000.0
2003-11-07 10:00:00	TLT	ETF	83.2	83.31	83.07	83.2	303000.0
2003-11-07 11:00:00	TLT	ETF	83.25	83.43	83.21	83.21	76100.0
2003-11-07 12:00:00	TLT	ETF	83.2	83.46	83.16	83.43	29700.0
2003-11-07 13:00:00	TLT	ETF	83.3	83.58	83.27	83.41	21600.0

> showing 50 of 481 rows — these rows as CSV

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