PREVIEW / etf_1hour / 2000-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-06-20.parquet
  size:    9 KB
  rows:    169

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-06-20 09:00:00	SPY	ETF	148.1875	148.7188	148.125	148.7188	1514900.0
2000-06-20 10:00:00	SPY	ETF	148.6875	148.875	148.0938	148.5	570300.0
2000-06-20 11:00:00	SPY	ETF	148.5	148.5	147.125	147.25	1095300.0
2000-06-20 12:00:00	SPY	ETF	147.25	147.8438	147.0938	147.6875	609000.0
2000-06-20 13:00:00	SPY	ETF	147.5938	148.0	147.5312	147.7188	181000.0
2000-06-20 14:00:00	SPY	ETF	147.6875	148.2812	147.2812	147.2812	478700.0
2000-06-20 15:00:00	SPY	ETF	147.3125	148.0312	147.0	147.8125	839000.0
2000-06-20 16:00:00	SPY	ETF	147.8125	147.9375	147.6562	147.9375	1173500.0
2000-06-20 09:00:00	QQQ	ETF	98.25	99.4688	98.0	99.3125	3797500.0
2000-06-20 10:00:00	QQQ	ETF	99.375	99.6875	98.625	99.1875	3603300.0
2000-06-20 11:00:00	QQQ	ETF	99.25	99.3125	97.1875	97.5625	4054600.0
2000-06-20 12:00:00	QQQ	ETF	97.5	98.5938	97.375	98.4375	2359800.0
2000-06-20 13:00:00	QQQ	ETF	98.4688	98.875	98.1875	98.5	1821900.0
2000-06-20 14:00:00	QQQ	ETF	98.5	98.9375	97.7812	97.9375	1431400.0
2000-06-20 15:00:00	QQQ	ETF	97.875	98.4375	97.3125	98.25	3362700.0
2000-06-20 16:00:00	QQQ	ETF	98.25	98.75	97.5	97.6875	435700.0
2000-06-20 17:00:00	QQQ	ETF	98.0	98.0	97.625	97.625	2200.0
2000-06-20 18:00:00	QQQ	ETF	97.625	97.625	97.625	97.625	100.0
2000-06-20 09:00:00	IWM	ETF	52.3281	52.4375	52.2344	52.4375	2600.0
2000-06-20 10:00:00	IWM	ETF	52.4375	52.6719	52.4062	52.6719	8000.0
2000-06-20 11:00:00	IWM	ETF	52.5625	52.5625	52.25	52.25	22000.0
2000-06-20 12:00:00	IWM	ETF	52.125	52.125	52.125	52.125	200.0
2000-06-20 13:00:00	IWM	ETF	52.3594	52.3594	52.3594	52.3594	400.0
2000-06-20 14:00:00	IWM	ETF	52.5625	52.5625	52.5	52.5	400.0
2000-06-20 15:00:00	IWM	ETF	52.625	52.625	52.625	52.625	5400.0
2000-06-20 16:00:00	IWM	ETF	52.625	52.625	52.5938	52.5938	8000.0
2000-06-20 09:00:00	DIA	ETF	105.4062	105.4375	104.8125	105.0625	187900.0
2000-06-20 10:00:00	DIA	ETF	105.1562	105.375	104.8438	105.0	162500.0
2000-06-20 11:00:00	DIA	ETF	105.0938	105.0938	104.1562	104.1562	340400.0
2000-06-20 12:00:00	DIA	ETF	104.3438	104.7812	104.125	104.5	242000.0
2000-06-20 13:00:00	DIA	ETF	104.5625	104.8438	104.375	104.625	57100.0
2000-06-20 14:00:00	DIA	ETF	104.6875	105.0	104.125	104.25	231400.0
2000-06-20 15:00:00	DIA	ETF	104.25	104.7188	104.0625	104.5625	134300.0
2000-06-20 16:00:00	DIA	ETF	104.375	104.75	104.3125	104.75	5200.0

> showing 34 of 169 rows — these rows as CSV

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