PREVIEW / etf_1hour / 2001-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-07.parquet
  size:    11 KB
  rows:    230

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-05-07 09:00:00	SPY	ETF	127.0	127.26	126.58	127.21	651400.0
2001-05-07 10:00:00	SPY	ETF	127.2	127.38	126.26	126.37	1481100.0
2001-05-07 11:00:00	SPY	ETF	126.36	126.79	126.26	126.5	607100.0
2001-05-07 12:00:00	SPY	ETF	126.53	126.69	126.32	126.55	450700.0
2001-05-07 13:00:00	SPY	ETF	126.55	126.87	126.23	126.85	649700.0
2001-05-07 14:00:00	SPY	ETF	126.85	127.27	126.71	126.9	780900.0
2001-05-07 15:00:00	SPY	ETF	126.96	127.07	126.45	126.57	888500.0
2001-05-07 16:00:00	SPY	ETF	126.56	126.96	126.24	126.5	657500.0
2001-05-07 09:00:00	QQQ	ETF	48.0	48.3	47.59	48.2	6928600.0
2001-05-07 10:00:00	QQQ	ETF	48.19	48.6	47.5	47.56	10377300.0
2001-05-07 11:00:00	QQQ	ETF	47.55	47.98	47.11	47.33	6082700.0
2001-05-07 12:00:00	QQQ	ETF	47.27	47.7	47.25	47.62	2911900.0
2001-05-07 13:00:00	QQQ	ETF	47.65	47.75	47.21	47.73	2654900.0
2001-05-07 14:00:00	QQQ	ETF	47.71	48.15	47.6	47.65	5558100.0
2001-05-07 15:00:00	QQQ	ETF	47.73	47.8	47.1	47.21	7203500.0
2001-05-07 16:00:00	QQQ	ETF	47.26	48.4	47.2	47.42	1340500.0
2001-05-07 17:00:00	QQQ	ETF	47.4	47.5	47.38	47.49	25900.0
2001-05-07 18:00:00	QQQ	ETF	47.45	47.47	47.4	47.47	4000.0
2001-05-07 09:00:00	IWM	ETF	49.3	49.3	49.1	49.15	7000.0
2001-05-07 10:00:00	IWM	ETF	49.4	49.5	49.005	49.005	29800.0
2001-05-07 11:00:00	IWM	ETF	49.085	49.175	48.97	48.97	133400.0
2001-05-07 12:00:00	IWM	ETF	48.955	49.21	48.955	49.145	17000.0
2001-05-07 13:00:00	IWM	ETF	49.145	49.145	49.125	49.14	4200.0
2001-05-07 14:00:00	IWM	ETF	49.125	49.35	49.125	49.32	14200.0
2001-05-07 15:00:00	IWM	ETF	49.15	49.28	48.7	48.825	34800.0
2001-05-07 16:00:00	IWM	ETF	48.75	48.75	48.75	48.75	13800.0
2001-05-07 09:00:00	DIA	ETF	109.5	109.95	109.33	109.92	568500.0
2001-05-07 10:00:00	DIA	ETF	109.93	110.03	109.11	109.33	677900.0
2001-05-07 11:00:00	DIA	ETF	109.33	109.5	108.95	109.19	256000.0
2001-05-07 12:00:00	DIA	ETF	109.16	109.34	109.05	109.17	94700.0
2001-05-07 13:00:00	DIA	ETF	109.25	109.55	109.0	109.53	174100.0
2001-05-07 14:00:00	DIA	ETF	109.52	109.88	109.46	109.62	165100.0
2001-05-07 15:00:00	DIA	ETF	109.61	109.73	109.21	109.44	305400.0
2001-05-07 16:00:00	DIA	ETF	109.36	109.62	109.21	109.42	36800.0
2001-05-07 18:00:00	DIA	ETF	109.3	109.3	109.3	109.3	100.0

> showing 35 of 230 rows — these rows as CSV

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