PREVIEW / etf_1hour / 2008-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-11.parquet
  size:    118 KB
  rows:    3,865

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-12-11 04:00:00	SPY	ETF	89.4	89.59	89.37	89.48	8000.0
2008-12-11 05:00:00	SPY	ETF	89.53	90.46	89.48	90.37	6600.0
2008-12-11 06:00:00	SPY	ETF	90.41	90.45	90.09	90.45	160412.0
2008-12-11 07:00:00	SPY	ETF	90.36	90.36	89.9	90.04	847045.0
2008-12-11 08:00:00	SPY	ETF	89.53	90.41	89.09	89.6	4099617.0
2008-12-11 09:00:00	SPY	ETF	89.59	90.25	89.04	90.06	32574161.0
2008-12-11 10:00:00	SPY	ETF	90.06	90.9	89.8	90.36	48414714.0
2008-12-11 11:00:00	SPY	ETF	90.35	90.75	89.93	90.68	33514144.0
2008-12-11 12:00:00	SPY	ETF	90.68	91.0	90.23	90.81	30669805.0
2008-12-11 13:00:00	SPY	ETF	90.8	90.84	89.72	89.82	23584596.0
2008-12-11 14:00:00	SPY	ETF	89.82	90.01	88.35	88.46	45886313.0
2008-12-11 15:00:00	SPY	ETF	88.47	89.9	87.37	87.95	110871545.0
2008-12-11 16:00:00	SPY	ETF	87.97	90.4334	86.75	86.97	20922309.0
2008-12-11 17:00:00	SPY	ETF	86.97	87.04	86.25	86.43	3381313.0
2008-12-11 18:00:00	SPY	ETF	86.41	86.53	86.01	86.07	1338522.0
2008-12-11 19:00:00	SPY	ETF	86.04	86.04	85.59	85.67	534067.0
2008-12-11 04:00:00	QQQ	ETF	29.79	29.85	29.79	29.85	300.0
2008-12-11 05:00:00	QQQ	ETF	29.85	30.15	29.85	30.15	500.0
2008-12-11 07:00:00	QQQ	ETF	30.17	30.21	29.98	30.03	590930.0
2008-12-11 08:00:00	QQQ	ETF	30.01	30.01	29.65	29.77	2093919.0
2008-12-11 09:00:00	QQQ	ETF	29.78	29.91	29.53	29.9	17790676.0
2008-12-11 10:00:00	QQQ	ETF	29.9	30.22	29.86	30.09	21867630.0
2008-12-11 11:00:00	QQQ	ETF	30.09	30.22	29.9	30.14	12676207.0
2008-12-11 12:00:00	QQQ	ETF	30.15	30.27	30.08	30.22	11761613.0
2008-12-11 13:00:00	QQQ	ETF	30.22	30.23	29.79	29.83	10591692.0
2008-12-11 14:00:00	QQQ	ETF	29.832	29.9	29.12	29.19	22316724.0
2008-12-11 15:00:00	QQQ	ETF	29.19	29.31	28.94	29.08	52300190.0
2008-12-11 16:00:00	QQQ	ETF	29.09	29.24	28.86	28.94	4382080.0
2008-12-11 17:00:00	QQQ	ETF	28.95	28.95	28.77	28.86	268992.0
2008-12-11 18:00:00	QQQ	ETF	28.82	28.86	28.7	28.71	117112.0
2008-12-11 19:00:00	QQQ	ETF	28.7	28.74	28.52	28.65	235361.0
2008-12-11 05:00:00	IWM	ETF	47.95	47.95	47.95	47.95	3000.0
2008-12-11 07:00:00	IWM	ETF	47.79	47.79	47.6	47.61	21400.0
2008-12-11 08:00:00	IWM	ETF	47.3	47.75	47.17	47.41	553368.0
2008-12-11 09:00:00	IWM	ETF	47.4	47.56	46.87	47.49	5152088.0
2008-12-11 10:00:00	IWM	ETF	47.49	47.91	47.21	47.55	9785338.0
2008-12-11 11:00:00	IWM	ETF	47.56	47.72	47.16	47.52	4102757.0
2008-12-11 12:00:00	IWM	ETF	47.53	47.87	47.45	47.78	5793216.0
2008-12-11 13:00:00	IWM	ETF	47.78	47.83	47.09	47.12	5342210.0
2008-12-11 14:00:00	IWM	ETF	47.13	47.26	45.96	46.01	7427558.0
2008-12-11 15:00:00	IWM	ETF	46.01	46.01	44.79	45.28	26782504.0
2008-12-11 16:00:00	IWM	ETF	45.29	46.08	44.68	44.9	4652703.0
2008-12-11 17:00:00	IWM	ETF	44.91	44.91	44.58	44.68	81255.0
2008-12-11 18:00:00	IWM	ETF	44.85	44.95	44.85	44.95	2670.0
2008-12-11 19:00:00	IWM	ETF	44.63	44.95	44.5	44.95	5726.0
2008-12-11 05:00:00	DIA	ETF	87.3	87.3	87.3	87.3	100.0
2008-12-11 06:00:00	DIA	ETF	87.52	87.52	87.48	87.48	300.0
2008-12-11 07:00:00	DIA	ETF	87.46	87.47	87.3	87.32	3300.0
2008-12-11 08:00:00	DIA	ETF	87.38	87.39	86.18	86.7	95440.0
2008-12-11 09:00:00	DIA	ETF	86.68	87.38	86.3	87.09	2167395.0

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

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