PREVIEW / etf_30min / 2000-03-14

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-14.parquet
  size:    10 KB
  rows:    219

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-03-14 09:30:00	SPY	ETF	139.2812	140.0938	139.125	139.125	523000.0
2000-03-14 10:00:00	SPY	ETF	139.1875	139.75	139.0	139.4062	1173800.0
2000-03-14 10:30:00	SPY	ETF	139.4062	139.875	139.25	139.375	512800.0
2000-03-14 11:00:00	SPY	ETF	139.375	139.7188	139.2188	139.3438	120800.0
2000-03-14 11:30:00	SPY	ETF	139.4375	139.5938	138.6562	138.6875	318800.0
2000-03-14 12:00:00	SPY	ETF	138.6875	139.0312	137.7812	137.875	867400.0
2000-03-14 12:30:00	SPY	ETF	138.0	138.3438	137.625	138.0625	613700.0
2000-03-14 13:00:00	SPY	ETF	138.3125	138.625	138.0625	138.4688	780600.0
2000-03-14 13:30:00	SPY	ETF	138.4688	138.875	138.4375	138.5	770200.0
2000-03-14 14:00:00	SPY	ETF	138.3438	138.6562	137.9375	138.0625	377800.0
2000-03-14 14:30:00	SPY	ETF	138.125	138.375	137.5312	138.0	294200.0
2000-03-14 15:00:00	SPY	ETF	137.875	138.375	136.8125	136.8125	489000.0
2000-03-14 15:30:00	SPY	ETF	137.0	137.375	136.1562	136.5	733000.0
2000-03-14 16:00:00	SPY	ETF	136.625	136.6562	136.2812	136.625	612400.0
2000-03-14 18:00:00	SPY	ETF	136.625	136.625	136.625	136.625	200.0
2000-03-14 09:30:00	QQQ	ETF	112.75	113.375	112.0	112.1562	3579600.0
2000-03-14 10:00:00	QQQ	ETF	112.1562	113.2188	112.0	112.7812	3795400.0
2000-03-14 10:30:00	QQQ	ETF	112.6562	113.1562	112.0	112.4062	1897200.0
2000-03-14 11:00:00	QQQ	ETF	112.25	112.8594	112.125	112.5312	820200.0
2000-03-14 11:30:00	QQQ	ETF	112.5	112.625	110.9375	111.0	2566600.0
2000-03-14 12:00:00	QQQ	ETF	111.0	111.0	109.1875	109.1875	3415800.0
2000-03-14 12:30:00	QQQ	ETF	109.3438	109.625	108.3438	109.25	3814000.0
2000-03-14 13:00:00	QQQ	ETF	109.25	110.1875	109.0	109.625	2461000.0
2000-03-14 13:30:00	QQQ	ETF	109.7188	110.1875	109.375	109.375	2310200.0
2000-03-14 14:00:00	QQQ	ETF	109.2812	109.5938	108.5938	108.9062	1546200.0
2000-03-14 14:30:00	QQQ	ETF	108.9062	109.0469	107.9375	108.625	2185200.0
2000-03-14 15:00:00	QQQ	ETF	108.625	108.7812	106.5	106.5	3761200.0
2000-03-14 15:30:00	QQQ	ETF	106.5	107.25	105.5	105.7188	5401200.0
2000-03-14 16:00:00	QQQ	ETF	105.8125	106.0625	105.4375	106.0	1251400.0
2000-03-14 16:30:00	QQQ	ETF	105.8438	106.375	105.0	106.0625	13400.0
2000-03-14 17:00:00	QQQ	ETF	106.375	107.0	106.375	107.0	600.0
2000-03-14 17:30:00	QQQ	ETF	107.25	107.5	106.875	106.875	2600.0
2000-03-14 18:00:00	QQQ	ETF	107.375	107.375	107.375	107.375	400.0
2000-03-14 09:30:00	DIA	ETF	100.3125	100.6875	99.75	99.7812	62000.0
2000-03-14 10:00:00	DIA	ETF	99.75	100.125	99.6875	99.875	57100.0
2000-03-14 10:30:00	DIA	ETF	99.875	100.1562	99.875	99.875	86400.0
2000-03-14 11:00:00	DIA	ETF	100.0	100.375	99.875	100.1875	31900.0
2000-03-14 11:30:00	DIA	ETF	100.0312	100.2188	99.6562	99.6875	30900.0
2000-03-14 12:00:00	DIA	ETF	99.75	100.0	99.5	99.5	81000.0
2000-03-14 12:30:00	DIA	ETF	99.625	99.7188	99.1562	99.4062	115000.0
2000-03-14 13:00:00	DIA	ETF	99.5	99.7812	99.4062	99.75	20800.0
2000-03-14 13:30:00	DIA	ETF	99.8125	99.9062	99.4375	99.4688	125400.0
2000-03-14 14:00:00	DIA	ETF	99.4688	99.8125	99.1875	99.375	45700.0
2000-03-14 14:30:00	DIA	ETF	99.4062	99.5625	98.875	99.4375	51100.0
2000-03-14 15:00:00	DIA	ETF	99.1875	99.6875	98.8438	98.875	36800.0
2000-03-14 15:30:00	DIA	ETF	98.875	99.1875	98.1875	98.1875	90900.0
2000-03-14 16:00:00	DIA	ETF	98.3438	98.4688	98.0	98.4688	18700.0

> showing 47 of 219 rows — these rows as CSV

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