PREVIEW / etf_1hour / 2006-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-15.parquet
  size:    40 KB
  rows:    1,218

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-15 07:00:00	SPY	ETF	127.6	127.66	127.58	127.6	69500.0
2006-02-15 08:00:00	SPY	ETF	127.6	127.8	127.59	127.74	597900.0
2006-02-15 09:00:00	SPY	ETF	127.71	127.73	127.5	127.69	4709600.0
2006-02-15 10:00:00	SPY	ETF	127.69	128.32	127.46	127.94	22105500.0
2006-02-15 11:00:00	SPY	ETF	127.94	127.95	127.52	127.84	13346200.0
2006-02-15 12:00:00	SPY	ETF	127.83	127.85	127.24	127.53	9556200.0
2006-02-15 13:00:00	SPY	ETF	127.52	128.05	127.51	127.9788	8372400.0
2006-02-15 14:00:00	SPY	ETF	127.97	128.19	127.75	128.16	7910100.0
2006-02-15 15:00:00	SPY	ETF	128.16	128.18	127.85	128.14	11654400.0
2006-02-15 16:00:00	SPY	ETF	128.14	128.26	128.06	128.2	2890700.0
2006-02-15 17:00:00	SPY	ETF	128.23	128.24	128.13	128.23	102200.0
2006-02-15 18:00:00	SPY	ETF	128.15	128.18	128.15	128.18	2200.0
2006-02-15 09:00:00	QQQ	ETF	40.79	40.9	40.73	40.9	6791400.0
2006-02-15 10:00:00	QQQ	ETF	40.89	41.26	40.79	41.09	21965900.0
2006-02-15 11:00:00	QQQ	ETF	41.08	41.09	40.83	40.98	16935600.0
2006-02-15 12:00:00	QQQ	ETF	40.97	40.98	40.77	40.88	9605500.0
2006-02-15 13:00:00	QQQ	ETF	40.88	41.11	40.88	41.09	8138200.0
2006-02-15 14:00:00	QQQ	ETF	41.08	41.2	41.01	41.19	8755500.0
2006-02-15 15:00:00	QQQ	ETF	41.19	41.19	41.04	41.15	10068500.0
2006-02-15 08:00:00	IWM	ETF	71.49	71.54	71.47	71.52	9100.0
2006-02-15 09:00:00	IWM	ETF	71.52	71.53	71.18	71.46	2787100.0
2006-02-15 10:00:00	IWM	ETF	71.46	72.13	71.31	72.01	14968000.0
2006-02-15 11:00:00	IWM	ETF	72.02	72.07	71.69	71.86	5476700.0
2006-02-15 12:00:00	IWM	ETF	71.85	71.86	71.45	71.64	4215900.0
2006-02-15 13:00:00	IWM	ETF	71.63	71.96	71.6	71.93	3365500.0
2006-02-15 14:00:00	IWM	ETF	71.94	72.09	71.82	72.07	3126100.0
2006-02-15 15:00:00	IWM	ETF	72.08	72.12	71.75	72.07	5708500.0
2006-02-15 16:00:00	IWM	ETF	72.07	72.27	72.03	72.22	112700.0
2006-02-15 08:00:00	DIA	ETF	110.28	110.35	110.25	110.35	19100.0
2006-02-15 09:00:00	DIA	ETF	110.35	110.38	110.23	110.33	344200.0
2006-02-15 10:00:00	DIA	ETF	110.33	110.83	110.19	110.55	3029000.0
2006-02-15 11:00:00	DIA	ETF	110.52	110.52	110.22	110.42	1394000.0
2006-02-15 12:00:00	DIA	ETF	110.42	110.44	109.99	110.2501	1121200.0
2006-02-15 13:00:00	DIA	ETF	110.25	110.54	110.24	110.51	823300.0
2006-02-15 14:00:00	DIA	ETF	110.5199	110.75	110.32	110.73	983200.0
2006-02-15 15:00:00	DIA	ETF	110.72	110.73	110.46	110.67	1726800.0
2006-02-15 16:00:00	DIA	ETF	110.66	110.73	110.64	110.72	23200.0
2006-02-15 07:00:00	GLD	ETF	54.25	54.25	54.25	54.25	1000.0
2006-02-15 08:00:00	GLD	ETF	54.31	54.4	54.15	54.28	18500.0
2006-02-15 09:00:00	GLD	ETF	54.25	54.3	53.89	53.91	869200.0
2006-02-15 10:00:00	GLD	ETF	53.91	54.23	53.81	54.15	1034300.0
2006-02-15 11:00:00	GLD	ETF	54.16	54.27	53.76	53.9099	643200.0
2006-02-15 12:00:00	GLD	ETF	53.91	53.97	53.33	53.5201	1033600.0
2006-02-15 13:00:00	GLD	ETF	53.52	53.84	53.42	53.7	662600.0
2006-02-15 14:00:00	GLD	ETF	53.71	53.81	53.68	53.71	339200.0
2006-02-15 15:00:00	GLD	ETF	53.73	53.82	53.7	53.78	199200.0
2006-02-15 16:00:00	GLD	ETF	53.78	53.78	53.78	53.78	300.0
2006-02-15 07:00:00	TLT	ETF	90.05	90.05	90.05	90.05	1000.0
2006-02-15 09:00:00	TLT	ETF	90.1	90.19	90.07	90.1301	133600.0
2006-02-15 10:00:00	TLT	ETF	90.1	90.47	89.88	90.26	402800.0

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

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