PREVIEW / etf_1hour / 2004-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-23.parquet
  size:    24 KB
  rows:    647

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-01-23 08:00:00	SPY	ETF	114.75	114.91	114.75	114.87	229800.0
2004-01-23 09:00:00	SPY	ETF	114.87	115.16	114.86	115.003	2977200.0
2004-01-23 10:00:00	SPY	ETF	115.01	115.37	114.88	114.95	4237700.0
2004-01-23 11:00:00	SPY	ETF	114.94	115.07	114.79	115.01	3651800.0
2004-01-23 12:00:00	SPY	ETF	115.0	115.0	114.43	114.55	3145900.0
2004-01-23 13:00:00	SPY	ETF	114.54	114.67	114.3	114.31	3213600.0
2004-01-23 14:00:00	SPY	ETF	114.34	114.52	114.17	114.4	3109000.0
2004-01-23 15:00:00	SPY	ETF	114.38	114.45	113.95	114.36	7070800.0
2004-01-23 16:00:00	SPY	ETF	114.39	114.51	114.3	114.45	14328500.0
2004-01-23 17:00:00	SPY	ETF	114.38	114.46	114.35	114.35	5733500.0
2004-01-23 18:00:00	SPY	ETF	114.35	114.35	114.35	114.35	700.0
2004-01-23 19:00:00	SPY	ETF	114.28	114.28	114.28	114.28	100.0
2004-01-23 08:00:00	QQQ	ETF	38.01	38.2	38.01	38.13	126900.0
2004-01-23 09:00:00	QQQ	ETF	38.13	38.3	38.05	38.17	13677400.0
2004-01-23 10:00:00	QQQ	ETF	38.17	38.46	38.11	38.28	15596300.0
2004-01-23 11:00:00	QQQ	ETF	38.271	38.33	38.15	38.181	7466900.0
2004-01-23 12:00:00	QQQ	ETF	38.2	38.24	37.88	37.95	10515700.0
2004-01-23 13:00:00	QQQ	ETF	37.95	38.05	37.89	37.92	10070500.0
2004-01-23 14:00:00	QQQ	ETF	37.91	38.02	37.82	37.918	10698500.0
2004-01-23 15:00:00	QQQ	ETF	37.92	38.04	37.78	38.03	13865900.0
2004-01-23 16:00:00	QQQ	ETF	38.03	38.06	37.99	38.03	2442700.0
2004-01-23 17:00:00	QQQ	ETF	38.022	38.05	38.0	38.04	91000.0
2004-01-23 18:00:00	QQQ	ETF	38.04	38.04	38.02	38.02	4300.0
2004-01-23 19:00:00	QQQ	ETF	38.02	38.03	37.99	38.03	6600.0
2004-01-23 09:00:00	IWM	ETF	59.045	59.13	58.865	58.915	773000.0
2004-01-23 10:00:00	IWM	ETF	58.93	59.41	58.875	59.22	1081600.0
2004-01-23 11:00:00	IWM	ETF	59.2175	59.32	59.11	59.25	580600.0
2004-01-23 12:00:00	IWM	ETF	59.255	59.325	58.955	58.97	844200.0
2004-01-23 13:00:00	IWM	ETF	58.98	59.02	58.775	58.795	908800.0
2004-01-23 14:00:00	IWM	ETF	58.765	59.005	58.7	58.94	1437000.0
2004-01-23 15:00:00	IWM	ETF	58.915	59.345	58.755	59.325	1208600.0
2004-01-23 16:00:00	IWM	ETF	59.35	59.385	59.12	59.375	824600.0
2004-01-23 17:00:00	IWM	ETF	59.44	59.44	59.375	59.44	1400.0
2004-01-23 08:00:00	DIA	ETF	106.46	106.5	106.4	106.5	4200.0
2004-01-23 09:00:00	DIA	ETF	106.6	106.62	106.26	106.39	626800.0
2004-01-23 10:00:00	DIA	ETF	106.4	106.59	106.22	106.31	849800.0
2004-01-23 11:00:00	DIA	ETF	106.29	106.34	106.07	106.2	750800.0
2004-01-23 12:00:00	DIA	ETF	106.2	106.24	105.78	105.89	884400.0
2004-01-23 13:00:00	DIA	ETF	105.86	105.98	105.65	105.65	623300.0
2004-01-23 14:00:00	DIA	ETF	105.65	105.87	105.5	105.77	1007600.0
2004-01-23 15:00:00	DIA	ETF	105.76	105.86	105.36	105.78	1591900.0
2004-01-23 16:00:00	DIA	ETF	105.784	105.89	105.76	105.88	180700.0
2004-01-23 17:00:00	DIA	ETF	105.88	105.88	105.77	105.85	600.0
2004-01-23 18:00:00	DIA	ETF	105.84	105.84	105.84	105.84	100.0
2004-01-23 19:00:00	DIA	ETF	105.86	105.86	105.86	105.86	200.0
2004-01-23 09:00:00	TLT	ETF	88.56	88.74	88.56	88.74	54200.0
2004-01-23 10:00:00	TLT	ETF	88.73	88.85	88.67	88.85	185800.0
2004-01-23 11:00:00	TLT	ETF	88.85	88.9	88.41	88.41	58100.0
2004-01-23 12:00:00	TLT	ETF	88.4	88.44	87.56	87.7	114900.0
2004-01-23 13:00:00	TLT	ETF	87.69	87.79	87.26	87.57	253600.0

> showing 50 of 647 rows — these rows as CSV

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