PREVIEW / etf_1hour / 2005-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-18.parquet
  size:    28 KB
  rows:    831

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
2005-02-18 08:00:00	SPY	ETF	120.41	120.45	119.96	120.12	815000.0
2005-02-18 09:00:00	SPY	ETF	120.12	120.31	120.07	120.23	9286500.0
2005-02-18 10:00:00	SPY	ETF	120.23	120.44	120.09	120.25	5777000.0
2005-02-18 11:00:00	SPY	ETF	120.25	120.36	119.9	120.01	9299800.0
2005-02-18 12:00:00	SPY	ETF	120.03	120.35	120.01	120.32	4803400.0
2005-02-18 13:00:00	SPY	ETF	120.32	120.35	120.14	120.28	2346600.0
2005-02-18 14:00:00	SPY	ETF	120.28	120.42	120.23	120.3	4415100.0
2005-02-18 15:00:00	SPY	ETF	120.3	120.48	120.24	120.34	7810700.0
2005-02-18 16:00:00	SPY	ETF	120.36	120.4	120.32	120.4	1656000.0
2005-02-18 17:00:00	SPY	ETF	120.4	120.4	120.2359	120.36	785400.0
2005-02-18 18:00:00	SPY	ETF	120.39	120.39	120.39	120.39	400.0
2005-02-18 19:00:00	SPY	ETF	120.35	120.35	120.35	120.35	100.0
2005-02-18 09:00:00	QQQ	ETF	37.5	37.52	37.39	37.42	15606400.0
2005-02-18 10:00:00	QQQ	ETF	37.42	37.57	37.39	37.49	9159300.0
2005-02-18 11:00:00	QQQ	ETF	37.49	37.52	37.26	37.34	10427600.0
2005-02-18 12:00:00	QQQ	ETF	37.34	37.47	37.33	37.44	7233800.0
2005-02-18 13:00:00	QQQ	ETF	37.44	37.46	37.36	37.41	2972800.0
2005-02-18 14:00:00	QQQ	ETF	37.41	37.45	37.38	37.39	3341600.0
2005-02-18 15:00:00	QQQ	ETF	37.39	37.42	37.31	37.35	9846100.0
2005-02-18 08:00:00	IWM	ETF	62.805	62.805	62.745	62.755	24800.0
2005-02-18 09:00:00	IWM	ETF	62.8	63.11	62.77	63.055	2588400.0
2005-02-18 10:00:00	IWM	ETF	63.05	63.205	62.87	62.995	2740200.0
2005-02-18 11:00:00	IWM	ETF	62.99	63.145	62.69	62.78	2706400.0
2005-02-18 12:00:00	IWM	ETF	62.78	62.935	62.615	62.69	1740200.0
2005-02-18 13:00:00	IWM	ETF	62.685	62.725	62.5	62.63	1372400.0
2005-02-18 14:00:00	IWM	ETF	62.625	62.845	62.585	62.755	1071400.0
2005-02-18 15:00:00	IWM	ETF	62.745	62.93	62.685	62.755	2590400.0
2005-02-18 16:00:00	IWM	ETF	62.75	62.815	62.715	62.775	339400.0
2005-02-18 08:00:00	DIA	ETF	107.68	107.71	107.32	107.36	7800.0
2005-02-18 09:00:00	DIA	ETF	107.38	107.53	107.31	107.47	650400.0
2005-02-18 10:00:00	DIA	ETF	107.48	107.62	107.3	107.42	1029300.0
2005-02-18 11:00:00	DIA	ETF	107.44	107.55	107.2	107.26	985400.0
2005-02-18 12:00:00	DIA	ETF	107.25	107.51	107.25	107.51	732800.0
2005-02-18 13:00:00	DIA	ETF	107.48	107.51	107.35	107.46	379700.0
2005-02-18 14:00:00	DIA	ETF	107.47	107.64	107.45	107.56	300900.0
2005-02-18 15:00:00	DIA	ETF	107.56	107.82	107.51	107.8	721700.0
2005-02-18 16:00:00	DIA	ETF	107.77	107.81	107.73	107.77	33000.0
2005-02-18 17:00:00	DIA	ETF	107.76	107.76	107.76	107.76	200.0
2005-02-18 18:00:00	DIA	ETF	107.77	107.77	107.77	107.77	400.0
2005-02-18 19:00:00	DIA	ETF	107.79	107.79	107.79	107.79	2500.0
2005-02-18 09:00:00	GLD	ETF	42.71	42.75	42.64	42.73	137200.0
2005-02-18 10:00:00	GLD	ETF	42.73	42.8	42.67	42.74	223300.0
2005-02-18 11:00:00	GLD	ETF	42.74	42.75	42.66	42.7	102500.0
2005-02-18 12:00:00	GLD	ETF	42.7	42.78	42.7	42.78	53100.0
2005-02-18 13:00:00	GLD	ETF	42.78	42.82	42.77	42.77	178400.0
2005-02-18 14:00:00	GLD	ETF	42.77	42.79	42.76	42.77	84800.0
2005-02-18 15:00:00	GLD	ETF	42.77	42.79	42.75	42.75	83700.0
2005-02-18 08:00:00	TLT	ETF	91.23	91.25	90.7	90.8	441400.0
2005-02-18 09:00:00	TLT	ETF	90.84	90.86	90.46	90.65	1290200.0
2005-02-18 10:00:00	TLT	ETF	90.65	90.84	90.63	90.73	371600.0

> showing 50 of 831 rows — these rows as CSV

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