PREVIEW / etf_1hour / 2004-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-30.parquet
  size:    24 KB
  rows:    680

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-07-30 08:00:00	SPY	ETF	110.44	110.52	110.13	110.22	327300.0
2004-07-30 09:00:00	SPY	ETF	110.22	110.49	110.22	110.32	4214300.0
2004-07-30 10:00:00	SPY	ETF	110.31	110.7	110.16	110.63	8675800.0
2004-07-30 11:00:00	SPY	ETF	110.63	110.85	110.4	110.46	3668300.0
2004-07-30 12:00:00	SPY	ETF	110.43	110.7	110.43	110.56	2407300.0
2004-07-30 13:00:00	SPY	ETF	110.56	110.61	110.18	110.25	3345900.0
2004-07-30 14:00:00	SPY	ETF	110.25	110.55	110.18	110.31	4056000.0
2004-07-30 15:00:00	SPY	ETF	110.28	110.68	110.1	110.67	7052700.0
2004-07-30 16:00:00	SPY	ETF	110.68	110.9	110.54	110.8	3671100.0
2004-07-30 17:00:00	SPY	ETF	110.82	110.85	110.76	110.83	50900.0
2004-07-30 18:00:00	SPY	ETF	110.8	110.85	110.77	110.85	2500.0
2004-07-30 08:00:00	QQQ	ETF	34.76	34.78	34.63	34.71	491100.0
2004-07-30 09:00:00	QQQ	ETF	34.7	34.8	34.65	34.68	9609800.0
2004-07-30 10:00:00	QQQ	ETF	34.68	35.04	34.65	34.99	17535300.0
2004-07-30 11:00:00	QQQ	ETF	34.99	35.1	34.87	34.92	10755400.0
2004-07-30 12:00:00	QQQ	ETF	34.92	35.07	34.9	35.041	6369300.0
2004-07-30 13:00:00	QQQ	ETF	35.04	35.06	34.85	34.88	7589100.0
2004-07-30 14:00:00	QQQ	ETF	34.88	35.01	34.83	34.87	8739600.0
2004-07-30 15:00:00	QQQ	ETF	34.86	34.931	34.705	34.851	15370400.0
2004-07-30 16:00:00	QQQ	ETF	34.85	34.943	34.76	34.87	3857300.0
2004-07-30 17:00:00	QQQ	ETF	34.89	34.94	34.89	34.94	45400.0
2004-07-30 18:00:00	QQQ	ETF	34.92	34.93	34.9	34.9	11500.0
2004-07-30 19:00:00	QQQ	ETF	34.9	34.94	34.9	34.93	3200.0
2004-07-30 08:00:00	IWM	ETF	54.375	54.455	54.375	54.38	19000.0
2004-07-30 09:00:00	IWM	ETF	54.475	54.815	54.475	54.625	1325800.0
2004-07-30 10:00:00	IWM	ETF	54.59	54.95	54.515	54.935	1780000.0
2004-07-30 11:00:00	IWM	ETF	54.95	55.075	54.81	54.86	810400.0
2004-07-30 12:00:00	IWM	ETF	54.875	55.045	54.845	55.01	305400.0
2004-07-30 13:00:00	IWM	ETF	54.995	55.02	54.765	54.85	950400.0
2004-07-30 14:00:00	IWM	ETF	54.86	55.055	54.745	54.84	1428000.0
2004-07-30 15:00:00	IWM	ETF	54.84	55.065	54.635	54.815	3596800.0
2004-07-30 16:00:00	IWM	ETF	54.815	55.035	54.65	54.65	1241400.0
2004-07-30 08:00:00	DIA	ETF	101.49	101.49	101.18	101.25	54100.0
2004-07-30 09:00:00	DIA	ETF	101.3	101.55	101.3	101.36	326400.0
2004-07-30 10:00:00	DIA	ETF	101.36	101.62	101.21	101.53	880000.0
2004-07-30 11:00:00	DIA	ETF	101.54	101.72	101.35	101.39	380400.0
2004-07-30 12:00:00	DIA	ETF	101.38	101.62	101.38	101.46	228400.0
2004-07-30 13:00:00	DIA	ETF	101.47	101.5	101.1	101.18	378000.0
2004-07-30 14:00:00	DIA	ETF	101.15	101.42	101.12	101.18	388200.0
2004-07-30 15:00:00	DIA	ETF	101.2	101.62	101.06	101.6	976100.0
2004-07-30 16:00:00	DIA	ETF	101.57	101.8	101.56	101.8	58300.0
2004-07-30 17:00:00	DIA	ETF	101.75	101.75	101.75	101.75	900.0
2004-07-30 19:00:00	DIA	ETF	101.77	101.77	101.77	101.77	100.0
2004-07-30 08:00:00	TLT	ETF	83.95	83.95	83.95	83.95	15000.0
2004-07-30 09:00:00	TLT	ETF	84.1	84.17	84.0	84.1	44500.0
2004-07-30 10:00:00	TLT	ETF	84.13	84.26	84.0	84.18	24600.0
2004-07-30 11:00:00	TLT	ETF	84.15	84.47	84.15	84.47	79000.0
2004-07-30 12:00:00	TLT	ETF	84.47	84.47	84.41	84.42	19500.0
2004-07-30 13:00:00	TLT	ETF	84.42	84.62	84.42	84.62	27700.0
2004-07-30 14:00:00	TLT	ETF	84.62	84.62	84.56	84.59	201600.0

> showing 50 of 680 rows — these rows as CSV

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