PREVIEW / etf_1hour / 2001-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-09.parquet
  size:    12 KB
  rows:    232

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-07-09 09:00:00	SPY	ETF	119.49	119.84	119.2	119.58	1315200.0
2001-07-09 10:00:00	SPY	ETF	119.51	120.23	119.45	119.9	1754900.0
2001-07-09 11:00:00	SPY	ETF	119.84	120.05	119.6	119.71	1271200.0
2001-07-09 12:00:00	SPY	ETF	119.7	119.93	119.41	119.82	660200.0
2001-07-09 13:00:00	SPY	ETF	119.81	120.5	119.74	120.42	835100.0
2001-07-09 14:00:00	SPY	ETF	120.41	120.54	119.95	119.95	548300.0
2001-07-09 15:00:00	SPY	ETF	120.0	120.35	119.83	120.1	933500.0
2001-07-09 16:00:00	SPY	ETF	120.03	120.1	119.61	119.82	494100.0
2001-07-09 17:00:00	SPY	ETF	119.89	119.89	119.75	119.75	600.0
2001-07-09 18:00:00	SPY	ETF	119.95	120.0	119.95	119.99	1200.0
2001-07-09 09:00:00	QQQ	ETF	41.89	42.2	41.55	41.92	8651300.0
2001-07-09 10:00:00	QQQ	ETF	42.03	42.67	41.85	42.42	8698700.0
2001-07-09 11:00:00	QQQ	ETF	42.4	42.54	42.09	42.2	6129900.0
2001-07-09 12:00:00	QQQ	ETF	42.2	42.25	41.9	42.15	4354100.0
2001-07-09 13:00:00	QQQ	ETF	42.17	42.69	42.15	42.55	4151200.0
2001-07-09 14:00:00	QQQ	ETF	42.51	42.64	42.21	42.3	3906100.0
2001-07-09 15:00:00	QQQ	ETF	42.26	42.39	42.07	42.25	6679500.0
2001-07-09 16:00:00	QQQ	ETF	42.29	42.3	42.0	42.22	1569200.0
2001-07-09 17:00:00	QQQ	ETF	42.2	42.27	42.12	42.25	91900.0
2001-07-09 18:00:00	QQQ	ETF	42.25	42.3	42.23	42.23	9200.0
2001-07-09 09:00:00	IWM	ETF	48.125	48.15	47.625	48.125	72400.0
2001-07-09 10:00:00	IWM	ETF	48.03	48.475	48.0	48.375	47000.0
2001-07-09 11:00:00	IWM	ETF	48.35	48.35	48.015	48.015	68600.0
2001-07-09 12:00:00	IWM	ETF	48.0	48.195	47.95	48.195	194200.0
2001-07-09 13:00:00	IWM	ETF	48.125	48.35	48.075	48.215	159400.0
2001-07-09 14:00:00	IWM	ETF	48.325	48.35	48.055	48.18	58200.0
2001-07-09 15:00:00	IWM	ETF	48.18	48.345	48.0	48.225	244400.0
2001-07-09 16:00:00	IWM	ETF	48.34	48.4	48.34	48.4	1000.0
2001-07-09 09:00:00	DIA	ETF	102.95	102.97	102.55	102.85	356300.0
2001-07-09 10:00:00	DIA	ETF	102.73	103.2	102.63	102.93	233500.0
2001-07-09 11:00:00	DIA	ETF	102.93	103.04	102.52	102.6	1262400.0
2001-07-09 12:00:00	DIA	ETF	102.6	102.83	102.32	102.75	174300.0
2001-07-09 13:00:00	DIA	ETF	102.69	103.39	102.63	103.34	254900.0
2001-07-09 14:00:00	DIA	ETF	103.34	103.34	102.83	102.83	142000.0
2001-07-09 15:00:00	DIA	ETF	102.83	103.24	102.69	103.14	175400.0
2001-07-09 16:00:00	DIA	ETF	103.0	103.05	102.85	102.85	137700.0

> showing 36 of 232 rows — these rows as CSV

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