PREVIEW / etf_1hour / 2005-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-27.parquet
  size:    29 KB
  rows:    847

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-05-27 06:00:00	SPY	ETF	120.03	120.03	120.03	120.03	500.0
2005-05-27 07:00:00	SPY	ETF	120.06	120.15	120.06	120.15	161900.0
2005-05-27 08:00:00	SPY	ETF	120.15	120.19	120.1	120.17	87700.0
2005-05-27 09:00:00	SPY	ETF	120.16	120.16	119.91	120.0	4450500.0
2005-05-27 10:00:00	SPY	ETF	119.99	120.05	119.8	119.92	4331200.0
2005-05-27 11:00:00	SPY	ETF	119.93	120.07	119.92	119.98	3295400.0
2005-05-27 12:00:00	SPY	ETF	119.98	120.05	119.93	120.05	1454700.0
2005-05-27 13:00:00	SPY	ETF	120.04	120.18	119.99	120.08	3135800.0
2005-05-27 14:00:00	SPY	ETF	120.09	120.23	120.06	120.19	2098600.0
2005-05-27 15:00:00	SPY	ETF	120.19	120.25	120.02	120.18	4058200.0
2005-05-27 16:00:00	SPY	ETF	120.18	120.4	120.15	120.4	188200.0
2005-05-27 17:00:00	SPY	ETF	120.4	120.43	120.34	120.34	7300.0
2005-05-27 18:00:00	SPY	ETF	120.38	120.4	120.35	120.35	1800.0
2005-05-27 19:00:00	SPY	ETF	120.35	120.35	120.35	120.35	100.0
2005-05-27 09:00:00	QQQ	ETF	38.14	38.17	38.08	38.11	9749700.0
2005-05-27 10:00:00	QQQ	ETF	38.11	38.15	38.02	38.11	11743500.0
2005-05-27 11:00:00	QQQ	ETF	38.11	38.16	38.1	38.12	3972700.0
2005-05-27 12:00:00	QQQ	ETF	38.12	38.17	38.11	38.16	1813200.0
2005-05-27 13:00:00	QQQ	ETF	38.17	38.22	38.15	38.2	4787600.0
2005-05-27 14:00:00	QQQ	ETF	38.19	38.25	38.15	38.24	4286000.0
2005-05-27 15:00:00	QQQ	ETF	38.23	38.25	38.15	38.22	8355000.0
2005-05-27 08:00:00	IWM	ETF	61.2	61.25	61.2	61.25	6600.0
2005-05-27 09:00:00	IWM	ETF	61.275	61.3	61.025	61.11	2292200.0
2005-05-27 10:00:00	IWM	ETF	61.11	61.17	60.9	61.06	3783600.0
2005-05-27 11:00:00	IWM	ETF	61.07	61.13	61.07	61.11	766800.0
2005-05-27 12:00:00	IWM	ETF	61.11	61.245	61.095	61.235	1060200.0
2005-05-27 13:00:00	IWM	ETF	61.245	61.465	61.225	61.43	2865600.0
2005-05-27 14:00:00	IWM	ETF	61.425	61.54	61.415	61.425	1203800.0
2005-05-27 15:00:00	IWM	ETF	61.425	61.475	61.3	61.475	2351400.0
2005-05-27 16:00:00	IWM	ETF	61.47	61.495	61.41	61.495	126800.0
2005-05-27 08:00:00	DIA	ETF	105.33	105.37	105.3	105.34	4000.0
2005-05-27 09:00:00	DIA	ETF	105.34	105.37	105.15	105.28	591300.0
2005-05-27 10:00:00	DIA	ETF	105.27	105.36	105.07	105.16	447700.0
2005-05-27 11:00:00	DIA	ETF	105.18	105.26	105.17	105.17	150600.0
2005-05-27 12:00:00	DIA	ETF	105.18	105.36	105.15	105.24	115700.0
2005-05-27 13:00:00	DIA	ETF	105.24	105.36	105.23	105.31	170900.0
2005-05-27 14:00:00	DIA	ETF	105.31	105.42	105.3	105.38	182500.0
2005-05-27 15:00:00	DIA	ETF	105.36	105.44	105.25	105.34	381600.0
2005-05-27 16:00:00	DIA	ETF	105.37	105.43	105.37	105.43	1800.0
2005-05-27 18:00:00	DIA	ETF	105.43	105.43	105.43	105.43	300.0
2005-05-27 19:00:00	DIA	ETF	105.4	105.4	105.4	105.4	500.0
2005-05-27 09:00:00	GLD	ETF	41.78	41.82	41.7602	41.77	342100.0
2005-05-27 10:00:00	GLD	ETF	41.77	41.8	41.76	41.77	191900.0
2005-05-27 11:00:00	GLD	ETF	41.76	41.95	41.74	41.94	190600.0
2005-05-27 12:00:00	GLD	ETF	41.92	41.96	41.86	41.93	244900.0
2005-05-27 13:00:00	GLD	ETF	41.94	41.94	41.89	41.92	259300.0
2005-05-27 14:00:00	GLD	ETF	41.92	41.95	41.88	41.89	921100.0
2005-05-27 15:00:00	GLD	ETF	41.9	41.96	41.89	41.89	289600.0
2005-05-27 16:00:00	GLD	ETF	41.89	41.89	41.88	41.88	4000.0
2005-05-27 17:00:00	GLD	ETF	41.94	41.94	41.94	41.94	100.0

> showing 50 of 847 rows — these rows as CSV

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