PREVIEW / etf_30min / 2009-07-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-22.parquet
  size:    225 KB
  rows:    7,448

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
2009-07-22 04:00:00	SPY	ETF	95.18	95.28	95.03	95.03	6200.0
2009-07-22 04:30:00	SPY	ETF	95.07	95.19	95.03	95.19	5750.0
2009-07-22 05:00:00	SPY	ETF	95.19	95.22	95.13	95.22	2400.0
2009-07-22 05:30:00	SPY	ETF	95.28	95.35	95.26	95.35	7700.0
2009-07-22 06:00:00	SPY	ETF	95.39	95.5	95.33	95.33	107100.0
2009-07-22 06:30:00	SPY	ETF	95.31	95.38	95.23	95.26	8501.0
2009-07-22 07:00:00	SPY	ETF	95.3	95.5	95.29	95.39	292550.0
2009-07-22 07:30:00	SPY	ETF	95.4	95.55	95.37	95.48	364486.0
2009-07-22 08:00:00	SPY	ETF	95.46	95.57	94.82	94.94	4360871.0
2009-07-22 08:30:00	SPY	ETF	94.95	95.04	94.91	94.98	1018225.0
2009-07-22 09:00:00	SPY	ETF	94.98	95.13	94.94	94.96	1553920.0
2009-07-22 09:30:00	SPY	ETF	94.96	95.69	94.89	95.59	26662456.0
2009-07-22 10:00:00	SPY	ETF	95.59	95.89	95.33	95.4	20899850.0
2009-07-22 10:30:00	SPY	ETF	95.4	95.63	95.23	95.61	14059431.0
2009-07-22 11:00:00	SPY	ETF	95.61	95.77	95.51	95.58	12036657.0
2009-07-22 11:30:00	SPY	ETF	95.58	95.7	95.37	95.53	7803335.0
2009-07-22 12:00:00	SPY	ETF	95.53	95.95	95.44	95.8974	9520244.0
2009-07-22 12:30:00	SPY	ETF	95.89	96.13	95.82	95.93	13329712.0
2009-07-22 13:00:00	SPY	ETF	95.93	96.1	95.69	95.75	7439589.0
2009-07-22 13:30:00	SPY	ETF	95.75	95.83	95.572	95.82	9919209.0
2009-07-22 14:00:00	SPY	ETF	95.81	95.9	95.52	95.62	10789033.0
2009-07-22 14:30:00	SPY	ETF	95.62	95.82	95.58	95.779	8375263.0
2009-07-22 15:00:00	SPY	ETF	95.77	95.88	95.29	95.4101	14919467.0
2009-07-22 15:30:00	SPY	ETF	95.41	95.79	95.29	95.54	18823277.0
2009-07-22 16:00:00	SPY	ETF	95.53	95.95	95.29	95.5	9219239.0
2009-07-22 16:30:00	SPY	ETF	95.5	95.55	95.41	95.52	2452418.0
2009-07-22 17:00:00	SPY	ETF	95.52	95.52	95.4	95.41	50130.0
2009-07-22 17:30:00	SPY	ETF	95.44	95.45	95.39	95.4	28708.0
2009-07-22 18:00:00	SPY	ETF	95.4	95.44	95.38	95.38	43250.0
2009-07-22 18:30:00	SPY	ETF	95.4	95.42	95.38	95.4	7300.0
2009-07-22 19:00:00	SPY	ETF	95.41	95.48	95.41	95.46	51905.0
2009-07-22 19:30:00	SPY	ETF	95.42	95.44	95.38	95.39	29912.0
2009-07-22 04:00:00	QQQ	ETF	38.14	38.14	38.11	38.11	1100.0
2009-07-22 04:30:00	QQQ	ETF	38.08	38.08	38.06	38.06	200.0
2009-07-22 06:00:00	QQQ	ETF	38.25	38.25	38.17	38.17	1300.0
2009-07-22 06:30:00	QQQ	ETF	38.19	38.2	38.15	38.16	1700.0
2009-07-22 07:00:00	QQQ	ETF	38.21	38.26	38.19	38.24	226800.0
2009-07-22 07:30:00	QQQ	ETF	38.26	38.31	38.26	38.27	185204.0
2009-07-22 08:00:00	QQQ	ETF	38.28	38.3	38.09	38.13	768811.0
2009-07-22 08:30:00	QQQ	ETF	38.13	38.16	38.12	38.12	328193.0
2009-07-22 09:00:00	QQQ	ETF	38.12	38.2	38.12	38.2	767263.0
2009-07-22 09:30:00	QQQ	ETF	38.2	38.5001	38.13	38.44	16852215.0
2009-07-22 10:00:00	QQQ	ETF	38.45	38.54	38.29	38.31	11984974.0
2009-07-22 10:30:00	QQQ	ETF	38.32	38.39	38.22	38.38	8709472.0
2009-07-22 11:00:00	QQQ	ETF	38.39	38.48	38.34	38.47	8166870.0
2009-07-22 11:30:00	QQQ	ETF	38.46	38.52	38.38	38.45	4579166.0
2009-07-22 12:00:00	QQQ	ETF	38.45	38.61	38.43	38.58	6033321.0
2009-07-22 12:30:00	QQQ	ETF	38.58	38.69	38.52	38.5795	7655179.0
2009-07-22 13:00:00	QQQ	ETF	38.5701	38.64	38.48	38.5124	3677536.0
2009-07-22 13:30:00	QQQ	ETF	38.52	38.54	38.448	38.5099	5204483.0

> showing 50 of 7,448 rows — these rows as CSV

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