PREVIEW / etf_1hour / 2001-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-05.parquet
  size:    12 KB
  rows:    253

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-10-05 09:00:00	SPY	ETF	107.25	107.38	106.43	106.45	3105700.0
2001-10-05 10:00:00	SPY	ETF	106.47	106.62	105.52	105.78	8971800.0
2001-10-05 11:00:00	SPY	ETF	105.72	106.78	105.7	106.41	4594600.0
2001-10-05 12:00:00	SPY	ETF	106.36	106.55	105.82	106.25	1514800.0
2001-10-05 13:00:00	SPY	ETF	106.25	106.55	105.91	106.25	1662800.0
2001-10-05 14:00:00	SPY	ETF	106.2	107.44	106.17	107.33	3672700.0
2001-10-05 15:00:00	SPY	ETF	107.3	107.62	106.82	107.26	3593100.0
2001-10-05 16:00:00	SPY	ETF	107.26	108.3	106.89	106.97	2117500.0
2001-10-05 17:00:00	SPY	ETF	107.33	107.33	107.33	107.33	100.0
2001-10-05 09:00:00	QQQ	ETF	31.0	31.26	30.53	30.56	14625200.0
2001-10-05 10:00:00	QQQ	ETF	30.55	30.85	30.26	30.5	18426800.0
2001-10-05 11:00:00	QQQ	ETF	30.5	31.12	30.39	30.84	13706500.0
2001-10-05 12:00:00	QQQ	ETF	30.82	31.16	30.67	31.15	7261400.0
2001-10-05 13:00:00	QQQ	ETF	31.15	31.39	30.92	31.12	8674500.0
2001-10-05 14:00:00	QQQ	ETF	31.14	31.9	31.13	31.85	14240700.0
2001-10-05 15:00:00	QQQ	ETF	31.86	31.89	31.3	31.65	13492800.0
2001-10-05 16:00:00	QQQ	ETF	31.63	31.8	31.2	31.79	2988600.0
2001-10-05 17:00:00	QQQ	ETF	31.71	31.74	31.68	31.7	31000.0
2001-10-05 18:00:00	QQQ	ETF	31.68	31.74	31.68	31.7	4400.0
2001-10-05 09:00:00	IWM	ETF	41.45	41.45	40.965	40.99	19000.0
2001-10-05 10:00:00	IWM	ETF	40.84	40.875	40.505	40.55	76400.0
2001-10-05 11:00:00	IWM	ETF	40.67	40.9	40.67	40.86	29600.0
2001-10-05 12:00:00	IWM	ETF	40.745	40.79	40.555	40.745	203200.0
2001-10-05 13:00:00	IWM	ETF	40.83	40.925	40.715	40.895	45000.0
2001-10-05 14:00:00	IWM	ETF	40.9	41.4	40.9	41.32	45400.0
2001-10-05 15:00:00	IWM	ETF	41.425	41.43	41.175	41.37	64400.0
2001-10-05 16:00:00	IWM	ETF	41.275	41.3	41.275	41.3	14800.0
2001-10-05 09:00:00	DIA	ETF	90.5	91.0	90.3	90.33	1187000.0
2001-10-05 10:00:00	DIA	ETF	90.28	90.61	89.57	89.72	1801300.0
2001-10-05 11:00:00	DIA	ETF	89.73	90.59	89.65	90.27	1393200.0
2001-10-05 12:00:00	DIA	ETF	90.33	90.45	89.81	90.15	319400.0
2001-10-05 13:00:00	DIA	ETF	90.15	90.38	89.88	90.18	412800.0
2001-10-05 14:00:00	DIA	ETF	90.21	91.25	90.16	91.15	1010200.0
2001-10-05 15:00:00	DIA	ETF	91.23	91.5	90.73	91.25	1556800.0
2001-10-05 16:00:00	DIA	ETF	91.2	91.29	91.05	91.12	99200.0
2001-10-05 18:00:00	DIA	ETF	90.65	90.65	90.65	90.65	100.0

> showing 36 of 253 rows — these rows as CSV

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