PREVIEW / etf_30min / 2000-06-20

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-20.parquet
  size:    11 KB
  rows:    271

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-20 09:30:00	SPY	ETF	148.1875	148.7188	148.125	148.7188	1514900.0
2000-06-20 10:00:00	SPY	ETF	148.6875	148.75	148.0938	148.6875	326800.0
2000-06-20 10:30:00	SPY	ETF	148.7188	148.875	148.5	148.5	243500.0
2000-06-20 11:00:00	SPY	ETF	148.5	148.5	147.8125	148.0	208700.0
2000-06-20 11:30:00	SPY	ETF	147.9062	148.0	147.125	147.25	886600.0
2000-06-20 12:00:00	SPY	ETF	147.25	147.7188	147.0938	147.625	411700.0
2000-06-20 12:30:00	SPY	ETF	147.5	147.8438	147.4688	147.6875	197300.0
2000-06-20 13:00:00	SPY	ETF	147.5938	148.0	147.5938	147.8125	68200.0
2000-06-20 13:30:00	SPY	ETF	147.75	147.9375	147.5312	147.7188	112800.0
2000-06-20 14:00:00	SPY	ETF	147.6875	147.9688	147.5	147.9688	65000.0
2000-06-20 14:30:00	SPY	ETF	148.0	148.2812	147.2812	147.2812	413700.0
2000-06-20 15:00:00	SPY	ETF	147.3125	147.8438	147.0625	147.3125	450700.0
2000-06-20 15:30:00	SPY	ETF	147.4688	148.0312	147.0	147.8125	388300.0
2000-06-20 16:00:00	SPY	ETF	147.8125	147.9375	147.6562	147.9375	1173500.0
2000-06-20 09:30:00	QQQ	ETF	98.25	99.4688	98.0	99.3125	3797500.0
2000-06-20 10:00:00	QQQ	ETF	99.375	99.5	98.625	99.5	2251500.0
2000-06-20 10:30:00	QQQ	ETF	99.5	99.6875	99.1875	99.1875	1351800.0
2000-06-20 11:00:00	QQQ	ETF	99.25	99.3125	98.3125	98.5	1937600.0
2000-06-20 11:30:00	QQQ	ETF	98.5625	98.625	97.1875	97.5625	2117000.0
2000-06-20 12:00:00	QQQ	ETF	97.5	98.4688	97.375	98.1875	926500.0
2000-06-20 12:30:00	QQQ	ETF	98.2188	98.5938	97.8125	98.4375	1433300.0
2000-06-20 13:00:00	QQQ	ETF	98.4688	98.875	98.375	98.625	870200.0
2000-06-20 13:30:00	QQQ	ETF	98.625	98.6875	98.1875	98.5	951700.0
2000-06-20 14:00:00	QQQ	ETF	98.5	98.75	98.0312	98.5	563300.0
2000-06-20 14:30:00	QQQ	ETF	98.5312	98.9375	97.7812	97.9375	868100.0
2000-06-20 15:00:00	QQQ	ETF	97.875	98.25	97.375	97.6875	1583800.0
2000-06-20 15:30:00	QQQ	ETF	97.875	98.4375	97.3125	98.25	1778900.0
2000-06-20 16:00:00	QQQ	ETF	98.25	98.75	97.5	98.25	423700.0
2000-06-20 16:30:00	QQQ	ETF	98.125	98.125	97.625	97.6875	12000.0
2000-06-20 17:00:00	QQQ	ETF	98.0	98.0	97.75	97.75	2100.0
2000-06-20 17:30:00	QQQ	ETF	97.625	97.625	97.625	97.625	100.0
2000-06-20 18:00:00	QQQ	ETF	97.625	97.625	97.625	97.625	100.0
2000-06-20 09:30:00	IWM	ETF	52.3281	52.4375	52.2344	52.4375	2600.0
2000-06-20 10:00:00	IWM	ETF	52.4375	52.4375	52.4062	52.4062	2800.0
2000-06-20 10:30:00	IWM	ETF	52.6094	52.6719	52.6094	52.6719	5200.0
2000-06-20 11:00:00	IWM	ETF	52.5625	52.5625	52.5625	52.5625	2000.0
2000-06-20 11:30:00	IWM	ETF	52.25	52.25	52.25	52.25	20000.0
2000-06-20 12:30:00	IWM	ETF	52.125	52.125	52.125	52.125	200.0
2000-06-20 13:00:00	IWM	ETF	52.3594	52.3594	52.3594	52.3594	400.0
2000-06-20 14:00:00	IWM	ETF	52.5625	52.5625	52.5625	52.5625	200.0
2000-06-20 14:30:00	IWM	ETF	52.5	52.5	52.5	52.5	200.0
2000-06-20 15:30:00	IWM	ETF	52.625	52.625	52.625	52.625	5400.0
2000-06-20 16:00:00	IWM	ETF	52.625	52.625	52.5938	52.5938	8000.0
2000-06-20 09:30:00	DIA	ETF	105.4062	105.4375	104.8125	105.0625	187900.0
2000-06-20 10:00:00	DIA	ETF	105.1562	105.1875	104.8438	105.125	77500.0
2000-06-20 10:30:00	DIA	ETF	105.2188	105.375	105.0	105.0	85000.0
2000-06-20 11:00:00	DIA	ETF	105.0938	105.0938	104.5	104.75	208000.0
2000-06-20 11:30:00	DIA	ETF	104.7812	104.7812	104.1562	104.1562	132400.0
2000-06-20 12:00:00	DIA	ETF	104.3438	104.7812	104.125	104.5	167200.0
2000-06-20 12:30:00	DIA	ETF	104.4375	104.75	104.4375	104.5	74800.0

> showing 50 of 271 rows — these rows as CSV

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