PREVIEW / etf_1hour / 2000-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-07-20.parquet
  size:    9 KB
  rows:    161

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-07-20 09:00:00	SPY	ETF	149.0	149.2812	148.8125	149.0312	512000.0
2000-07-20 10:00:00	SPY	ETF	148.9062	150.5	148.9062	150.2188	1541800.0
2000-07-20 11:00:00	SPY	ETF	150.25	150.4375	149.625	149.8438	509500.0
2000-07-20 12:00:00	SPY	ETF	149.875	150.0938	149.75	150.0	312500.0
2000-07-20 13:00:00	SPY	ETF	149.875	149.9688	149.4062	149.7188	178900.0
2000-07-20 14:00:00	SPY	ETF	149.7188	150.125	149.625	150.0312	399400.0
2000-07-20 15:00:00	SPY	ETF	149.9688	150.125	149.5625	149.8125	559400.0
2000-07-20 16:00:00	SPY	ETF	149.7188	150.625	149.7188	150.625	524200.0
2000-07-20 09:00:00	QQQ	ETF	97.875	98.25	97.2812	97.3125	3352800.0
2000-07-20 10:00:00	QQQ	ETF	97.3125	99.75	97.25	99.5	6273300.0
2000-07-20 11:00:00	QQQ	ETF	99.5	99.75	98.9375	99.0312	1958300.0
2000-07-20 12:00:00	QQQ	ETF	99.0	99.5	99.0	99.1875	873500.0
2000-07-20 13:00:00	QQQ	ETF	99.1875	99.4375	99.0	99.1875	1145200.0
2000-07-20 14:00:00	QQQ	ETF	99.1875	99.875	99.125	99.625	1975800.0
2000-07-20 15:00:00	QQQ	ETF	99.6875	99.8438	99.25	99.5	3174800.0
2000-07-20 16:00:00	QQQ	ETF	99.5625	100.5	97.9375	97.9375	633600.0
2000-07-20 17:00:00	QQQ	ETF	97.5312	100.375	97.5312	100.375	24100.0
2000-07-20 09:00:00	IWM	ETF	53.125	53.125	53.125	53.125	1000.0
2000-07-20 10:00:00	IWM	ETF	53.2188	53.4375	53.2188	53.4219	16600.0
2000-07-20 11:00:00	IWM	ETF	53.375	53.375	53.375	53.375	11400.0
2000-07-20 12:00:00	IWM	ETF	53.375	53.375	53.25	53.25	800.0
2000-07-20 13:00:00	IWM	ETF	53.375	53.375	53.375	53.375	3000.0
2000-07-20 14:00:00	IWM	ETF	53.3594	53.3594	53.3594	53.3594	100400.0
2000-07-20 15:00:00	IWM	ETF	53.3281	53.4688	53.3281	53.4688	17000.0
2000-07-20 16:00:00	IWM	ETF	53.5	53.5	53.5	53.5	200.0
2000-07-20 09:00:00	DIA	ETF	107.8125	108.1875	107.8125	107.8125	169800.0
2000-07-20 10:00:00	DIA	ETF	108.0	108.7188	108.0	108.5938	258500.0
2000-07-20 11:00:00	DIA	ETF	108.5	108.6875	108.2188	108.375	21800.0
2000-07-20 12:00:00	DIA	ETF	108.4062	108.5	108.375	108.375	19400.0
2000-07-20 13:00:00	DIA	ETF	108.375	108.5	108.2188	108.4375	9400.0
2000-07-20 14:00:00	DIA	ETF	108.5	108.875	108.4375	108.8125	64500.0
2000-07-20 15:00:00	DIA	ETF	108.8438	108.9375	108.5625	108.6875	84700.0
2000-07-20 16:00:00	DIA	ETF	108.8125	109.0938	108.8125	109.0938	29800.0

> showing 33 of 161 rows — these rows as CSV

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