PREVIEW / etf_1hour / 2004-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-27.parquet
  size:    27 KB
  rows:    756

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-10-27 08:00:00	SPY	ETF	111.47	111.53	111.34	111.47	354900.0
2004-10-27 09:00:00	SPY	ETF	111.39	111.45	111.16	111.18	6282400.0
2004-10-27 10:00:00	SPY	ETF	111.19	111.91	111.12	111.89	11766400.0
2004-10-27 11:00:00	SPY	ETF	111.9	112.43	111.86	112.32	14609200.0
2004-10-27 12:00:00	SPY	ETF	112.33	112.4	112.11	112.29	4803200.0
2004-10-27 13:00:00	SPY	ETF	112.3	112.72	112.27	112.65	9742700.0
2004-10-27 14:00:00	SPY	ETF	112.65	112.92	112.55	112.9	7002300.0
2004-10-27 15:00:00	SPY	ETF	112.9	113.1	112.76	112.96	9490200.0
2004-10-27 16:00:00	SPY	ETF	112.97	113.08	112.78	112.87	1891200.0
2004-10-27 17:00:00	SPY	ETF	112.9	112.9	112.87	112.88	7300.0
2004-10-27 18:00:00	SPY	ETF	112.88	112.95	112.88	112.95	31700.0
2004-10-27 19:00:00	SPY	ETF	112.9	112.9	112.9	112.9	1200.0
2004-10-27 08:00:00	QQQ	ETF	35.88	35.88	35.78	35.83	426400.0
2004-10-27 09:00:00	QQQ	ETF	35.83	35.893	35.75	35.76	11711800.0
2004-10-27 10:00:00	QQQ	ETF	35.751	36.34	35.71	36.3	28998800.0
2004-10-27 11:00:00	QQQ	ETF	36.338	36.693	36.3	36.6	32766200.0
2004-10-27 12:00:00	QQQ	ETF	36.59	36.64	36.484	36.61	13629700.0
2004-10-27 13:00:00	QQQ	ETF	36.61	36.79	36.6	36.71	16708300.0
2004-10-27 14:00:00	QQQ	ETF	36.71	36.78	36.67	36.78	13886500.0
2004-10-27 15:00:00	QQQ	ETF	36.78	36.89	36.72	36.79	25056500.0
2004-10-27 16:00:00	QQQ	ETF	36.771	36.8	36.697	36.7	3578400.0
2004-10-27 17:00:00	QQQ	ETF	36.71	36.74	36.7	36.71	331700.0
2004-10-27 18:00:00	QQQ	ETF	36.72	36.78	36.71	36.78	133700.0
2004-10-27 19:00:00	QQQ	ETF	36.77	36.78	36.76	36.78	29500.0
2004-10-27 08:00:00	IWM	ETF	57.71	57.755	57.675	57.755	8200.0
2004-10-27 09:00:00	IWM	ETF	57.725	57.865	57.65	57.695	2309000.0
2004-10-27 10:00:00	IWM	ETF	57.66	58.04	57.59	58.04	2913000.0
2004-10-27 11:00:00	IWM	ETF	58.08	58.3	58.05	58.21	3344800.0
2004-10-27 12:00:00	IWM	ETF	58.205	58.26	57.9	57.995	2963400.0
2004-10-27 13:00:00	IWM	ETF	57.995	58.29	57.99	58.16	1294000.0
2004-10-27 14:00:00	IWM	ETF	58.165	58.25	58.135	58.2	1427200.0
2004-10-27 15:00:00	IWM	ETF	58.23	58.59	58.16	58.495	2457400.0
2004-10-27 16:00:00	IWM	ETF	58.495	58.545	58.36	58.425	908200.0
2004-10-27 18:00:00	IWM	ETF	58.44	58.465	58.44	58.465	6400.0
2004-10-27 08:00:00	DIA	ETF	98.97	99.05	98.95	99.01	10300.0
2004-10-27 09:00:00	DIA	ETF	99.03	99.03	98.64	98.65	1059400.0
2004-10-27 10:00:00	DIA	ETF	98.67	99.25	98.62	99.22	2244300.0
2004-10-27 11:00:00	DIA	ETF	99.26	99.8	99.24	99.72	1786600.0
2004-10-27 12:00:00	DIA	ETF	99.71	99.77	99.52	99.63	839600.0
2004-10-27 13:00:00	DIA	ETF	99.63	100.02	99.63	99.95	1213400.0
2004-10-27 14:00:00	DIA	ETF	99.95	100.25	99.9	100.2	914500.0
2004-10-27 15:00:00	DIA	ETF	100.23	100.37	100.05	100.18	1872900.0
2004-10-27 16:00:00	DIA	ETF	100.18	100.28	100.08	100.08	107300.0
2004-10-27 17:00:00	DIA	ETF	100.08	100.13	100.08	100.13	900.0
2004-10-27 18:00:00	DIA	ETF	100.1	100.1	100.1	100.1	800.0
2004-10-27 09:00:00	TLT	ETF	89.82	90.05	89.82	90.01	165400.0
2004-10-27 10:00:00	TLT	ETF	90.01	90.05	89.8	89.8	205200.0
2004-10-27 11:00:00	TLT	ETF	89.79	89.79	89.46	89.53	719400.0
2004-10-27 12:00:00	TLT	ETF	89.5	89.53	89.25	89.3	376500.0
2004-10-27 13:00:00	TLT	ETF	89.29	89.29	88.95	89.02	270400.0

> showing 50 of 756 rows — these rows as CSV

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