PREVIEW / etf_1hour / 2003-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-19.parquet
  size:    18 KB
  rows:    435

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-06-19 08:00:00	SPY	ETF	101.67	101.97	101.67	101.81	56300.0
2003-06-19 09:00:00	SPY	ETF	101.76	101.76	101.29	101.3	3585000.0
2003-06-19 10:00:00	SPY	ETF	101.38	101.7	100.74	100.87	7492600.0
2003-06-19 11:00:00	SPY	ETF	100.86	100.89	100.4	100.85	5625900.0
2003-06-19 12:00:00	SPY	ETF	100.85	100.88	100.24	100.65	7742900.0
2003-06-19 13:00:00	SPY	ETF	100.653	100.78	100.51	100.569	2355200.0
2003-06-19 14:00:00	SPY	ETF	100.56	100.72	100.38	100.421	2168000.0
2003-06-19 15:00:00	SPY	ETF	100.42	100.48	99.84	100.0	6830700.0
2003-06-19 16:00:00	SPY	ETF	100.01	100.15	99.96	100.011	2919500.0
2003-06-19 17:00:00	SPY	ETF	100.04	100.11	100.0	100.11	471000.0
2003-06-19 18:00:00	SPY	ETF	100.13	100.13	100.07	100.11	4100.0
2003-06-19 19:00:00	SPY	ETF	100.06	100.06	99.9	99.92	9700.0
2003-06-19 20:00:00	SPY	ETF	99.9	99.9	99.9	99.9	200.0
2003-06-19 08:00:00	QQQ	ETF	31.01	31.1	30.99	31.01	154800.0
2003-06-19 09:00:00	QQQ	ETF	31.0	31.17	30.87	31.03	9147900.0
2003-06-19 10:00:00	QQQ	ETF	31.01	31.24	30.79	30.86	16960500.0
2003-06-19 11:00:00	QQQ	ETF	30.86	30.87	30.64	30.85	9122300.0
2003-06-19 12:00:00	QQQ	ETF	30.85	30.87	30.65	30.834	8492600.0
2003-06-19 13:00:00	QQQ	ETF	30.83	30.94	30.79	30.84	4137500.0
2003-06-19 14:00:00	QQQ	ETF	30.84	30.92	30.77	30.78	3645000.0
2003-06-19 15:00:00	QQQ	ETF	30.77	30.79	30.38	30.48	17209000.0
2003-06-19 16:00:00	QQQ	ETF	30.491	30.5	30.37	30.41	2251400.0
2003-06-19 17:00:00	QQQ	ETF	30.4	30.41	30.38	30.4	109000.0
2003-06-19 18:00:00	QQQ	ETF	30.41	30.484	30.406	30.44	73800.0
2003-06-19 19:00:00	QQQ	ETF	30.43	30.46	30.41	30.42	15800.0
2003-06-19 20:00:00	QQQ	ETF	30.42	30.42	30.42	30.42	500.0
2003-06-19 09:00:00	IWM	ETF	45.75	45.775	45.595	45.685	286400.0
2003-06-19 10:00:00	IWM	ETF	45.69	45.92	45.46	45.465	751600.0
2003-06-19 11:00:00	IWM	ETF	45.435	45.45	45.105	45.175	658400.0
2003-06-19 12:00:00	IWM	ETF	45.19	45.2	45.005	45.2	593200.0
2003-06-19 13:00:00	IWM	ETF	45.19	45.255	45.148	45.255	235000.0
2003-06-19 14:00:00	IWM	ETF	45.25	45.26	45.15	45.15	256000.0
2003-06-19 15:00:00	IWM	ETF	45.185	45.195	44.83	44.945	842600.0
2003-06-19 16:00:00	IWM	ETF	45.0	45.02	44.975	45.02	37000.0
2003-06-19 18:00:00	IWM	ETF	45.125	45.125	45.125	45.125	5000.0
2003-06-19 08:00:00	DIA	ETF	93.42	93.53	93.4	93.43	3100.0
2003-06-19 09:00:00	DIA	ETF	93.43	93.44	93.08	93.086	865000.0
2003-06-19 10:00:00	DIA	ETF	93.08	93.51	92.64	92.75	1554000.0
2003-06-19 11:00:00	DIA	ETF	92.76	92.78	92.35	92.74	1543900.0
2003-06-19 12:00:00	DIA	ETF	92.7	92.75	92.17	92.47	1603800.0
2003-06-19 13:00:00	DIA	ETF	92.49	92.67	92.38	92.47	603400.0
2003-06-19 14:00:00	DIA	ETF	92.47	92.58	92.27	92.29	741100.0
2003-06-19 15:00:00	DIA	ETF	92.3	92.35	91.84	92.05	2226300.0
2003-06-19 16:00:00	DIA	ETF	92.08	92.21	92.05	92.11	77100.0
2003-06-19 18:00:00	DIA	ETF	92.13	92.13	92.12	92.13	400.0
2003-06-19 19:00:00	DIA	ETF	92.05	92.12	92.05	92.05	2300.0
2003-06-19 09:00:00	TLT	ETF	93.96	94.07	93.73	93.75	70500.0
2003-06-19 10:00:00	TLT	ETF	93.75	94.05	93.5	93.91	142100.0
2003-06-19 11:00:00	TLT	ETF	93.91	94.08	93.8	93.8	87700.0
2003-06-19 12:00:00	TLT	ETF	93.82	94.48	93.82	94.3	94300.0

> showing 50 of 435 rows — these rows as CSV

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