PREVIEW / etf_1hour / 2001-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-30.parquet
  size:    12 KB
  rows:    233

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-04-30 09:00:00	SPY	ETF	126.45	126.86	126.1	126.86	1650100.0
2001-04-30 10:00:00	SPY	ETF	126.8	127.21	126.53	126.97	1182800.0
2001-04-30 11:00:00	SPY	ETF	126.97	127.27	126.8	126.83	595300.0
2001-04-30 12:00:00	SPY	ETF	126.85	127.1	126.75	127.1	710000.0
2001-04-30 13:00:00	SPY	ETF	127.1	127.2	126.3	126.32	678500.0
2001-04-30 14:00:00	SPY	ETF	126.45	126.47	124.81	124.94	1786200.0
2001-04-30 15:00:00	SPY	ETF	124.98	125.43	124.67	125.21	1709400.0
2001-04-30 16:00:00	SPY	ETF	125.21	125.25	124.3	124.91	1978600.0
2001-04-30 17:00:00	SPY	ETF	124.86	125.28	124.85	124.97	6300.0
2001-04-30 18:00:00	SPY	ETF	124.97	124.97	124.79	124.97	2500.0
2001-04-30 09:00:00	QQQ	ETF	46.25	46.72	45.95	46.67	9691600.0
2001-04-30 10:00:00	QQQ	ETF	46.71	47.28	46.54	47.11	10946200.0
2001-04-30 11:00:00	QQQ	ETF	47.11	47.57	47.02	47.24	6665900.0
2001-04-30 12:00:00	QQQ	ETF	47.24	47.36	46.84	47.22	6205900.0
2001-04-30 13:00:00	QQQ	ETF	47.2	47.42	46.75	46.85	7279200.0
2001-04-30 14:00:00	QQQ	ETF	46.86	46.9	45.65	45.71	11466000.0
2001-04-30 15:00:00	QQQ	ETF	45.75	46.54	45.45	46.23	11700100.0
2001-04-30 16:00:00	QQQ	ETF	46.23	46.5	45.9	46.1	3833000.0
2001-04-30 17:00:00	QQQ	ETF	46.06	46.15	46.06	46.12	34000.0
2001-04-30 18:00:00	QQQ	ETF	46.1	46.3	46.1	46.3	7900.0
2001-04-30 09:00:00	IWM	ETF	48.825	48.825	48.55	48.775	180800.0
2001-04-30 10:00:00	IWM	ETF	48.8	48.95	48.65	48.95	418400.0
2001-04-30 11:00:00	IWM	ETF	48.995	49.05	48.815	48.955	48200.0
2001-04-30 12:00:00	IWM	ETF	49.0	49.05	48.775	49.03	19000.0
2001-04-30 13:00:00	IWM	ETF	48.955	49.045	48.77	48.77	46600.0
2001-04-30 14:00:00	IWM	ETF	48.845	48.845	48.425	48.475	157600.0
2001-04-30 15:00:00	IWM	ETF	48.3	48.675	48.255	48.5	190000.0
2001-04-30 16:00:00	IWM	ETF	48.5	48.5	48.5	48.5	4800.0
2001-04-30 09:00:00	DIA	ETF	108.49	109.0	108.15	108.83	708400.0
2001-04-30 10:00:00	DIA	ETF	108.95	109.12	108.62	108.9	686900.0
2001-04-30 11:00:00	DIA	ETF	108.9	109.07	108.6	108.75	263100.0
2001-04-30 12:00:00	DIA	ETF	108.71	108.95	108.63	108.9	193500.0
2001-04-30 13:00:00	DIA	ETF	108.9	108.98	108.31	108.31	190700.0
2001-04-30 14:00:00	DIA	ETF	108.35	108.4	107.32	107.44	906800.0
2001-04-30 15:00:00	DIA	ETF	107.46	107.6	107.1	107.4	619400.0
2001-04-30 16:00:00	DIA	ETF	107.32	108.23	107.2	108.23	107700.0
2001-04-30 17:00:00	DIA	ETF	107.2	107.2	107.2	107.2	200.0

> showing 37 of 233 rows — these rows as CSV

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