PREVIEW / etf_1hour / 2001-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-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-07-30 09:00:00	SPY	ETF	121.19	121.35	120.82	120.87	613100.0
2001-07-30 10:00:00	SPY	ETF	120.81	120.95	120.3	120.35	952900.0
2001-07-30 11:00:00	SPY	ETF	120.42	120.98	120.42	120.81	1298700.0
2001-07-30 12:00:00	SPY	ETF	120.92	121.1	120.71	120.91	1096300.0
2001-07-30 13:00:00	SPY	ETF	120.85	121.07	120.67	120.87	581300.0
2001-07-30 14:00:00	SPY	ETF	120.85	120.85	120.35	120.49	1577100.0
2001-07-30 15:00:00	SPY	ETF	120.5	120.86	120.5	120.82	829700.0
2001-07-30 16:00:00	SPY	ETF	120.82	120.94	120.73	120.89	350700.0
2001-07-30 17:00:00	SPY	ETF	120.89	121.02	120.55	121.0	7300.0
2001-07-30 09:00:00	QQQ	ETF	42.13	42.27	41.81	41.81	4894300.0
2001-07-30 10:00:00	QQQ	ETF	41.85	41.93	41.52	41.59	6989500.0
2001-07-30 11:00:00	QQQ	ETF	41.62	42.18	41.55	42.09	5454100.0
2001-07-30 12:00:00	QQQ	ETF	42.13	42.3	41.89	42.09	3495000.0
2001-07-30 13:00:00	QQQ	ETF	42.09	42.21	41.91	41.95	3249300.0
2001-07-30 14:00:00	QQQ	ETF	41.93	41.94	41.4	41.4	6479200.0
2001-07-30 15:00:00	QQQ	ETF	41.43	41.75	41.4	41.65	6208800.0
2001-07-30 16:00:00	QQQ	ETF	41.64	41.75	41.56	41.75	1297900.0
2001-07-30 17:00:00	QQQ	ETF	41.72	41.75	41.65	41.7	16300.0
2001-07-30 18:00:00	QQQ	ETF	41.67	41.7	41.65	41.65	4900.0
2001-07-30 09:00:00	IWM	ETF	48.45	48.5	48.395	48.4	28200.0
2001-07-30 10:00:00	IWM	ETF	48.325	48.325	47.88	48.0	39800.0
2001-07-30 11:00:00	IWM	ETF	47.975	48.075	47.85	48.075	47200.0
2001-07-30 12:00:00	IWM	ETF	48.075	48.075	48.005	48.075	11800.0
2001-07-30 13:00:00	IWM	ETF	48.01	48.15	47.975	48.0	52600.0
2001-07-30 14:00:00	IWM	ETF	48.125	48.125	47.975	48.0	78600.0
2001-07-30 15:00:00	IWM	ETF	48.115	48.27	48.0	48.175	97400.0
2001-07-30 16:00:00	IWM	ETF	48.175	48.175	48.175	48.175	18600.0
2001-07-30 09:00:00	DIA	ETF	104.65	104.65	104.17	104.17	218800.0
2001-07-30 10:00:00	DIA	ETF	104.17	104.31	103.67	103.67	152100.0
2001-07-30 11:00:00	DIA	ETF	103.63	104.1	103.63	103.99	115300.0
2001-07-30 12:00:00	DIA	ETF	103.98	104.19	103.92	104.09	29900.0
2001-07-30 13:00:00	DIA	ETF	104.09	104.19	103.95	104.15	27400.0
2001-07-30 14:00:00	DIA	ETF	104.14	104.14	103.67	103.96	69400.0
2001-07-30 15:00:00	DIA	ETF	103.91	104.15	103.85	104.1	156400.0
2001-07-30 16:00:00	DIA	ETF	104.13	104.19	104.11	104.18	36900.0

> showing 35 of 233 rows — these rows as CSV

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