PREVIEW / etf_30min / 2000-01-06

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-06.parquet
  size:    10 KB
  rows:    223

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-06 09:30:00	SPY	ETF	139.625	140.5	139.625	139.625	1263500.0
2000-01-06 10:00:00	SPY	ETF	139.6875	140.3125	139.25	139.4688	761200.0
2000-01-06 10:30:00	SPY	ETF	139.7188	140.625	139.6562	140.3125	149500.0
2000-01-06 11:00:00	SPY	ETF	140.3125	140.6875	140.0312	140.2188	193200.0
2000-01-06 11:30:00	SPY	ETF	140.125	140.5	140.0	140.3438	161600.0
2000-01-06 12:00:00	SPY	ETF	140.375	140.8438	140.1875	140.7188	195500.0
2000-01-06 12:30:00	SPY	ETF	140.8438	141.0938	140.5938	141.0938	121500.0
2000-01-06 13:00:00	SPY	ETF	141.125	141.4062	140.8125	141.0625	226100.0
2000-01-06 13:30:00	SPY	ETF	140.9375	141.25	140.7812	141.25	234600.0
2000-01-06 14:00:00	SPY	ETF	141.2812	141.375	141.0	141.375	166300.0
2000-01-06 14:30:00	SPY	ETF	141.4688	141.5	140.5938	140.875	358900.0
2000-01-06 15:00:00	SPY	ETF	140.9375	141.125	139.5938	140.3438	1077300.0
2000-01-06 15:30:00	SPY	ETF	140.4688	141.1875	140.2812	140.3438	319200.0
2000-01-06 16:00:00	SPY	ETF	140.375	140.375	138.875	139.5625	844100.0
2000-01-06 16:30:00	SPY	ETF	138.875	138.875	138.625	138.625	14000.0
2000-01-06 17:00:00	SPY	ETF	137.75	137.75	137.75	137.75	70400.0
2000-01-06 09:30:00	QQQ	ETF	86.875	88.0	86.0156	86.1875	5899000.0
2000-01-06 10:00:00	QQQ	ETF	86.1562	87.0	84.875	85.375	4450600.0
2000-01-06 10:30:00	QQQ	ETF	85.1562	86.25	85.125	85.9375	2939800.0
2000-01-06 11:00:00	QQQ	ETF	86.0	86.2031	85.25	85.5	1331800.0
2000-01-06 11:30:00	QQQ	ETF	85.5	85.7812	85.125	85.4688	709000.0
2000-01-06 12:00:00	QQQ	ETF	85.4375	85.9844	85.375	85.875	1558200.0
2000-01-06 12:30:00	QQQ	ETF	86.0	86.4062	85.625	86.375	1737800.0
2000-01-06 13:00:00	QQQ	ETF	86.4844	86.625	85.8125	86.0	1511200.0
2000-01-06 13:30:00	QQQ	ETF	86.0	86.125	85.4062	85.75	1360000.0
2000-01-06 14:00:00	QQQ	ETF	85.875	85.9375	85.125	85.625	1639800.0
2000-01-06 14:30:00	QQQ	ETF	85.6719	85.7188	84.125	84.5	2200600.0
2000-01-06 15:00:00	QQQ	ETF	84.75	84.9375	83.0	84.2188	4944800.0
2000-01-06 15:30:00	QQQ	ETF	84.1875	85.2188	83.5	83.5625	3414000.0
2000-01-06 16:00:00	QQQ	ETF	83.5625	83.75	80.9688	81.25	2989000.0
2000-01-06 16:30:00	QQQ	ETF	81.0	81.75	80.625	80.75	113800.0
2000-01-06 17:00:00	QQQ	ETF	80.9688	81.5312	79.75	81.25	81400.0
2000-01-06 17:30:00	QQQ	ETF	80.25	80.5	80.0	80.0	24200.0
2000-01-06 18:00:00	QQQ	ETF	80.0938	80.125	80.0	80.0938	2800.0
2000-01-06 09:30:00	DIA	ETF	111.4062	111.75	111.1875	111.4062	466100.0
2000-01-06 10:00:00	DIA	ETF	111.375	111.8438	111.3125	111.5	94100.0
2000-01-06 10:30:00	DIA	ETF	111.7188	112.0	111.5	111.9688	690500.0
2000-01-06 11:00:00	DIA	ETF	111.9688	112.1875	111.75	111.875	63700.0
2000-01-06 11:30:00	DIA	ETF	111.875	112.2188	111.75	112.1562	22200.0
2000-01-06 12:00:00	DIA	ETF	112.1562	112.4688	112.0	112.25	221200.0
2000-01-06 12:30:00	DIA	ETF	112.5	112.75	112.3125	112.7188	30600.0
2000-01-06 13:00:00	DIA	ETF	112.625	113.0938	112.625	112.6562	52200.0
2000-01-06 13:30:00	DIA	ETF	112.625	112.9062	112.5	112.8438	26300.0
2000-01-06 14:00:00	DIA	ETF	112.875	113.125	112.75	113.125	56000.0
2000-01-06 14:30:00	DIA	ETF	113.125	113.1562	112.75	112.9375	104500.0
2000-01-06 15:00:00	DIA	ETF	112.8125	113.125	111.9375	112.6875	376000.0
2000-01-06 15:30:00	DIA	ETF	112.6875	113.0	112.375	112.6875	209000.0
2000-01-06 16:00:00	DIA	ETF	112.5	112.5625	111.5625	112.1875	168400.0
2000-01-06 16:30:00	DIA	ETF	111.75	111.75	111.75	111.75	300.0

> showing 49 of 223 rows — these rows as CSV

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