PREVIEW / etf_30min / 2000-01-19

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-19.parquet
  size:    10 KB
  rows:    202

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-19 09:30:00	SPY	ETF	145.3125	145.6875	145.0	145.5625	730400.0
2000-01-19 10:00:00	SPY	ETF	145.6562	146.3125	145.4062	146.2812	422100.0
2000-01-19 10:30:00	SPY	ETF	146.1875	146.4062	145.9062	146.0	419800.0
2000-01-19 11:00:00	SPY	ETF	146.0312	146.375	145.9062	146.0	373000.0
2000-01-19 11:30:00	SPY	ETF	145.9375	146.0625	145.625	145.875	311000.0
2000-01-19 12:00:00	SPY	ETF	145.875	146.2188	145.8125	146.125	346700.0
2000-01-19 12:30:00	SPY	ETF	146.125	146.3438	145.9375	146.0312	183900.0
2000-01-19 13:00:00	SPY	ETF	146.2188	146.25	145.875	146.0	70100.0
2000-01-19 13:30:00	SPY	ETF	146.0938	146.4688	145.875	146.25	165700.0
2000-01-19 14:00:00	SPY	ETF	146.3125	146.3125	145.9375	146.0312	335300.0
2000-01-19 14:30:00	SPY	ETF	146.125	146.2188	145.9375	146.0	111700.0
2000-01-19 15:00:00	SPY	ETF	146.0	146.125	145.1562	145.625	1105300.0
2000-01-19 15:30:00	SPY	ETF	145.5	145.8125	145.375	145.6875	739700.0
2000-01-19 16:00:00	SPY	ETF	145.7188	146.375	145.7188	146.25	318100.0
2000-01-19 17:00:00	SPY	ETF	146.75	147.0	146.75	147.0	5000.0
2000-01-19 09:30:00	QQQ	ETF	93.4844	93.7188	92.4219	93.3438	4306000.0
2000-01-19 10:00:00	QQQ	ETF	93.3125	93.875	92.8438	93.8438	1993200.0
2000-01-19 10:30:00	QQQ	ETF	93.9062	94.3125	93.6875	94.0312	1691600.0
2000-01-19 11:00:00	QQQ	ETF	94.0312	94.4375	93.7188	94.25	1131200.0
2000-01-19 11:30:00	QQQ	ETF	94.1875	94.25	93.5	93.9688	551400.0
2000-01-19 12:00:00	QQQ	ETF	93.9688	94.4844	93.875	94.375	963000.0
2000-01-19 12:30:00	QQQ	ETF	94.375	94.7188	94.25	94.5	928600.0
2000-01-19 13:00:00	QQQ	ETF	94.5	94.875	94.3125	94.375	833200.0
2000-01-19 13:30:00	QQQ	ETF	94.375	94.9688	94.375	94.7188	593400.0
2000-01-19 14:00:00	QQQ	ETF	94.6562	94.9062	94.5	94.8125	754200.0
2000-01-19 14:30:00	QQQ	ETF	94.8125	95.125	94.625	94.9375	770000.0
2000-01-19 15:00:00	QQQ	ETF	94.9375	94.9375	93.875	94.125	2196400.0
2000-01-19 15:30:00	QQQ	ETF	94.2188	94.7812	93.9375	94.75	1393800.0
2000-01-19 16:00:00	QQQ	ETF	94.75	95.5	94.5625	95.5	629800.0
2000-01-19 16:30:00	QQQ	ETF	96.0	96.0	94.625	95.6875	9000.0
2000-01-19 17:00:00	QQQ	ETF	95.75	96.0	95.25	95.5	3800.0
2000-01-19 17:30:00	QQQ	ETF	96.0	96.0	96.0	96.0	6800.0
2000-01-19 18:00:00	QQQ	ETF	95.9688	96.0	95.9688	96.0	800.0
2000-01-19 09:30:00	DIA	ETF	115.625	115.6562	115.0	115.25	110800.0
2000-01-19 10:00:00	DIA	ETF	115.2188	115.7812	115.2188	115.5938	50900.0
2000-01-19 10:30:00	DIA	ETF	115.7812	115.7812	115.2812	115.375	41200.0
2000-01-19 11:00:00	DIA	ETF	115.3125	115.5312	115.1562	115.1562	40900.0
2000-01-19 11:30:00	DIA	ETF	115.125	115.25	114.9062	115.0312	90100.0
2000-01-19 12:00:00	DIA	ETF	115.1875	115.375	115.0625	115.375	284800.0
2000-01-19 12:30:00	DIA	ETF	115.4688	115.5625	115.2188	115.2188	6100.0
2000-01-19 13:00:00	DIA	ETF	115.4062	115.4062	115.1875	115.3438	3700.0
2000-01-19 13:30:00	DIA	ETF	115.3438	115.5938	115.1875	115.5312	11100.0
2000-01-19 14:00:00	DIA	ETF	115.3438	115.5312	115.25	115.3438	11600.0
2000-01-19 14:30:00	DIA	ETF	115.4375	115.4688	115.125	115.125	18200.0
2000-01-19 15:00:00	DIA	ETF	115.125	115.3438	114.5938	114.9375	258300.0
2000-01-19 15:30:00	DIA	ETF	114.75	115.125	114.75	114.9688	34300.0
2000-01-19 16:00:00	DIA	ETF	115.0	115.5625	115.0	115.5625	16200.0

> showing 47 of 202 rows — these rows as CSV

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