PREVIEW / etf_1hour / 2004-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-26.parquet
  size:    24 KB
  rows:    675

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-03-26 08:00:00	SPY	ETF	111.19	111.19	111.01	111.01	19400.0
2004-03-26 09:00:00	SPY	ETF	111.01	111.37	110.83	111.16	5930600.0
2004-03-26 10:00:00	SPY	ETF	111.17	111.37	110.92	111.15	4349700.0
2004-03-26 11:00:00	SPY	ETF	111.12	111.69	111.06	111.56	5101200.0
2004-03-26 12:00:00	SPY	ETF	111.56	111.64	111.35	111.48	2900700.0
2004-03-26 13:00:00	SPY	ETF	111.48	111.61	111.33	111.34	2737600.0
2004-03-26 14:00:00	SPY	ETF	111.36	111.68	111.35	111.58	2096600.0
2004-03-26 15:00:00	SPY	ETF	111.59	111.79	111.08	111.17	7358200.0
2004-03-26 16:00:00	SPY	ETF	111.18	111.63	110.86	110.98	2270900.0
2004-03-26 17:00:00	SPY	ETF	110.9	111.0	110.9	110.9	5200.0
2004-03-26 18:00:00	SPY	ETF	110.96	110.98	110.96	110.98	500.0
2004-03-26 19:00:00	SPY	ETF	110.95	110.97	110.95	110.97	600.0
2004-03-26 08:00:00	QQQ	ETF	34.92	35.43	34.92	35.37	381600.0
2004-03-26 09:00:00	QQQ	ETF	35.36	35.53	35.24	35.464	11640100.0
2004-03-26 10:00:00	QQQ	ETF	35.464	35.54	35.25	35.37	14021900.0
2004-03-26 11:00:00	QQQ	ETF	35.372	35.58	35.36	35.45	12372600.0
2004-03-26 12:00:00	QQQ	ETF	35.45	35.5	35.39	35.45	6113400.0
2004-03-26 13:00:00	QQQ	ETF	35.45	35.52	35.36	35.387	5543300.0
2004-03-26 14:00:00	QQQ	ETF	35.385	35.5	35.37	35.477	5376700.0
2004-03-26 15:00:00	QQQ	ETF	35.47	35.583	35.26	35.27	13033900.0
2004-03-26 16:00:00	QQQ	ETF	35.28	35.35	35.2	35.28	2703800.0
2004-03-26 17:00:00	QQQ	ETF	35.29	35.37	35.28	35.35	121800.0
2004-03-26 18:00:00	QQQ	ETF	35.35	35.37	35.3	35.31	7700.0
2004-03-26 19:00:00	QQQ	ETF	35.32	35.36	35.3	35.36	5600.0
2004-03-26 08:00:00	IWM	ETF	57.04	57.075	57.025	57.025	7200.0
2004-03-26 09:00:00	IWM	ETF	56.905	57.225	56.795	57.14	1234400.0
2004-03-26 10:00:00	IWM	ETF	57.125	57.245	57.005	57.15	1166200.0
2004-03-26 11:00:00	IWM	ETF	57.15	57.465	57.11	57.355	1896200.0
2004-03-26 12:00:00	IWM	ETF	57.37	57.415	57.2	57.275	679600.0
2004-03-26 13:00:00	IWM	ETF	57.275	57.32	57.175	57.185	453000.0
2004-03-26 14:00:00	IWM	ETF	57.185	57.345	57.175	57.315	1289600.0
2004-03-26 15:00:00	IWM	ETF	57.3	57.45	56.99	57.025	2270000.0
2004-03-26 16:00:00	IWM	ETF	57.055	57.125	56.95	56.95	760000.0
2004-03-26 08:00:00	DIA	ETF	102.26	102.32	102.2	102.21	15500.0
2004-03-26 09:00:00	DIA	ETF	102.19	102.35	101.87	102.2	635000.0
2004-03-26 10:00:00	DIA	ETF	102.19	102.38	102.05	102.2	1128400.0
2004-03-26 11:00:00	DIA	ETF	102.19	102.74	102.12	102.61	776700.0
2004-03-26 12:00:00	DIA	ETF	102.63	102.7	102.43	102.49	225600.0
2004-03-26 13:00:00	DIA	ETF	102.49	102.62	102.39	102.42	169100.0
2004-03-26 14:00:00	DIA	ETF	102.4	102.73	102.4	102.66	346100.0
2004-03-26 15:00:00	DIA	ETF	102.66	102.85	102.27	102.31	1319600.0
2004-03-26 16:00:00	DIA	ETF	102.33	102.38	102.17	102.25	103000.0
2004-03-26 17:00:00	DIA	ETF	102.2	102.25	102.2	102.25	2900.0
2004-03-26 18:00:00	DIA	ETF	102.31	102.31	102.24	102.25	400.0
2004-03-26 19:00:00	DIA	ETF	102.24	102.24	102.24	102.24	100.0
2004-03-26 09:00:00	TLT	ETF	90.48	90.6	90.42	90.42	145000.0
2004-03-26 10:00:00	TLT	ETF	90.42	90.45	90.18	90.19	165100.0
2004-03-26 11:00:00	TLT	ETF	90.19	90.23	89.7	89.86	280600.0
2004-03-26 12:00:00	TLT	ETF	89.88	89.95	89.6	89.8	163100.0
2004-03-26 13:00:00	TLT	ETF	89.8	89.8	89.65	89.7	46100.0

> showing 50 of 675 rows — these rows as CSV

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