PREVIEW / etf_1hour / 2001-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-27.parquet
  size:    13 KB
  rows:    282

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-11-27 09:00:00	SPY	ETF	115.62	115.85	115.46	115.8	1205900.0
2001-11-27 10:00:00	SPY	ETF	115.82	115.84	114.51	114.59	3626900.0
2001-11-27 11:00:00	SPY	ETF	114.61	115.14	114.52	115.01	1253200.0
2001-11-27 12:00:00	SPY	ETF	115.0	115.34	114.94	115.18	1446800.0
2001-11-27 13:00:00	SPY	ETF	115.16	116.46	115.16	116.46	3559500.0
2001-11-27 14:00:00	SPY	ETF	116.39	116.9	116.0	116.02	2794000.0
2001-11-27 15:00:00	SPY	ETF	116.03	116.17	115.07	115.4	4064100.0
2001-11-27 16:00:00	SPY	ETF	115.37	116.08	115.35	115.47	870000.0
2001-11-27 09:00:00	QQQ	ETF	40.05	40.24	39.88	40.17	8881300.0
2001-11-27 10:00:00	QQQ	ETF	40.17	40.2	39.2	39.3	17727900.0
2001-11-27 11:00:00	QQQ	ETF	39.31	39.69	39.23	39.62	11857400.0
2001-11-27 12:00:00	QQQ	ETF	39.61	39.95	39.59	39.84	7473000.0
2001-11-27 13:00:00	QQQ	ETF	39.84	40.82	39.82	40.78	17708900.0
2001-11-27 14:00:00	QQQ	ETF	40.8	40.97	40.62	40.62	15544500.0
2001-11-27 15:00:00	QQQ	ETF	40.64	40.7	39.82	40.13	17270400.0
2001-11-27 16:00:00	QQQ	ETF	40.15	40.9	40.11	40.15	1539500.0
2001-11-27 09:00:00	IWM	ETF	45.95	45.975	45.85	45.975	48200.0
2001-11-27 10:00:00	IWM	ETF	45.975	45.975	45.555	45.64	130200.0
2001-11-27 11:00:00	IWM	ETF	45.635	45.765	45.575	45.585	54800.0
2001-11-27 12:00:00	IWM	ETF	45.67	45.79	45.67	45.78	18400.0
2001-11-27 13:00:00	IWM	ETF	45.79	46.1	45.79	46.1	58000.0
2001-11-27 14:00:00	IWM	ETF	46.12	46.17	46.035	46.035	79600.0
2001-11-27 15:00:00	IWM	ETF	46.025	46.03	45.825	45.955	27200.0
2001-11-27 16:00:00	IWM	ETF	45.855	45.855	45.825	45.825	1200.0
2001-11-27 09:00:00	DIA	ETF	99.5	99.63	99.32	99.56	542900.0
2001-11-27 10:00:00	DIA	ETF	99.57	99.57	98.41	98.56	935500.0
2001-11-27 11:00:00	DIA	ETF	98.56	98.94	98.5	98.79	578000.0
2001-11-27 12:00:00	DIA	ETF	98.81	99.0	98.73	98.93	939500.0
2001-11-27 13:00:00	DIA	ETF	98.94	99.7	98.85	99.69	664600.0
2001-11-27 14:00:00	DIA	ETF	99.69	100.14	99.4	99.4	651300.0
2001-11-27 15:00:00	DIA	ETF	99.4	99.5	98.6	98.81	520700.0
2001-11-27 16:00:00	DIA	ETF	98.91	99.08	98.8	99.08	149000.0

> showing 32 of 282 rows — these rows as CSV

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