PREVIEW / etf_30min / 2000-04-05

all etf 30-min files

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

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-05 09:30:00	SPY	ETF	147.875	150.4375	147.875	149.0	1370300.0
2000-04-05 10:00:00	SPY	ETF	149.0	149.875	148.25	149.25	633200.0
2000-04-05 10:30:00	SPY	ETF	149.25	150.8125	149.25	149.8438	437900.0
2000-04-05 11:00:00	SPY	ETF	149.75	149.75	148.0312	148.75	423200.0
2000-04-05 11:30:00	SPY	ETF	148.6875	149.125	147.625	148.0625	546300.0
2000-04-05 12:00:00	SPY	ETF	148.0625	149.25	147.9062	149.1875	182200.0
2000-04-05 12:30:00	SPY	ETF	149.1875	149.5625	148.9062	149.2188	187800.0
2000-04-05 13:00:00	SPY	ETF	149.375	150.1875	149.125	149.625	739500.0
2000-04-05 13:30:00	SPY	ETF	149.625	150.1875	149.0312	149.75	443700.0
2000-04-05 14:00:00	SPY	ETF	149.75	150.4375	149.4375	150.0	337700.0
2000-04-05 14:30:00	SPY	ETF	150.125	150.5625	149.4062	150.25	594100.0
2000-04-05 15:00:00	SPY	ETF	150.1562	150.7812	149.4375	149.625	708000.0
2000-04-05 15:30:00	SPY	ETF	149.5312	149.6875	148.2812	148.875	812700.0
2000-04-05 16:00:00	SPY	ETF	148.9375	149.375	148.75	149.1875	315100.0
2000-04-05 09:30:00	QQQ	ETF	97.5	101.5	96.25	97.5	6533200.0
2000-04-05 10:00:00	QQQ	ETF	98.75	100.2812	97.5	100.0625	3279300.0
2000-04-05 10:30:00	QQQ	ETF	100.125	102.125	99.5	99.75	3245100.0
2000-04-05 11:00:00	QQQ	ETF	100.0625	101.0	98.5	99.5312	2253100.0
2000-04-05 11:30:00	QQQ	ETF	99.75	100.7812	98.625	99.0625	982000.0
2000-04-05 12:00:00	QQQ	ETF	99.0	100.5	98.4375	100.5	1187600.0
2000-04-05 12:30:00	QQQ	ETF	100.5	101.625	100.125	101.25	1396300.0
2000-04-05 13:00:00	QQQ	ETF	101.25	103.0	101.0	101.875	2782700.0
2000-04-05 13:30:00	QQQ	ETF	102.0	102.75	101.1875	102.25	2479600.0
2000-04-05 14:00:00	QQQ	ETF	102.25	103.5	102.0625	103.0	2409700.0
2000-04-05 14:30:00	QQQ	ETF	102.875	103.625	102.25	103.3125	1930600.0
2000-04-05 15:00:00	QQQ	ETF	103.125	103.9375	101.1875	101.375	3418300.0
2000-04-05 15:30:00	QQQ	ETF	101.3125	102.0	98.875	100.125	3436000.0
2000-04-05 16:00:00	QQQ	ETF	100.25	100.875	100.0	100.5	592500.0
2000-04-05 16:30:00	QQQ	ETF	100.5	100.75	99.75	100.125	8500.0
2000-04-05 17:00:00	QQQ	ETF	100.0	100.125	100.0	100.125	1700.0
2000-04-05 17:30:00	QQQ	ETF	99.875	100.0	99.875	100.0	300.0
2000-04-05 18:00:00	QQQ	ETF	100.125	100.125	100.125	100.125	100.0
2000-04-05 09:30:00	DIA	ETF	110.3125	112.125	110.2812	111.5	329400.0
2000-04-05 10:00:00	DIA	ETF	111.5625	111.9688	111.0312	111.3125	119300.0
2000-04-05 10:30:00	DIA	ETF	111.8125	112.3125	111.3125	111.6875	251300.0
2000-04-05 11:00:00	DIA	ETF	111.4062	111.5625	110.5312	111.0625	1080300.0
2000-04-05 11:30:00	DIA	ETF	110.7812	111.0625	109.875	110.4062	124600.0
2000-04-05 12:00:00	DIA	ETF	110.4062	111.0	110.1875	111.0	89200.0
2000-04-05 12:30:00	DIA	ETF	111.0625	111.2812	110.625	110.9375	72700.0
2000-04-05 13:00:00	DIA	ETF	111.0	111.25	110.5625	110.75	90000.0
2000-04-05 13:30:00	DIA	ETF	110.9375	111.3438	110.4688	110.5625	746700.0
2000-04-05 14:00:00	DIA	ETF	110.8438	111.1875	110.5938	110.75	182400.0
2000-04-05 14:30:00	DIA	ETF	110.7812	111.0938	110.4688	110.75	89700.0
2000-04-05 15:00:00	DIA	ETF	110.9375	111.4688	110.6875	110.75	49400.0
2000-04-05 15:30:00	DIA	ETF	110.75	111.125	110.0312	110.2812	99300.0
2000-04-05 16:00:00	DIA	ETF	110.2812	110.5625	110.2812	110.375	14600.0

> showing 46 of 215 rows — these rows as CSV

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