PREVIEW / etf_1hour / 2001-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-15.parquet
  size:    12 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-08-15 09:00:00	SPY	ETF	119.23	119.61	119.2	119.23	751000.0
2001-08-15 10:00:00	SPY	ETF	119.25	119.58	118.66	118.91	2021800.0
2001-08-15 11:00:00	SPY	ETF	118.95	119.01	118.16	118.33	1013800.0
2001-08-15 12:00:00	SPY	ETF	118.35	118.6	118.28	118.58	615200.0
2001-08-15 13:00:00	SPY	ETF	118.53	118.95	118.53	118.73	712500.0
2001-08-15 14:00:00	SPY	ETF	118.74	119.13	118.54	118.67	956400.0
2001-08-15 15:00:00	SPY	ETF	118.6	118.72	118.2	118.28	1157200.0
2001-08-15 16:00:00	SPY	ETF	118.23	118.42	118.08	118.18	1107000.0
2001-08-15 17:00:00	SPY	ETF	118.05	118.05	118.05	118.05	100.0
2001-08-15 09:00:00	QQQ	ETF	40.62	40.93	40.3	40.37	7121200.0
2001-08-15 10:00:00	QQQ	ETF	40.37	40.6	39.94	40.16	11358600.0
2001-08-15 11:00:00	QQQ	ETF	40.13	40.2	39.49	39.6	8148900.0
2001-08-15 12:00:00	QQQ	ETF	39.63	39.75	39.46	39.71	5938300.0
2001-08-15 13:00:00	QQQ	ETF	39.69	39.92	39.65	39.68	4016900.0
2001-08-15 14:00:00	QQQ	ETF	39.69	39.8	39.34	39.43	7520400.0
2001-08-15 15:00:00	QQQ	ETF	39.42	39.6	39.16	39.19	10710600.0
2001-08-15 16:00:00	QQQ	ETF	39.15	39.42	39.07	39.2	1736900.0
2001-08-15 17:00:00	QQQ	ETF	39.2	39.23	39.13	39.18	59300.0
2001-08-15 18:00:00	QQQ	ETF	39.17	39.22	39.15	39.15	13600.0
2001-08-15 09:00:00	IWM	ETF	47.875	48.09	47.875	47.935	7400.0
2001-08-15 10:00:00	IWM	ETF	48.07	48.115	47.705	47.71	31400.0
2001-08-15 11:00:00	IWM	ETF	47.68	47.68	47.655	47.655	1000.0
2001-08-15 12:00:00	IWM	ETF	47.6	47.72	47.51	47.6	133200.0
2001-08-15 13:00:00	IWM	ETF	47.74	47.94	47.705	47.85	144400.0
2001-08-15 14:00:00	IWM	ETF	47.865	47.95	47.75	47.75	240600.0
2001-08-15 15:00:00	IWM	ETF	47.79	47.92	47.68	47.8	275600.0
2001-08-15 16:00:00	IWM	ETF	47.79	47.79	47.79	47.79	20000.0
2001-08-15 09:00:00	DIA	ETF	104.31	104.7	104.27	104.56	185900.0
2001-08-15 10:00:00	DIA	ETF	104.51	104.84	104.16	104.34	539500.0
2001-08-15 11:00:00	DIA	ETF	104.38	104.45	103.8	103.92	286000.0
2001-08-15 12:00:00	DIA	ETF	103.91	104.09	103.9	104.07	193400.0
2001-08-15 13:00:00	DIA	ETF	104.04	104.45	104.04	104.36	281700.0
2001-08-15 14:00:00	DIA	ETF	104.25	104.55	104.01	104.14	347700.0
2001-08-15 15:00:00	DIA	ETF	104.12	104.12	103.6	103.64	443300.0
2001-08-15 16:00:00	DIA	ETF	103.6	103.65	103.51	103.57	49500.0
2001-08-15 17:00:00	DIA	ETF	103.5	103.5	103.5	103.5	200.0

> showing 36 of 230 rows — these rows as CSV

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