PREVIEW / etf_1hour / 2001-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-16.parquet
  size:    12 KB
  rows:    253

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-10-16 09:00:00	SPY	ETF	109.8	110.61	109.46	110.3	2779200.0
2001-10-16 10:00:00	SPY	ETF	110.27	110.45	109.0	109.25	3727600.0
2001-10-16 11:00:00	SPY	ETF	109.26	109.52	108.95	109.2	1959400.0
2001-10-16 12:00:00	SPY	ETF	109.24	109.4	108.97	109.39	983600.0
2001-10-16 13:00:00	SPY	ETF	109.34	109.79	109.27	109.54	1339800.0
2001-10-16 14:00:00	SPY	ETF	109.51	109.93	109.25	109.67	1579600.0
2001-10-16 15:00:00	SPY	ETF	109.67	110.24	109.48	110.06	2135900.0
2001-10-16 16:00:00	SPY	ETF	110.06	110.17	109.5	109.99	938300.0
2001-10-16 17:00:00	SPY	ETF	110.1	110.67	109.95	110.62	36400.0
2001-10-16 18:00:00	SPY	ETF	110.59	110.8	110.46	110.6	2300.0
2001-10-16 09:00:00	QQQ	ETF	34.66	35.06	34.35	34.89	13529200.0
2001-10-16 10:00:00	QQQ	ETF	34.89	35.0	34.07	34.33	18614500.0
2001-10-16 11:00:00	QQQ	ETF	34.32	34.5	34.17	34.3	8522100.0
2001-10-16 12:00:00	QQQ	ETF	34.31	34.45	34.1	34.44	6016100.0
2001-10-16 13:00:00	QQQ	ETF	34.45	34.73	34.39	34.57	6689400.0
2001-10-16 14:00:00	QQQ	ETF	34.58	34.79	34.38	34.63	6833600.0
2001-10-16 15:00:00	QQQ	ETF	34.62	35.04	34.5	34.95	12362300.0
2001-10-16 16:00:00	QQQ	ETF	34.98	35.4	34.7	34.9	3798900.0
2001-10-16 17:00:00	QQQ	ETF	34.9	35.43	34.85	35.37	1082800.0
2001-10-16 18:00:00	QQQ	ETF	35.43	35.5	35.26	35.46	202500.0
2001-10-16 09:00:00	IWM	ETF	42.95	43.29	42.95	43.135	15800.0
2001-10-16 10:00:00	IWM	ETF	43.13	43.25	42.875	42.91	192200.0
2001-10-16 11:00:00	IWM	ETF	42.865	43.15	42.865	43.07	140200.0
2001-10-16 12:00:00	IWM	ETF	43.015	43.025	42.94	42.945	89200.0
2001-10-16 13:00:00	IWM	ETF	42.95	43.12	42.95	43.05	106600.0
2001-10-16 14:00:00	IWM	ETF	43.135	43.14	42.91	43.025	104600.0
2001-10-16 15:00:00	IWM	ETF	43.09	43.4	43.09	43.265	279600.0
2001-10-16 16:00:00	IWM	ETF	43.3	43.4	43.275	43.275	19000.0
2001-10-16 09:00:00	DIA	ETF	93.9	94.3	93.55	94.1	646200.0
2001-10-16 10:00:00	DIA	ETF	94.1	94.24	93.06	93.32	1299600.0
2001-10-16 11:00:00	DIA	ETF	93.25	93.58	93.03	93.31	670700.0
2001-10-16 12:00:00	DIA	ETF	93.35	93.45	93.14	93.35	118400.0
2001-10-16 13:00:00	DIA	ETF	93.4	93.75	93.35	93.54	218100.0
2001-10-16 14:00:00	DIA	ETF	93.58	93.8	93.27	93.68	557900.0
2001-10-16 15:00:00	DIA	ETF	93.66	94.08	93.43	93.93	616300.0
2001-10-16 16:00:00	DIA	ETF	93.94	94.06	93.85	93.89	173800.0
2001-10-16 17:00:00	DIA	ETF	94.05	94.9	94.05	94.9	2100.0

> showing 37 of 253 rows — these rows as CSV

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