PREVIEW / etf_30min / 2000-04-18

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-18.parquet
  size:    10 KB
  rows:    218

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-04-18 09:30:00	SPY	ETF	140.5625	141.5	139.7812	141.125	1282200.0
2000-04-18 10:00:00	SPY	ETF	140.9688	141.75	140.875	141.1562	731500.0
2000-04-18 10:30:00	SPY	ETF	141.125	141.75	140.6875	141.75	673300.0
2000-04-18 11:00:00	SPY	ETF	141.625	142.4688	141.375	142.4375	1635700.0
2000-04-18 11:30:00	SPY	ETF	142.4062	142.9062	142.25	142.75	696200.0
2000-04-18 12:00:00	SPY	ETF	142.9062	143.5	142.5938	143.0	724600.0
2000-04-18 12:30:00	SPY	ETF	143.2188	143.3438	142.5625	143.0	346300.0
2000-04-18 13:00:00	SPY	ETF	143.1875	143.25	142.5	143.125	613500.0
2000-04-18 13:30:00	SPY	ETF	143.1875	143.5	142.875	143.4062	323900.0
2000-04-18 14:00:00	SPY	ETF	143.5	143.7188	143.125	143.4375	389300.0
2000-04-18 14:30:00	SPY	ETF	143.5625	143.5938	142.5625	143.125	530700.0
2000-04-18 15:00:00	SPY	ETF	143.0312	143.1562	142.0	142.5625	1261500.0
2000-04-18 15:30:00	SPY	ETF	142.4688	144.2188	142.4688	144.2188	1352300.0
2000-04-18 16:00:00	SPY	ETF	144.2812	144.4688	144.0	144.4688	364400.0
2000-04-18 17:30:00	SPY	ETF	144.4688	144.4688	144.4688	144.4688	115000.0
2000-04-18 09:30:00	QQQ	ETF	89.4688	90.125	87.375	89.5625	6193000.0
2000-04-18 10:00:00	QQQ	ETF	89.875	90.5625	88.9375	89.25	3696000.0
2000-04-18 10:30:00	QQQ	ETF	89.25	89.6875	88.0312	89.125	3187300.0
2000-04-18 11:00:00	QQQ	ETF	89.1875	90.7188	89.0	90.5	2588100.0
2000-04-18 11:30:00	QQQ	ETF	90.625	91.3125	90.375	90.9688	2398700.0
2000-04-18 12:00:00	QQQ	ETF	90.9688	92.25	90.625	91.875	2181100.0
2000-04-18 12:30:00	QQQ	ETF	91.75	92.0	91.0312	91.9375	1887200.0
2000-04-18 13:00:00	QQQ	ETF	91.875	92.0	90.75	91.75	1793300.0
2000-04-18 13:30:00	QQQ	ETF	91.75	92.0	91.0625	91.9375	1182800.0
2000-04-18 14:00:00	QQQ	ETF	91.9688	92.375	91.4688	92.25	1283500.0
2000-04-18 14:30:00	QQQ	ETF	92.25	92.25	90.5	91.0	1563000.0
2000-04-18 15:00:00	QQQ	ETF	91.0	91.5	89.5	90.125	3721400.0
2000-04-18 15:30:00	QQQ	ETF	90.125	92.625	90.0	92.5	3208500.0
2000-04-18 16:00:00	QQQ	ETF	92.375	92.75	92.125	92.75	1050900.0
2000-04-18 16:30:00	QQQ	ETF	93.0	93.0	91.375	92.25	107900.0
2000-04-18 17:00:00	QQQ	ETF	92.25	92.5	91.625	91.75	4800.0
2000-04-18 17:30:00	QQQ	ETF	91.875	91.875	91.0	91.25	2800.0
2000-04-18 18:00:00	QQQ	ETF	91.875	92.0	91.75	92.0	4200.0
2000-04-18 09:30:00	DIA	ETF	106.4688	106.7812	105.875	106.5	421600.0
2000-04-18 10:00:00	DIA	ETF	106.625	106.9375	106.2188	106.8125	141400.0
2000-04-18 10:30:00	DIA	ETF	106.5938	106.875	106.1875	106.6875	189300.0
2000-04-18 11:00:00	DIA	ETF	106.5938	107.375	106.5938	107.375	150300.0
2000-04-18 11:30:00	DIA	ETF	107.25	107.5	106.875	107.4062	84400.0
2000-04-18 12:00:00	DIA	ETF	107.4062	107.5938	107.0938	107.3125	136100.0
2000-04-18 12:30:00	DIA	ETF	107.5312	107.5938	107.0312	107.4062	46800.0
2000-04-18 13:00:00	DIA	ETF	107.625	107.625	107.0312	107.2812	18800.0
2000-04-18 13:30:00	DIA	ETF	107.2812	107.625	107.1875	107.4688	48000.0
2000-04-18 14:00:00	DIA	ETF	107.375	107.625	106.9375	107.0938	33900.0
2000-04-18 14:30:00	DIA	ETF	107.125	107.3125	106.4375	107.125	58800.0
2000-04-18 15:00:00	DIA	ETF	107.0625	107.1562	106.25	106.5	37000.0
2000-04-18 15:30:00	DIA	ETF	106.7188	107.6562	106.7188	107.5938	198600.0
2000-04-18 16:00:00	DIA	ETF	107.5625	107.7812	107.5	107.7812	10600.0
2000-04-18 17:00:00	DIA	ETF	107.0625	107.0625	107.0625	107.0625	100.0

> showing 48 of 218 rows — these rows as CSV

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