PREVIEW / etf_1hour / 2000-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-10-13.parquet
  size:    10 KB
  rows:    189

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-13 09:00:00	SPY	ETF	132.9375	134.9375	132.875	134.75	1668800.0
2000-10-13 10:00:00	SPY	ETF	134.7812	135.5	134.5	135.2188	3045500.0
2000-10-13 11:00:00	SPY	ETF	135.2188	136.0	134.6875	136.0	965400.0
2000-10-13 12:00:00	SPY	ETF	136.0	136.6875	135.9062	136.1875	675700.0
2000-10-13 13:00:00	SPY	ETF	136.25	136.9062	136.125	136.7812	903300.0
2000-10-13 14:00:00	SPY	ETF	136.875	137.1875	136.5	137.0	1221000.0
2000-10-13 15:00:00	SPY	ETF	137.125	137.6562	136.5312	137.5938	2081600.0
2000-10-13 16:00:00	SPY	ETF	137.5625	137.5625	137.1562	137.5625	1152900.0
2000-10-13 18:00:00	SPY	ETF	137.0625	137.0625	137.0625	137.0625	2000.0
2000-10-13 09:00:00	QQQ	ETF	74.6875	77.0	74.625	76.875	5793200.0
2000-10-13 10:00:00	QQQ	ETF	76.8438	77.4062	76.25	77.0312	6326900.0
2000-10-13 11:00:00	QQQ	ETF	77.0625	78.25	76.6875	78.25	5405400.0
2000-10-13 12:00:00	QQQ	ETF	78.0938	78.875	78.0	78.5625	4988800.0
2000-10-13 13:00:00	QQQ	ETF	78.5625	79.8125	78.5	79.5	4614300.0
2000-10-13 14:00:00	QQQ	ETF	79.6875	80.5625	79.1875	80.375	4396600.0
2000-10-13 15:00:00	QQQ	ETF	80.25	81.5	79.6875	81.4375	8743000.0
2000-10-13 16:00:00	QQQ	ETF	81.4688	81.9375	80.0	80.875	1939100.0
2000-10-13 17:00:00	QQQ	ETF	80.875	81.125	80.8125	80.875	8900.0
2000-10-13 18:00:00	QQQ	ETF	80.8125	80.8125	80.8125	80.8125	100.0
2000-10-13 09:00:00	IWM	ETF	46.0938	46.3438	46.0625	46.3438	7600.0
2000-10-13 10:00:00	IWM	ETF	46.3594	46.5781	46.3438	46.3438	15600.0
2000-10-13 11:00:00	IWM	ETF	46.5312	46.875	46.5312	46.75	22400.0
2000-10-13 12:00:00	IWM	ETF	46.9062	47.125	46.75	47.0469	46800.0
2000-10-13 13:00:00	IWM	ETF	47.0938	47.3125	47.0938	47.3125	22400.0
2000-10-13 14:00:00	IWM	ETF	47.3906	47.5625	47.3125	47.5312	46800.0
2000-10-13 15:00:00	IWM	ETF	47.125	48.1406	47.125	48.1406	194400.0
2000-10-13 16:00:00	IWM	ETF	47.9688	47.9688	47.75	47.75	22800.0
2000-10-13 09:00:00	DIA	ETF	100.0625	101.4375	100.0625	101.2188	397200.0
2000-10-13 10:00:00	DIA	ETF	101.375	101.7188	100.9375	101.5625	288100.0
2000-10-13 11:00:00	DIA	ETF	101.5	101.9375	101.1562	101.9375	105100.0
2000-10-13 12:00:00	DIA	ETF	101.9375	102.1875	101.6875	101.75	86600.0
2000-10-13 13:00:00	DIA	ETF	101.9688	102.25	101.8125	102.125	95300.0
2000-10-13 14:00:00	DIA	ETF	102.0312	102.1875	101.8438	102.0938	95900.0
2000-10-13 15:00:00	DIA	ETF	102.0938	102.25	101.75	102.2188	335100.0
2000-10-13 16:00:00	DIA	ETF	102.0312	102.1875	101.8125	101.875	53100.0

> showing 35 of 189 rows — these rows as CSV

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