PREVIEW / etf_30min / 2000-05-17

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-05-17.parquet
  size:    9 KB
  rows:    197

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-05-17 09:30:00	SPY	ETF	145.6875	145.9375	144.875	145.5938	1146200.0
2000-05-17 10:00:00	SPY	ETF	145.375	145.5	144.7812	145.125	504400.0
2000-05-17 10:30:00	SPY	ETF	145.25	145.625	144.7812	145.25	266900.0
2000-05-17 11:00:00	SPY	ETF	145.125	145.3125	144.4688	144.8438	347300.0
2000-05-17 11:30:00	SPY	ETF	144.8438	144.875	144.5	144.7812	259300.0
2000-05-17 12:00:00	SPY	ETF	144.6875	145.1875	144.6875	145.1875	267300.0
2000-05-17 12:30:00	SPY	ETF	145.1875	145.2188	144.75	144.9688	236200.0
2000-05-17 13:00:00	SPY	ETF	145.0	145.3438	144.75	145.3125	113900.0
2000-05-17 13:30:00	SPY	ETF	144.9688	145.6875	144.9688	145.4375	681000.0
2000-05-17 14:00:00	SPY	ETF	145.5	145.625	145.125	145.125	123000.0
2000-05-17 14:30:00	SPY	ETF	145.1875	145.3125	144.75	145.0312	417100.0
2000-05-17 15:00:00	SPY	ETF	145.0625	146.1875	144.9375	145.875	490900.0
2000-05-17 15:30:00	SPY	ETF	145.875	145.9688	145.25	145.25	545200.0
2000-05-17 16:00:00	SPY	ETF	145.1875	145.5625	145.1562	145.1562	407800.0
2000-05-17 17:30:00	SPY	ETF	145.1562	145.1562	145.1562	145.1562	300.0
2000-05-17 09:30:00	QQQ	ETF	89.25	90.0	88.5	89.125	3007200.0
2000-05-17 10:00:00	QQQ	ETF	89.125	89.2812	88.125	88.875	2290700.0
2000-05-17 10:30:00	QQQ	ETF	88.875	89.375	88.3125	88.9688	1202100.0
2000-05-17 11:00:00	QQQ	ETF	88.75	88.875	87.75	88.25	1800900.0
2000-05-17 11:30:00	QQQ	ETF	88.25	88.75	88.0625	88.4375	766500.0
2000-05-17 12:00:00	QQQ	ETF	88.625	88.9375	88.2812	88.8125	593000.0
2000-05-17 12:30:00	QQQ	ETF	88.9375	89.125	88.5	88.6875	1153400.0
2000-05-17 13:00:00	QQQ	ETF	88.625	89.4688	88.5	89.4375	878000.0
2000-05-17 13:30:00	QQQ	ETF	89.3125	89.9375	89.0625	89.8125	1652100.0
2000-05-17 14:00:00	QQQ	ETF	89.8125	89.875	89.125	89.25	1244100.0
2000-05-17 14:30:00	QQQ	ETF	89.25	89.25	88.5	89.0	801400.0
2000-05-17 15:00:00	QQQ	ETF	89.1875	90.4375	88.75	90.4375	2299500.0
2000-05-17 15:30:00	QQQ	ETF	90.4375	90.5	88.6875	88.75	1985900.0
2000-05-17 16:00:00	QQQ	ETF	88.75	89.4375	88.625	89.1875	389500.0
2000-05-17 17:00:00	QQQ	ETF	89.125	89.125	89.125	89.125	800.0
2000-05-17 17:30:00	QQQ	ETF	89.0	89.125	89.0	89.125	1300.0
2000-05-17 18:00:00	QQQ	ETF	88.9375	88.9375	88.9375	88.9375	500.0
2000-05-17 09:30:00	DIA	ETF	108.3125	108.5938	108.0	108.3438	239100.0
2000-05-17 10:00:00	DIA	ETF	108.25	108.375	107.75	108.375	200000.0
2000-05-17 10:30:00	DIA	ETF	108.4375	108.6875	107.875	108.1875	49300.0
2000-05-17 11:00:00	DIA	ETF	108.0625	108.25	107.625	107.6875	39600.0
2000-05-17 11:30:00	DIA	ETF	107.8125	107.9688	107.6562	107.8125	31600.0
2000-05-17 12:00:00	DIA	ETF	107.9062	108.0312	107.6875	108.0312	31300.0
2000-05-17 12:30:00	DIA	ETF	108.0	108.1562	107.8125	107.9688	6100.0
2000-05-17 13:00:00	DIA	ETF	107.9375	108.3438	107.9375	108.3438	79500.0
2000-05-17 13:30:00	DIA	ETF	108.1875	108.4062	108.0312	108.4062	56100.0
2000-05-17 14:00:00	DIA	ETF	108.3125	108.3125	108.0	108.0	19300.0
2000-05-17 14:30:00	DIA	ETF	107.9375	108.0312	107.5625	107.8125	12700.0
2000-05-17 15:00:00	DIA	ETF	107.75	108.3438	107.75	108.3438	71000.0
2000-05-17 15:30:00	DIA	ETF	108.3125	108.3125	107.8438	108.0312	54500.0
2000-05-17 16:00:00	DIA	ETF	108.0312	108.0312	107.75	107.75	5900.0

> showing 46 of 197 rows — these rows as CSV

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