PREVIEW / etf_1hour / 2005-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-28.parquet
  size:    29 KB
  rows:    825

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-28 08:00:00	SPY	ETF	121.45	121.45	121.14	121.18	179800.0
2005-02-28 09:00:00	SPY	ETF	121.16	121.24	121.04	121.14	6191500.0
2005-02-28 10:00:00	SPY	ETF	121.13	121.3	120.97	121.22	10616700.0
2005-02-28 11:00:00	SPY	ETF	121.22	121.26	120.84	120.86	7422400.0
2005-02-28 12:00:00	SPY	ETF	120.85	120.87	120.28	120.45	11885000.0
2005-02-28 13:00:00	SPY	ETF	120.44	120.51	120.2	120.23	6488900.0
2005-02-28 14:00:00	SPY	ETF	120.23	120.61	120.05	120.59	8559600.0
2005-02-28 15:00:00	SPY	ETF	120.58	121.04	120.53	120.53	13292000.0
2005-02-28 16:00:00	SPY	ETF	120.48	120.8	120.48	120.67	2958000.0
2005-02-28 17:00:00	SPY	ETF	120.68	120.68	120.64	120.64	19600.0
2005-02-28 18:00:00	SPY	ETF	120.65	120.65	120.63	120.63	5400.0
2005-02-28 19:00:00	SPY	ETF	120.64	120.64	120.64	120.64	1000.0
2005-02-28 09:00:00	QQQ	ETF	37.47	37.6	37.42	37.49	10547700.0
2005-02-28 10:00:00	QQQ	ETF	37.49	37.59	37.33	37.52	12933800.0
2005-02-28 11:00:00	QQQ	ETF	37.52	39.39	37.28	37.33	9889400.0
2005-02-28 12:00:00	QQQ	ETF	37.33	37.33	37.03	37.11	16367800.0
2005-02-28 13:00:00	QQQ	ETF	37.12	37.14	36.97	37.01	11375400.0
2005-02-28 14:00:00	QQQ	ETF	37.01	37.43	36.92	37.18	12959000.0
2005-02-28 15:00:00	QQQ	ETF	37.18	37.32	37.15	37.23	14591100.0
2005-02-28 09:00:00	IWM	ETF	63.45	63.58	63.34	63.49	2417400.0
2005-02-28 10:00:00	IWM	ETF	63.475	63.635	63.265	63.58	2356200.0
2005-02-28 11:00:00	IWM	ETF	63.57	63.59	63.17	63.192	1547600.0
2005-02-28 12:00:00	IWM	ETF	63.185	63.37	62.825	63.01	3359200.0
2005-02-28 13:00:00	IWM	ETF	63.01	63.015	62.675	62.725	2681000.0
2005-02-28 14:00:00	IWM	ETF	62.72	63.0	62.675	62.985	1589200.0
2005-02-28 15:00:00	IWM	ETF	62.985	63.355	62.95	63.07	3390800.0
2005-02-28 16:00:00	IWM	ETF	63.075	63.22	63.045	63.205	720400.0
2005-02-28 17:00:00	IWM	ETF	63.245	63.25	63.235	63.245	40600.0
2005-02-28 08:00:00	DIA	ETF	108.3	108.3	108.14	108.14	200.0
2005-02-28 09:00:00	DIA	ETF	108.14	108.15	107.98	108.09	840200.0
2005-02-28 10:00:00	DIA	ETF	108.09	108.25	107.92	108.21	1102800.0
2005-02-28 11:00:00	DIA	ETF	108.2	108.98	107.86	107.88	410000.0
2005-02-28 12:00:00	DIA	ETF	107.87	107.89	107.42	107.54	1840800.0
2005-02-28 13:00:00	DIA	ETF	107.55	107.6	107.37	107.42	636300.0
2005-02-28 14:00:00	DIA	ETF	107.41	107.71	107.26	107.69	1129900.0
2005-02-28 15:00:00	DIA	ETF	107.68	108.08	107.62	107.64	1394500.0
2005-02-28 16:00:00	DIA	ETF	107.65	107.7	107.62	107.7	17600.0
2005-02-28 09:00:00	GLD	ETF	43.68	43.69	43.62	43.63	160900.0
2005-02-28 10:00:00	GLD	ETF	43.61	43.74	43.54	43.74	214700.0
2005-02-28 11:00:00	GLD	ETF	43.74	43.74	43.6	43.66	103200.0
2005-02-28 12:00:00	GLD	ETF	43.67	43.68	43.58	43.6	70400.0
2005-02-28 13:00:00	GLD	ETF	43.6	43.64	43.58	43.62	25700.0
2005-02-28 14:00:00	GLD	ETF	43.62	43.65	43.55	43.55	79200.0
2005-02-28 15:00:00	GLD	ETF	43.56	43.57	43.52	43.52	104900.0
2005-02-28 08:00:00	TLT	ETF	90.97	90.97	90.94	90.94	5100.0
2005-02-28 09:00:00	TLT	ETF	91.08	91.1	90.9	90.9	37800.0
2005-02-28 10:00:00	TLT	ETF	90.92	91.06	90.89	90.92	197200.0
2005-02-28 11:00:00	TLT	ETF	90.9	90.9	90.37	90.43	243200.0
2005-02-28 12:00:00	TLT	ETF	90.42	90.43	90.04	90.27	602800.0
2005-02-28 13:00:00	TLT	ETF	90.37	90.37	89.94	89.94	551500.0

> showing 50 of 825 rows — these rows as CSV

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