PREVIEW / etf_1hour / 2004-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-04.parquet
  size:    25 KB
  rows:    676

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-05-04 08:00:00	SPY	ETF	112.3	112.41	112.3	112.31	42300.0
2004-05-04 09:00:00	SPY	ETF	112.33	112.35	112.08	112.26	4731400.0
2004-05-04 10:00:00	SPY	ETF	112.28	112.43	112.11	112.2	3599100.0
2004-05-04 11:00:00	SPY	ETF	112.2	112.3	111.91	111.92	3886800.0
2004-05-04 12:00:00	SPY	ETF	111.96	111.99	111.66	111.81	3469000.0
2004-05-04 13:00:00	SPY	ETF	111.81	112.11	111.78	112.05	2414500.0
2004-05-04 14:00:00	SPY	ETF	112.03	113.26	111.7	113.21	16063700.0
2004-05-04 15:00:00	SPY	ETF	113.2	113.25	111.95	112.36	12919200.0
2004-05-04 16:00:00	SPY	ETF	112.34	112.93	112.03	112.05	1675800.0
2004-05-04 17:00:00	SPY	ETF	112.05	112.5424	112.02	112.07	67000.0
2004-05-04 18:00:00	SPY	ETF	112.14	112.14	112.05	112.07	3100.0
2004-05-04 19:00:00	SPY	ETF	112.12	112.14	112.12	112.14	3700.0
2004-05-04 08:00:00	QQQ	ETF	35.25	35.27	35.23	35.24	37000.0
2004-05-04 09:00:00	QQQ	ETF	35.25	35.33	35.16	35.24	11192900.0
2004-05-04 10:00:00	QQQ	ETF	35.25	35.36	35.18	35.27	14119700.0
2004-05-04 11:00:00	QQQ	ETF	35.272	35.29	35.1	35.15	7330000.0
2004-05-04 12:00:00	QQQ	ETF	35.15	35.18	35.03	35.06	5694100.0
2004-05-04 13:00:00	QQQ	ETF	35.07	35.26	35.06	35.234	6504700.0
2004-05-04 14:00:00	QQQ	ETF	35.23	35.746	35.118	35.72	38841900.0
2004-05-04 15:00:00	QQQ	ETF	35.72	35.75	35.22	35.41	29614300.0
2004-05-04 16:00:00	QQQ	ETF	35.41	35.42	35.23	35.25	6105000.0
2004-05-04 17:00:00	QQQ	ETF	35.24	35.4855	35.201	35.25	182300.0
2004-05-04 18:00:00	QQQ	ETF	35.25	35.26	35.23	35.23	47800.0
2004-05-04 19:00:00	QQQ	ETF	35.25	35.26	35.24	35.24	16400.0
2004-05-04 08:00:00	IWM	ETF	56.345	56.44	56.345	56.405	6200.0
2004-05-04 09:00:00	IWM	ETF	56.33	56.625	56.33	56.43	921600.0
2004-05-04 10:00:00	IWM	ETF	56.45	56.62	56.33	56.5	860400.0
2004-05-04 11:00:00	IWM	ETF	56.5	56.555	56.225	56.315	1572400.0
2004-05-04 12:00:00	IWM	ETF	56.31	56.405	56.25	56.365	626200.0
2004-05-04 13:00:00	IWM	ETF	56.355	56.67	56.35	56.585	588200.0
2004-05-04 14:00:00	IWM	ETF	56.56	57.45	56.445	57.45	4230400.0
2004-05-04 15:00:00	IWM	ETF	57.45	57.46	56.46	56.67	3469200.0
2004-05-04 16:00:00	IWM	ETF	56.67	56.72	56.6	56.63	456800.0
2004-05-04 08:00:00	DIA	ETF	103.5	103.6	103.5	103.6	600.0
2004-05-04 09:00:00	DIA	ETF	103.53	103.56	103.21	103.43	899700.0
2004-05-04 10:00:00	DIA	ETF	103.42	103.56	103.27	103.33	455800.0
2004-05-04 11:00:00	DIA	ETF	103.33	103.41	103.07	103.13	677900.0
2004-05-04 12:00:00	DIA	ETF	103.13	103.13	102.9	103.0	595900.0
2004-05-04 13:00:00	DIA	ETF	103.0	103.24	102.98	103.11	717100.0
2004-05-04 14:00:00	DIA	ETF	103.09	104.14	102.91	104.07	2599100.0
2004-05-04 15:00:00	DIA	ETF	104.08	104.11	103.04	103.37	1248400.0
2004-05-04 16:00:00	DIA	ETF	103.36	103.4	103.11	103.17	342800.0
2004-05-04 17:00:00	DIA	ETF	103.18	103.22	103.17	103.17	3300.0
2004-05-04 18:00:00	DIA	ETF	103.13	103.25	103.11	103.25	400.0
2004-05-04 08:00:00	TLT	ETF	83.52	83.52	83.52	83.52	600.0
2004-05-04 09:00:00	TLT	ETF	83.63	83.63	83.54	83.58	184000.0
2004-05-04 10:00:00	TLT	ETF	83.54	83.54	83.37	83.42	130900.0
2004-05-04 11:00:00	TLT	ETF	83.4	83.46	83.33	83.34	348900.0
2004-05-04 12:00:00	TLT	ETF	83.34	83.39	83.27	83.3	121000.0
2004-05-04 13:00:00	TLT	ETF	83.36	83.39	83.27	83.28	11400.0

> showing 50 of 676 rows — these rows as CSV

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