PREVIEW / etf_30min / 2000-06-22

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-22.parquet
  size:    11 KB
  rows:    249

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-06-22 09:30:00	SPY	ETF	147.5625	147.6875	146.5625	147.0312	947800.0
2000-06-22 10:00:00	SPY	ETF	147.1875	147.4375	146.875	147.0625	390800.0
2000-06-22 10:30:00	SPY	ETF	147.0625	147.125	145.9375	146.25	761200.0
2000-06-22 11:00:00	SPY	ETF	146.0938	146.3438	145.6875	146.0	439300.0
2000-06-22 11:30:00	SPY	ETF	146.0625	146.5	145.7812	146.375	643300.0
2000-06-22 12:00:00	SPY	ETF	146.3125	146.4062	146.125	146.3438	115000.0
2000-06-22 12:30:00	SPY	ETF	146.3438	146.6562	146.25	146.25	95400.0
2000-06-22 13:00:00	SPY	ETF	146.2812	146.4062	146.1562	146.4062	128600.0
2000-06-22 13:30:00	SPY	ETF	146.4062	146.7188	146.25	146.5312	457300.0
2000-06-22 14:00:00	SPY	ETF	146.4375	146.625	146.0312	146.0312	273400.0
2000-06-22 14:30:00	SPY	ETF	146.0312	146.125	145.5312	145.5625	515100.0
2000-06-22 15:00:00	SPY	ETF	145.5	145.9375	145.0625	145.3125	465000.0
2000-06-22 15:30:00	SPY	ETF	145.1562	145.75	145.0	145.5312	862900.0
2000-06-22 16:00:00	SPY	ETF	145.375	145.7188	145.375	145.625	426000.0
2000-06-22 16:30:00	SPY	ETF	145.625	145.625	145.625	145.625	200.0
2000-06-22 09:30:00	QQQ	ETF	98.625	99.0	97.25	98.0625	2517600.0
2000-06-22 10:00:00	QQQ	ETF	98.0312	98.5	97.75	98.125	1241600.0
2000-06-22 10:30:00	QQQ	ETF	98.0312	98.125	97.0	97.1875	2347500.0
2000-06-22 11:00:00	QQQ	ETF	97.1875	97.6562	96.8125	97.25	1747500.0
2000-06-22 11:30:00	QQQ	ETF	97.25	97.625	96.8125	97.5	1058300.0
2000-06-22 12:00:00	QQQ	ETF	97.5	97.625	97.2812	97.5	224200.0
2000-06-22 12:30:00	QQQ	ETF	97.5	97.875	97.125	97.125	511600.0
2000-06-22 13:00:00	QQQ	ETF	97.125	97.75	97.125	97.75	445000.0
2000-06-22 13:30:00	QQQ	ETF	97.75	98.2188	97.5	98.0	1080400.0
2000-06-22 14:00:00	QQQ	ETF	98.125	98.125	97.0	97.0	1366800.0
2000-06-22 14:30:00	QQQ	ETF	97.0	97.2188	96.25	96.25	2329500.0
2000-06-22 15:00:00	QQQ	ETF	96.5	96.625	95.5938	95.9375	2691000.0
2000-06-22 15:30:00	QQQ	ETF	95.8125	96.125	95.0	95.0	3372100.0
2000-06-22 16:00:00	QQQ	ETF	95.25	96.25	94.5	94.5	526600.0
2000-06-22 16:30:00	QQQ	ETF	94.8125	95.0	94.8125	95.0	300.0
2000-06-22 17:00:00	QQQ	ETF	95.25	95.25	95.25	95.25	1500.0
2000-06-22 17:30:00	QQQ	ETF	95.4688	95.5	95.4688	95.5	800.0
2000-06-22 18:00:00	QQQ	ETF	95.5	95.5	95.0	95.25	3500.0
2000-06-22 09:30:00	IWM	ETF	53.0	53.0	52.7344	52.7344	2600.0
2000-06-22 10:00:00	IWM	ETF	52.9375	52.9531	52.9375	52.9531	11000.0
2000-06-22 10:30:00	IWM	ETF	52.7812	52.7812	52.4688	52.4688	38400.0
2000-06-22 11:00:00	IWM	ETF	52.5625	52.5625	52.3125	52.3125	5800.0
2000-06-22 11:30:00	IWM	ETF	52.3906	52.5	52.3906	52.5	3000.0
2000-06-22 12:00:00	IWM	ETF	52.5781	52.5781	52.5781	52.5781	200.0
2000-06-22 12:30:00	IWM	ETF	52.5781	52.5781	52.5781	52.5781	600.0
2000-06-22 13:00:00	IWM	ETF	52.5	52.5	52.5	52.5	200.0
2000-06-22 13:30:00	IWM	ETF	52.5469	52.5469	52.5469	52.5469	400.0
2000-06-22 14:30:00	IWM	ETF	52.25	52.25	52.0938	52.0938	28200.0
2000-06-22 15:00:00	IWM	ETF	52.0625	52.0625	51.9688	51.9688	40200.0
2000-06-22 15:30:00	IWM	ETF	51.7812	51.7812	51.3438	51.3438	8600.0
2000-06-22 16:00:00	IWM	ETF	51.25	51.25	51.25	51.25	400.0
2000-06-22 09:30:00	DIA	ETF	104.5938	105.0312	104.5312	104.6875	168500.0
2000-06-22 10:00:00	DIA	ETF	104.5	104.8125	104.5	104.6562	5300.0
2000-06-22 10:30:00	DIA	ETF	104.6875	104.6875	103.875	104.2188	116500.0
2000-06-22 11:00:00	DIA	ETF	104.0312	104.25	103.75	103.9062	65000.0

> showing 50 of 249 rows — these rows as CSV

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