PREVIEW / etf_1hour / 2004-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-24.parquet
  size:    25 KB
  rows:    699

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-24 08:00:00	SPY	ETF	114.35	114.35	114.09	114.16	81900.0
2004-02-24 09:00:00	SPY	ETF	114.15	114.38	114.15	114.34	6994100.0
2004-02-24 10:00:00	SPY	ETF	114.28	114.99	113.99	114.8	11262600.0
2004-02-24 11:00:00	SPY	ETF	114.81	114.88	114.47	114.6	4153100.0
2004-02-24 12:00:00	SPY	ETF	114.59	114.74	114.42	114.62	1594500.0
2004-02-24 13:00:00	SPY	ETF	114.62	114.84	114.41	114.47	2989400.0
2004-02-24 14:00:00	SPY	ETF	114.5	114.52	113.9	114.07	7528600.0
2004-02-24 15:00:00	SPY	ETF	114.07	114.49	114.05	114.45	4590500.0
2004-02-24 16:00:00	SPY	ETF	114.45	114.48	114.33	114.43	1212200.0
2004-02-24 17:00:00	SPY	ETF	114.43	114.48	114.43	114.48	3400.0
2004-02-24 18:00:00	SPY	ETF	114.48	114.48	114.46	114.46	4200.0
2004-02-24 19:00:00	SPY	ETF	114.45	114.5	114.45	114.5	1200.0
2004-02-24 08:00:00	QQQ	ETF	36.45	36.45	36.17	36.22	271400.0
2004-02-24 09:00:00	QQQ	ETF	36.22	36.34	36.15	36.32	18018500.0
2004-02-24 10:00:00	QQQ	ETF	36.32	36.65	36.1	36.53	36862100.0
2004-02-24 11:00:00	QQQ	ETF	36.53	36.6	36.37	36.44	14376000.0
2004-02-24 12:00:00	QQQ	ETF	36.44	36.56	36.36	36.41	5832300.0
2004-02-24 13:00:00	QQQ	ETF	36.413	36.59	36.38	36.45	8213700.0
2004-02-24 14:00:00	QQQ	ETF	36.452	36.46	36.15	36.22	17245200.0
2004-02-24 15:00:00	QQQ	ETF	36.23	36.4	36.2	36.38	11236600.0
2004-02-24 16:00:00	QQQ	ETF	36.39	36.42	36.329	36.4	2133700.0
2004-02-24 17:00:00	QQQ	ETF	36.39	36.43	36.382	36.41	320700.0
2004-02-24 18:00:00	QQQ	ETF	36.41	36.42	36.39	36.42	19000.0
2004-02-24 19:00:00	QQQ	ETF	36.4	36.43	36.4	36.43	7000.0
2004-02-24 08:00:00	IWM	ETF	56.785	56.785	56.65	56.655	57800.0
2004-02-24 09:00:00	IWM	ETF	56.73	56.834	56.395	56.74	1902600.0
2004-02-24 10:00:00	IWM	ETF	56.725	57.495	56.3	57.295	5674000.0
2004-02-24 11:00:00	IWM	ETF	57.245	57.27	56.905	56.98	1086200.0
2004-02-24 12:00:00	IWM	ETF	56.95	57.045	56.85	56.995	943200.0
2004-02-24 13:00:00	IWM	ETF	56.985	57.165	56.96	57.025	1070000.0
2004-02-24 14:00:00	IWM	ETF	57.025	57.025	56.655	56.755	1416000.0
2004-02-24 15:00:00	IWM	ETF	56.8	57.05	56.755	56.945	1291000.0
2004-02-24 16:00:00	IWM	ETF	56.91	56.9535	56.5	56.915	204200.0
2004-02-24 17:00:00	IWM	ETF	56.995	56.995	56.995	56.995	1000.0
2004-02-24 08:00:00	DIA	ETF	106.03	106.03	105.79	105.84	12800.0
2004-02-24 09:00:00	DIA	ETF	105.88	106.12	105.83	106.007	926900.0
2004-02-24 10:00:00	DIA	ETF	106.02	106.53	105.74	106.3	1796600.0
2004-02-24 11:00:00	DIA	ETF	106.3	106.34	105.91	106.0	1019800.0
2004-02-24 12:00:00	DIA	ETF	106.03	106.11	105.89	105.96	724000.0
2004-02-24 13:00:00	DIA	ETF	105.96	106.17	105.76	105.84	812500.0
2004-02-24 14:00:00	DIA	ETF	105.82	105.85	105.33	105.463	1531200.0
2004-02-24 15:00:00	DIA	ETF	105.49	105.85	105.48	105.84	866700.0
2004-02-24 16:00:00	DIA	ETF	105.83	105.84	105.76	105.831	65800.0
2004-02-24 17:00:00	DIA	ETF	105.84	105.84	105.84	105.84	1000.0
2004-02-24 18:00:00	DIA	ETF	105.84	105.84	105.84	105.84	200.0
2004-02-24 09:00:00	TLT	ETF	88.05	88.1	87.95	88.0	24800.0
2004-02-24 10:00:00	TLT	ETF	88.03	88.39	88.03	88.35	111500.0
2004-02-24 11:00:00	TLT	ETF	88.35	88.37	88.225	88.25	68900.0
2004-02-24 12:00:00	TLT	ETF	88.25	88.32	88.22	88.23	114100.0
2004-02-24 13:00:00	TLT	ETF	88.23	88.34	87.86	87.9	56000.0

> showing 50 of 699 rows — these rows as CSV

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