PREVIEW / etf_1hour / 2005-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-10.parquet
  size:    29 KB
  rows:    832

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-10 08:00:00	SPY	ETF	119.53	119.66	119.45	119.6	254300.0
2005-02-10 09:00:00	SPY	ETF	119.63	119.75	119.51	119.6	5118600.0
2005-02-10 10:00:00	SPY	ETF	119.61	119.81	119.38	119.46	8779200.0
2005-02-10 11:00:00	SPY	ETF	119.48	119.57	119.26	119.5	5681100.0
2005-02-10 12:00:00	SPY	ETF	119.5	119.63	119.43	119.57	4236200.0
2005-02-10 13:00:00	SPY	ETF	119.58	119.91	119.42	119.87	5900900.0
2005-02-10 14:00:00	SPY	ETF	119.86	119.94	119.59	119.79	6427300.0
2005-02-10 15:00:00	SPY	ETF	119.78	120.02	119.75	119.83	7380900.0
2005-02-10 16:00:00	SPY	ETF	119.85	119.93	119.65	119.68	922500.0
2005-02-10 17:00:00	SPY	ETF	119.68	119.71	119.66	119.71	8200.0
2005-02-10 18:00:00	SPY	ETF	119.71	119.73	119.68	119.73	1300.0
2005-02-10 19:00:00	SPY	ETF	119.78	119.88	119.78	119.84	2600.0
2005-02-10 09:00:00	QQQ	ETF	37.24	37.28	37.12	37.16	11915000.0
2005-02-10 10:00:00	QQQ	ETF	37.15	37.25	36.93	36.97	18908400.0
2005-02-10 11:00:00	QQQ	ETF	36.98	37.08	36.88	37.04	16164500.0
2005-02-10 12:00:00	QQQ	ETF	37.04	37.19	37.03	37.13	10524000.0
2005-02-10 13:00:00	QQQ	ETF	37.13	37.31	37.04	37.29	11547600.0
2005-02-10 14:00:00	QQQ	ETF	37.29	37.32	37.01	37.11	10115600.0
2005-02-10 15:00:00	QQQ	ETF	37.11	37.24	37.09	37.15	14609900.0
2005-02-10 08:00:00	IWM	ETF	62.24	62.365	62.24	62.365	8200.0
2005-02-10 09:00:00	IWM	ETF	62.375	62.5	62.315	62.326	2168400.0
2005-02-10 10:00:00	IWM	ETF	62.325	62.48	62.015	62.08	4447200.0
2005-02-10 11:00:00	IWM	ETF	62.085	62.31	61.905	62.285	4059600.0
2005-02-10 12:00:00	IWM	ETF	62.285	62.45	62.175	62.3	2356400.0
2005-02-10 13:00:00	IWM	ETF	62.305	62.6	62.21	62.575	1635600.0
2005-02-10 14:00:00	IWM	ETF	62.575	62.615	62.255	62.43	2063400.0
2005-02-10 15:00:00	IWM	ETF	62.44	62.6	62.39	62.4108	2763800.0
2005-02-10 16:00:00	IWM	ETF	62.41	62.445	62.22	62.22	421200.0
2005-02-10 17:00:00	IWM	ETF	62.23	62.25	62.23	62.25	11000.0
2005-02-10 08:00:00	DIA	ETF	106.87	107.0	106.87	106.94	3700.0
2005-02-10 09:00:00	DIA	ETF	106.97	107.09	106.93	107.01	364600.0
2005-02-10 10:00:00	DIA	ETF	107.0	107.32	106.99	107.09	1770500.0
2005-02-10 11:00:00	DIA	ETF	107.09	107.21	106.95	107.12	550800.0
2005-02-10 12:00:00	DIA	ETF	107.13	107.22	107.05	107.17	261200.0
2005-02-10 13:00:00	DIA	ETF	107.16	107.56	107.05	107.49	855200.0
2005-02-10 14:00:00	DIA	ETF	107.52	107.6	107.31	107.5	507400.0
2005-02-10 15:00:00	DIA	ETF	107.5	107.7	107.45	107.55	796800.0
2005-02-10 16:00:00	DIA	ETF	107.56	107.59	107.48	107.48	77000.0
2005-02-10 17:00:00	DIA	ETF	107.55	107.55	107.43	107.43	2800.0
2005-02-10 18:00:00	DIA	ETF	107.43	107.43	107.43	107.43	1000.0
2005-02-10 19:00:00	DIA	ETF	107.52	107.52	107.52	107.52	1000.0
2005-02-10 09:00:00	GLD	ETF	41.53	41.55	41.45	41.51	1770500.0
2005-02-10 10:00:00	GLD	ETF	41.5	41.73	41.48	41.72	2568000.0
2005-02-10 11:00:00	GLD	ETF	41.7	41.76	41.61	41.61	1245900.0
2005-02-10 12:00:00	GLD	ETF	41.61	41.8	41.61	41.79	206000.0
2005-02-10 13:00:00	GLD	ETF	41.8	41.84	41.68	41.75	322900.0
2005-02-10 14:00:00	GLD	ETF	41.75	41.8	41.72	41.79	455900.0
2005-02-10 15:00:00	GLD	ETF	41.8	41.8	41.75	41.77	191300.0
2005-02-10 16:00:00	GLD	ETF	41.72	41.8	41.71	41.8	12300.0
2005-02-10 08:00:00	TLT	ETF	93.58	93.7	93.23	93.33	61300.0

> showing 50 of 832 rows — these rows as CSV

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