PREVIEW / etf_1hour / 2004-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-27.parquet
  size:    25 KB
  rows:    698

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-02-27 08:00:00	SPY	ETF	115.2	115.36	115.2	115.32	89700.0
2004-02-27 09:00:00	SPY	ETF	115.31	115.4	115.11	115.33	3401400.0
2004-02-27 10:00:00	SPY	ETF	115.34	115.74	115.33	115.48	5737700.0
2004-02-27 11:00:00	SPY	ETF	115.48	115.61	114.63	114.86	7212900.0
2004-02-27 12:00:00	SPY	ETF	114.86	115.07	114.83	115.03	4418600.0
2004-02-27 13:00:00	SPY	ETF	115.03	115.22	114.99	115.01	2959700.0
2004-02-27 14:00:00	SPY	ETF	115.01	115.55	115.01	115.5	3510600.0
2004-02-27 15:00:00	SPY	ETF	115.52	115.55	115.02	115.08	6259800.0
2004-02-27 16:00:00	SPY	ETF	115.1	115.21	114.95	115.08	2460100.0
2004-02-27 17:00:00	SPY	ETF	115.07	115.12	115.04	115.04	2400.0
2004-02-27 18:00:00	SPY	ETF	115.05	115.05	115.04	115.04	500.0
2004-02-27 19:00:00	SPY	ETF	115.15	115.15	115.15	115.15	400.0
2004-02-27 08:00:00	QQQ	ETF	36.83	36.85	36.75	36.82	135400.0
2004-02-27 09:00:00	QQQ	ETF	36.81	36.84	36.68	36.74	8192300.0
2004-02-27 10:00:00	QQQ	ETF	36.73	36.94	36.73	36.76	18694000.0
2004-02-27 11:00:00	QQQ	ETF	36.75	36.81	36.27	36.41	19707700.0
2004-02-27 12:00:00	QQQ	ETF	36.41	36.5	36.353	36.43	9694600.0
2004-02-27 13:00:00	QQQ	ETF	36.42	36.49	36.36	36.41	6896900.0
2004-02-27 14:00:00	QQQ	ETF	36.41	36.7	36.4	36.68	12544200.0
2004-02-27 15:00:00	QQQ	ETF	36.68	36.7	36.47	36.54	15075400.0
2004-02-27 16:00:00	QQQ	ETF	36.54	36.67	36.48	36.5	3706500.0
2004-02-27 17:00:00	QQQ	ETF	36.5	36.549	36.47	36.54	89400.0
2004-02-27 18:00:00	QQQ	ETF	36.54	36.54	36.51	36.53	11500.0
2004-02-27 19:00:00	QQQ	ETF	36.52	36.53	36.5	36.5	4300.0
2004-02-27 08:00:00	IWM	ETF	58.31	58.31	58.31	58.31	1000.0
2004-02-27 09:00:00	IWM	ETF	58.275	58.275	58.085	58.22	1159800.0
2004-02-27 10:00:00	IWM	ETF	58.225	58.525	58.205	58.45	1482600.0
2004-02-27 11:00:00	IWM	ETF	58.435	58.5	57.975	58.08	1720400.0
2004-02-27 12:00:00	IWM	ETF	58.065	58.275	58.04	58.245	694600.0
2004-02-27 13:00:00	IWM	ETF	58.25	58.365	58.22	58.2205	442800.0
2004-02-27 14:00:00	IWM	ETF	58.2	58.52	58.19	58.505	634600.0
2004-02-27 15:00:00	IWM	ETF	58.505	58.55	58.15	58.16	1703000.0
2004-02-27 16:00:00	IWM	ETF	58.195	58.35	58.185	58.35	494200.0
2004-02-27 08:00:00	DIA	ETF	106.1	106.3	106.1	106.21	13000.0
2004-02-27 09:00:00	DIA	ETF	106.22	106.364	106.0	106.35	784200.0
2004-02-27 10:00:00	DIA	ETF	106.33	106.66	106.3	106.41	1052600.0
2004-02-27 11:00:00	DIA	ETF	106.38	106.51	105.737	105.9	1007800.0
2004-02-27 12:00:00	DIA	ETF	105.9	106.0	105.82	105.98	356600.0
2004-02-27 13:00:00	DIA	ETF	105.98	106.15	105.98	106.05	358400.0
2004-02-27 14:00:00	DIA	ETF	106.06	106.46	106.03	106.41	423100.0
2004-02-27 15:00:00	DIA	ETF	106.43	106.43	105.97	106.06	779800.0
2004-02-27 16:00:00	DIA	ETF	106.03	106.16	105.97	106.06	227500.0
2004-02-27 17:00:00	DIA	ETF	106.1	106.1	106.0	106.06	1400.0
2004-02-27 19:00:00	DIA	ETF	106.06	106.06	106.06	106.06	200.0
2004-02-27 09:00:00	TLT	ETF	88.22	88.27	88.17	88.17	231900.0
2004-02-27 10:00:00	TLT	ETF	88.24	88.27	87.96	88.2	154800.0
2004-02-27 11:00:00	TLT	ETF	88.2	88.25	88.15	88.2	45300.0
2004-02-27 12:00:00	TLT	ETF	88.24	88.29	88.18	88.23	100000.0
2004-02-27 13:00:00	TLT	ETF	88.19	88.3	88.19	88.28	53000.0
2004-02-27 14:00:00	TLT	ETF	88.29	88.59	88.29	88.55	143900.0

> showing 50 of 698 rows — these rows as CSV

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