PREVIEW / etf_1hour / 2004-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-23.parquet
  size:    25 KB
  rows:    684

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-04-23 08:00:00	SPY	ETF	114.5	114.63	114.3	114.38	93000.0
2004-04-23 09:00:00	SPY	ETF	114.39	114.48	114.0	114.22	4327000.0
2004-04-23 10:00:00	SPY	ETF	114.22	114.26	113.95	114.16	4559300.0
2004-04-23 11:00:00	SPY	ETF	114.13	114.21	113.83	113.94	3228500.0
2004-04-23 12:00:00	SPY	ETF	113.94	114.266	113.79	114.21	2672700.0
2004-04-23 13:00:00	SPY	ETF	114.21	114.38	114.01	114.28	2228800.0
2004-04-23 14:00:00	SPY	ETF	114.27	114.57	114.07	114.5	3634000.0
2004-04-23 15:00:00	SPY	ETF	114.5	114.55	114.28	114.44	4263900.0
2004-04-23 16:00:00	SPY	ETF	114.39	114.53	114.33	114.38	1536000.0
2004-04-23 17:00:00	SPY	ETF	114.33	114.42	114.3	114.3	28900.0
2004-04-23 18:00:00	SPY	ETF	114.31	114.4	114.3	114.4	2100.0
2004-04-23 08:00:00	QQQ	ETF	37.15	37.19	37.05	37.1	378100.0
2004-04-23 09:00:00	QQQ	ETF	37.09	37.21	36.95	37.17	18967100.0
2004-04-23 10:00:00	QQQ	ETF	37.164	37.23	36.95	37.05	19168900.0
2004-04-23 11:00:00	QQQ	ETF	37.049	37.1	36.9	36.96	11444200.0
2004-04-23 12:00:00	QQQ	ETF	36.95	37.12	36.91	37.086	6643300.0
2004-04-23 13:00:00	QQQ	ETF	37.088	37.144	37.0	37.1	6552500.0
2004-04-23 14:00:00	QQQ	ETF	37.1	37.2	37.01	37.17	9830800.0
2004-04-23 15:00:00	QQQ	ETF	37.172	37.22	37.08	37.205	13380500.0
2004-04-23 16:00:00	QQQ	ETF	37.2	37.26	37.15	37.19	2932700.0
2004-04-23 17:00:00	QQQ	ETF	37.1	37.21	37.1	37.17	213800.0
2004-04-23 18:00:00	QQQ	ETF	37.17	37.21	37.13	37.19	82600.0
2004-04-23 19:00:00	QQQ	ETF	37.18	37.2	37.17	37.19	28200.0
2004-04-23 08:00:00	IWM	ETF	59.2	59.2	59.13	59.13	4000.0
2004-04-23 09:00:00	IWM	ETF	59.245	59.28	58.915	59.06	1216000.0
2004-04-23 10:00:00	IWM	ETF	59.05	59.075	58.67	58.75	1920800.0
2004-04-23 11:00:00	IWM	ETF	58.77	58.835	58.345	58.4	1306600.0
2004-04-23 12:00:00	IWM	ETF	58.405	58.735	58.375	58.715	1110800.0
2004-04-23 13:00:00	IWM	ETF	58.685	58.765	58.55	58.62	595000.0
2004-04-23 14:00:00	IWM	ETF	58.615	58.85	58.525	58.775	979200.0
2004-04-23 15:00:00	IWM	ETF	58.755	58.865	58.7	58.81	549600.0
2004-04-23 16:00:00	IWM	ETF	58.78	58.92	58.75	58.825	389600.0
2004-04-23 17:00:00	IWM	ETF	58.825	58.87	58.825	58.85	47000.0
2004-04-23 08:00:00	DIA	ETF	104.96	105.03	104.74	104.77	28600.0
2004-04-23 09:00:00	DIA	ETF	104.78	104.89	104.49	104.65	781100.0
2004-04-23 10:00:00	DIA	ETF	104.66	104.7	104.34	104.49	810600.0
2004-04-23 11:00:00	DIA	ETF	104.48	104.59	104.28	104.43	528400.0
2004-04-23 12:00:00	DIA	ETF	104.43	104.74	104.35	104.67	379900.0
2004-04-23 13:00:00	DIA	ETF	104.7	104.83	104.57	104.78	386900.0
2004-04-23 14:00:00	DIA	ETF	104.74	105.01	104.59	105.0	644700.0
2004-04-23 15:00:00	DIA	ETF	104.96	105.0	104.74	104.91	644400.0
2004-04-23 16:00:00	DIA	ETF	104.87	104.96	104.85	104.94	334700.0
2004-04-23 17:00:00	DIA	ETF	104.87	104.87	104.85	104.85	500.0
2004-04-23 09:00:00	TLT	ETF	84.09	84.15	83.75	83.88	171200.0
2004-04-23 10:00:00	TLT	ETF	83.9	83.96	83.76	83.93	318300.0
2004-04-23 11:00:00	TLT	ETF	83.96	84.05	83.85	84.03	76400.0
2004-04-23 12:00:00	TLT	ETF	84.04	84.21	83.99	84.12	39800.0
2004-04-23 13:00:00	TLT	ETF	84.22	84.34	84.1	84.1	164900.0
2004-04-23 14:00:00	TLT	ETF	84.15	84.16	83.92	83.98	49000.0
2004-04-23 15:00:00	TLT	ETF	83.94	84.06	83.87	84.01	92800.0

> showing 50 of 684 rows — these rows as CSV

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