PREVIEW / etf_30min / 2000-01-07

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-07.parquet
  size:    10 KB
  rows:    236

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-07 09:30:00	SPY	ETF	140.3125	141.4062	140.0625	141.0938	1107200.0
2000-01-07 10:00:00	SPY	ETF	141.25	142.4688	141.0	142.3438	1376700.0
2000-01-07 10:30:00	SPY	ETF	142.25	142.5312	141.9062	142.1875	619400.0
2000-01-07 11:00:00	SPY	ETF	142.1875	142.3438	141.8125	142.0	739700.0
2000-01-07 11:30:00	SPY	ETF	142.0625	142.1875	141.6562	142.0	114700.0
2000-01-07 12:00:00	SPY	ETF	141.875	142.1875	141.8125	141.875	345200.0
2000-01-07 12:30:00	SPY	ETF	142.0	142.125	141.625	141.75	85600.0
2000-01-07 13:00:00	SPY	ETF	141.6562	142.6875	141.5938	142.625	399200.0
2000-01-07 13:30:00	SPY	ETF	142.5938	142.7812	142.125	142.1562	401400.0
2000-01-07 14:00:00	SPY	ETF	142.125	142.7188	142.125	142.7188	79500.0
2000-01-07 14:30:00	SPY	ETF	142.7188	143.125	142.5312	143.0	523000.0
2000-01-07 15:00:00	SPY	ETF	143.0	143.75	142.8125	143.6875	675400.0
2000-01-07 15:30:00	SPY	ETF	143.625	144.4375	143.4062	144.4375	583700.0
2000-01-07 16:00:00	SPY	ETF	144.5	145.75	144.3125	145.75	794500.0
2000-01-07 09:30:00	QQQ	ETF	82.9375	83.875	82.5	83.875	5263800.0
2000-01-07 10:00:00	QQQ	ETF	83.5	86.0	83.5	85.4688	2791400.0
2000-01-07 10:30:00	QQQ	ETF	85.6562	86.0	85.25	85.75	1891400.0
2000-01-07 11:00:00	QQQ	ETF	85.75	85.9688	85.0625	85.4375	1594800.0
2000-01-07 11:30:00	QQQ	ETF	85.3438	85.4375	84.625	85.0	2137200.0
2000-01-07 12:00:00	QQQ	ETF	85.0	85.5	85.0	85.3125	660600.0
2000-01-07 12:30:00	QQQ	ETF	85.3125	85.75	84.625	84.75	1141000.0
2000-01-07 13:00:00	QQQ	ETF	84.75	85.8125	84.625	85.75	753600.0
2000-01-07 13:30:00	QQQ	ETF	85.7344	86.1875	85.375	85.5625	2062000.0
2000-01-07 14:00:00	QQQ	ETF	85.5625	86.0938	85.2812	86.0625	1190000.0
2000-01-07 14:30:00	QQQ	ETF	86.0312	86.4375	85.75	86.2188	1994600.0
2000-01-07 15:00:00	QQQ	ETF	86.2188	86.875	86.0156	86.7812	2156200.0
2000-01-07 15:30:00	QQQ	ETF	86.7812	88.4375	86.3438	88.4375	3273600.0
2000-01-07 16:00:00	QQQ	ETF	88.125	88.5	87.375	88.5	1143000.0
2000-01-07 16:30:00	QQQ	ETF	88.125	88.125	87.5	87.5	400.0
2000-01-07 17:00:00	QQQ	ETF	88.5	88.5	87.0	87.0	2400.0
2000-01-07 17:30:00	QQQ	ETF	88.0	88.0	88.0	88.0	1600.0
2000-01-07 18:00:00	QQQ	ETF	88.5	90.0	88.5	90.0	1200.0
2000-01-07 09:30:00	DIA	ETF	113.3125	113.875	113.2188	113.875	269300.0
2000-01-07 10:00:00	DIA	ETF	113.8438	114.4688	113.75	114.375	988600.0
2000-01-07 10:30:00	DIA	ETF	114.2812	114.6875	114.0	114.6562	67500.0
2000-01-07 11:00:00	DIA	ETF	114.375	114.5938	113.9375	113.9375	644600.0
2000-01-07 11:30:00	DIA	ETF	114.125	114.1875	113.875	113.9688	126200.0
2000-01-07 12:00:00	DIA	ETF	114.0	114.1562	113.6875	113.6875	86100.0
2000-01-07 12:30:00	DIA	ETF	113.8438	114.0	113.3438	113.7188	374300.0
2000-01-07 13:00:00	DIA	ETF	113.75	114.3438	113.7188	114.3438	121200.0
2000-01-07 13:30:00	DIA	ETF	114.3438	114.4688	113.9688	114.1562	38500.0
2000-01-07 14:00:00	DIA	ETF	114.1562	114.4375	114.0625	114.4062	45100.0
2000-01-07 14:30:00	DIA	ETF	114.4375	114.5938	114.2812	114.375	269700.0
2000-01-07 15:00:00	DIA	ETF	114.4688	114.9688	114.25	114.9688	93100.0
2000-01-07 15:30:00	DIA	ETF	115.0	115.375	114.7812	115.375	558100.0
2000-01-07 16:00:00	DIA	ETF	115.3438	115.5625	115.1562	115.5	61200.0

> showing 46 of 236 rows — these rows as CSV

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