PREVIEW / etf_1hour / 2004-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-15.parquet
  size:    25 KB
  rows:    692

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-15 08:00:00	SPY	ETF	111.57	111.85	111.49	111.7	275400.0
2004-07-15 09:00:00	SPY	ETF	111.73	111.83	111.56	111.62	3331600.0
2004-07-15 10:00:00	SPY	ETF	111.64	111.68	111.27	111.32	5006600.0
2004-07-15 11:00:00	SPY	ETF	111.32	111.48	111.13	111.34	4677800.0
2004-07-15 12:00:00	SPY	ETF	111.34	111.87	111.29	111.79	6036900.0
2004-07-15 13:00:00	SPY	ETF	111.8	111.91	111.41	111.57	3528700.0
2004-07-15 14:00:00	SPY	ETF	111.55	111.63	111.36	111.43	3182900.0
2004-07-15 15:00:00	SPY	ETF	111.42	111.5	111.01	111.04	6423900.0
2004-07-15 16:00:00	SPY	ETF	111.03	111.18	110.7	110.82	4348500.0
2004-07-15 17:00:00	SPY	ETF	110.82	110.84	110.67	110.7	134200.0
2004-07-15 18:00:00	SPY	ETF	110.7	110.8	110.7	110.79	13800.0
2004-07-15 19:00:00	SPY	ETF	110.79	110.88	110.79	110.88	4900.0
2004-07-15 08:00:00	QQQ	ETF	35.26	35.35	35.17	35.32	237000.0
2004-07-15 09:00:00	QQQ	ETF	35.31	35.443	35.26	35.27	9301600.0
2004-07-15 10:00:00	QQQ	ETF	35.279	35.33	35.1	35.213	17072000.0
2004-07-15 11:00:00	QQQ	ETF	35.21	35.34	35.16	35.293	10990800.0
2004-07-15 12:00:00	QQQ	ETF	35.293	35.49	35.28	35.447	12461500.0
2004-07-15 13:00:00	QQQ	ETF	35.46	35.48	35.26	35.362	8927700.0
2004-07-15 14:00:00	QQQ	ETF	35.37	35.41	35.28	35.32	7271400.0
2004-07-15 15:00:00	QQQ	ETF	35.33	35.36	35.18	35.19	14158100.0
2004-07-15 16:00:00	QQQ	ETF	35.19	35.3227	35.06	35.09	6079900.0
2004-07-15 17:00:00	QQQ	ETF	35.09	35.1	35.01	35.07	345200.0
2004-07-15 18:00:00	QQQ	ETF	35.06	35.1	35.031	35.1	126900.0
2004-07-15 19:00:00	QQQ	ETF	35.08	35.13	35.08	35.13	4700.0
2004-07-15 08:00:00	IWM	ETF	55.915	55.915	55.915	55.915	2000.0
2004-07-15 09:00:00	IWM	ETF	55.9	56.065	55.885	55.955	985200.0
2004-07-15 10:00:00	IWM	ETF	55.95	56.04	55.765	55.88	876000.0
2004-07-15 11:00:00	IWM	ETF	55.88	55.975	55.815	55.95	797000.0
2004-07-15 12:00:00	IWM	ETF	55.955	56.265	55.95	56.26	1376800.0
2004-07-15 13:00:00	IWM	ETF	56.265	56.29	56.05	56.135	643600.0
2004-07-15 14:00:00	IWM	ETF	56.14	56.225	56.065	56.175	353600.0
2004-07-15 15:00:00	IWM	ETF	56.165	56.17	55.91	55.93	1503800.0
2004-07-15 16:00:00	IWM	ETF	55.93	56.03	55.46	55.765	320600.0
2004-07-15 17:00:00	IWM	ETF	55.755	55.755	55.755	55.755	200.0
2004-07-15 08:00:00	DIA	ETF	102.3	102.48	102.2	102.43	44400.0
2004-07-15 09:00:00	DIA	ETF	102.43	102.54	102.32	102.35	499000.0
2004-07-15 10:00:00	DIA	ETF	102.36	102.43	102.09	102.17	806900.0
2004-07-15 11:00:00	DIA	ETF	102.15	102.26	101.94	102.13	479100.0
2004-07-15 12:00:00	DIA	ETF	102.12	102.54	102.08	102.46	752800.0
2004-07-15 13:00:00	DIA	ETF	102.45	102.54	102.15	102.26	451600.0
2004-07-15 14:00:00	DIA	ETF	102.25	102.36	102.08	102.2	384400.0
2004-07-15 15:00:00	DIA	ETF	102.21	102.25	101.85	101.89	650800.0
2004-07-15 16:00:00	DIA	ETF	101.9	101.95	101.61	101.68	389500.0
2004-07-15 17:00:00	DIA	ETF	101.65	101.74	101.65	101.7	3800.0
2004-07-15 18:00:00	DIA	ETF	101.7	101.74	101.7	101.74	1000.0
2004-07-15 19:00:00	DIA	ETF	101.74	101.74	101.74	101.74	1000.0
2004-07-15 08:00:00	TLT	ETF	84.39	84.39	84.25	84.25	5500.0
2004-07-15 09:00:00	TLT	ETF	84.29	84.35	84.29	84.33	5700.0
2004-07-15 10:00:00	TLT	ETF	84.32	84.32	84.26	84.32	35000.0
2004-07-15 11:00:00	TLT	ETF	84.32	84.36	84.25	84.36	239800.0

> showing 50 of 692 rows — these rows as CSV

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