PREVIEW / etf_30min / 2008-12-31

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-31.parquet
  size:    214 KB
  rows:    6,891

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-31 04:00:00	SPY	ETF	88.98	88.98	88.94	88.97	1800.0
2008-12-31 04:30:00	SPY	ETF	88.94	89.04	88.94	89.04	300.0
2008-12-31 05:00:00	SPY	ETF	89.11	89.11	89.11	89.11	100.0
2008-12-31 05:30:00	SPY	ETF	89.19	89.45	89.19	89.44	500.0
2008-12-31 06:00:00	SPY	ETF	89.48	89.6	89.48	89.48	1300.0
2008-12-31 06:30:00	SPY	ETF	89.43	89.43	89.43	89.43	252.0
2008-12-31 07:00:00	SPY	ETF	89.48	89.48	89.28	89.31	218396.0
2008-12-31 07:30:00	SPY	ETF	89.29	89.38	89.13	89.18	145850.0
2008-12-31 08:00:00	SPY	ETF	89.19	89.4	89.04	89.04	739677.0
2008-12-31 08:30:00	SPY	ETF	89.1	89.47	89.1	89.33	1100537.0
2008-12-31 09:00:00	SPY	ETF	89.33	89.35	89.03	89.08	1310137.0
2008-12-31 09:30:00	SPY	ETF	89.08	89.5	88.87	89.41	15245513.0
2008-12-31 10:00:00	SPY	ETF	89.41	89.75	89.4	89.75	12951274.0
2008-12-31 10:30:00	SPY	ETF	89.74	89.86	89.5	89.78	11980054.0
2008-12-31 11:00:00	SPY	ETF	89.78	89.98	89.68	89.97	8371903.0
2008-12-31 11:30:00	SPY	ETF	89.97	90.14	89.82	89.97	14296457.0
2008-12-31 12:00:00	SPY	ETF	89.97	90.1	89.84	89.9783	6757755.0
2008-12-31 12:30:00	SPY	ETF	89.97	90.18	89.92	90.12	6193659.0
2008-12-31 13:00:00	SPY	ETF	90.12	90.19	89.72	89.7692	8689628.0
2008-12-31 13:30:00	SPY	ETF	89.77	90.27	89.745	90.19	6784714.0
2008-12-31 14:00:00	SPY	ETF	90.18	90.6	90.159	90.42	13513249.0
2008-12-31 14:30:00	SPY	ETF	90.41	90.56	90.04	90.46	10594472.0
2008-12-31 15:00:00	SPY	ETF	90.47	90.71	90.25	90.58	15401071.0
2008-12-31 15:30:00	SPY	ETF	90.58	90.97	90.04	90.24	42417776.0
2008-12-31 16:00:00	SPY	ETF	90.24	90.585	89.36	89.64	14921720.0
2008-12-31 16:30:00	SPY	ETF	89.62	90.25	89.51	89.51	1533283.0
2008-12-31 17:00:00	SPY	ETF	89.51	89.6	89.48	89.49	55105.0
2008-12-31 17:30:00	SPY	ETF	89.49	90.24	89.48	89.55	86560.0
2008-12-31 18:00:00	SPY	ETF	89.6	89.64	89.6	89.63	25530.0
2008-12-31 18:30:00	SPY	ETF	89.64	89.64	89.62	89.62	3551.0
2008-12-31 19:00:00	SPY	ETF	89.62	89.62	89.62	89.62	200.0
2008-12-31 19:30:00	SPY	ETF	89.6	89.68	89.6	89.68	53819.0
2008-12-31 04:00:00	QQQ	ETF	29.5	29.52	29.5	29.52	200.0
2008-12-31 05:00:00	QQQ	ETF	29.53	29.58	29.53	29.58	300.0
2008-12-31 05:30:00	QQQ	ETF	29.64	29.64	29.64	29.64	300.0
2008-12-31 06:00:00	QQQ	ETF	29.71	29.71	29.71	29.71	5000.0
2008-12-31 07:00:00	QQQ	ETF	29.68	29.68	29.59	29.59	174997.0
2008-12-31 07:30:00	QQQ	ETF	29.58	29.63	29.55	29.55	58256.0
2008-12-31 08:00:00	QQQ	ETF	29.58	29.62	29.5	29.5	170587.0
2008-12-31 08:30:00	QQQ	ETF	29.5	29.64	29.49	29.58	992462.0
2008-12-31 09:00:00	QQQ	ETF	29.59	29.59	29.46	29.47	562097.0
2008-12-31 09:30:00	QQQ	ETF	29.48	29.78	29.45	29.72	11020111.0
2008-12-31 10:00:00	QQQ	ETF	29.73	29.8599	29.7275	29.84	5305664.0
2008-12-31 10:30:00	QQQ	ETF	29.832	29.88	29.75	29.8599	4011359.0
2008-12-31 11:00:00	QQQ	ETF	29.86	29.93	29.81	29.92	2434487.0
2008-12-31 11:30:00	QQQ	ETF	29.92	29.98	29.85	29.918	5901842.0
2008-12-31 12:00:00	QQQ	ETF	29.92	29.95	29.85	29.871	3162751.0
2008-12-31 12:30:00	QQQ	ETF	29.8704	29.97	29.85	29.95	3132092.0
2008-12-31 13:00:00	QQQ	ETF	29.96	29.99	29.86	29.88	4079845.0
2008-12-31 13:30:00	QQQ	ETF	29.88	29.99	29.87	29.97	3926003.0

> showing 50 of 6,891 rows — these rows as CSV

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