PREVIEW / etf_1hour / 2006-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-09.parquet
  size:    44 KB
  rows:    1,360

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-06-09 04:00:00	SPY	ETF	126.15	126.15	126.15	126.15	3000.0
2006-06-09 05:00:00	SPY	ETF	126.01	126.13	126.01	126.11	50000.0
2006-06-09 06:00:00	SPY	ETF	126.06	126.16	126.06	126.16	105000.0
2006-06-09 07:00:00	SPY	ETF	126.26	126.43	126.26	126.33	27600.0
2006-06-09 08:00:00	SPY	ETF	126.3	126.49	126.05	126.24	2392600.0
2006-06-09 09:00:00	SPY	ETF	126.23	126.61	125.76	126.48	12452700.0
2006-06-09 10:00:00	SPY	ETF	126.47	126.67	126.13	126.18	15938300.0
2006-06-09 11:00:00	SPY	ETF	126.18	126.59	125.75	125.92	13699400.0
2006-06-09 12:00:00	SPY	ETF	125.92	126.16	125.6	125.68	10144500.0
2006-06-09 13:00:00	SPY	ETF	125.69	125.88	125.34	125.68	12178200.0
2006-06-09 14:00:00	SPY	ETF	125.68	126.34	125.65	126.11	9538400.0
2006-06-09 15:00:00	SPY	ETF	126.1	126.96	125.51	125.52	10380800.0
2006-06-09 16:00:00	SPY	ETF	125.51	125.62	125.25	125.28	6181700.0
2006-06-09 17:00:00	SPY	ETF	125.28	125.35	125.28	125.35	4800.0
2006-06-09 18:00:00	SPY	ETF	125.3	125.37	125.3	125.33	4500.0
2006-06-09 19:00:00	SPY	ETF	125.37	125.37	125.37	125.37	900.0
2006-06-09 09:00:00	QQQ	ETF	38.54	38.72	38.49	38.62	25693800.0
2006-06-09 10:00:00	QQQ	ETF	38.61	39.7	38.47	38.52	22178200.0
2006-06-09 11:00:00	QQQ	ETF	38.53	38.7	38.37	38.42	19828700.0
2006-06-09 12:00:00	QQQ	ETF	38.42	38.5	38.26	38.29	12044300.0
2006-06-09 13:00:00	QQQ	ETF	38.29	38.32	38.11	38.27	20019700.0
2006-06-09 14:00:00	QQQ	ETF	38.27	38.46	38.26	38.35	10705800.0
2006-06-09 15:00:00	QQQ	ETF	38.36	38.38	38.12	38.15	16827900.0
2006-06-09 08:00:00	IWM	ETF	70.53	70.64	70.32	70.49	544300.0
2006-06-09 09:00:00	IWM	ETF	70.5	70.88	70.17	70.83	10793900.0
2006-06-09 10:00:00	IWM	ETF	70.82	71.1	70.56	70.57	10279200.0
2006-06-09 11:00:00	IWM	ETF	70.56	70.88	70.04	70.26	6875400.0
2006-06-09 12:00:00	IWM	ETF	70.25	70.4	69.79	69.81	6008300.0
2006-06-09 13:00:00	IWM	ETF	69.81	70.11	69.5	69.93	11128900.0
2006-06-09 14:00:00	IWM	ETF	69.94	70.44	69.85	70.18	7564000.0
2006-06-09 15:00:00	IWM	ETF	70.18	70.29	69.69	69.75	8349700.0
2006-06-09 16:00:00	IWM	ETF	69.74	69.75	69.43	69.45	893800.0
2006-06-09 17:00:00	IWM	ETF	69.45	69.45	69.4	69.4	14500.0
2006-06-09 18:00:00	IWM	ETF	69.5	69.5	69.43	69.43	3200.0
2006-06-09 19:00:00	IWM	ETF	69.45	69.45	69.45	69.45	100.0
2006-06-09 07:00:00	DIA	ETF	109.37	109.37	109.37	109.37	800.0
2006-06-09 08:00:00	DIA	ETF	109.38	109.4	109.18	109.32	40200.0
2006-06-09 09:00:00	DIA	ETF	109.32	109.68	109.13	109.59	1934800.0
2006-06-09 10:00:00	DIA	ETF	109.59	109.75	109.28	109.38	1231500.0
2006-06-09 11:00:00	DIA	ETF	109.36	109.7	109.05	109.2	1075900.0
2006-06-09 12:00:00	DIA	ETF	109.2	109.33	108.85	108.92	769300.0
2006-06-09 13:00:00	DIA	ETF	108.92	109.04	108.68	108.91	678600.0
2006-06-09 14:00:00	DIA	ETF	108.9	109.46	108.9	109.24	535600.0
2006-06-09 15:00:00	DIA	ETF	109.24	109.55	108.83	108.888	923800.0
2006-06-09 16:00:00	DIA	ETF	108.85	108.9	108.7	108.8	49600.0
2006-06-09 17:00:00	DIA	ETF	108.82	108.82	108.75	108.75	800.0
2006-06-09 18:00:00	DIA	ETF	108.75	108.75	108.73	108.73	2300.0
2006-06-09 07:00:00	GLD	ETF	61.05	61.05	60.83	60.83	4400.0
2006-06-09 08:00:00	GLD	ETF	60.71	61.2	60.59	60.86	328300.0
2006-06-09 09:00:00	GLD	ETF	60.85	61.3	60.82	61.2	1125400.0

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

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