PREVIEW / etf_1hour / 2001-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-24.parquet
  size:    12 KB
  rows:    228

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-24 09:00:00	SPY	ETF	117.21	117.21	116.74	116.95	917700.0
2001-08-24 10:00:00	SPY	ETF	116.95	118.25	116.95	118.05	2031200.0
2001-08-24 11:00:00	SPY	ETF	118.05	119.0	118.05	118.9	2150300.0
2001-08-24 12:00:00	SPY	ETF	118.93	118.99	118.67	118.74	678500.0
2001-08-24 13:00:00	SPY	ETF	118.74	118.91	118.41	118.53	957900.0
2001-08-24 14:00:00	SPY	ETF	118.52	118.8	118.37	118.66	1625100.0
2001-08-24 15:00:00	SPY	ETF	118.65	119.1	118.54	119.0	2058600.0
2001-08-24 16:00:00	SPY	ETF	118.97	119.13	118.83	119.0	970800.0
2001-08-24 17:00:00	SPY	ETF	119.15	119.15	119.15	119.15	500.0
2001-08-24 18:00:00	SPY	ETF	119.01	119.01	119.01	119.01	600.0
2001-08-24 09:00:00	QQQ	ETF	37.86	38.09	37.75	38.0	7032500.0
2001-08-24 10:00:00	QQQ	ETF	38.0	38.68	37.96	38.52	14938800.0
2001-08-24 11:00:00	QQQ	ETF	38.52	39.07	38.47	38.93	10815300.0
2001-08-24 12:00:00	QQQ	ETF	38.94	39.17	38.81	39.11	4600400.0
2001-08-24 13:00:00	QQQ	ETF	39.11	39.35	38.96	39.03	5416200.0
2001-08-24 14:00:00	QQQ	ETF	39.04	39.15	38.9	39.04	4983400.0
2001-08-24 15:00:00	QQQ	ETF	39.01	39.39	38.97	39.35	7541500.0
2001-08-24 16:00:00	QQQ	ETF	39.36	39.41	39.27	39.32	1192900.0
2001-08-24 17:00:00	QQQ	ETF	39.35	39.39	39.28	39.31	14200.0
2001-08-24 18:00:00	QQQ	ETF	39.33	39.35	39.28	39.28	3300.0
2001-08-24 09:00:00	IWM	ETF	47.5	47.5	47.425	47.425	5200.0
2001-08-24 10:00:00	IWM	ETF	47.545	47.695	47.5	47.5	10600.0
2001-08-24 11:00:00	IWM	ETF	47.75	47.76	47.675	47.755	924000.0
2001-08-24 12:00:00	IWM	ETF	47.75	47.75	47.63	47.72	753600.0
2001-08-24 13:00:00	IWM	ETF	47.69	47.725	47.625	47.675	297400.0
2001-08-24 14:00:00	IWM	ETF	47.6	47.675	47.58	47.675	102400.0
2001-08-24 15:00:00	IWM	ETF	47.675	47.965	47.675	47.85	147200.0
2001-08-24 16:00:00	IWM	ETF	47.85	48.05	47.85	48.05	99400.0
2001-08-24 09:00:00	DIA	ETF	102.75	102.75	102.38	102.5	103100.0
2001-08-24 10:00:00	DIA	ETF	102.51	103.92	102.48	103.66	681900.0
2001-08-24 11:00:00	DIA	ETF	103.66	104.69	103.66	104.54	811700.0
2001-08-24 12:00:00	DIA	ETF	104.48	104.49	104.24	104.34	235900.0
2001-08-24 13:00:00	DIA	ETF	104.34	104.52	104.05	104.18	122500.0
2001-08-24 14:00:00	DIA	ETF	104.15	104.33	104.05	104.23	170700.0
2001-08-24 15:00:00	DIA	ETF	104.2	104.62	104.08	104.41	460700.0
2001-08-24 16:00:00	DIA	ETF	104.43	104.63	104.36	104.56	107900.0

> showing 36 of 228 rows — these rows as CSV

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