PREVIEW / etf_30min / 2000-07-13

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-13.parquet
  size:    11 KB
  rows:    273

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-07-13 09:30:00	SPY	ETF	149.9688	149.9688	149.4062	149.5312	520000.0
2000-07-13 10:00:00	SPY	ETF	149.375	149.6875	149.1875	149.6875	391400.0
2000-07-13 10:30:00	SPY	ETF	149.625	149.9688	149.5312	149.75	311200.0
2000-07-13 11:00:00	SPY	ETF	149.8438	149.8438	149.4375	149.5	232600.0
2000-07-13 11:30:00	SPY	ETF	149.5	149.8125	149.4375	149.625	235500.0
2000-07-13 12:00:00	SPY	ETF	149.625	149.9688	149.5625	149.875	379600.0
2000-07-13 12:30:00	SPY	ETF	149.875	149.9375	149.5625	149.5625	98500.0
2000-07-13 13:00:00	SPY	ETF	149.5625	149.8125	149.5625	149.625	52900.0
2000-07-13 13:30:00	SPY	ETF	149.5938	150.2188	149.5938	150.0625	341500.0
2000-07-13 14:00:00	SPY	ETF	150.0625	150.375	150.0625	150.125	284500.0
2000-07-13 14:30:00	SPY	ETF	150.0625	150.3125	149.8125	149.875	591900.0
2000-07-13 15:00:00	SPY	ETF	149.875	150.0625	149.5312	149.9688	1098100.0
2000-07-13 15:30:00	SPY	ETF	149.9375	150.0	149.4375	149.875	551700.0
2000-07-13 16:00:00	SPY	ETF	149.875	149.9688	149.625	149.7812	248900.0
2000-07-13 16:30:00	SPY	ETF	149.7812	149.7812	149.7812	149.7812	900.0
2000-07-13 09:30:00	QQQ	ETF	97.9375	98.375	97.75	97.8125	2972100.0
2000-07-13 10:00:00	QQQ	ETF	97.8125	98.125	97.125	98.0938	2574400.0
2000-07-13 10:30:00	QQQ	ETF	98.0938	98.8125	98.0625	98.8125	1628100.0
2000-07-13 11:00:00	QQQ	ETF	98.8125	98.875	98.1875	98.25	893600.0
2000-07-13 11:30:00	QQQ	ETF	98.2188	98.8125	98.125	98.625	669100.0
2000-07-13 12:00:00	QQQ	ETF	98.625	99.0625	98.5	98.875	998500.0
2000-07-13 12:30:00	QQQ	ETF	98.875	99.0	98.25	98.375	589000.0
2000-07-13 13:00:00	QQQ	ETF	98.375	98.625	98.3125	98.4688	555600.0
2000-07-13 13:30:00	QQQ	ETF	98.4688	99.1562	98.4375	99.1562	973700.0
2000-07-13 14:00:00	QQQ	ETF	99.125	99.75	99.125	99.25	2222000.0
2000-07-13 14:30:00	QQQ	ETF	99.1875	99.5	98.75	98.75	1296600.0
2000-07-13 15:00:00	QQQ	ETF	98.8125	99.0625	98.3125	98.9375	1798700.0
2000-07-13 15:30:00	QQQ	ETF	98.8438	98.9375	98.0625	98.75	1769800.0
2000-07-13 16:00:00	QQQ	ETF	98.5	99.375	98.4375	98.9375	547200.0
2000-07-13 16:30:00	QQQ	ETF	98.75	99.125	98.75	99.125	6800.0
2000-07-13 17:00:00	QQQ	ETF	99.0	99.25	98.5	98.75	2600.0
2000-07-13 17:30:00	QQQ	ETF	98.5	99.125	98.5	99.0	2800.0
2000-07-13 18:00:00	QQQ	ETF	99.0	99.0	98.5	98.5	800.0
2000-07-13 09:30:00	IWM	ETF	54.1406	54.25	54.1406	54.25	3800.0
2000-07-13 10:00:00	IWM	ETF	54.1562	54.1562	54.1562	54.1562	200.0
2000-07-13 10:30:00	IWM	ETF	54.2031	54.2188	54.2031	54.2031	1200.0
2000-07-13 11:00:00	IWM	ETF	54.2188	54.2344	54.125	54.1406	2200.0
2000-07-13 11:30:00	IWM	ETF	54.125	54.1406	54.125	54.1406	41400.0
2000-07-13 12:00:00	IWM	ETF	54.1875	54.1875	54.1875	54.1875	200.0
2000-07-13 12:30:00	IWM	ETF	54.1406	54.1406	54.0625	54.1094	21200.0
2000-07-13 13:00:00	IWM	ETF	54.1094	54.125	54.1094	54.125	400.0
2000-07-13 13:30:00	IWM	ETF	54.0	54.0	54.0	54.0	10000.0
2000-07-13 14:00:00	IWM	ETF	54.25	54.25	54.25	54.25	800.0
2000-07-13 14:30:00	IWM	ETF	54.25	54.25	54.25	54.25	400.0
2000-07-13 15:00:00	IWM	ETF	54.2188	54.2188	54.1562	54.1875	1200.0
2000-07-13 15:30:00	IWM	ETF	54.1562	54.2656	54.1094	54.2656	19600.0
2000-07-13 09:30:00	DIA	ETF	108.5312	108.6875	108.0312	108.2188	273700.0
2000-07-13 10:00:00	DIA	ETF	108.0	108.125	107.625	108.0938	117100.0
2000-07-13 10:30:00	DIA	ETF	108.2188	108.25	107.875	108.1875	29200.0
2000-07-13 11:00:00	DIA	ETF	108.1875	108.1875	107.75	107.875	233200.0

> showing 50 of 273 rows — these rows as CSV

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