PREVIEW / etf_1hour / 2005-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-21.parquet
  size:    37 KB
  rows:    1,175

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-12-21 04:00:00	SPY	ETF	126.15	126.15	126.15	126.15	100.0
2005-12-21 06:00:00	SPY	ETF	126.13	126.13	126.13	126.13	5000.0
2005-12-21 07:00:00	SPY	ETF	126.15	126.22	126.15	126.2	25400.0
2005-12-21 08:00:00	SPY	ETF	126.2	126.24	126.04	126.22	1798100.0
2005-12-21 09:00:00	SPY	ETF	126.21	126.41	126.14	126.36	8974800.0
2005-12-21 10:00:00	SPY	ETF	126.36	126.66	126.279	126.63	8110800.0
2005-12-21 11:00:00	SPY	ETF	126.64	126.75	126.57	126.6	4193000.0
2005-12-21 12:00:00	SPY	ETF	126.6	126.76	126.54	126.62	4583600.0
2005-12-21 13:00:00	SPY	ETF	126.63	126.66	126.05	126.25	6782000.0
2005-12-21 14:00:00	SPY	ETF	126.24	126.41	125.8	125.87	6757700.0
2005-12-21 15:00:00	SPY	ETF	125.87	126.21	125.8	126.12	7550600.0
2005-12-21 16:00:00	SPY	ETF	126.11	126.15	126.0	126.11	919800.0
2005-12-21 17:00:00	SPY	ETF	126.1	126.1	125.7	126.03	55000.0
2005-12-21 18:00:00	SPY	ETF	126.08	126.1	126.07	126.1	31100.0
2005-12-21 19:00:00	SPY	ETF	126.1	126.13	126.09	126.13	5700.0
2005-12-21 09:00:00	QQQ	ETF	41.01	41.17	41.01	41.13	9184900.0
2005-12-21 10:00:00	QQQ	ETF	41.13	41.41	41.12	41.31	19271900.0
2005-12-21 11:00:00	QQQ	ETF	41.31	41.35	41.22	41.24	5419700.0
2005-12-21 12:00:00	QQQ	ETF	41.23	41.31	41.21	41.26	4737500.0
2005-12-21 13:00:00	QQQ	ETF	41.27	41.28	41.01	41.12	8669800.0
2005-12-21 14:00:00	QQQ	ETF	41.12	41.17	40.96	41.0	6819200.0
2005-12-21 15:00:00	QQQ	ETF	41.0	41.13	40.95	41.11	9209100.0
2005-12-21 08:00:00	IWM	ETF	67.19	67.26	67.12	67.14	31100.0
2005-12-21 09:00:00	IWM	ETF	67.16	67.75	67.08	67.57	4336100.0
2005-12-21 10:00:00	IWM	ETF	67.57	67.91	67.56	67.73	5955900.0
2005-12-21 11:00:00	IWM	ETF	67.73	67.85	67.66	67.77	2244700.0
2005-12-21 12:00:00	IWM	ETF	67.76	67.98	67.74	67.78	2447500.0
2005-12-21 13:00:00	IWM	ETF	67.79	67.84	67.38	67.53	3489900.0
2005-12-21 14:00:00	IWM	ETF	67.53	67.75	67.38	67.43	4707800.0
2005-12-21 15:00:00	IWM	ETF	67.42	67.76	67.3	67.7	4204100.0
2005-12-21 16:00:00	IWM	ETF	67.7	68.09	67.68	67.76	1006700.0
2005-12-21 17:00:00	IWM	ETF	67.78	67.78	67.78	67.78	100.0
2005-12-21 07:00:00	DIA	ETF	108.11	108.11	108.11	108.11	200.0
2005-12-21 08:00:00	DIA	ETF	108.18	108.18	108.17	108.18	9600.0
2005-12-21 09:00:00	DIA	ETF	108.18	108.52	108.08	108.41	828900.0
2005-12-21 10:00:00	DIA	ETF	108.43	108.7	108.43	108.64	1551300.0
2005-12-21 11:00:00	DIA	ETF	108.65	108.79	108.64	108.69	1358200.0
2005-12-21 12:00:00	DIA	ETF	108.69	108.84	108.62	108.73	432900.0
2005-12-21 13:00:00	DIA	ETF	108.74	108.76	108.3	108.42	404700.0
2005-12-21 14:00:00	DIA	ETF	108.4	108.52	108.0	108.02	794100.0
2005-12-21 15:00:00	DIA	ETF	108.02	108.3	107.99	108.21	493600.0
2005-12-21 16:00:00	DIA	ETF	108.18	108.23	108.13	108.14	18400.0
2005-12-21 08:00:00	GLD	ETF	49.13	49.31	49.13	49.16	35100.0
2005-12-21 09:00:00	GLD	ETF	49.17	49.2	48.92	48.95	648500.0
2005-12-21 10:00:00	GLD	ETF	48.96	49.17	48.8	49.14	1729400.0
2005-12-21 11:00:00	GLD	ETF	49.13	49.25	49.06	49.151	398200.0
2005-12-21 12:00:00	GLD	ETF	49.15	49.31	49.06	49.31	285600.0
2005-12-21 13:00:00	GLD	ETF	49.31	49.33	49.1	49.15	164900.0
2005-12-21 14:00:00	GLD	ETF	49.15	49.32	49.15	49.32	186300.0
2005-12-21 15:00:00	GLD	ETF	49.31	49.45	49.3	49.45	483900.0

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

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