PREVIEW / etf_1hour / 2008-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-14.parquet
  size:    115 KB
  rows:    3,730

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
2008-11-14 04:00:00	SPY	ETF	90.22	90.22	89.8	89.8	28000.0
2008-11-14 05:00:00	SPY	ETF	89.79	90.17	89.43	90.13	9524.0
2008-11-14 06:00:00	SPY	ETF	90.14	90.4	90.01	90.34	83723.0
2008-11-14 07:00:00	SPY	ETF	90.31	90.59	89.74	89.78	1079895.0
2008-11-14 08:00:00	SPY	ETF	89.79	90.8598	89.24	89.87	7087376.0
2008-11-14 09:00:00	SPY	ETF	89.88	91.17	89.26	90.67	53524431.0
2008-11-14 10:00:00	SPY	ETF	90.66	90.96	88.13	88.5001	77440999.0
2008-11-14 11:00:00	SPY	ETF	88.5	89.05	87.84	88.0	43993467.0
2008-11-14 12:00:00	SPY	ETF	88.0	88.74	87.23	88.44	47278036.0
2008-11-14 13:00:00	SPY	ETF	88.43	89.28	87.42	88.76	48888326.0
2008-11-14 14:00:00	SPY	ETF	88.77	91.79	88.57	91.69	88200927.0
2008-11-14 15:00:00	SPY	ETF	91.69	92.06	87.32	87.55	136876733.0
2008-11-14 16:00:00	SPY	ETF	87.56	91.94	86.32	86.75	24565012.0
2008-11-14 17:00:00	SPY	ETF	86.75	87.62	86.55	86.72	6090656.0
2008-11-14 18:00:00	SPY	ETF	86.7	91.4135	86.65	86.78	1105810.0
2008-11-14 19:00:00	SPY	ETF	86.73	86.85	86.68	86.8	53223.0
2008-11-14 05:00:00	QQQ	ETF	30.01	30.14	29.95	30.14	1920.0
2008-11-14 06:00:00	QQQ	ETF	30.18	30.18	30.18	30.18	300.0
2008-11-14 07:00:00	QQQ	ETF	30.25	30.25	30.09	30.15	370391.0
2008-11-14 08:00:00	QQQ	ETF	30.13	30.15	29.79	29.93	2195737.0
2008-11-14 09:00:00	QQQ	ETF	29.92	30.06	29.62	29.89	29600624.0
2008-11-14 10:00:00	QQQ	ETF	29.89	29.98	29.27	29.37	40983783.0
2008-11-14 11:00:00	QQQ	ETF	29.37	29.49	29.09	29.19	23619311.0
2008-11-14 12:00:00	QQQ	ETF	29.19	29.56	28.96	29.46	22119918.0
2008-11-14 13:00:00	QQQ	ETF	29.46	29.69	29.16	29.5	24021456.0
2008-11-14 14:00:00	QQQ	ETF	29.51	30.3374	29.47	30.3304	42063584.0
2008-11-14 15:00:00	QQQ	ETF	30.33	30.42	28.87	28.97	60237865.0
2008-11-14 16:00:00	QQQ	ETF	28.97	29.9074	28.43	28.68	10545573.0
2008-11-14 17:00:00	QQQ	ETF	28.65	28.74	28.65	28.74	74218.0
2008-11-14 18:00:00	QQQ	ETF	28.75	28.77	28.71	28.76	20387.0
2008-11-14 19:00:00	QQQ	ETF	28.77	28.8	28.72	28.79	29365.0
2008-11-14 05:00:00	IWM	ETF	48.47	48.47	48.47	48.47	5000.0
2008-11-14 06:00:00	IWM	ETF	48.47	48.47	48.47	48.47	2000.0
2008-11-14 07:00:00	IWM	ETF	48.76	48.93	48.54	48.55	14065.0
2008-11-14 08:00:00	IWM	ETF	48.59	48.59	48.16	48.48	469371.0
2008-11-14 09:00:00	IWM	ETF	48.49	49.31	48.03	48.51	10801721.0
2008-11-14 10:00:00	IWM	ETF	48.52	48.69	46.91	47.2	13869209.0
2008-11-14 11:00:00	IWM	ETF	47.19	47.45	46.65	46.71	7283759.0
2008-11-14 12:00:00	IWM	ETF	46.68	46.99	46.31	46.8	7898499.0
2008-11-14 13:00:00	IWM	ETF	46.8	47.15	46.25	46.75	6937933.0
2008-11-14 14:00:00	IWM	ETF	46.77	48.65	46.65	48.2	16751629.0
2008-11-14 15:00:00	IWM	ETF	48.2	48.33	45.5	45.61	27017698.0
2008-11-14 16:00:00	IWM	ETF	45.6	47.06	44.81	45.32	5873658.0
2008-11-14 17:00:00	IWM	ETF	45.7	45.7	45.16	45.16	1003050.0
2008-11-14 18:00:00	IWM	ETF	45.4	45.4	45.31	45.31	2840.0
2008-11-14 19:00:00	IWM	ETF	45.31	45.4	45.31	45.4	1395.0
2008-11-14 06:00:00	DIA	ETF	87.97	87.97	87.79	87.95	2700.0
2008-11-14 07:00:00	DIA	ETF	87.93	88.0	87.4	87.4	34125.0
2008-11-14 08:00:00	DIA	ETF	87.45	87.7	86.98	87.48	175970.0
2008-11-14 09:00:00	DIA	ETF	87.53	88.45	86.87	88.17	4939951.0

> showing 50 of 3,730 rows — these rows as CSV

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