PREVIEW / etf_1hour / 2004-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-04.parquet
  size:    24 KB
  rows:    670

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
2004-08-04 08:00:00	SPY	ETF	109.82	109.84	109.71	109.79	75800.0
2004-08-04 09:00:00	SPY	ETF	109.8	110.11	109.78	110.01	4692600.0
2004-08-04 10:00:00	SPY	ETF	110.01	110.25	109.7	109.86	10093400.0
2004-08-04 11:00:00	SPY	ETF	109.82	110.04	109.64	109.94	5057300.0
2004-08-04 12:00:00	SPY	ETF	109.95	110.03	109.82	109.87	1645100.0
2004-08-04 13:00:00	SPY	ETF	109.87	110.34	109.75	110.26	4587400.0
2004-08-04 14:00:00	SPY	ETF	110.25	110.75	110.24	110.61	6359300.0
2004-08-04 15:00:00	SPY	ETF	110.61	110.71	110.25	110.28	5675600.0
2004-08-04 16:00:00	SPY	ETF	110.28	110.3	110.0	110.05	1290000.0
2004-08-04 17:00:00	SPY	ETF	110.05	110.14	110.05	110.11	50500.0
2004-08-04 18:00:00	SPY	ETF	110.15	110.19	110.1	110.19	8000.0
2004-08-04 19:00:00	SPY	ETF	110.18	110.2	110.14	110.14	52000.0
2004-08-04 08:00:00	QQQ	ETF	34.1	34.1	34.05	34.07	118300.0
2004-08-04 09:00:00	QQQ	ETF	34.08	34.31	34.07	34.29	9764400.0
2004-08-04 10:00:00	QQQ	ETF	34.283	34.35	34.086	34.09	19821800.0
2004-08-04 11:00:00	QQQ	ETF	34.09	34.23	34.01	34.2	13092300.0
2004-08-04 12:00:00	QQQ	ETF	34.21	34.23	34.09	34.12	6074900.0
2004-08-04 13:00:00	QQQ	ETF	34.12	34.33	34.055	34.3	10146800.0
2004-08-04 14:00:00	QQQ	ETF	34.3	34.461	34.29	34.405	13834900.0
2004-08-04 15:00:00	QQQ	ETF	34.409	34.45	34.24	34.27	10605900.0
2004-08-04 16:00:00	QQQ	ETF	34.26	34.3	34.174	34.21	1442800.0
2004-08-04 17:00:00	QQQ	ETF	34.227	34.28	34.2	34.26	310400.0
2004-08-04 18:00:00	QQQ	ETF	34.26	34.3	34.26	34.29	39800.0
2004-08-04 19:00:00	QQQ	ETF	34.28	34.28	34.27	34.28	12300.0
2004-08-04 08:00:00	IWM	ETF	53.695	53.695	53.695	53.695	2000.0
2004-08-04 09:00:00	IWM	ETF	53.665	53.84	53.665	53.825	2291000.0
2004-08-04 10:00:00	IWM	ETF	53.825	53.93	53.5	53.5	4283200.0
2004-08-04 11:00:00	IWM	ETF	53.505	53.57	53.35	53.53	2106600.0
2004-08-04 12:00:00	IWM	ETF	53.53	53.635	53.52	53.575	643800.0
2004-08-04 13:00:00	IWM	ETF	53.575	53.91	53.555	53.85	1855200.0
2004-08-04 14:00:00	IWM	ETF	53.855	54.495	53.85	54.36	3647400.0
2004-08-04 15:00:00	IWM	ETF	54.36	54.43	54.015	54.045	2181800.0
2004-08-04 16:00:00	IWM	ETF	54.05	54.07	53.52	53.52	516600.0
2004-08-04 17:00:00	IWM	ETF	53.97	53.97	53.97	53.97	100000.0
2004-08-04 08:00:00	DIA	ETF	100.9	100.96	100.81	100.86	10400.0
2004-08-04 09:00:00	DIA	ETF	100.91	101.13	100.87	101.06	430600.0
2004-08-04 10:00:00	DIA	ETF	101.07	101.33	100.87	101.06	1598000.0
2004-08-04 11:00:00	DIA	ETF	101.07	101.16	100.9	101.09	688800.0
2004-08-04 12:00:00	DIA	ETF	101.09	101.22	101.02	101.03	270700.0
2004-08-04 13:00:00	DIA	ETF	101.04	101.48	100.94	101.41	438700.0
2004-08-04 14:00:00	DIA	ETF	101.41	101.85	101.41	101.7	567600.0
2004-08-04 15:00:00	DIA	ETF	101.72	101.8	101.41	101.47	721900.0
2004-08-04 16:00:00	DIA	ETF	101.46	101.47	101.27	101.27	48200.0
2004-08-04 17:00:00	DIA	ETF	101.35	101.35	101.27	101.27	1200.0
2004-08-04 08:00:00	TLT	ETF	84.89	84.89	84.89	84.89	700.0
2004-08-04 09:00:00	TLT	ETF	84.76	84.76	84.6015	84.65	230100.0
2004-08-04 10:00:00	TLT	ETF	84.62	84.82	84.5	84.82	69700.0
2004-08-04 11:00:00	TLT	ETF	84.82	85.04	84.77	84.94	72400.0
2004-08-04 12:00:00	TLT	ETF	85.0	85.12	84.98	85.04	39700.0
2004-08-04 13:00:00	TLT	ETF	85.02	85.02	84.86	84.9	16900.0

> showing 50 of 670 rows — these rows as CSV

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