PREVIEW / etf_1hour / 2001-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-06.parquet
  size:    11 KB
  rows:    229

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-06-06 09:00:00	SPY	ETF	128.83	128.83	128.24	128.41	1841700.0
2001-06-06 10:00:00	SPY	ETF	128.44	128.8	127.81	128.18	2069300.0
2001-06-06 11:00:00	SPY	ETF	128.18	128.23	127.45	127.63	2335500.0
2001-06-06 12:00:00	SPY	ETF	127.62	128.04	127.57	127.9	1351400.0
2001-06-06 13:00:00	SPY	ETF	127.87	128.19	127.6	128.17	991500.0
2001-06-06 14:00:00	SPY	ETF	128.11	128.25	127.62	127.72	988600.0
2001-06-06 15:00:00	SPY	ETF	127.76	127.76	127.36	127.48	1294000.0
2001-06-06 16:00:00	SPY	ETF	127.53	127.84	127.43	127.72	762500.0
2001-06-06 18:00:00	SPY	ETF	127.5	127.5	127.3	127.3	2700.0
2001-06-06 09:00:00	QQQ	ETF	48.08	48.19	47.7	48.0	10187700.0
2001-06-06 10:00:00	QQQ	ETF	48.0	48.49	47.6	47.97	11714600.0
2001-06-06 11:00:00	QQQ	ETF	47.99	48.05	47.07	47.2	14098800.0
2001-06-06 12:00:00	QQQ	ETF	47.19	47.85	47.15	47.7	4846100.0
2001-06-06 13:00:00	QQQ	ETF	47.69	47.98	47.51	47.97	3834200.0
2001-06-06 14:00:00	QQQ	ETF	47.97	48.14	47.58	47.68	5221300.0
2001-06-06 15:00:00	QQQ	ETF	47.67	47.75	47.34	47.43	7337000.0
2001-06-06 16:00:00	QQQ	ETF	47.4	47.6	47.4	47.54	1270900.0
2001-06-06 17:00:00	QQQ	ETF	47.5	47.58	47.4	47.45	26500.0
2001-06-06 18:00:00	QQQ	ETF	47.45	47.46	47.37	47.4	9500.0
2001-06-06 09:00:00	IWM	ETF	51.5	51.625	51.325	51.375	28000.0
2001-06-06 10:00:00	IWM	ETF	51.4	51.595	51.255	51.255	99600.0
2001-06-06 11:00:00	IWM	ETF	51.3	51.3	51.075	51.11	317200.0
2001-06-06 12:00:00	IWM	ETF	51.25	51.295	51.15	51.275	9600.0
2001-06-06 13:00:00	IWM	ETF	51.275	51.275	51.115	51.175	232000.0
2001-06-06 14:00:00	IWM	ETF	51.225	51.395	51.205	51.275	135200.0
2001-06-06 15:00:00	IWM	ETF	51.29	51.29	51.11	51.125	216400.0
2001-06-06 16:00:00	IWM	ETF	51.125	51.175	51.105	51.175	15200.0
2001-06-06 09:00:00	DIA	ETF	111.85	111.92	111.5	111.7	406100.0
2001-06-06 10:00:00	DIA	ETF	111.74	111.94	111.35	111.53	398400.0
2001-06-06 11:00:00	DIA	ETF	111.55	111.62	111.0	111.0	244500.0
2001-06-06 12:00:00	DIA	ETF	111.0	111.34	110.91	111.19	89500.0
2001-06-06 13:00:00	DIA	ETF	111.19	111.34	110.85	111.26	316400.0
2001-06-06 14:00:00	DIA	ETF	111.32	111.36	110.91	111.02	134900.0
2001-06-06 15:00:00	DIA	ETF	110.96	110.98	110.71	110.75	510300.0
2001-06-06 16:00:00	DIA	ETF	110.81	111.05	110.71	110.9	62800.0

> showing 35 of 229 rows — these rows as CSV

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