PREVIEW / etf_30min / 2000-03-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-20.parquet
  size:    10 KB
  rows:    221

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
2000-03-20 09:30:00	SPY	ETF	146.875	147.3438	146.5	147.0312	899500.0
2000-03-20 10:00:00	SPY	ETF	147.0	147.2812	146.5312	146.5625	304100.0
2000-03-20 10:30:00	SPY	ETF	146.5625	147.0	146.1875	146.5312	545900.0
2000-03-20 11:00:00	SPY	ETF	146.5625	147.0625	146.375	147.0625	700200.0
2000-03-20 11:30:00	SPY	ETF	147.0625	147.1562	146.5625	146.8125	547800.0
2000-03-20 12:00:00	SPY	ETF	146.9375	147.0625	146.5938	147.0	559200.0
2000-03-20 12:30:00	SPY	ETF	146.75	147.1562	146.5	146.7812	2545100.0
2000-03-20 13:00:00	SPY	ETF	146.625	146.7188	146.3125	146.3438	418000.0
2000-03-20 13:30:00	SPY	ETF	146.4688	146.9375	146.1875	146.25	477400.0
2000-03-20 14:00:00	SPY	ETF	146.1875	146.6875	145.6875	145.6875	951200.0
2000-03-20 14:30:00	SPY	ETF	145.8125	146.0938	144.7812	145.8125	1660300.0
2000-03-20 15:00:00	SPY	ETF	145.5625	146.0312	145.2812	145.6875	1403100.0
2000-03-20 15:30:00	SPY	ETF	145.75	146.1875	145.5938	145.9688	1074900.0
2000-03-20 16:00:00	SPY	ETF	145.8125	146.375	145.8125	146.1875	343900.0
2000-03-20 16:30:00	SPY	ETF	146.7812	146.7812	146.7812	146.7812	300.0
2000-03-20 17:30:00	SPY	ETF	146.1875	146.1875	146.1875	146.1875	200.0
2000-03-20 09:30:00	QQQ	ETF	111.0	111.5	110.0625	110.75	2712900.0
2000-03-20 10:00:00	QQQ	ETF	110.7812	111.3438	110.5	110.5	1210000.0
2000-03-20 10:30:00	QQQ	ETF	110.4375	110.875	109.125	109.7188	1484900.0
2000-03-20 11:00:00	QQQ	ETF	109.5312	110.3125	109.125	110.3125	1349700.0
2000-03-20 11:30:00	QQQ	ETF	110.3125	110.7188	109.6875	110.1875	609100.0
2000-03-20 12:00:00	QQQ	ETF	110.125	110.625	109.625	110.1875	1036700.0
2000-03-20 12:30:00	QQQ	ETF	110.2812	110.5312	109.375	109.5	942700.0
2000-03-20 13:00:00	QQQ	ETF	109.5	109.5	108.75	108.9688	1216600.0
2000-03-20 13:30:00	QQQ	ETF	108.7812	109.5	108.125	108.25	1515700.0
2000-03-20 14:00:00	QQQ	ETF	108.25	108.625	106.875	106.875	2336500.0
2000-03-20 14:30:00	QQQ	ETF	107.0	108.0	106.25	107.25	2049400.0
2000-03-20 15:00:00	QQQ	ETF	107.375	107.75	106.5	107.375	1708500.0
2000-03-20 15:30:00	QQQ	ETF	107.3125	107.75	106.5	106.75	2157700.0
2000-03-20 16:00:00	QQQ	ETF	106.75	107.125	106.6875	107.0	631900.0
2000-03-20 16:30:00	QQQ	ETF	107.125	107.75	107.0	107.25	3900.0
2000-03-20 17:00:00	QQQ	ETF	107.5	107.6875	107.25	107.6875	600.0
2000-03-20 17:30:00	QQQ	ETF	107.0	107.6875	107.0	107.6875	2300.0
2000-03-20 18:00:00	QQQ	ETF	107.6875	107.6875	107.6875	107.6875	300.0
2000-03-20 09:30:00	DIA	ETF	106.2812	106.8438	106.125	106.625	153100.0
2000-03-20 10:00:00	DIA	ETF	106.75	106.9375	106.3125	106.3125	105700.0
2000-03-20 10:30:00	DIA	ETF	106.3438	106.9375	106.3438	106.875	71400.0
2000-03-20 11:00:00	DIA	ETF	106.875	107.2812	106.8125	107.2188	173400.0
2000-03-20 11:30:00	DIA	ETF	107.0938	107.3438	107.0	107.0	102500.0
2000-03-20 12:00:00	DIA	ETF	107.0625	107.25	106.875	107.25	88500.0
2000-03-20 12:30:00	DIA	ETF	107.125	107.2188	106.6875	106.7812	44500.0
2000-03-20 13:00:00	DIA	ETF	106.7812	107.0938	106.625	106.9688	96200.0
2000-03-20 13:30:00	DIA	ETF	106.9688	107.25	106.8125	106.9375	99400.0
2000-03-20 14:00:00	DIA	ETF	106.8125	107.1875	106.5625	106.7188	65400.0
2000-03-20 14:30:00	DIA	ETF	106.5	106.75	105.875	106.375	342900.0
2000-03-20 15:00:00	DIA	ETF	106.375	106.8125	106.25	106.5938	98900.0
2000-03-20 15:30:00	DIA	ETF	106.7188	107.0	106.5	106.6875	242800.0
2000-03-20 16:00:00	DIA	ETF	106.6875	106.9375	106.5625	106.8125	30900.0

> showing 48 of 221 rows — these rows as CSV

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