PREVIEW / etf_30min / 2000-10-31

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-10-31.parquet
  size:    12 KB
  rows:    303

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-10-31 09:30:00	SPY	ETF	141.0312	141.4062	140.9062	141.25	1327300.0
2000-10-31 10:00:00	SPY	ETF	141.0312	141.625	140.8438	141.2812	889600.0
2000-10-31 10:30:00	SPY	ETF	141.125	141.875	141.0	141.5938	673400.0
2000-10-31 11:00:00	SPY	ETF	141.625	141.9062	141.4688	141.6875	417500.0
2000-10-31 11:30:00	SPY	ETF	141.5938	142.0	141.5938	141.875	266700.0
2000-10-31 12:00:00	SPY	ETF	141.8438	142.2188	141.8125	142.125	174200.0
2000-10-31 12:30:00	SPY	ETF	142.125	142.6562	142.0312	142.5938	220600.0
2000-10-31 13:00:00	SPY	ETF	142.5	142.625	142.0938	142.625	334800.0
2000-10-31 13:30:00	SPY	ETF	142.625	142.7812	142.3438	142.6875	377500.0
2000-10-31 14:00:00	SPY	ETF	142.6875	143.0312	142.6875	143.0	306600.0
2000-10-31 14:30:00	SPY	ETF	143.0312	143.125	142.5312	142.8125	299000.0
2000-10-31 15:00:00	SPY	ETF	142.6875	143.6875	142.6875	143.5625	571400.0
2000-10-31 15:30:00	SPY	ETF	143.5	143.5938	142.8438	142.9688	780600.0
2000-10-31 16:00:00	SPY	ETF	143.0	143.1875	142.7812	142.9375	224200.0
2000-10-31 16:30:00	SPY	ETF	142.9375	142.9375	142.9375	142.9375	300.0
2000-10-31 09:30:00	QQQ	ETF	78.0	79.5	77.9375	79.25	6027000.0
2000-10-31 10:00:00	QQQ	ETF	79.1875	80.3125	79.0625	79.9375	3890300.0
2000-10-31 10:30:00	QQQ	ETF	80.0312	81.1875	79.75	80.75	5301300.0
2000-10-31 11:00:00	QQQ	ETF	80.875	81.5	80.625	80.8125	3189900.0
2000-10-31 11:30:00	QQQ	ETF	80.75	81.25	80.75	81.0625	2239700.0
2000-10-31 12:00:00	QQQ	ETF	81.0312	81.5938	81.0	81.5	1318600.0
2000-10-31 12:30:00	QQQ	ETF	81.625	82.0312	81.3125	82.0	1924600.0
2000-10-31 13:00:00	QQQ	ETF	82.0	82.0	81.375	81.9375	1711600.0
2000-10-31 13:30:00	QQQ	ETF	81.9375	82.125	81.4375	81.9688	1847900.0
2000-10-31 14:00:00	QQQ	ETF	81.875	82.5625	81.875	82.1562	2096200.0
2000-10-31 14:30:00	QQQ	ETF	82.125	82.25	80.625	80.9375	4866200.0
2000-10-31 15:00:00	QQQ	ETF	80.75	82.2188	80.75	81.9375	3802700.0
2000-10-31 15:30:00	QQQ	ETF	81.9062	82.125	81.0	81.9375	3934100.0
2000-10-31 16:00:00	QQQ	ETF	81.875	81.9688	81.0312	81.8125	1089900.0
2000-10-31 16:30:00	QQQ	ETF	81.6875	81.9375	81.6875	81.75	23100.0
2000-10-31 17:00:00	QQQ	ETF	81.8125	81.875	81.6875	81.7188	19300.0
2000-10-31 17:30:00	QQQ	ETF	81.6875	81.9062	81.6875	81.6875	1700.0
2000-10-31 18:00:00	QQQ	ETF	81.625	82.0	81.5	81.625	1400.0
2000-10-31 09:30:00	IWM	ETF	48.4375	48.8594	48.4375	48.5938	43800.0
2000-10-31 10:00:00	IWM	ETF	48.7188	48.7188	48.5625	48.5625	11000.0
2000-10-31 11:00:00	IWM	ETF	48.9375	48.9375	48.8125	48.9062	113400.0
2000-10-31 11:30:00	IWM	ETF	48.9062	48.9062	48.9062	48.9062	15600.0
2000-10-31 12:30:00	IWM	ETF	49.0625	49.0625	49.0625	49.0625	600.0
2000-10-31 13:00:00	IWM	ETF	49.3438	49.3438	49.2656	49.2812	3200.0
2000-10-31 13:30:00	IWM	ETF	49.375	49.375	49.3125	49.375	600.0
2000-10-31 14:00:00	IWM	ETF	49.4688	49.5625	49.3438	49.3438	2600.0
2000-10-31 14:30:00	IWM	ETF	49.5625	49.5625	49.5625	49.5625	400.0
2000-10-31 15:00:00	IWM	ETF	49.1562	49.5	49.1562	49.5	14400.0
2000-10-31 15:30:00	IWM	ETF	49.5	49.6719	49.4062	49.5	25000.0
2000-10-31 16:00:00	IWM	ETF	49.5	49.6562	49.5	49.6562	40600.0
2000-10-31 09:30:00	DIA	ETF	108.9062	108.9062	108.2812	108.5	295100.0
2000-10-31 10:00:00	DIA	ETF	108.4062	108.6875	107.8438	108.0312	588000.0
2000-10-31 10:30:00	DIA	ETF	108.125	108.4688	108.0	108.3125	464300.0
2000-10-31 11:00:00	DIA	ETF	108.25	108.5	108.0625	108.4688	223000.0
2000-10-31 11:30:00	DIA	ETF	108.4375	108.8125	108.375	108.5312	233000.0

> showing 50 of 303 rows — these rows as CSV

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