PREVIEW / etf_30min / 2003-07-09

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-09.parquet
  size:    24 KB
  rows:    729

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
2003-07-09 08:00:00	SPY	ETF	100.77	100.85	100.77	100.85	1800.0
2003-07-09 08:30:00	SPY	ETF	100.83	100.9	100.77	100.89	30800.0
2003-07-09 09:00:00	SPY	ETF	100.88	100.97	100.88	100.91	19200.0
2003-07-09 09:30:00	SPY	ETF	100.92	101.17	100.69	100.91	3543500.0
2003-07-09 10:00:00	SPY	ETF	100.9	101.4	100.7	101.31	2851100.0
2003-07-09 10:30:00	SPY	ETF	101.35	101.35	100.391	100.47	3643100.0
2003-07-09 11:00:00	SPY	ETF	100.45	100.69	100.34	100.62	3010800.0
2003-07-09 11:30:00	SPY	ETF	100.61	100.71	100.38	100.4	1576500.0
2003-07-09 12:00:00	SPY	ETF	100.38	100.44	100.03	100.33	3526500.0
2003-07-09 12:30:00	SPY	ETF	100.34	100.45	100.27	100.41	845300.0
2003-07-09 13:00:00	SPY	ETF	100.4	100.58	100.35	100.4	916300.0
2003-07-09 13:30:00	SPY	ETF	100.39	100.53	100.32	100.47	536500.0
2003-07-09 14:00:00	SPY	ETF	100.47	100.83	100.46	100.66	1777000.0
2003-07-09 14:30:00	SPY	ETF	100.65	100.9	100.52	100.77	1423300.0
2003-07-09 15:00:00	SPY	ETF	100.76	101.1	100.62	101.0	2490100.0
2003-07-09 15:30:00	SPY	ETF	100.98	101.005	100.43	100.57	3422700.0
2003-07-09 16:00:00	SPY	ETF	100.56	100.63	100.33	100.42	1109600.0
2003-07-09 16:30:00	SPY	ETF	100.42	100.7143	100.25	100.31	1310900.0
2003-07-09 17:00:00	SPY	ETF	100.32	100.32	100.23	100.26	51400.0
2003-07-09 17:30:00	SPY	ETF	100.25	100.28	100.24	100.28	58900.0
2003-07-09 18:00:00	SPY	ETF	100.29	100.3	100.28	100.3	7100.0
2003-07-09 18:30:00	SPY	ETF	100.32	100.32	100.3	100.3	900.0
2003-07-09 19:00:00	SPY	ETF	100.31	100.31	100.27	100.27	600.0
2003-07-09 19:30:00	SPY	ETF	100.31	100.34	100.31	100.34	1200.0
2003-07-09 08:00:00	QQQ	ETF	32.08	32.17	32.08	32.16	143700.0
2003-07-09 08:30:00	QQQ	ETF	32.17	32.17	32.14	32.15	42000.0
2003-07-09 09:00:00	QQQ	ETF	32.15	32.22	32.14	32.17	66800.0
2003-07-09 09:30:00	QQQ	ETF	32.18	32.35	32.1	32.212	10018700.0
2003-07-09 10:00:00	QQQ	ETF	32.21	32.49	32.14	32.414	10456700.0
2003-07-09 10:30:00	QQQ	ETF	32.418	32.44	32.07	32.1	6482100.0
2003-07-09 11:00:00	QQQ	ETF	32.08	32.24	32.06	32.19	5885400.0
2003-07-09 11:30:00	QQQ	ETF	32.19	32.29	32.06	32.08	5918800.0
2003-07-09 12:00:00	QQQ	ETF	32.08	32.1	31.93	32.06	5045600.0
2003-07-09 12:30:00	QQQ	ETF	32.065	32.16	32.04	32.11	2812000.0
2003-07-09 13:00:00	QQQ	ETF	32.09	32.2	32.08	32.09	2018100.0
2003-07-09 13:30:00	QQQ	ETF	32.1	32.15	32.07	32.12	2228200.0
2003-07-09 14:00:00	QQQ	ETF	32.119	32.28	32.08	32.196	4041700.0
2003-07-09 14:30:00	QQQ	ETF	32.2	32.36	32.15	32.301	4382200.0
2003-07-09 15:00:00	QQQ	ETF	32.294	32.45	32.249	32.384	5685000.0
2003-07-09 15:30:00	QQQ	ETF	32.388	32.41	32.1	32.17	6155700.0
2003-07-09 16:00:00	QQQ	ETF	32.17	32.23	32.14	32.16	3249100.0
2003-07-09 16:30:00	QQQ	ETF	32.16	32.16	31.933	31.97	1844200.0
2003-07-09 17:00:00	QQQ	ETF	31.96	31.994	31.95	31.99	717200.0
2003-07-09 17:30:00	QQQ	ETF	31.98	32.0	31.95	31.99	149700.0
2003-07-09 18:00:00	QQQ	ETF	31.99	32.01	31.96	32.0	87100.0
2003-07-09 18:30:00	QQQ	ETF	32.0	32.02	31.98	31.99	16300.0
2003-07-09 19:00:00	QQQ	ETF	31.98	31.99	31.96	31.96	6400.0
2003-07-09 19:30:00	QQQ	ETF	31.99	31.99	31.97	31.97	10900.0
2003-07-09 09:30:00	IWM	ETF	47.26	47.365	46.87	47.07	1105600.0
2003-07-09 10:00:00	IWM	ETF	47.045	47.385	46.9625	47.35	1209600.0

> showing 50 of 729 rows — these rows as CSV

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