PREVIEW / etf_30min / 2000-01-21

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-21.parquet
  size:    10 KB
  rows:    233

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-01-21 09:30:00	SPY	ETF	145.5	145.5	144.8125	145.2188	678600.0
2000-01-21 10:00:00	SPY	ETF	145.1875	145.3125	144.3125	144.4375	617900.0
2000-01-21 10:30:00	SPY	ETF	144.4688	144.8125	144.125	144.75	1073600.0
2000-01-21 11:00:00	SPY	ETF	144.75	145.0625	144.625	144.6875	225800.0
2000-01-21 11:30:00	SPY	ETF	144.625	144.875	144.25	144.2812	389700.0
2000-01-21 12:00:00	SPY	ETF	144.25	144.875	144.25	144.6562	868000.0
2000-01-21 12:30:00	SPY	ETF	144.625	144.8438	144.375	144.625	322300.0
2000-01-21 13:00:00	SPY	ETF	144.5	144.8125	144.4375	144.8125	519600.0
2000-01-21 13:30:00	SPY	ETF	144.8125	145.125	144.6875	144.9375	364200.0
2000-01-21 14:00:00	SPY	ETF	144.875	145.0	144.4688	144.625	131600.0
2000-01-21 14:30:00	SPY	ETF	144.75	144.8125	144.2188	144.4375	80500.0
2000-01-21 15:00:00	SPY	ETF	144.4375	144.625	144.1562	144.4688	241800.0
2000-01-21 15:30:00	SPY	ETF	144.4688	144.5938	144.0938	144.125	472500.0
2000-01-21 16:00:00	SPY	ETF	144.0625	144.625	144.0625	144.4375	217300.0
2000-01-21 16:30:00	SPY	ETF	144.4375	144.4375	144.4375	144.4375	400.0
2000-01-21 19:00:00	SPY	ETF	144.5938	144.5938	144.5938	144.5938	150300.0
2000-01-21 09:30:00	QQQ	ETF	96.5	96.5625	95.9062	96.2344	2791800.0
2000-01-21 10:00:00	QQQ	ETF	96.1875	96.2344	95.0625	95.375	2162200.0
2000-01-21 10:30:00	QQQ	ETF	95.375	95.9062	95.125	95.8125	1266200.0
2000-01-21 11:00:00	QQQ	ETF	95.75	96.1562	95.75	95.875	1186800.0
2000-01-21 11:30:00	QQQ	ETF	95.8125	96.125	95.25	95.4375	792600.0
2000-01-21 12:00:00	QQQ	ETF	95.5	96.1562	95.4688	96.1562	1671000.0
2000-01-21 12:30:00	QQQ	ETF	96.0	96.4375	95.875	96.2188	2285800.0
2000-01-21 13:00:00	QQQ	ETF	96.1875	96.3281	95.75	96.25	488800.0
2000-01-21 13:30:00	QQQ	ETF	96.25	96.5469	96.125	96.2812	819200.0
2000-01-21 14:00:00	QQQ	ETF	96.2344	96.3125	95.8125	95.8438	416400.0
2000-01-21 14:30:00	QQQ	ETF	95.8125	96.25	95.8125	95.8438	822800.0
2000-01-21 15:00:00	QQQ	ETF	95.8125	96.25	95.75	95.75	1563600.0
2000-01-21 15:30:00	QQQ	ETF	95.75	96.25	95.75	96.0625	1878800.0
2000-01-21 16:00:00	QQQ	ETF	96.125	96.4375	96.0625	96.2188	284600.0
2000-01-21 16:30:00	QQQ	ETF	96.25	96.3125	96.25	96.25	20000.0
2000-01-21 19:00:00	QQQ	ETF	96.125	96.125	96.125	96.125	297400.0
2000-01-21 09:30:00	DIA	ETF	114.1875	114.1875	113.375	113.5625	159500.0
2000-01-21 10:00:00	DIA	ETF	113.5938	113.7812	112.8125	113.0625	103800.0
2000-01-21 10:30:00	DIA	ETF	113.0625	113.1875	112.5938	113.0	63300.0
2000-01-21 11:00:00	DIA	ETF	113.125	113.1875	112.8125	113.0	31500.0
2000-01-21 11:30:00	DIA	ETF	112.9375	113.1875	112.6875	112.8438	20500.0
2000-01-21 12:00:00	DIA	ETF	112.7812	113.0	112.625	112.8438	37000.0
2000-01-21 12:30:00	DIA	ETF	112.9688	113.0	112.625	112.7812	24200.0
2000-01-21 13:00:00	DIA	ETF	112.6562	113.0	112.625	113.0	27000.0
2000-01-21 13:30:00	DIA	ETF	113.0312	113.1562	112.6875	112.9062	108900.0
2000-01-21 14:00:00	DIA	ETF	112.7812	113.125	112.625	112.625	36600.0
2000-01-21 14:30:00	DIA	ETF	112.875	112.9375	112.5312	112.7188	53600.0
2000-01-21 15:00:00	DIA	ETF	112.7812	112.7812	112.3125	112.375	58000.0
2000-01-21 15:30:00	DIA	ETF	112.4375	112.7812	112.3125	112.5	51300.0
2000-01-21 16:00:00	DIA	ETF	112.5	112.8125	112.3438	112.8125	8000.0
2000-01-21 19:00:00	DIA	ETF	112.5625	112.5625	112.5625	112.5625	46000.0

> showing 47 of 233 rows — these rows as CSV

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