PREVIEW / etf_1hour / 2006-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-17.parquet
  size:    39 KB
  rows:    1,215

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
2006-02-17 07:00:00	SPY	ETF	129.03	129.11	128.99	129.11	62900.0
2006-02-17 08:00:00	SPY	ETF	129.03	129.16	128.98	129.09	1256900.0
2006-02-17 09:00:00	SPY	ETF	129.09	129.2	128.8	128.9	7710500.0
2006-02-17 10:00:00	SPY	ETF	128.91	128.93	128.58	128.72	7744300.0
2006-02-17 11:00:00	SPY	ETF	128.72	128.99	128.63	128.89	6063800.0
2006-02-17 12:00:00	SPY	ETF	128.89	129.05	128.84	128.97	3589500.0
2006-02-17 13:00:00	SPY	ETF	128.98	129.14	128.88	129.02	2486300.0
2006-02-17 14:00:00	SPY	ETF	129.03	129.15	128.96	129.12	2201600.0
2006-02-17 15:00:00	SPY	ETF	129.1	129.14	128.76	128.8888	7814900.0
2006-02-17 16:00:00	SPY	ETF	128.88	128.9	128.81	128.81	698800.0
2006-02-17 17:00:00	SPY	ETF	128.8	128.82	128.7	128.73	12800.0
2006-02-17 18:00:00	SPY	ETF	128.78	128.86	128.78	128.86	3100.0
2006-02-17 19:00:00	SPY	ETF	128.86	128.86	128.86	128.86	200.0
2006-02-17 09:00:00	QQQ	ETF	41.45	41.46	41.26	41.35	16453200.0
2006-02-17 10:00:00	QQQ	ETF	41.34	41.37	41.26	41.32	13418100.0
2006-02-17 11:00:00	QQQ	ETF	41.32	41.43	41.3	41.36	7334400.0
2006-02-17 12:00:00	QQQ	ETF	41.36	41.43	41.36	41.38	6202900.0
2006-02-17 13:00:00	QQQ	ETF	41.38	41.45	41.38	41.43	5828200.0
2006-02-17 14:00:00	QQQ	ETF	41.43	41.44	41.38	41.4	4425900.0
2006-02-17 15:00:00	QQQ	ETF	41.4	41.43	41.2	41.22	20388600.0
2006-02-17 08:00:00	IWM	ETF	72.83	72.84	72.74	72.79	70200.0
2006-02-17 09:00:00	IWM	ETF	72.78	72.83	72.44	72.51	1713700.0
2006-02-17 10:00:00	IWM	ETF	72.52	72.58	72.3	72.5	3105900.0
2006-02-17 11:00:00	IWM	ETF	72.5	72.73	72.44	72.7	2276500.0
2006-02-17 12:00:00	IWM	ETF	72.71	72.86	72.66	72.74	2213300.0
2006-02-17 13:00:00	IWM	ETF	72.74	72.85	72.66	72.8	1744400.0
2006-02-17 14:00:00	IWM	ETF	72.79	72.87	72.73	72.84	1523400.0
2006-02-17 15:00:00	IWM	ETF	72.85	72.9	72.56	72.62	4130100.0
2006-02-17 16:00:00	IWM	ETF	72.62	72.71	72.55	72.6	313600.0
2006-02-17 06:00:00	DIA	ETF	111.1	111.1	111.1	111.1	100.0
2006-02-17 07:00:00	DIA	ETF	111.03	111.03	111.01	111.01	4500.0
2006-02-17 08:00:00	DIA	ETF	111.06	111.09	110.98	111.01	15900.0
2006-02-17 09:00:00	DIA	ETF	110.97	111.1	110.82	110.9	603200.0
2006-02-17 10:00:00	DIA	ETF	110.88	110.9	110.68	110.84	444600.0
2006-02-17 11:00:00	DIA	ETF	110.84	111.06	110.79	110.86	620700.0
2006-02-17 12:00:00	DIA	ETF	110.92	111.04	110.89	111.0	221400.0
2006-02-17 13:00:00	DIA	ETF	111.0	111.15	110.97	111.08	340500.0
2006-02-17 14:00:00	DIA	ETF	111.08	111.23	111.06	111.18	755600.0
2006-02-17 15:00:00	DIA	ETF	111.2	111.22	110.86	111.0	871000.0
2006-02-17 16:00:00	DIA	ETF	111.01	111.04	110.98	111.02	21900.0
2006-02-17 17:00:00	DIA	ETF	111.0	111.0	111.0	111.0	400.0
2006-02-17 18:00:00	DIA	ETF	111.04	111.1	111.04	111.1	300.0
2006-02-17 07:00:00	GLD	ETF	54.55	54.57	54.54	54.57	5800.0
2006-02-17 08:00:00	GLD	ETF	54.59	54.61	54.44	54.5	4800.0
2006-02-17 09:00:00	GLD	ETF	54.62	54.88	54.55	54.82	741100.0
2006-02-17 10:00:00	GLD	ETF	54.82	55.2	54.8	55.17	1116900.0
2006-02-17 11:00:00	GLD	ETF	55.1676	55.18	54.86	54.95	967000.0
2006-02-17 12:00:00	GLD	ETF	54.95	55.05	54.9	54.98	302600.0
2006-02-17 13:00:00	GLD	ETF	55.0	55.03	54.95	54.99	116000.0
2006-02-17 14:00:00	GLD	ETF	55.0	55.02	54.96	54.98	206800.0

> showing 50 of 1,215 rows — these rows as CSV

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