PREVIEW / etf_30min / 2000-04-04

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-04.parquet
  size:    10 KB
  rows:    217

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-04 09:30:00	SPY	ETF	151.75	152.4062	150.8438	152.4062	1363300.0
2000-04-04 10:00:00	SPY	ETF	152.3438	153.0	151.875	152.125	1040000.0
2000-04-04 10:30:00	SPY	ETF	152.125	152.2188	150.6562	151.25	862700.0
2000-04-04 11:00:00	SPY	ETF	151.25	151.6562	150.75	151.0312	774800.0
2000-04-04 11:30:00	SPY	ETF	151.1875	151.1875	147.6875	148.0625	1803500.0
2000-04-04 12:00:00	SPY	ETF	147.875	149.4688	147.5	148.25	1459200.0
2000-04-04 12:30:00	SPY	ETF	148.1562	148.2188	144.0	144.6875	2044700.0
2000-04-04 13:00:00	SPY	ETF	144.3125	145.5	141.375	144.875	1269900.0
2000-04-04 13:30:00	SPY	ETF	145.5	147.625	144.75	146.75	1283500.0
2000-04-04 14:00:00	SPY	ETF	146.8125	149.0	145.5	148.75	1498400.0
2000-04-04 14:30:00	SPY	ETF	148.375	148.9375	146.3125	147.0625	718200.0
2000-04-04 15:00:00	SPY	ETF	147.375	150.5	147.2188	150.5	1665800.0
2000-04-04 15:30:00	SPY	ETF	150.5	151.25	149.0625	150.0	867500.0
2000-04-04 16:00:00	SPY	ETF	149.75	150.375	145.3438	145.3438	1408900.0
2000-04-04 17:00:00	SPY	ETF	145.75	145.75	145.75	145.75	600000.0
2000-04-04 09:30:00	QQQ	ETF	103.625	103.6875	100.0312	103.0	6771700.0
2000-04-04 10:00:00	QQQ	ETF	103.0	103.875	100.5	101.1875	4656800.0
2000-04-04 10:30:00	QQQ	ETF	101.25	102.0	97.375	98.9375	4902700.0
2000-04-04 11:00:00	QQQ	ETF	98.9375	100.5	98.375	99.25	3076800.0
2000-04-04 11:30:00	QQQ	ETF	99.1875	99.9375	93.5	93.5	4975400.0
2000-04-04 12:00:00	QQQ	ETF	94.5	96.8125	93.5	95.0	4388600.0
2000-04-04 12:30:00	QQQ	ETF	95.75	95.75	91.25	92.8125	3979300.0
2000-04-04 13:00:00	QQQ	ETF	92.4375	93.875	88.3125	93.75	5417700.0
2000-04-04 13:30:00	QQQ	ETF	93.75	96.125	92.0	96.0	5853900.0
2000-04-04 14:00:00	QQQ	ETF	96.0	101.0	94.0	100.5625	6479100.0
2000-04-04 14:30:00	QQQ	ETF	100.5625	101.0	95.375	97.0	4019100.0
2000-04-04 15:00:00	QQQ	ETF	96.9375	102.0	96.0	102.0	4528500.0
2000-04-04 15:30:00	QQQ	ETF	102.0	103.9375	98.125	101.0625	4746100.0
2000-04-04 16:00:00	QQQ	ETF	101.1562	101.375	99.5	100.3125	636600.0
2000-04-04 16:30:00	QQQ	ETF	100.3125	101.0	100.3125	100.5	4800.0
2000-04-04 17:00:00	QQQ	ETF	100.625	100.75	100.0	100.0	900.0
2000-04-04 17:30:00	QQQ	ETF	100.5	100.75	100.0625	100.75	700.0
2000-04-04 18:00:00	QQQ	ETF	100.5	101.9375	100.5	101.9375	4100.0
2000-04-04 09:30:00	DIA	ETF	112.5625	113.9688	112.2188	113.8125	333200.0
2000-04-04 10:00:00	DIA	ETF	113.9688	114.3438	113.4062	114.0312	905900.0
2000-04-04 10:30:00	DIA	ETF	114.125	114.125	113.375	113.625	271200.0
2000-04-04 11:00:00	DIA	ETF	113.4375	113.75	113.25	113.5	303000.0
2000-04-04 11:30:00	DIA	ETF	113.5	113.6875	111.3438	111.3438	669800.0
2000-04-04 12:00:00	DIA	ETF	111.3438	112.25	111.125	111.5938	589100.0
2000-04-04 12:30:00	DIA	ETF	111.6875	111.6875	107.5625	107.5625	788500.0
2000-04-04 13:00:00	DIA	ETF	107.8125	110.375	106.3438	110.0625	922400.0
2000-04-04 13:30:00	DIA	ETF	110.0625	111.2188	109.25	110.9375	771400.0
2000-04-04 14:00:00	DIA	ETF	110.9375	111.625	109.2812	111.0312	294000.0
2000-04-04 14:30:00	DIA	ETF	111.0	111.25	109.6875	110.4375	167600.0
2000-04-04 15:00:00	DIA	ETF	110.4688	112.375	110.1562	112.375	261900.0
2000-04-04 15:30:00	DIA	ETF	112.4375	112.6562	111.2188	111.9688	288000.0
2000-04-04 16:00:00	DIA	ETF	111.9688	112.0625	111.6562	111.6875	9400.0

> showing 47 of 217 rows — these rows as CSV

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