PREVIEW / etf_30min / 2000-01-18

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-18.parquet
  size:    10 KB
  rows:    231

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-01-18 09:30:00	SPY	ETF	145.3438	145.9375	145.25	145.9375	863200.0
2000-01-18 10:00:00	SPY	ETF	145.875	146.3125	145.625	146.0	649600.0
2000-01-18 10:30:00	SPY	ETF	145.9375	146.4688	145.3438	145.5	818500.0
2000-01-18 11:00:00	SPY	ETF	145.6562	145.75	145.1875	145.625	415200.0
2000-01-18 11:30:00	SPY	ETF	145.75	145.8438	145.4062	145.5625	401300.0
2000-01-18 12:00:00	SPY	ETF	145.625	145.9375	145.4688	145.9062	271700.0
2000-01-18 12:30:00	SPY	ETF	145.9062	146.0	145.625	145.75	529500.0
2000-01-18 13:00:00	SPY	ETF	145.75	146.1875	145.5625	146.0	311100.0
2000-01-18 13:30:00	SPY	ETF	146.0	146.25	145.75	145.75	364800.0
2000-01-18 14:00:00	SPY	ETF	145.75	146.3438	145.6562	146.2812	301200.0
2000-01-18 14:30:00	SPY	ETF	146.25	146.5312	146.0312	146.0312	472000.0
2000-01-18 15:00:00	SPY	ETF	146.25	146.625	146.125	146.1875	134100.0
2000-01-18 15:30:00	SPY	ETF	146.25	146.4062	145.5	145.625	627400.0
2000-01-18 16:00:00	SPY	ETF	145.5625	146.0625	145.5625	145.8125	261200.0
2000-01-18 09:30:00	QQQ	ETF	92.0625	92.5	91.4375	92.4844	2429600.0
2000-01-18 10:00:00	QQQ	ETF	92.25	93.0312	91.9375	92.9062	2064000.0
2000-01-18 10:30:00	QQQ	ETF	92.9062	93.4375	92.625	92.8438	2352800.0
2000-01-18 11:00:00	QQQ	ETF	92.8125	92.9219	92.25	92.8906	1421200.0
2000-01-18 11:30:00	QQQ	ETF	92.8906	92.9688	92.4375	92.75	555600.0
2000-01-18 12:00:00	QQQ	ETF	92.7188	93.2188	92.6875	93.0312	367600.0
2000-01-18 12:30:00	QQQ	ETF	93.1094	93.25	92.9375	93.125	341200.0
2000-01-18 13:00:00	QQQ	ETF	93.125	93.5	93.0	93.375	791600.0
2000-01-18 13:30:00	QQQ	ETF	93.375	93.5	92.9219	92.9688	732200.0
2000-01-18 14:00:00	QQQ	ETF	92.9688	93.875	92.8125	93.6875	783600.0
2000-01-18 14:30:00	QQQ	ETF	93.8125	94.375	93.5	93.9375	1438800.0
2000-01-18 15:00:00	QQQ	ETF	93.875	94.4375	93.7812	94.0625	1180400.0
2000-01-18 15:30:00	QQQ	ETF	94.0625	94.2969	93.5625	93.875	1477400.0
2000-01-18 16:00:00	QQQ	ETF	93.9062	94.25	93.8438	94.125	349600.0
2000-01-18 16:30:00	QQQ	ETF	94.1875	94.25	94.0	94.0	1000.0
2000-01-18 17:30:00	QQQ	ETF	93.5	93.5	93.5	93.5	1000.0
2000-01-18 18:00:00	QQQ	ETF	93.5312	93.875	93.5312	93.875	2400.0
2000-01-18 09:30:00	DIA	ETF	116.4375	116.625	116.0625	116.5625	205800.0
2000-01-18 10:00:00	DIA	ETF	116.5938	116.875	116.3125	116.7188	40700.0
2000-01-18 10:30:00	DIA	ETF	116.625	116.8438	116.0312	116.1875	24800.0
2000-01-18 11:00:00	DIA	ETF	116.1875	116.4688	115.875	116.25	48300.0
2000-01-18 11:30:00	DIA	ETF	116.3125	116.4375	116.125	116.2812	15100.0
2000-01-18 12:00:00	DIA	ETF	116.0938	116.3438	116.0625	116.3438	30600.0
2000-01-18 12:30:00	DIA	ETF	116.3438	116.3438	116.0625	116.2188	9000.0
2000-01-18 13:00:00	DIA	ETF	116.0625	116.375	116.0625	116.3125	14500.0
2000-01-18 13:30:00	DIA	ETF	116.3438	116.5	116.0625	116.0625	10400.0
2000-01-18 14:00:00	DIA	ETF	116.1562	116.4062	116.0938	116.25	13200.0
2000-01-18 14:30:00	DIA	ETF	116.3438	116.4688	116.1562	116.1562	40200.0
2000-01-18 15:00:00	DIA	ETF	116.25	116.5312	116.0938	116.25	36900.0
2000-01-18 15:30:00	DIA	ETF	116.1875	116.2812	115.5	115.625	157100.0
2000-01-18 16:00:00	DIA	ETF	115.7188	115.7188	115.7188	115.7188	100.0

> showing 45 of 231 rows — these rows as CSV

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