PREVIEW / etf_1hour / 2001-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-01-08.parquet
  size:    10 KB
  rows:    201

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
2001-01-08 09:00:00	SPY	ETF	129.875	129.875	128.8438	129.4375	1281700.0
2001-01-08 10:00:00	SPY	ETF	129.3125	130.0625	128.8438	129.2812	704200.0
2001-01-08 11:00:00	SPY	ETF	129.1562	129.4062	128.8438	129.3438	1143100.0
2001-01-08 12:00:00	SPY	ETF	129.25	129.8438	128.6562	128.7812	462300.0
2001-01-08 13:00:00	SPY	ETF	128.9375	129.4062	128.5625	128.75	232100.0
2001-01-08 14:00:00	SPY	ETF	128.75	129.0938	127.6875	128.0625	685000.0
2001-01-08 15:00:00	SPY	ETF	127.875	129.75	127.7812	129.75	1361200.0
2001-01-08 16:00:00	SPY	ETF	129.8125	130.1875	129.6562	130.125	484300.0
2001-01-08 17:00:00	SPY	ETF	128.6875	128.6875	128.6875	128.6875	64200.0
2001-01-08 09:00:00	QQQ	ETF	56.3125	56.4688	54.5	54.875	10659500.0
2001-01-08 10:00:00	QQQ	ETF	54.9062	55.9062	54.375	55.125	10813300.0
2001-01-08 11:00:00	QQQ	ETF	55.0625	55.5312	54.5	54.875	4054000.0
2001-01-08 12:00:00	QQQ	ETF	54.9375	55.6875	54.3125	54.5625	2673700.0
2001-01-08 13:00:00	QQQ	ETF	54.5	54.9375	54.1875	54.4375	3515100.0
2001-01-08 14:00:00	QQQ	ETF	54.4688	54.8438	53.5	53.75	7474300.0
2001-01-08 15:00:00	QQQ	ETF	53.7812	56.9375	53.6875	56.875	11515700.0
2001-01-08 16:00:00	QQQ	ETF	54.625	58.1875	53.6875	58.0	2440600.0
2001-01-08 17:00:00	QQQ	ETF	58.125	58.25	57.8125	57.9375	219200.0
2001-01-08 18:00:00	QQQ	ETF	58.0	58.125	57.75	57.9375	27800.0
2001-01-08 09:00:00	IWM	ETF	45.875	45.9375	45.6562	45.6562	25400.0
2001-01-08 10:00:00	IWM	ETF	45.8125	46.0781	45.6562	46.0312	28200.0
2001-01-08 11:00:00	IWM	ETF	45.875	45.8906	45.6875	45.7188	9000.0
2001-01-08 12:00:00	IWM	ETF	45.875	45.875	45.875	45.875	5200.0
2001-01-08 13:00:00	IWM	ETF	45.8594	45.875	45.7344	45.75	13400.0
2001-01-08 14:00:00	IWM	ETF	45.6562	45.8125	45.3438	45.3438	74600.0
2001-01-08 15:00:00	IWM	ETF	45.5	46.1875	45.5	46.1875	155000.0
2001-01-08 16:00:00	IWM	ETF	46.0	46.25	46.0	46.1875	56000.0
2001-01-08 09:00:00	DIA	ETF	106.0	106.7188	105.875	106.625	302100.0
2001-01-08 10:00:00	DIA	ETF	106.6875	107.125	106.2188	106.3125	221100.0
2001-01-08 11:00:00	DIA	ETF	106.25	106.4688	106.0625	106.375	164000.0
2001-01-08 12:00:00	DIA	ETF	106.3438	106.4688	105.625	105.875	85100.0
2001-01-08 13:00:00	DIA	ETF	105.875	106.5	105.625	106.0	126100.0
2001-01-08 14:00:00	DIA	ETF	106.0	106.2812	105.25	105.25	158600.0
2001-01-08 15:00:00	DIA	ETF	105.25	106.4375	105.125	106.1562	332800.0
2001-01-08 16:00:00	DIA	ETF	106.2188	106.4062	106.125	106.25	34900.0

> showing 35 of 201 rows — these rows as CSV

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