PREVIEW / etf_30min / 2003-08-20

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-08-20.parquet
  size:    23 KB
  rows:    704

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-08-20 08:00:00	SPY	ETF	100.5	100.55	100.43	100.43	20000.0
2003-08-20 08:30:00	SPY	ETF	100.44	100.5	100.38	100.38	22300.0
2003-08-20 09:00:00	SPY	ETF	100.36	100.41	100.3	100.3	16100.0
2003-08-20 09:30:00	SPY	ETF	100.29	100.54	100.24	100.33	2279500.0
2003-08-20 10:00:00	SPY	ETF	100.34	100.46	100.164	100.39	1346200.0
2003-08-20 10:30:00	SPY	ETF	100.39	100.572	100.21	100.55	812400.0
2003-08-20 11:00:00	SPY	ETF	100.54	100.73	100.52	100.73	1761300.0
2003-08-20 11:30:00	SPY	ETF	100.7	100.89	100.69	100.8	1674700.0
2003-08-20 12:00:00	SPY	ETF	100.78	100.82	100.56	100.6	2089000.0
2003-08-20 12:30:00	SPY	ETF	100.59	100.74	100.56	100.67	1140600.0
2003-08-20 13:00:00	SPY	ETF	100.67	100.78	100.63	100.71	619600.0
2003-08-20 13:30:00	SPY	ETF	100.7	100.89	100.64	100.7	902400.0
2003-08-20 14:00:00	SPY	ETF	100.72	100.8	100.43	100.58	1147600.0
2003-08-20 14:30:00	SPY	ETF	100.57	100.69	100.48	100.65	767900.0
2003-08-20 15:00:00	SPY	ETF	100.64	100.82	100.53	100.56	733200.0
2003-08-20 15:30:00	SPY	ETF	100.54	100.61	100.41	100.5	1833600.0
2003-08-20 16:00:00	SPY	ETF	100.5	100.61	100.4	100.4	1317900.0
2003-08-20 16:30:00	SPY	ETF	100.4	100.48	100.387	100.438	7800.0
2003-08-20 17:00:00	SPY	ETF	100.489	100.557	100.46	100.5	1908400.0
2003-08-20 17:30:00	SPY	ETF	100.53	100.54	100.53	100.54	700.0
2003-08-20 18:00:00	SPY	ETF	100.52	100.52	100.47	100.47	600.0
2003-08-20 18:30:00	SPY	ETF	100.47	100.47	100.45	100.45	600.0
2003-08-20 08:00:00	QQQ	ETF	32.11	32.12	32.07	32.1	103500.0
2003-08-20 08:30:00	QQQ	ETF	32.1	32.12	32.08	32.09	37800.0
2003-08-20 09:00:00	QQQ	ETF	32.08	32.09	32.06	32.09	85100.0
2003-08-20 09:30:00	QQQ	ETF	32.1	32.21	32.04	32.11	6933900.0
2003-08-20 10:00:00	QQQ	ETF	32.11	32.2	32.02	32.18	4179100.0
2003-08-20 10:30:00	QQQ	ETF	32.18	32.28	32.076	32.25	3921100.0
2003-08-20 11:00:00	QQQ	ETF	32.25	32.35	32.228	32.34	4634400.0
2003-08-20 11:30:00	QQQ	ETF	32.33	32.46	32.32	32.43	5158800.0
2003-08-20 12:00:00	QQQ	ETF	32.43	32.44	32.31	32.33	3041300.0
2003-08-20 12:30:00	QQQ	ETF	32.31	32.42	32.31	32.4	1857700.0
2003-08-20 13:00:00	QQQ	ETF	32.39	32.44	32.37	32.431	1916800.0
2003-08-20 13:30:00	QQQ	ETF	32.431	32.52	32.38	32.424	4717300.0
2003-08-20 14:00:00	QQQ	ETF	32.42	32.46	32.27	32.34	3350800.0
2003-08-20 14:30:00	QQQ	ETF	32.341	32.39	32.28	32.34	3059300.0
2003-08-20 15:00:00	QQQ	ETF	32.34	32.45	32.28	32.29	3037100.0
2003-08-20 15:30:00	QQQ	ETF	32.3	32.33	32.2	32.27	5491000.0
2003-08-20 16:00:00	QQQ	ETF	32.27	32.33	32.25	32.32	1601200.0
2003-08-20 16:30:00	QQQ	ETF	32.33	32.33	32.28	32.295	74500.0
2003-08-20 17:00:00	QQQ	ETF	32.3	32.326	32.3	32.31	12800.0
2003-08-20 17:30:00	QQQ	ETF	32.32	32.33	32.309	32.33	7300.0
2003-08-20 18:00:00	QQQ	ETF	32.33	32.36	32.32	32.33	26600.0
2003-08-20 18:30:00	QQQ	ETF	32.33	32.34	32.33	32.34	4100.0
2003-08-20 19:00:00	QQQ	ETF	32.35	32.35	32.31	32.31	4000.0
2003-08-20 19:30:00	QQQ	ETF	32.31	32.36	32.31	32.36	6200.0
2003-08-20 09:30:00	IWM	ETF	48.505	48.6	48.4	48.595	418800.0
2003-08-20 10:00:00	IWM	ETF	48.585	48.6	48.465	48.57	223800.0
2003-08-20 10:30:00	IWM	ETF	48.595	48.625	48.515	48.625	155800.0
2003-08-20 11:00:00	IWM	ETF	48.635	48.885	48.635	48.885	816600.0

> showing 50 of 704 rows — these rows as CSV

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