PREVIEW / etf_1hour / 2003-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-10.parquet
  size:    18 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-11-10 08:00:00	SPY	ETF	105.75	105.8	105.58	105.64	30900.0
2003-11-10 09:00:00	SPY	ETF	105.7	105.84	105.58	105.77	3427600.0
2003-11-10 10:00:00	SPY	ETF	105.741	105.75	105.34	105.5	6048400.0
2003-11-10 11:00:00	SPY	ETF	105.53	105.63	105.27	105.28	2425300.0
2003-11-10 12:00:00	SPY	ETF	105.29	105.44	105.27	105.35	1500400.0
2003-11-10 13:00:00	SPY	ETF	105.36	105.56	105.27	105.53	1975100.0
2003-11-10 14:00:00	SPY	ETF	105.55	105.56	105.22	105.4	1915100.0
2003-11-10 15:00:00	SPY	ETF	105.37	105.49	105.01	105.18	4451500.0
2003-11-10 16:00:00	SPY	ETF	105.14	105.27	105.13	105.19	1580900.0
2003-11-10 17:00:00	SPY	ETF	105.19	105.52	105.19	105.23	103400.0
2003-11-10 18:00:00	SPY	ETF	105.24	105.24	105.21	105.22	6300.0
2003-11-10 19:00:00	SPY	ETF	105.2	105.2	105.2	105.2	200.0
2003-11-10 08:00:00	QQQ	ETF	35.66	35.73	35.65	35.66	91400.0
2003-11-10 09:00:00	QQQ	ETF	35.68	35.743	35.6	35.73	7579400.0
2003-11-10 10:00:00	QQQ	ETF	35.72	35.74	35.45	35.53	14021800.0
2003-11-10 11:00:00	QQQ	ETF	35.54	35.57	35.37	35.4	7042400.0
2003-11-10 12:00:00	QQQ	ETF	35.42	35.46	35.358	35.43	4633200.0
2003-11-10 13:00:00	QQQ	ETF	35.43	35.53	35.36	35.482	6900800.0
2003-11-10 14:00:00	QQQ	ETF	35.48	35.5	35.32	35.38	6177200.0
2003-11-10 15:00:00	QQQ	ETF	35.38	35.44	35.1	35.182	12009500.0
2003-11-10 16:00:00	QQQ	ETF	35.19	35.26	35.16	35.23	2151600.0
2003-11-10 17:00:00	QQQ	ETF	35.223	35.246	35.18	35.19	90000.0
2003-11-10 18:00:00	QQQ	ETF	35.19	35.22	35.19	35.22	38000.0
2003-11-10 19:00:00	QQQ	ETF	35.21	35.23	35.21	35.23	1200.0
2003-11-10 09:00:00	IWM	ETF	54.135	54.26	54.074	54.16	344400.0
2003-11-10 10:00:00	IWM	ETF	54.116	54.15	53.595	53.755	894600.0
2003-11-10 11:00:00	IWM	ETF	53.76	53.805	53.525	53.53	551400.0
2003-11-10 12:00:00	IWM	ETF	53.5	53.6	53.475	53.57	344600.0
2003-11-10 13:00:00	IWM	ETF	53.55	53.745	53.55	53.745	241400.0
2003-11-10 14:00:00	IWM	ETF	53.745	53.775	53.45	53.55	737000.0
2003-11-10 15:00:00	IWM	ETF	53.56	53.61	53.169	53.179	853400.0
2003-11-10 16:00:00	IWM	ETF	53.155	53.205	53.11	53.125	251000.0
2003-11-10 08:00:00	DIA	ETF	98.32	98.33	98.26	98.3	2000.0
2003-11-10 09:00:00	DIA	ETF	98.38	98.5	98.27	98.4	465900.0
2003-11-10 10:00:00	DIA	ETF	98.4	98.43	98.05	98.18	641800.0
2003-11-10 11:00:00	DIA	ETF	98.15	98.23	97.82	97.85	535500.0
2003-11-10 12:00:00	DIA	ETF	97.84	98.01	97.84	97.92	355200.0
2003-11-10 13:00:00	DIA	ETF	97.94	98.06	97.84	98.05	491000.0
2003-11-10 14:00:00	DIA	ETF	98.05	98.12	97.81	97.98	211800.0
2003-11-10 15:00:00	DIA	ETF	98.009	98.05	97.6	97.8	998500.0
2003-11-10 16:00:00	DIA	ETF	97.78	97.895	97.725	97.83	240000.0
2003-11-10 17:00:00	DIA	ETF	97.79	97.79	97.79	97.79	300.0
2003-11-10 09:00:00	TLT	ETF	83.6	83.7	83.6	83.66	6800.0
2003-11-10 10:00:00	TLT	ETF	83.7	83.81	83.68	83.8	37200.0
2003-11-10 11:00:00	TLT	ETF	83.79	83.84	83.71	83.8	24300.0
2003-11-10 12:00:00	TLT	ETF	83.77	83.79	83.6	83.6	27500.0
2003-11-10 13:00:00	TLT	ETF	83.63	83.64	83.44	83.44	18700.0
2003-11-10 14:00:00	TLT	ETF	83.42	83.42	83.2	83.25	326100.0
2003-11-10 15:00:00	TLT	ETF	83.28	83.53	83.28	83.44	82800.0
2003-11-10 16:00:00	TLT	ETF	83.43	83.43	83.43	83.43	26300.0

> showing 50 of 470 rows — these rows as CSV

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