PREVIEW / etf_30min / 2001-03-09

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-09.parquet
  size:    14 KB
  rows:    363

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
2001-03-09 09:30:00	SPY	ETF	126.1	126.1	124.94	125.1	1418100.0
2001-03-09 10:00:00	SPY	ETF	125.05	125.1	123.8	124.45	914600.0
2001-03-09 10:30:00	SPY	ETF	124.31	124.76	124.06	124.3	990800.0
2001-03-09 11:00:00	SPY	ETF	124.3	124.42	123.76	124.1	548300.0
2001-03-09 11:30:00	SPY	ETF	124.24	124.39	123.91	124.27	354100.0
2001-03-09 12:00:00	SPY	ETF	124.4	124.48	124.11	124.13	540200.0
2001-03-09 12:30:00	SPY	ETF	124.1	124.26	123.91	123.94	387000.0
2001-03-09 13:00:00	SPY	ETF	124.0	124.35	123.88	124.04	423600.0
2001-03-09 13:30:00	SPY	ETF	124.06	124.38	123.9	124.25	372900.0
2001-03-09 14:00:00	SPY	ETF	124.32	124.39	123.98	124.06	678200.0
2001-03-09 14:30:00	SPY	ETF	124.16	124.25	123.37	123.58	458400.0
2001-03-09 15:00:00	SPY	ETF	123.5	124.32	123.3	123.45	1078600.0
2001-03-09 15:30:00	SPY	ETF	123.52	124.04	123.11	123.67	1086200.0
2001-03-09 16:00:00	SPY	ETF	123.6	123.82	123.36	123.36	347400.0
2001-03-09 09:30:00	QQQ	ETF	47.25	47.37	46.54	46.67	10088200.0
2001-03-09 10:00:00	QQQ	ETF	46.6	46.69	45.9	46.28	9293100.0
2001-03-09 10:30:00	QQQ	ETF	46.3	46.4	45.94	46.0	5092200.0
2001-03-09 11:00:00	QQQ	ETF	45.98	46.12	45.51	45.8	5795800.0
2001-03-09 11:30:00	QQQ	ETF	45.8	46.0	45.55	45.83	3598200.0
2001-03-09 12:00:00	QQQ	ETF	45.84	46.05	45.55	45.6	2848000.0
2001-03-09 12:30:00	QQQ	ETF	45.6	45.7	45.35	45.48	2770400.0
2001-03-09 13:00:00	QQQ	ETF	45.54	45.88	45.4	45.59	2230300.0
2001-03-09 13:30:00	QQQ	ETF	45.56	45.88	45.47	45.83	2318700.0
2001-03-09 14:00:00	QQQ	ETF	45.85	45.9	45.46	45.64	4058300.0
2001-03-09 14:30:00	QQQ	ETF	45.64	45.7	45.07	45.12	6369000.0
2001-03-09 15:00:00	QQQ	ETF	45.1	45.9	45.01	45.3	8119400.0
2001-03-09 15:30:00	QQQ	ETF	45.27	45.48	44.95	45.2	9903400.0
2001-03-09 16:00:00	QQQ	ETF	45.32	45.51	45.04	45.14	1995700.0
2001-03-09 16:30:00	QQQ	ETF	45.15	45.25	45.0	45.01	26800.0
2001-03-09 17:00:00	QQQ	ETF	45.02	45.12	45.01	45.05	22200.0
2001-03-09 17:30:00	QQQ	ETF	45.04	45.85	45.0	45.78	20700.0
2001-03-09 18:00:00	QQQ	ETF	45.04	45.2	45.0	45.04	6700.0
2001-03-09 09:30:00	IWM	ETF	47.3	47.4	47.2	47.3	66200.0
2001-03-09 10:00:00	IWM	ETF	47.255	47.255	47.0	47.005	55400.0
2001-03-09 10:30:00	IWM	ETF	47.25	47.25	47.25	47.25	200.0
2001-03-09 11:00:00	IWM	ETF	47.05	47.05	47.025	47.05	8000.0
2001-03-09 11:30:00	IWM	ETF	47.225	47.225	47.225	47.225	800.0
2001-03-09 12:00:00	IWM	ETF	47.25	47.25	47.1	47.225	10800.0
2001-03-09 12:30:00	IWM	ETF	47.18	47.345	47.18	47.345	45400.0
2001-03-09 13:00:00	IWM	ETF	47.29	47.4	47.15	47.4	3400.0
2001-03-09 13:30:00	IWM	ETF	47.4	47.4	47.25	47.25	2600.0
2001-03-09 14:00:00	IWM	ETF	47.3	47.3	47.3	47.3	200.0
2001-03-09 14:30:00	IWM	ETF	47.425	47.425	47.17	47.2	7200.0
2001-03-09 15:00:00	IWM	ETF	47.0	47.395	47.0	47.25	9000.0
2001-03-09 15:30:00	IWM	ETF	47.205	47.775	47.055	47.225	15200.0
2001-03-09 16:00:00	IWM	ETF	46.955	47.055	46.955	47.055	800.0
2001-03-09 09:30:00	DIA	ETF	108.0	108.0	107.41	107.45	580300.0
2001-03-09 10:00:00	DIA	ETF	107.45	107.55	106.51	107.1	455500.0
2001-03-09 10:30:00	DIA	ETF	107.05	107.1	106.7	106.83	175000.0
2001-03-09 11:00:00	DIA	ETF	106.83	107.03	106.52	106.87	208900.0

> showing 50 of 363 rows — these rows as CSV

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