PREVIEW / etf_1hour / 2006-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-12.parquet
  size:    40 KB
  rows:    1,254

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-04-12 06:00:00	SPY	ETF	128.62	128.62	128.6	128.6	300.0
2006-04-12 07:00:00	SPY	ETF	128.65	128.86	128.65	128.86	60100.0
2006-04-12 08:00:00	SPY	ETF	128.8	128.94	128.69	128.75	550900.0
2006-04-12 09:00:00	SPY	ETF	128.77	129.03	128.58	128.82	5387200.0
2006-04-12 10:00:00	SPY	ETF	128.82	129.13	128.61	128.88	10194100.0
2006-04-12 11:00:00	SPY	ETF	128.89	129.0	128.7	128.72	5965300.0
2006-04-12 12:00:00	SPY	ETF	128.73	128.95	128.65	128.89	3325300.0
2006-04-12 13:00:00	SPY	ETF	128.89	129.01	128.73	128.78	4613700.0
2006-04-12 14:00:00	SPY	ETF	128.78	128.86	128.63	128.71	4363500.0
2006-04-12 15:00:00	SPY	ETF	128.7	128.9	128.64	128.85	6573200.0
2006-04-12 16:00:00	SPY	ETF	128.83	128.97	128.79	128.89	807900.0
2006-04-12 17:00:00	SPY	ETF	128.89	128.96	128.87	128.9	16900.0
2006-04-12 18:00:00	SPY	ETF	128.93	128.95	128.9	128.9	10100.0
2006-04-12 19:00:00	SPY	ETF	128.96	128.96	128.95	128.96	700.0
2006-04-12 09:00:00	QQQ	ETF	41.95	42.01	41.91	41.95	11242400.0
2006-04-12 10:00:00	QQQ	ETF	41.95	42.08	41.86	41.96	13222700.0
2006-04-12 11:00:00	QQQ	ETF	41.96	42.03	41.9	41.91	7421700.0
2006-04-12 12:00:00	QQQ	ETF	41.92	42.01	41.88	42.01	5248500.0
2006-04-12 13:00:00	QQQ	ETF	42.01	42.03	41.91	41.94	6202300.0
2006-04-12 14:00:00	QQQ	ETF	41.94	41.96	41.8	41.86	6882500.0
2006-04-12 15:00:00	QQQ	ETF	41.85	41.95	41.84	41.93	5674600.0
2006-04-12 08:00:00	IWM	ETF	73.5	73.7	73.5	73.65	17200.0
2006-04-12 09:00:00	IWM	ETF	73.6	74.04	73.55	73.89	6524000.0
2006-04-12 10:00:00	IWM	ETF	73.89	74.19	73.77	73.98	9824300.0
2006-04-12 11:00:00	IWM	ETF	73.97	74.14	73.85	73.9	3915900.0
2006-04-12 12:00:00	IWM	ETF	73.9	74.19	73.81	74.19	2223300.0
2006-04-12 13:00:00	IWM	ETF	74.19	74.4	74.08	74.1	7577600.0
2006-04-12 14:00:00	IWM	ETF	74.11	74.18	73.94	74.02	3117900.0
2006-04-12 15:00:00	IWM	ETF	74.02	74.33	74.01	74.31	3130700.0
2006-04-12 16:00:00	IWM	ETF	74.31	74.63	73.718	74.34	2150200.0
2006-04-12 17:00:00	IWM	ETF	74.41	74.41	74.38	74.38	1500.0
2006-04-12 18:00:00	IWM	ETF	74.38	74.4	74.28	74.4	345200.0
2006-04-12 19:00:00	IWM	ETF	74.4	74.4	74.4	74.4	100.0
2006-04-12 07:00:00	DIA	ETF	110.98	110.98	110.98	110.98	1000.0
2006-04-12 08:00:00	DIA	ETF	111.05	111.23	110.98	111.06	19700.0
2006-04-12 09:00:00	DIA	ETF	111.06	111.34	111.05	111.2	567700.0
2006-04-12 10:00:00	DIA	ETF	111.2	111.45	111.02	111.29	729300.0
2006-04-12 11:00:00	DIA	ETF	111.29	111.43	111.19	111.2	759200.0
2006-04-12 12:00:00	DIA	ETF	111.2	111.37	111.12	111.37	516800.0
2006-04-12 13:00:00	DIA	ETF	111.36	111.43	111.21	111.25	380000.0
2006-04-12 14:00:00	DIA	ETF	111.27	111.34	111.16	111.23	267100.0
2006-04-12 15:00:00	DIA	ETF	111.21	111.36	111.19	111.29	410200.0
2006-04-12 16:00:00	DIA	ETF	111.28	111.38	111.22	111.36	14600.0
2006-04-12 07:00:00	GLD	ETF	59.42	59.42	59.42	59.42	500.0
2006-04-12 08:00:00	GLD	ETF	59.3	59.45	59.16	59.39	30700.0
2006-04-12 09:00:00	GLD	ETF	59.4	59.53	59.27	59.5	561100.0
2006-04-12 10:00:00	GLD	ETF	59.5	59.6	59.39	59.53	748600.0
2006-04-12 11:00:00	GLD	ETF	59.5	59.71	59.43	59.45	714300.0
2006-04-12 12:00:00	GLD	ETF	59.43	59.51	59.15	59.26	378600.0
2006-04-12 13:00:00	GLD	ETF	59.26	59.48	59.26	59.42	372600.0

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

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