PREVIEW / etf_30min / 2000-01-24

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-24.parquet
  size:    10 KB
  rows:    228

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-24 09:30:00	SPY	ETF	145.6562	145.8438	144.9062	145.0	706100.0
2000-01-24 10:00:00	SPY	ETF	145.0938	145.25	144.0938	144.1875	410200.0
2000-01-24 10:30:00	SPY	ETF	144.125	144.4375	143.5938	143.5938	200700.0
2000-01-24 11:00:00	SPY	ETF	143.5938	144.0625	143.375	143.4688	544300.0
2000-01-24 11:30:00	SPY	ETF	143.5312	143.875	143.2812	143.875	197300.0
2000-01-24 12:00:00	SPY	ETF	143.7188	144.125	143.7188	143.75	319800.0
2000-01-24 12:30:00	SPY	ETF	143.8125	143.9688	143.5625	143.7812	139400.0
2000-01-24 13:00:00	SPY	ETF	143.6875	143.9062	143.375	143.625	115700.0
2000-01-24 13:30:00	SPY	ETF	143.625	143.7188	142.375	142.6562	931700.0
2000-01-24 14:00:00	SPY	ETF	142.6875	142.8125	141.75	141.75	465400.0
2000-01-24 14:30:00	SPY	ETF	141.6875	142.0	141.0	141.0312	679200.0
2000-01-24 15:00:00	SPY	ETF	140.9375	141.375	139.9375	139.9375	812400.0
2000-01-24 15:30:00	SPY	ETF	140.0312	140.5	139.4062	140.0625	1895500.0
2000-01-24 16:00:00	SPY	ETF	140.0	140.5	140.0	140.3438	400500.0
2000-01-24 09:30:00	QQQ	ETF	97.4375	97.625	96.75	96.75	2649600.0
2000-01-24 10:00:00	QQQ	ETF	96.8438	97.3125	96.375	96.5938	2139800.0
2000-01-24 10:30:00	QQQ	ETF	96.5625	96.6875	95.9219	95.9375	2213600.0
2000-01-24 11:00:00	QQQ	ETF	95.9375	96.1875	95.3906	95.625	2373600.0
2000-01-24 11:30:00	QQQ	ETF	95.625	96.0781	95.5	96.0	1501000.0
2000-01-24 12:00:00	QQQ	ETF	96.0	96.5	95.9688	95.9688	1416800.0
2000-01-24 12:30:00	QQQ	ETF	95.9688	96.2812	95.875	96.1562	381200.0
2000-01-24 13:00:00	QQQ	ETF	96.1406	96.2188	95.75	96.0	332000.0
2000-01-24 13:30:00	QQQ	ETF	96.0469	96.1719	95.0469	95.375	1772400.0
2000-01-24 14:00:00	QQQ	ETF	95.25	95.4375	94.125	94.375	2727800.0
2000-01-24 14:30:00	QQQ	ETF	94.125	94.4375	93.0	93.2812	2806400.0
2000-01-24 15:00:00	QQQ	ETF	93.125	93.1875	91.9688	92.0625	3214000.0
2000-01-24 15:30:00	QQQ	ETF	92.0	92.2656	91.375	91.5625	3875400.0
2000-01-24 16:00:00	QQQ	ETF	91.5	91.625	90.9688	91.2188	785000.0
2000-01-24 16:30:00	QQQ	ETF	91.0625	91.5	91.0625	91.5	5400.0
2000-01-24 17:00:00	QQQ	ETF	91.1875	91.25	91.1875	91.25	3400.0
2000-01-24 17:30:00	QQQ	ETF	91.2188	92.0	91.2188	92.0	800.0
2000-01-24 18:00:00	QQQ	ETF	92.0	92.0	91.625	91.625	400.0
2000-01-24 09:30:00	DIA	ETF	113.25	113.625	113.0625	113.3438	165800.0
2000-01-24 10:00:00	DIA	ETF	113.4688	113.4688	112.4688	112.625	105200.0
2000-01-24 10:30:00	DIA	ETF	112.5938	112.7188	112.0312	112.25	217600.0
2000-01-24 11:00:00	DIA	ETF	112.125	112.5	112.0312	112.125	99200.0
2000-01-24 11:30:00	DIA	ETF	112.0625	112.4375	112.0	112.3438	63300.0
2000-01-24 12:00:00	DIA	ETF	112.3438	112.875	112.25	112.4375	329400.0
2000-01-24 12:30:00	DIA	ETF	112.4062	112.7188	112.2812	112.4375	118800.0
2000-01-24 13:00:00	DIA	ETF	112.5625	112.5938	112.0312	112.25	38700.0
2000-01-24 13:30:00	DIA	ETF	112.3125	112.375	111.5	111.75	57800.0
2000-01-24 14:00:00	DIA	ETF	111.75	111.8438	110.9375	111.0	301000.0
2000-01-24 14:30:00	DIA	ETF	110.9062	111.0	110.25	110.25	86400.0
2000-01-24 15:00:00	DIA	ETF	110.375	110.6875	109.4375	109.625	191400.0
2000-01-24 15:30:00	DIA	ETF	109.5	110.125	109.0625	110.0312	279100.0
2000-01-24 16:00:00	DIA	ETF	110.0	110.0312	109.8125	110.0	12400.0

> showing 46 of 228 rows — these rows as CSV

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