PREVIEW / etf_1hour / 2001-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-23.parquet
  size:    12 KB
  rows:    257

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-23 09:00:00	SPY	ETF	109.96	109.99	108.95	109.4	2650800.0
2001-10-23 10:00:00	SPY	ETF	109.39	110.28	109.36	109.98	4780300.0
2001-10-23 11:00:00	SPY	ETF	109.97	110.15	109.35	109.38	2502500.0
2001-10-23 12:00:00	SPY	ETF	109.4	109.48	108.82	109.12	2951000.0
2001-10-23 13:00:00	SPY	ETF	109.12	109.31	108.84	109.28	1314700.0
2001-10-23 14:00:00	SPY	ETF	109.23	109.29	108.47	108.65	1983400.0
2001-10-23 15:00:00	SPY	ETF	108.63	109.18	108.37	108.8	3311400.0
2001-10-23 16:00:00	SPY	ETF	108.72	108.99	108.72	108.9	1208100.0
2001-10-23 17:00:00	SPY	ETF	108.96	109.0	108.9	108.9	1900.0
2001-10-23 09:00:00	QQQ	ETF	34.82	34.91	34.45	34.86	12354200.0
2001-10-23 10:00:00	QQQ	ETF	34.89	35.4	34.8	35.2	22221800.0
2001-10-23 11:00:00	QQQ	ETF	35.2	35.33	34.85	34.89	10080600.0
2001-10-23 12:00:00	QQQ	ETF	34.9	34.98	34.54	34.8	13885100.0
2001-10-23 13:00:00	QQQ	ETF	34.8	34.99	34.55	34.97	8508500.0
2001-10-23 14:00:00	QQQ	ETF	34.94	34.96	34.23	34.33	13773900.0
2001-10-23 15:00:00	QQQ	ETF	34.33	34.7	34.12	34.56	16834100.0
2001-10-23 16:00:00	QQQ	ETF	34.54	34.64	34.25	34.51	1678900.0
2001-10-23 17:00:00	QQQ	ETF	34.52	34.6	34.48	34.51	35900.0
2001-10-23 18:00:00	QQQ	ETF	34.5	34.54	34.47	34.54	18100.0
2001-10-23 09:00:00	IWM	ETF	43.005	43.145	42.71	42.79	49800.0
2001-10-23 10:00:00	IWM	ETF	42.805	43.06	42.805	42.98	136600.0
2001-10-23 11:00:00	IWM	ETF	42.93	43.025	42.84	42.855	60600.0
2001-10-23 12:00:00	IWM	ETF	42.79	42.79	42.715	42.715	46800.0
2001-10-23 13:00:00	IWM	ETF	42.785	42.835	42.675	42.825	49000.0
2001-10-23 14:00:00	IWM	ETF	42.78	42.8	42.585	42.6	157200.0
2001-10-23 15:00:00	IWM	ETF	42.65	42.705	42.5	42.5	308000.0
2001-10-23 16:00:00	IWM	ETF	42.5	42.505	42.4	42.4	32800.0
2001-10-23 09:00:00	DIA	ETF	94.4	94.45	93.58	93.79	548700.0
2001-10-23 10:00:00	DIA	ETF	93.8	94.54	93.8	94.25	735400.0
2001-10-23 11:00:00	DIA	ETF	94.29	94.44	93.67	93.8	531600.0
2001-10-23 12:00:00	DIA	ETF	93.79	93.84	93.25	93.58	483800.0
2001-10-23 13:00:00	DIA	ETF	93.55	93.74	93.34	93.7	269100.0
2001-10-23 14:00:00	DIA	ETF	93.72	93.72	93.03	93.17	419400.0
2001-10-23 15:00:00	DIA	ETF	93.2	93.74	93.0	93.4	574100.0
2001-10-23 16:00:00	DIA	ETF	93.48	93.67	93.41	93.6	71400.0

> showing 35 of 257 rows — these rows as CSV

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