PREVIEW / etf_1hour / 2004-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-28.parquet
  size:    25 KB
  rows:    660

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-28 08:00:00	SPY	ETF	109.73	109.73	109.5	109.56	195600.0
2004-07-28 09:00:00	SPY	ETF	109.55	109.87	109.54	109.8	4733200.0
2004-07-28 10:00:00	SPY	ETF	109.79	109.84	108.86	108.99	15463900.0
2004-07-28 11:00:00	SPY	ETF	108.96	109.07	108.66	108.99	7463800.0
2004-07-28 12:00:00	SPY	ETF	108.99	108.99	108.59	108.79	5050300.0
2004-07-28 13:00:00	SPY	ETF	108.78	109.05	108.76	108.9	4118700.0
2004-07-28 14:00:00	SPY	ETF	108.88	109.54	108.75	109.49	8048200.0
2004-07-28 15:00:00	SPY	ETF	109.5	110.37	109.4	110.03	16048700.0
2004-07-28 16:00:00	SPY	ETF	110.01	110.18	109.94	110.05	1255500.0
2004-07-28 17:00:00	SPY	ETF	110.1	110.17	110.08	110.17	361600.0
2004-07-28 18:00:00	SPY	ETF	110.13	110.16	110.12	110.12	26600.0
2004-07-28 19:00:00	SPY	ETF	110.12	110.12	110.12	110.12	200.0
2004-07-28 08:00:00	QQQ	ETF	34.48	34.48	34.41	34.43	136700.0
2004-07-28 09:00:00	QQQ	ETF	34.43	34.51	34.32	34.439	12373200.0
2004-07-28 10:00:00	QQQ	ETF	34.439	34.44	33.92	33.994	35858500.0
2004-07-28 11:00:00	QQQ	ETF	33.994	34.12	33.87	34.03	19619300.0
2004-07-28 12:00:00	QQQ	ETF	34.03	34.03	33.81	33.88	15764400.0
2004-07-28 13:00:00	QQQ	ETF	33.89	34.01	33.874	33.88	8945300.0
2004-07-28 14:00:00	QQQ	ETF	33.89	34.23	33.83	34.198	17466900.0
2004-07-28 15:00:00	QQQ	ETF	34.18	34.626	34.15	34.398	30191200.0
2004-07-28 16:00:00	QQQ	ETF	34.39	34.44	34.36	34.43	3530100.0
2004-07-28 17:00:00	QQQ	ETF	34.43	34.47	34.4	34.43	611400.0
2004-07-28 18:00:00	QQQ	ETF	34.417	34.44	34.41	34.43	28600.0
2004-07-28 19:00:00	QQQ	ETF	34.4	34.42	34.4	34.42	5400.0
2004-07-28 08:00:00	IWM	ETF	54.1	54.115	54.05	54.06	59200.0
2004-07-28 09:00:00	IWM	ETF	54.07	54.07	53.75	53.9507	1598800.0
2004-07-28 10:00:00	IWM	ETF	53.95	53.95	53.225	53.37	5247200.0
2004-07-28 11:00:00	IWM	ETF	53.35	53.5	53.25	53.385	1355800.0
2004-07-28 12:00:00	IWM	ETF	53.385	53.39	53.21	53.26	682600.0
2004-07-28 13:00:00	IWM	ETF	53.255	53.465	53.25	53.39	1052600.0
2004-07-28 14:00:00	IWM	ETF	53.36	53.91	53.3	53.895	1855200.0
2004-07-28 15:00:00	IWM	ETF	53.905	54.34	53.88	54.0	6760800.0
2004-07-28 16:00:00	IWM	ETF	54.0	54.5	53.34	54.035	526600.0
2004-07-28 17:00:00	IWM	ETF	54.065	54.08	54.065	54.075	11400.0
2004-07-28 08:00:00	DIA	ETF	100.71	100.8	100.71	100.73	6000.0
2004-07-28 09:00:00	DIA	ETF	100.8	101.19	100.75	101.11	1076700.0
2004-07-28 10:00:00	DIA	ETF	101.11	101.11	100.39	100.47	1325600.0
2004-07-28 11:00:00	DIA	ETF	100.47	100.5	100.23	100.42	1374300.0
2004-07-28 12:00:00	DIA	ETF	100.42	100.43	100.07	100.25	1223700.0
2004-07-28 13:00:00	DIA	ETF	100.26	100.47	100.25	100.31	697100.0
2004-07-28 14:00:00	DIA	ETF	100.3	100.88	100.25	100.88	984700.0
2004-07-28 15:00:00	DIA	ETF	100.85	101.69	100.8	101.39	2156900.0
2004-07-28 16:00:00	DIA	ETF	101.42	101.51	101.37	101.45	28600.0
2004-07-28 17:00:00	DIA	ETF	101.45	101.45	101.42	101.42	11000.0
2004-07-28 08:00:00	TLT	ETF	83.56	83.56	83.54	83.54	12000.0
2004-07-28 09:00:00	TLT	ETF	83.22	83.32	83.05	83.06	193900.0
2004-07-28 10:00:00	TLT	ETF	83.07	83.39	83.04	83.31	70800.0
2004-07-28 11:00:00	TLT	ETF	83.31	83.47	83.31	83.34	74700.0
2004-07-28 12:00:00	TLT	ETF	83.38	83.49	83.37	83.41	35100.0
2004-07-28 13:00:00	TLT	ETF	83.45	83.45	83.28	83.37	24500.0

> showing 50 of 660 rows — these rows as CSV

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