PREVIEW / etf_1hour / 2004-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-23.parquet
  size:    25 KB
  rows:    700

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-23 08:00:00	SPY	ETF	115.18	115.23	115.18	115.22	14600.0
2004-02-23 09:00:00	SPY	ETF	115.23	115.29	114.82	114.98	5064700.0
2004-02-23 10:00:00	SPY	ETF	114.99	115.1	114.57	114.9	6471800.0
2004-02-23 11:00:00	SPY	ETF	114.9	114.92	114.35	114.43	4368100.0
2004-02-23 12:00:00	SPY	ETF	114.43	114.6	114.21	114.48	5091800.0
2004-02-23 13:00:00	SPY	ETF	114.47	114.71	114.29	114.5	2888400.0
2004-02-23 14:00:00	SPY	ETF	114.47	114.51	114.17	114.3	3500300.0
2004-02-23 15:00:00	SPY	ETF	114.3	114.68	114.29	114.55	5732100.0
2004-02-23 16:00:00	SPY	ETF	114.52	114.61	114.46	114.57	897300.0
2004-02-23 17:00:00	SPY	ETF	114.57	114.59	114.55	114.55	41600.0
2004-02-23 18:00:00	SPY	ETF	114.54	114.6	114.51	114.51	8100.0
2004-02-23 19:00:00	SPY	ETF	114.51	114.54	114.51	114.54	400.0
2004-02-23 08:00:00	QQQ	ETF	37.05	37.1	37.03	37.06	286500.0
2004-02-23 09:00:00	QQQ	ETF	37.04	37.07	36.68	36.79	16880000.0
2004-02-23 10:00:00	QQQ	ETF	36.789	36.83	36.51	36.68	19591800.0
2004-02-23 11:00:00	QQQ	ETF	36.675	36.7	36.36	36.376	15557100.0
2004-02-23 12:00:00	QQQ	ETF	36.38	36.47	36.29	36.38	12269300.0
2004-02-23 13:00:00	QQQ	ETF	36.38	36.55	36.32	36.39	12029000.0
2004-02-23 14:00:00	QQQ	ETF	36.39	36.4	36.11	36.19	18918900.0
2004-02-23 15:00:00	QQQ	ETF	36.19	36.42	36.16	36.399	22879800.0
2004-02-23 16:00:00	QQQ	ETF	36.38	36.48	36.36	36.41	2734200.0
2004-02-23 17:00:00	QQQ	ETF	36.42	36.44	36.33	36.35	251100.0
2004-02-23 18:00:00	QQQ	ETF	36.384	36.384	36.35	36.37	100600.0
2004-02-23 19:00:00	QQQ	ETF	36.37	36.42	36.37	36.42	10400.0
2004-02-23 08:00:00	IWM	ETF	58.015	58.015	58.015	58.015	800.0
2004-02-23 09:00:00	IWM	ETF	57.956	57.98	57.591	57.7	905200.0
2004-02-23 10:00:00	IWM	ETF	57.715	57.76	57.32	57.52	2132400.0
2004-02-23 11:00:00	IWM	ETF	57.515	57.525	57.07	57.095	2050600.0
2004-02-23 12:00:00	IWM	ETF	57.09	57.15	56.95	57.07	1039000.0
2004-02-23 13:00:00	IWM	ETF	57.06	57.305	57.055	57.225	1485600.0
2004-02-23 14:00:00	IWM	ETF	57.225	57.23	56.79	56.8	1160200.0
2004-02-23 15:00:00	IWM	ETF	56.81	56.9965	56.805	56.85	2179200.0
2004-02-23 16:00:00	IWM	ETF	56.85	56.971	56.835	56.835	578600.0
2004-02-23 17:00:00	IWM	ETF	56.99	56.99	56.99	56.99	200.0
2004-02-23 08:00:00	DIA	ETF	106.61	106.64	106.59	106.61	6100.0
2004-02-23 09:00:00	DIA	ETF	106.6	106.68	106.36	106.5	901000.0
2004-02-23 10:00:00	DIA	ETF	106.492	106.54	105.92	106.2	1203900.0
2004-02-23 11:00:00	DIA	ETF	106.21	106.25	105.85	105.901	990200.0
2004-02-23 12:00:00	DIA	ETF	105.9	106.07	105.74	106.02	941400.0
2004-02-23 13:00:00	DIA	ETF	106.04	106.2	105.88	106.0	607100.0
2004-02-23 14:00:00	DIA	ETF	106.02	106.1	105.83	105.93	1254800.0
2004-02-23 15:00:00	DIA	ETF	105.932	106.28	105.93	106.18	1143200.0
2004-02-23 16:00:00	DIA	ETF	106.155	106.23	106.127	106.225	49200.0
2004-02-23 17:00:00	DIA	ETF	106.2	106.2	106.2	106.2	200.0
2004-02-23 18:00:00	DIA	ETF	106.12	106.12	106.0	106.0	7600.0
2004-02-23 08:00:00	TLT	ETF	87.67	87.67	87.67	87.67	200.0
2004-02-23 09:00:00	TLT	ETF	87.39	87.46	87.32	87.46	72800.0
2004-02-23 10:00:00	TLT	ETF	87.46	87.62	87.45	87.55	90100.0
2004-02-23 11:00:00	TLT	ETF	87.55	87.59	87.48	87.57	68300.0
2004-02-23 12:00:00	TLT	ETF	87.52	87.6	87.5	87.56	21500.0

> showing 50 of 700 rows — these rows as CSV

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