PREVIEW / etf_1hour / 2003-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-31.parquet
  size:    19 KB
  rows:    515

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
2003-12-31 08:00:00	SPY	ETF	111.23	111.41	111.23	111.4	56400.0
2003-12-31 09:00:00	SPY	ETF	111.39	111.52	111.22	111.36	3483700.0
2003-12-31 10:00:00	SPY	ETF	111.37	111.45	111.04	111.12	3555000.0
2003-12-31 11:00:00	SPY	ETF	111.12	111.21	110.97	111.09	2868100.0
2003-12-31 12:00:00	SPY	ETF	111.06	111.17	111.03	111.1	1559700.0
2003-12-31 13:00:00	SPY	ETF	111.1	111.2	111.03	111.11	2942300.0
2003-12-31 14:00:00	SPY	ETF	111.07	111.13	110.84	111.07	3424800.0
2003-12-31 15:00:00	SPY	ETF	111.08	111.52	111.07	111.15	9008400.0
2003-12-31 16:00:00	SPY	ETF	111.19	111.44	111.02	111.28	3174600.0
2003-12-31 17:00:00	SPY	ETF	111.26	111.27	111.26	111.26	3000.0
2003-12-31 18:00:00	SPY	ETF	111.27	111.27	111.26	111.26	1700.0
2003-12-31 19:00:00	SPY	ETF	111.27	111.32	111.27	111.32	2100.0
2003-12-31 08:00:00	QQQ	ETF	36.58	36.67	36.52	36.64	126400.0
2003-12-31 09:00:00	QQQ	ETF	36.64	36.67	36.489	36.56	5482400.0
2003-12-31 10:00:00	QQQ	ETF	36.56	36.58	36.33	36.36	9308900.0
2003-12-31 11:00:00	QQQ	ETF	36.36	36.39	36.25	36.29	9189400.0
2003-12-31 12:00:00	QQQ	ETF	36.29	36.35	36.28	36.33	3324100.0
2003-12-31 13:00:00	QQQ	ETF	36.328	36.44	36.31	36.4	6967000.0
2003-12-31 14:00:00	QQQ	ETF	36.395	36.43	36.28	36.4	6587400.0
2003-12-31 15:00:00	QQQ	ETF	36.409	36.59	36.32	36.37	13162100.0
2003-12-31 16:00:00	QQQ	ETF	36.35	36.47	36.31	36.44	4069000.0
2003-12-31 17:00:00	QQQ	ETF	36.45	36.46	36.4	36.41	35100.0
2003-12-31 18:00:00	QQQ	ETF	36.4	36.4	36.38	36.4	12100.0
2003-12-31 19:00:00	QQQ	ETF	36.37	36.42	36.35	36.41	7900.0
2003-12-31 09:00:00	IWM	ETF	56.325	56.495	56.05	56.195	446200.0
2003-12-31 10:00:00	IWM	ETF	56.176	56.176	55.555	55.635	1647800.0
2003-12-31 11:00:00	IWM	ETF	55.635	55.75	55.575	55.725	731800.0
2003-12-31 12:00:00	IWM	ETF	55.7	55.83	55.685	55.815	511000.0
2003-12-31 13:00:00	IWM	ETF	55.815	55.825	55.74	55.8	450800.0
2003-12-31 14:00:00	IWM	ETF	55.8	55.84	55.575	55.81	760400.0
2003-12-31 15:00:00	IWM	ETF	55.81	55.975	55.4	55.425	3000600.0
2003-12-31 16:00:00	IWM	ETF	55.43	55.55	55.34	55.4	4426400.0
2003-12-31 17:00:00	IWM	ETF	55.3	55.3	55.3	55.3	200.0
2003-12-31 18:00:00	IWM	ETF	55.425	55.425	55.425	55.425	2000.0
2003-12-31 08:00:00	DIA	ETF	104.44	104.52	104.44	104.5	8300.0
2003-12-31 09:00:00	DIA	ETF	104.5	104.74	104.43	104.65	962300.0
2003-12-31 10:00:00	DIA	ETF	104.64	104.69	104.31	104.43	1498600.0
2003-12-31 11:00:00	DIA	ETF	104.41	104.48	104.25	104.38	378400.0
2003-12-31 12:00:00	DIA	ETF	104.387	104.44	104.32	104.41	211800.0
2003-12-31 13:00:00	DIA	ETF	104.38	104.49	104.29	104.38	231100.0
2003-12-31 14:00:00	DIA	ETF	104.38	104.43	104.18	104.37	411500.0
2003-12-31 15:00:00	DIA	ETF	104.39	104.73	104.39	104.52	1543500.0
2003-12-31 16:00:00	DIA	ETF	104.5	104.57	104.3	104.4	360900.0
2003-12-31 17:00:00	DIA	ETF	104.48	104.48	104.48	104.48	100.0
2003-12-31 09:00:00	TLT	ETF	85.37	85.51	85.35	85.49	32800.0
2003-12-31 10:00:00	TLT	ETF	85.48	85.57	85.4	85.47	25900.0
2003-12-31 11:00:00	TLT	ETF	85.47	85.47	85.3	85.46	66500.0
2003-12-31 12:00:00	TLT	ETF	85.49	85.49	85.4	85.44	17000.0
2003-12-31 13:00:00	TLT	ETF	85.42	85.56	85.42	85.56	13300.0
2003-12-31 14:00:00	TLT	ETF	85.56	85.56	85.52	85.55	1900.0

> showing 50 of 515 rows — these rows as CSV

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