PREVIEW / etf_30min / 2000-04-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-20.parquet
  size:    9 KB
  rows:    181

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-04-20 09:30:00	SPY	ETF	143.5625	143.9375	142.875	143.0625	1066000.0
2000-04-20 10:00:00	SPY	ETF	143.125	143.3438	142.7812	143.3438	723200.0
2000-04-20 10:30:00	SPY	ETF	143.1875	143.9062	143.125	143.2812	406900.0
2000-04-20 11:00:00	SPY	ETF	143.5	143.9375	143.2188	143.5	707000.0
2000-04-20 11:30:00	SPY	ETF	143.5	143.625	143.125	143.125	876200.0
2000-04-20 12:00:00	SPY	ETF	143.25	143.25	142.375	142.4062	453500.0
2000-04-20 12:30:00	SPY	ETF	142.5312	143.2188	142.5312	142.6875	705400.0
2000-04-20 13:00:00	SPY	ETF	142.875	143.2812	142.6562	143.0312	422400.0
2000-04-20 13:30:00	SPY	ETF	143.0	143.375	142.8438	143.125	193600.0
2000-04-20 14:00:00	SPY	ETF	143.1562	143.1562	142.4375	142.6562	558700.0
2000-04-20 14:30:00	SPY	ETF	142.875	143.375	142.75	143.375	152900.0
2000-04-20 15:00:00	SPY	ETF	143.1875	143.875	143.125	143.5312	1478300.0
2000-04-20 15:30:00	SPY	ETF	143.4375	143.875	143.3125	143.375	304500.0
2000-04-20 16:00:00	SPY	ETF	143.5	143.8125	143.4062	143.8125	354600.0
2000-04-20 09:30:00	QQQ	ETF	90.375	90.9688	89.0	89.0	3104100.0
2000-04-20 10:00:00	QQQ	ETF	89.0	89.4062	88.0625	89.0	2578000.0
2000-04-20 10:30:00	QQQ	ETF	89.0	89.5	88.3125	88.5625	1400700.0
2000-04-20 11:00:00	QQQ	ETF	88.75	89.25	88.625	88.8125	623200.0
2000-04-20 11:30:00	QQQ	ETF	88.8125	88.9375	87.1875	87.1875	1317000.0
2000-04-20 12:00:00	QQQ	ETF	87.1875	87.375	86.1875	86.25	1778800.0
2000-04-20 12:30:00	QQQ	ETF	86.3125	87.5625	86.1875	86.625	1833000.0
2000-04-20 13:00:00	QQQ	ETF	86.75	87.375	86.375	87.25	1078100.0
2000-04-20 13:30:00	QQQ	ETF	87.0	87.875	87.0	87.8125	1189200.0
2000-04-20 14:00:00	QQQ	ETF	87.625	87.75	86.375	86.9375	1127400.0
2000-04-20 14:30:00	QQQ	ETF	86.9375	88.2188	86.75	88.0	1418500.0
2000-04-20 15:00:00	QQQ	ETF	88.0	88.9375	87.625	88.1875	1498200.0
2000-04-20 15:30:00	QQQ	ETF	88.125	88.375	87.3125	87.3125	1700700.0
2000-04-20 16:00:00	QQQ	ETF	87.5	87.625	86.875	87.625	479600.0
2000-04-20 16:30:00	QQQ	ETF	87.25	87.375	86.8125	86.875	22400.0
2000-04-20 17:00:00	QQQ	ETF	86.75	86.75	86.75	86.75	500.0
2000-04-20 17:30:00	QQQ	ETF	86.5	86.5	86.0625	86.0625	2500.0
2000-04-20 18:00:00	QQQ	ETF	86.375	87.25	86.375	87.25	500.0
2000-04-20 09:30:00	DIA	ETF	107.0625	107.375	106.8438	107.125	47900.0
2000-04-20 10:00:00	DIA	ETF	107.0	107.4375	106.8438	107.4375	356800.0
2000-04-20 10:30:00	DIA	ETF	107.25	107.8438	107.25	107.5938	170700.0
2000-04-20 11:00:00	DIA	ETF	107.5625	108.2812	107.5625	108.2188	215200.0
2000-04-20 11:30:00	DIA	ETF	108.0	108.125	107.75	107.75	53000.0
2000-04-20 12:00:00	DIA	ETF	107.6875	108.0	107.3438	107.5	206000.0
2000-04-20 12:30:00	DIA	ETF	107.4375	108.0312	107.4375	107.875	100900.0
2000-04-20 13:00:00	DIA	ETF	107.7188	108.2188	107.6875	108.0	121700.0
2000-04-20 13:30:00	DIA	ETF	107.9062	108.2188	107.875	108.0312	23200.0
2000-04-20 14:00:00	DIA	ETF	107.875	108.0938	107.5	107.8438	74500.0
2000-04-20 14:30:00	DIA	ETF	107.875	108.25	107.75	108.2188	92600.0
2000-04-20 15:00:00	DIA	ETF	108.0	108.5625	108.0	108.25	124200.0
2000-04-20 15:30:00	DIA	ETF	108.4688	108.5625	108.125	108.4062	136000.0
2000-04-20 16:00:00	DIA	ETF	108.25	108.7812	108.25	108.7812	38600.0

> showing 46 of 181 rows — these rows as CSV

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