PREVIEW / etf_30min / 2000-01-13

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-13.parquet
  size:    10 KB
  rows:    217

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-13 09:30:00	SPY	ETF	144.4688	144.6562	143.7812	143.9375	875600.0
2000-01-13 10:00:00	SPY	ETF	143.875	144.2188	143.2812	143.875	502300.0
2000-01-13 10:30:00	SPY	ETF	143.875	144.25	143.6875	143.9375	216300.0
2000-01-13 11:00:00	SPY	ETF	143.875	144.5625	143.8125	144.1875	765500.0
2000-01-13 11:30:00	SPY	ETF	144.0625	144.2188	143.75	143.9375	168700.0
2000-01-13 12:00:00	SPY	ETF	144.0625	144.25	143.75	143.9688	153200.0
2000-01-13 12:30:00	SPY	ETF	144.0938	144.1875	143.8438	143.9688	60300.0
2000-01-13 13:00:00	SPY	ETF	144.125	144.375	143.875	144.1562	145900.0
2000-01-13 13:30:00	SPY	ETF	144.25	144.875	144.0	144.7812	259700.0
2000-01-13 14:00:00	SPY	ETF	144.8438	145.25	144.625	145.25	334000.0
2000-01-13 14:30:00	SPY	ETF	145.25	145.375	144.8125	145.0	211600.0
2000-01-13 15:00:00	SPY	ETF	144.875	145.75	144.875	145.4062	527300.0
2000-01-13 15:30:00	SPY	ETF	145.4062	145.625	144.9375	145.125	489300.0
2000-01-13 16:00:00	SPY	ETF	145.0312	145.1875	144.6875	144.9062	405300.0
2000-01-13 16:30:00	SPY	ETF	145.0	145.0	145.0	145.0	2000.0
2000-01-13 09:30:00	QQQ	ETF	88.5	89.25	87.875	88.0938	4074200.0
2000-01-13 10:00:00	QQQ	ETF	88.0938	88.25	87.0781	88.0	3084600.0
2000-01-13 10:30:00	QQQ	ETF	87.8125	88.625	87.75	88.0625	2135600.0
2000-01-13 11:00:00	QQQ	ETF	88.0625	88.7188	87.875	88.1875	1085400.0
2000-01-13 11:30:00	QQQ	ETF	88.1875	88.2188	87.5625	87.8594	1190200.0
2000-01-13 12:00:00	QQQ	ETF	87.875	88.1875	87.625	87.8125	560800.0
2000-01-13 12:30:00	QQQ	ETF	87.875	88.1562	87.75	87.9062	616200.0
2000-01-13 13:00:00	QQQ	ETF	87.9062	88.25	87.8125	88.0938	1246200.0
2000-01-13 13:30:00	QQQ	ETF	88.0469	88.6875	87.875	88.625	1329400.0
2000-01-13 14:00:00	QQQ	ETF	88.625	89.0	88.4219	89.0	1240000.0
2000-01-13 14:30:00	QQQ	ETF	89.0	89.125	88.3125	88.7031	1561200.0
2000-01-13 15:00:00	QQQ	ETF	88.6875	90.125	88.6562	89.6875	3967000.0
2000-01-13 15:30:00	QQQ	ETF	89.6875	90.3125	89.125	90.125	2161200.0
2000-01-13 16:00:00	QQQ	ETF	90.0	90.2188	89.75	90.1875	513000.0
2000-01-13 16:30:00	QQQ	ETF	90.1875	91.25	90.125	91.25	19200.0
2000-01-13 17:00:00	QQQ	ETF	91.25	91.5	90.75	90.75	4200.0
2000-01-13 17:30:00	QQQ	ETF	90.75	91.25	90.75	91.25	600.0
2000-01-13 18:00:00	QQQ	ETF	91.25	91.25	91.25	91.25	200.0
2000-01-13 09:30:00	DIA	ETF	116.0312	116.2188	115.5312	115.75	340700.0
2000-01-13 10:00:00	DIA	ETF	115.75	116.0	115.2188	115.5	65600.0
2000-01-13 10:30:00	DIA	ETF	115.5	115.75	115.375	115.625	65000.0
2000-01-13 11:00:00	DIA	ETF	115.6875	116.0	115.5625	115.75	67200.0
2000-01-13 11:30:00	DIA	ETF	115.625	115.8125	115.5	115.5	70000.0
2000-01-13 12:00:00	DIA	ETF	115.6875	115.75	115.5	115.5625	4200.0
2000-01-13 12:30:00	DIA	ETF	115.5	115.7812	115.5	115.6562	40400.0
2000-01-13 13:00:00	DIA	ETF	115.5312	115.7812	115.5312	115.6875	23600.0
2000-01-13 13:30:00	DIA	ETF	115.5625	115.9688	115.5	115.9688	84700.0
2000-01-13 14:00:00	DIA	ETF	115.875	116.25	115.75	116.25	181400.0
2000-01-13 14:30:00	DIA	ETF	116.4062	116.4062	116.0312	116.25	21600.0
2000-01-13 15:00:00	DIA	ETF	116.3438	116.625	116.1875	116.3438	129800.0
2000-01-13 15:30:00	DIA	ETF	116.125	116.375	115.875	115.9062	45600.0
2000-01-13 16:00:00	DIA	ETF	115.9375	115.9688	115.7188	115.875	51800.0

> showing 47 of 217 rows — these rows as CSV

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