PREVIEW / etf_30min / 2000-07-24

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-24.parquet
  size:    10 KB
  rows:    244

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-24 09:30:00	SPY	ETF	148.125	148.375	147.7812	148.3125	815400.0
2000-07-24 10:00:00	SPY	ETF	148.4375	148.8438	148.1875	148.6875	754800.0
2000-07-24 10:30:00	SPY	ETF	148.7188	148.8438	148.5	148.5	167000.0
2000-07-24 11:00:00	SPY	ETF	148.5625	148.5625	148.1875	148.4062	306900.0
2000-07-24 11:30:00	SPY	ETF	148.375	148.6875	148.3125	148.5	170600.0
2000-07-24 12:00:00	SPY	ETF	148.375	148.4375	148.0312	148.1562	253600.0
2000-07-24 12:30:00	SPY	ETF	148.0	148.0312	147.3125	147.6875	707700.0
2000-07-24 13:00:00	SPY	ETF	147.6875	147.6875	147.25	147.5312	302300.0
2000-07-24 13:30:00	SPY	ETF	147.4688	147.7188	146.9375	147.0312	281300.0
2000-07-24 14:00:00	SPY	ETF	147.1562	147.5	147.0	147.3438	504900.0
2000-07-24 14:30:00	SPY	ETF	147.375	147.4688	146.875	147.0	317000.0
2000-07-24 15:00:00	SPY	ETF	147.0625	147.125	146.5625	146.9688	457500.0
2000-07-24 15:30:00	SPY	ETF	146.8438	147.0938	146.5938	146.6562	399900.0
2000-07-24 16:00:00	SPY	ETF	146.8438	146.9688	146.6875	146.8438	123800.0
2000-07-24 16:30:00	SPY	ETF	146.625	146.625	146.625	146.625	27000.0
2000-07-24 09:30:00	QQQ	ETF	97.9375	98.0	97.1875	98.0	1816200.0
2000-07-24 10:00:00	QQQ	ETF	98.0	99.0	97.875	98.875	1308700.0
2000-07-24 10:30:00	QQQ	ETF	98.8438	98.9688	98.375	98.5	858300.0
2000-07-24 11:00:00	QQQ	ETF	98.4375	98.5938	98.0312	98.0312	803200.0
2000-07-24 11:30:00	QQQ	ETF	98.0625	98.5	97.875	97.875	788300.0
2000-07-24 12:00:00	QQQ	ETF	97.875	97.9688	97.1875	97.4375	1054700.0
2000-07-24 12:30:00	QQQ	ETF	97.4375	97.4375	96.3125	96.5	1315600.0
2000-07-24 13:00:00	QQQ	ETF	96.5	96.6875	95.875	96.25	2001900.0
2000-07-24 13:30:00	QQQ	ETF	96.125	96.375	95.125	95.375	1729200.0
2000-07-24 14:00:00	QQQ	ETF	95.3125	96.0625	95.125	95.4375	1303400.0
2000-07-24 14:30:00	QQQ	ETF	95.4062	95.875	95.125	95.1875	1155300.0
2000-07-24 15:00:00	QQQ	ETF	95.2812	95.375	94.5	95.0	2154200.0
2000-07-24 15:30:00	QQQ	ETF	95.0625	95.4375	94.5	94.625	1784200.0
2000-07-24 16:00:00	QQQ	ETF	94.625	94.75	94.25	94.4375	408400.0
2000-07-24 16:30:00	QQQ	ETF	94.25	95.0	94.25	94.5	51200.0
2000-07-24 17:00:00	QQQ	ETF	94.75	95.0	94.75	95.0	2200.0
2000-07-24 17:30:00	QQQ	ETF	95.0	95.0	95.0	95.0	700.0
2000-07-24 09:30:00	IWM	ETF	52.3125	52.3125	52.1562	52.2031	1400.0
2000-07-24 10:00:00	IWM	ETF	52.2812	52.3125	52.2812	52.3125	400.0
2000-07-24 11:00:00	IWM	ETF	52.1875	52.1875	52.125	52.125	800.0
2000-07-24 12:30:00	IWM	ETF	51.875	51.875	51.8594	51.8594	2000.0
2000-07-24 13:00:00	IWM	ETF	51.5469	51.6562	51.5312	51.6562	1400.0
2000-07-24 13:30:00	IWM	ETF	51.5938	51.5938	51.4531	51.4531	2600.0
2000-07-24 14:30:00	IWM	ETF	51.5469	51.5781	51.5469	51.5781	1200.0
2000-07-24 15:00:00	IWM	ETF	51.3125	51.3594	51.3125	51.3594	24000.0
2000-07-24 15:30:00	IWM	ETF	51.3125	51.375	51.1562	51.1875	3000.0
2000-07-24 16:00:00	IWM	ETF	51.2656	51.2656	51.2656	51.2656	200.0
2000-07-24 09:30:00	DIA	ETF	107.375	107.4375	106.875	107.3125	62900.0
2000-07-24 10:00:00	DIA	ETF	107.3125	107.4688	107.1875	107.1875	10500.0
2000-07-24 10:30:00	DIA	ETF	107.25	107.4375	107.2188	107.375	3200.0
2000-07-24 11:00:00	DIA	ETF	107.4062	107.4688	107.1875	107.4688	6000.0
2000-07-24 11:30:00	DIA	ETF	107.5	107.75	107.4375	107.625	25700.0
2000-07-24 12:00:00	DIA	ETF	107.5	107.6562	107.4375	107.4375	21100.0
2000-07-24 12:30:00	DIA	ETF	107.4375	107.4375	107.1875	107.375	6400.0
2000-07-24 13:00:00	DIA	ETF	107.25	107.25	107.0	107.1875	114200.0

> showing 50 of 244 rows — these rows as CSV

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