PREVIEW / etf_30min / 2000-02-01

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-02-01.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-02-01 09:30:00	SPY	ETF	139.75	139.75	139.0312	139.4688	1106900.0
2000-02-01 10:00:00	SPY	ETF	139.25	139.7188	138.5312	138.9375	482700.0
2000-02-01 10:30:00	SPY	ETF	139.0	139.8125	138.9375	139.5	813900.0
2000-02-01 11:00:00	SPY	ETF	139.5	139.9688	139.3438	139.8438	375800.0
2000-02-01 11:30:00	SPY	ETF	139.875	139.9688	139.2188	139.3438	464600.0
2000-02-01 12:00:00	SPY	ETF	139.2812	140.25	139.125	140.25	367400.0
2000-02-01 12:30:00	SPY	ETF	140.1875	140.3438	139.9688	140.3438	783200.0
2000-02-01 13:00:00	SPY	ETF	140.25	140.5938	140.0938	140.375	543500.0
2000-02-01 13:30:00	SPY	ETF	140.25	140.3438	139.9062	140.0938	486800.0
2000-02-01 14:00:00	SPY	ETF	139.875	140.625	139.8438	140.3438	477100.0
2000-02-01 14:30:00	SPY	ETF	140.3125	140.5	139.875	140.125	451600.0
2000-02-01 15:00:00	SPY	ETF	140.2812	141.0938	140.0312	140.75	486600.0
2000-02-01 15:30:00	SPY	ETF	140.6875	141.6875	140.6562	140.9062	841800.0
2000-02-01 16:00:00	SPY	ETF	140.9062	141.2812	140.9062	140.9375	367800.0
2000-02-01 18:00:00	SPY	ETF	140.9375	140.9375	140.9375	140.9375	100.0
2000-02-01 09:30:00	QQQ	ETF	89.5312	90.4375	89.2188	89.4062	3428400.0
2000-02-01 10:00:00	QQQ	ETF	89.4062	89.7188	88.4375	89.3125	2786800.0
2000-02-01 10:30:00	QQQ	ETF	89.3125	90.1562	89.2969	89.8125	2342000.0
2000-02-01 11:00:00	QQQ	ETF	89.8594	90.5312	89.5938	90.5156	952000.0
2000-02-01 11:30:00	QQQ	ETF	90.5	90.75	90.2188	90.4375	1403600.0
2000-02-01 12:00:00	QQQ	ETF	90.4375	91.1562	90.2188	91.0	1515800.0
2000-02-01 12:30:00	QQQ	ETF	91.0312	91.25	90.75	90.9375	2553200.0
2000-02-01 13:00:00	QQQ	ETF	90.9688	91.4688	90.8438	91.3594	1569800.0
2000-02-01 13:30:00	QQQ	ETF	91.3125	91.3438	90.6562	90.9219	1047000.0
2000-02-01 14:00:00	QQQ	ETF	90.9219	91.2344	90.5	91.1875	1481200.0
2000-02-01 14:30:00	QQQ	ETF	91.1875	91.4062	90.4062	90.6719	886800.0
2000-02-01 15:00:00	QQQ	ETF	90.6719	91.75	90.625	91.4375	2223600.0
2000-02-01 15:30:00	QQQ	ETF	91.5625	92.5	91.5	92.1562	3315800.0
2000-02-01 16:00:00	QQQ	ETF	92.3125	92.375	92.125	92.2188	476800.0
2000-02-01 16:30:00	QQQ	ETF	92.0938	92.5	92.0938	92.5	3000.0
2000-02-01 17:00:00	QQQ	ETF	92.0938	92.0938	92.0938	92.0938	1000.0
2000-02-01 09:30:00	DIA	ETF	109.5625	109.7812	109.3125	109.375	212000.0
2000-02-01 10:00:00	DIA	ETF	109.625	109.8125	109.0312	109.0312	167000.0
2000-02-01 10:30:00	DIA	ETF	109.3438	109.9375	109.3438	109.75	48700.0
2000-02-01 11:00:00	DIA	ETF	109.625	109.9688	109.625	109.8438	17900.0
2000-02-01 11:30:00	DIA	ETF	109.9062	109.9688	109.375	109.375	25900.0
2000-02-01 12:00:00	DIA	ETF	109.5	109.9688	109.4375	109.9688	31500.0
2000-02-01 12:30:00	DIA	ETF	110.0	110.0	109.6875	109.9688	38900.0
2000-02-01 13:00:00	DIA	ETF	110.0	110.2812	109.875	110.0625	40700.0
2000-02-01 13:30:00	DIA	ETF	110.0	110.0	109.6875	109.8438	13400.0
2000-02-01 14:00:00	DIA	ETF	109.8125	110.375	109.5938	110.2812	35000.0
2000-02-01 14:30:00	DIA	ETF	110.2812	110.2812	109.7188	109.9688	27400.0
2000-02-01 15:00:00	DIA	ETF	110.0	110.4062	109.875	110.0938	38200.0
2000-02-01 15:30:00	DIA	ETF	110.0625	110.7188	110.0	110.2812	69100.0
2000-02-01 16:00:00	DIA	ETF	110.375	110.5	110.2812	110.2812	20800.0

> showing 45 of 215 rows — these rows as CSV

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