PREVIEW / etf_30min / 2000-01-04

all etf 30-min files

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

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-04 09:30:00	SPY	ETF	143.5312	144.0625	143.2188	143.8438	744800.0
2000-01-04 10:00:00	SPY	ETF	143.8125	143.875	143.2812	143.5	713400.0
2000-01-04 10:30:00	SPY	ETF	143.5	143.8438	143.0625	143.375	695800.0
2000-01-04 11:00:00	SPY	ETF	143.5	143.625	142.6562	143.1562	363600.0
2000-01-04 11:30:00	SPY	ETF	143.0	143.25	142.875	142.9062	227500.0
2000-01-04 12:00:00	SPY	ETF	142.8438	143.0312	142.25	142.4688	476700.0
2000-01-04 12:30:00	SPY	ETF	142.625	142.7188	141.6875	141.75	457600.0
2000-01-04 13:00:00	SPY	ETF	141.7188	141.875	140.6562	141.4375	1230600.0
2000-01-04 13:30:00	SPY	ETF	141.5312	141.875	141.3438	141.625	429300.0
2000-01-04 14:00:00	SPY	ETF	141.5	141.875	141.0	141.0	467600.0
2000-01-04 14:30:00	SPY	ETF	141.0625	141.8125	140.7812	141.0938	365300.0
2000-01-04 15:00:00	SPY	ETF	141.0938	141.0938	140.1562	140.5625	902500.0
2000-01-04 15:30:00	SPY	ETF	140.625	141.0312	139.625	140.0625	589400.0
2000-01-04 16:00:00	SPY	ETF	139.875	140.0938	139.75	139.75	378600.0
2000-01-04 17:00:00	SPY	ETF	139.75	139.75	139.75	139.75	1000.0
2000-01-04 09:30:00	QQQ	ETF	92.0	93.5	91.8125	93.0938	4536800.0
2000-01-04 10:00:00	QQQ	ETF	92.9688	93.375	92.75	93.3125	2550200.0
2000-01-04 10:30:00	QQQ	ETF	93.3125	93.4844	92.7188	93.0625	1884200.0
2000-01-04 11:00:00	QQQ	ETF	93.0625	93.2188	92.25	92.6562	2086600.0
2000-01-04 11:30:00	QQQ	ETF	92.625	92.8125	92.4062	92.4844	749000.0
2000-01-04 12:00:00	QQQ	ETF	92.4844	92.5469	91.875	92.1562	2109400.0
2000-01-04 12:30:00	QQQ	ETF	92.125	92.4688	91.25	91.25	1803200.0
2000-01-04 13:00:00	QQQ	ETF	91.25	91.375	89.9375	90.6875	3411000.0
2000-01-04 13:30:00	QQQ	ETF	90.875	91.7188	90.5	91.25	3492800.0
2000-01-04 14:00:00	QQQ	ETF	91.25	91.4688	90.875	91.1562	1259400.0
2000-01-04 14:30:00	QQQ	ETF	91.0625	91.3281	90.25	90.75	2699400.0
2000-01-04 15:00:00	QQQ	ETF	90.75	90.7969	89.4062	90.3125	2901000.0
2000-01-04 15:30:00	QQQ	ETF	90.3125	90.5312	88.5	88.8125	3253000.0
2000-01-04 16:00:00	QQQ	ETF	88.75	88.75	88.0156	88.0625	862200.0
2000-01-04 16:30:00	QQQ	ETF	87.9375	88.25	87.9375	88.25	1600.0
2000-01-04 17:00:00	QQQ	ETF	88.0	88.0156	88.0	88.0156	1800.0
2000-01-04 17:30:00	QQQ	ETF	88.2188	88.5	88.2188	88.5	1400.0
2000-01-04 18:00:00	QQQ	ETF	88.375	88.375	88.125	88.25	2400.0
2000-01-04 09:30:00	DIA	ETF	112.2812	112.9688	112.25	112.625	158800.0
2000-01-04 10:00:00	DIA	ETF	112.625	112.625	112.3125	112.4688	82100.0
2000-01-04 10:30:00	DIA	ETF	112.4688	112.5938	112.25	112.3125	28400.0
2000-01-04 11:00:00	DIA	ETF	112.3125	112.4062	111.625	111.9062	81100.0
2000-01-04 11:30:00	DIA	ETF	112.0	112.1875	111.7812	112.0	30400.0
2000-01-04 12:00:00	DIA	ETF	112.0	112.0938	111.5312	111.7188	85100.0
2000-01-04 12:30:00	DIA	ETF	111.7188	111.8125	111.0	111.0	143600.0
2000-01-04 13:00:00	DIA	ETF	111.0625	111.1875	110.3438	110.875	215500.0
2000-01-04 13:30:00	DIA	ETF	110.9688	111.3125	110.8125	111.0312	158200.0
2000-01-04 14:00:00	DIA	ETF	110.875	111.0312	110.625	110.75	152200.0
2000-01-04 14:30:00	DIA	ETF	110.5	111.0	110.3438	110.5	142600.0
2000-01-04 15:00:00	DIA	ETF	110.4688	110.5	109.8438	110.2812	164800.0
2000-01-04 15:30:00	DIA	ETF	110.3125	110.5938	109.8125	110.1562	74300.0
2000-01-04 16:00:00	DIA	ETF	109.9375	109.9375	109.75	109.75	16300.0

> showing 47 of 222 rows — these rows as CSV

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