PREVIEW / etf_1hour / 2001-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-02.parquet
  size:    11 KB
  rows:    217

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-02 09:00:00	SPY	ETF	116.3	116.6	115.99	116.58	1077800.0
2001-04-02 10:00:00	SPY	ETF	116.48	116.95	116.1	116.59	1674700.0
2001-04-02 11:00:00	SPY	ETF	116.59	117.38	116.4	117.02	1415400.0
2001-04-02 12:00:00	SPY	ETF	116.95	117.05	115.28	115.69	1177400.0
2001-04-02 13:00:00	SPY	ETF	115.69	115.7	114.28	114.58	1418800.0
2001-04-02 14:00:00	SPY	ETF	114.55	114.81	113.96	114.25	1370300.0
2001-04-02 15:00:00	SPY	ETF	114.21	114.9	113.8	114.54	1568100.0
2001-04-02 16:00:00	SPY	ETF	114.6	115.5	113.75	114.4	721600.0
2001-04-02 17:00:00	SPY	ETF	114.4	114.4	114.3	114.3	1600.0
2001-04-02 09:00:00	QQQ	ETF	39.17	39.85	39.03	39.49	5451800.0
2001-04-02 10:00:00	QQQ	ETF	39.5	39.78	38.55	38.84	12297000.0
2001-04-02 11:00:00	QQQ	ETF	38.8	39.39	38.78	39.0	6905000.0
2001-04-02 12:00:00	QQQ	ETF	39.0	39.11	38.2	38.43	9130500.0
2001-04-02 13:00:00	QQQ	ETF	38.47	38.5	37.63	37.78	9688500.0
2001-04-02 14:00:00	QQQ	ETF	37.75	37.87	37.35	37.53	8255200.0
2001-04-02 15:00:00	QQQ	ETF	37.57	37.98	37.34	37.75	14191700.0
2001-04-02 16:00:00	QQQ	ETF	37.72	39.5	37.3	37.51	2533900.0
2001-04-02 17:00:00	QQQ	ETF	37.48	37.6	37.39	37.6	97000.0
2001-04-02 18:00:00	QQQ	ETF	37.6	37.6	37.4	37.4	19100.0
2001-04-02 09:00:00	IWM	ETF	44.775	45.0	44.75	44.825	60600.0
2001-04-02 10:00:00	IWM	ETF	44.86	44.86	44.45	44.45	13600.0
2001-04-02 11:00:00	IWM	ETF	44.54	44.75	44.54	44.75	34800.0
2001-04-02 12:00:00	IWM	ETF	44.725	44.725	44.225	44.255	41600.0
2001-04-02 13:00:00	IWM	ETF	44.05	44.2	43.8	43.875	69000.0
2001-04-02 14:00:00	IWM	ETF	44.0	44.05	43.775	44.0	40400.0
2001-04-02 15:00:00	IWM	ETF	43.725	44.025	43.675	43.75	78400.0
2001-04-02 16:00:00	IWM	ETF	43.75	43.75	43.75	43.75	1800.0
2001-04-02 09:00:00	DIA	ETF	98.4	99.3	98.4	99.3	425300.0
2001-04-02 10:00:00	DIA	ETF	99.3	99.65	98.95	99.44	976700.0
2001-04-02 11:00:00	DIA	ETF	99.44	99.97	99.32	99.73	698100.0
2001-04-02 12:00:00	DIA	ETF	99.7	99.75	97.82	98.2	3042100.0
2001-04-02 13:00:00	DIA	ETF	98.16	98.18	97.02	97.35	1193100.0
2001-04-02 14:00:00	DIA	ETF	97.45	97.8	97.03	97.25	879800.0
2001-04-02 15:00:00	DIA	ETF	97.6	98.0	97.02	97.74	1022800.0
2001-04-02 16:00:00	DIA	ETF	97.65	97.8	97.2	97.8	167900.0
2001-04-02 17:00:00	DIA	ETF	97.38	97.38	97.38	97.38	500.0

> showing 36 of 217 rows — these rows as CSV

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