PREVIEW / etf_1hour / 2005-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-11.parquet
  size:    31 KB
  rows:    947

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-08-11 07:00:00	SPY	ETF	123.5	123.53	123.46	123.46	94700.0
2005-08-11 08:00:00	SPY	ETF	123.47	123.5	123.22	123.29	511000.0
2005-08-11 09:00:00	SPY	ETF	123.29	123.51	123.24	123.42	5618600.0
2005-08-11 10:00:00	SPY	ETF	123.43	124.03	123.36	123.83	9975200.0
2005-08-11 11:00:00	SPY	ETF	123.84	123.94	123.4	123.53	8590400.0
2005-08-11 12:00:00	SPY	ETF	123.51	123.62	123.14	123.33	9175200.0
2005-08-11 13:00:00	SPY	ETF	123.32	123.48	123.19	123.3	5246200.0
2005-08-11 14:00:00	SPY	ETF	123.29	123.46	123.01	123.35	4122900.0
2005-08-11 15:00:00	SPY	ETF	123.36	124.0	123.27	123.97	10031300.0
2005-08-11 16:00:00	SPY	ETF	124.03	124.03	123.72	123.73	2397000.0
2005-08-11 17:00:00	SPY	ETF	123.75	123.79	123.72	123.78	213900.0
2005-08-11 18:00:00	SPY	ETF	123.77	123.82	123.76	123.82	8800.0
2005-08-11 19:00:00	SPY	ETF	123.8	123.82	123.77	123.82	27000.0
2005-08-11 09:00:00	QQQ	ETF	39.13	39.25	39.1	39.13	10331700.0
2005-08-11 10:00:00	QQQ	ETF	39.12	39.54	39.12	39.46	22430000.0
2005-08-11 11:00:00	QQQ	ETF	39.46	39.49	39.26	39.34	10254100.0
2005-08-11 12:00:00	QQQ	ETF	39.34	39.49	39.15	39.23	12259100.0
2005-08-11 13:00:00	QQQ	ETF	39.23	39.28	39.21	39.25	7439300.0
2005-08-11 14:00:00	QQQ	ETF	39.25	39.34	39.15	39.29	7237600.0
2005-08-11 15:00:00	QQQ	ETF	39.29	39.47	39.25	39.44	10864000.0
2005-08-11 07:00:00	IWM	ETF	65.78	65.78	65.78	65.78	200.0
2005-08-11 08:00:00	IWM	ETF	65.68	65.68	65.6	65.6	102000.0
2005-08-11 09:00:00	IWM	ETF	65.61	65.71	65.55	65.67	1904200.0
2005-08-11 10:00:00	IWM	ETF	65.67	66.27	65.662	66.11	4618200.0
2005-08-11 11:00:00	IWM	ETF	66.12	66.16	65.77	65.83	2528500.0
2005-08-11 12:00:00	IWM	ETF	65.83	65.92	65.62	65.78	1685200.0
2005-08-11 13:00:00	IWM	ETF	65.78	65.95	65.74	65.91	1951700.0
2005-08-11 14:00:00	IWM	ETF	65.91	66.06	65.69	65.98	2113200.0
2005-08-11 15:00:00	IWM	ETF	65.98	66.4	65.92	66.32	6402700.0
2005-08-11 16:00:00	IWM	ETF	66.31	66.48	66.17	66.17	267900.0
2005-08-11 17:00:00	IWM	ETF	66.17	66.21	66.13	66.21	40100.0
2005-08-11 07:00:00	DIA	ETF	106.4	106.42	106.4	106.42	1600.0
2005-08-11 08:00:00	DIA	ETF	106.36	106.38	106.19	106.19	3200.0
2005-08-11 09:00:00	DIA	ETF	106.13	106.39	106.12	106.32	429900.0
2005-08-11 10:00:00	DIA	ETF	106.34	106.89	106.29	106.72	1623500.0
2005-08-11 11:00:00	DIA	ETF	106.74	106.81	106.29	106.36	956400.0
2005-08-11 12:00:00	DIA	ETF	106.36	106.41	106.09	106.28	239700.0
2005-08-11 13:00:00	DIA	ETF	106.28	106.46	106.19	106.34	255400.0
2005-08-11 14:00:00	DIA	ETF	106.32	106.39	106.05	106.31	879900.0
2005-08-11 15:00:00	DIA	ETF	106.32	107.0	106.25	106.96	1104700.0
2005-08-11 16:00:00	DIA	ETF	106.96	106.97	106.8	106.8	111600.0
2005-08-11 17:00:00	DIA	ETF	106.87	106.9	106.87	106.9	100300.0
2005-08-11 18:00:00	DIA	ETF	106.87	106.92	106.87	106.92	1400.0
2005-08-11 19:00:00	DIA	ETF	106.95	106.95	106.95	106.95	1000.0
2005-08-11 09:00:00	GLD	ETF	43.81	44.03	43.81	44.0	235300.0
2005-08-11 10:00:00	GLD	ETF	44.0	44.18	43.93	44.13	571000.0
2005-08-11 11:00:00	GLD	ETF	44.12	44.25	44.06	44.21	285200.0
2005-08-11 12:00:00	GLD	ETF	44.21	44.62	44.2	44.51	370800.0
2005-08-11 13:00:00	GLD	ETF	44.51	44.53	44.38	44.42	362900.0
2005-08-11 14:00:00	GLD	ETF	44.41	44.42	44.33	44.38	104700.0

> showing 50 of 947 rows — these rows as CSV

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