PREVIEW / etf_1hour / 2006-03-17

all etf 1-hour files

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

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-03-17 06:00:00	SPY	ETF	130.57	130.58	130.57	130.58	50000.0
2006-03-17 07:00:00	SPY	ETF	130.59	130.64	130.58	130.64	49000.0
2006-03-17 08:00:00	SPY	ETF	130.62	130.64	130.32	130.38	393100.0
2006-03-17 09:00:00	SPY	ETF	130.38	130.74	130.37	130.6	7189100.0
2006-03-17 10:00:00	SPY	ETF	130.6	130.74	130.38	130.45	7113400.0
2006-03-17 11:00:00	SPY	ETF	130.45	130.62	130.42	130.59	3637500.0
2006-03-17 12:00:00	SPY	ETF	130.59	130.9	130.54	130.76	3990700.0
2006-03-17 13:00:00	SPY	ETF	130.76	130.8	130.42	130.54	6494000.0
2006-03-17 14:00:00	SPY	ETF	130.55	130.68	130.42	130.51	3767300.0
2006-03-17 15:00:00	SPY	ETF	130.5	130.61	130.43	130.58	7907500.0
2006-03-17 16:00:00	SPY	ETF	130.58	130.69	130.55	130.67	4066000.0
2006-03-17 17:00:00	SPY	ETF	130.65	130.7	130.6	130.6	15600.0
2006-03-17 19:00:00	SPY	ETF	130.7	130.7	130.7	130.7	1500.0
2006-03-17 09:00:00	QQQ	ETF	41.33	41.37	41.23	41.32	9750300.0
2006-03-17 10:00:00	QQQ	ETF	41.32	41.41	41.24	41.25	11710400.0
2006-03-17 11:00:00	QQQ	ETF	41.26	41.45	41.25	41.44	9471200.0
2006-03-17 12:00:00	QQQ	ETF	41.45	41.59	41.44	41.5	12480100.0
2006-03-17 13:00:00	QQQ	ETF	41.5	41.54	41.37	41.42	7952700.0
2006-03-17 14:00:00	QQQ	ETF	41.41	41.48	41.35	41.39	5425000.0
2006-03-17 15:00:00	QQQ	ETF	41.39	41.43	41.32	41.42	12279500.0
2006-03-17 08:00:00	IWM	ETF	73.94	73.98	73.7	73.75	105200.0
2006-03-17 09:00:00	IWM	ETF	73.8	74.2	73.7	73.85	4690000.0
2006-03-17 10:00:00	IWM	ETF	73.87	74.08	73.78	73.85	5214800.0
2006-03-17 11:00:00	IWM	ETF	73.85	74.11	73.85	74.07	1764400.0
2006-03-17 12:00:00	IWM	ETF	74.1	74.3	74.07	74.19	2720900.0
2006-03-17 13:00:00	IWM	ETF	74.18	74.3	74.09	74.2	4207500.0
2006-03-17 14:00:00	IWM	ETF	74.2	74.3	74.06	74.18	3326400.0
2006-03-17 15:00:00	IWM	ETF	74.18	74.3	74.07	74.15	7132200.0
2006-03-17 16:00:00	IWM	ETF	74.15	74.16	74.06	74.08	1753000.0
2006-03-17 17:00:00	IWM	ETF	74.08	74.08	74.08	74.08	200.0
2006-03-17 19:00:00	IWM	ETF	74.12	74.12	74.12	74.12	200.0
2006-03-17 07:00:00	DIA	ETF	112.54	112.57	112.5	112.57	5500.0
2006-03-17 08:00:00	DIA	ETF	112.55	112.59	112.35	112.38	22400.0
2006-03-17 09:00:00	DIA	ETF	112.36	112.77	112.36	112.63	1347200.0
2006-03-17 10:00:00	DIA	ETF	112.63	112.74	112.45	112.51	1160900.0
2006-03-17 11:00:00	DIA	ETF	112.49	112.62	112.48	112.57	405700.0
2006-03-17 12:00:00	DIA	ETF	112.57	112.81	112.54	112.71	578200.0
2006-03-17 13:00:00	DIA	ETF	112.71	112.76	112.45	112.5524	408600.0
2006-03-17 14:00:00	DIA	ETF	112.57	112.65	112.48	112.55	380300.0
2006-03-17 15:00:00	DIA	ETF	112.56	112.75	112.53	112.7	1123800.0
2006-03-17 16:00:00	DIA	ETF	112.71	112.86	112.63	112.75	180600.0
2006-03-17 17:00:00	DIA	ETF	112.73	112.73	112.71	112.71	800.0
2006-03-17 07:00:00	GLD	ETF	55.24	55.32	55.24	55.32	5000.0
2006-03-17 08:00:00	GLD	ETF	55.29	55.5	55.24	55.31	37200.0
2006-03-17 09:00:00	GLD	ETF	55.26	55.3	55.111	55.14	280500.0
2006-03-17 10:00:00	GLD	ETF	55.12	55.27	54.93	55.23	470800.0
2006-03-17 11:00:00	GLD	ETF	55.22	55.33	55.1	55.3	583400.0
2006-03-17 12:00:00	GLD	ETF	55.3	55.32	55.12	55.2	286400.0
2006-03-17 13:00:00	GLD	ETF	55.2	55.28	55.09	55.13	205200.0
2006-03-17 14:00:00	GLD	ETF	55.15	55.17	55.12	55.17	83200.0

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

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