PREVIEW / etf_1hour / 2001-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-01.parquet
  size:    13 KB
  rows:    259

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-11-01 09:00:00	SPY	ETF	106.6	106.88	106.29	106.58	2949400.0
2001-11-01 10:00:00	SPY	ETF	106.64	107.5	105.69	107.44	6645500.0
2001-11-01 11:00:00	SPY	ETF	107.45	107.59	107.06	107.25	3958500.0
2001-11-01 12:00:00	SPY	ETF	107.28	107.82	107.18	107.69	1874700.0
2001-11-01 13:00:00	SPY	ETF	107.69	108.7	107.68	108.37	4243400.0
2001-11-01 14:00:00	SPY	ETF	108.31	108.77	108.05	108.11	2854700.0
2001-11-01 15:00:00	SPY	ETF	108.15	109.01	108.06	108.67	4717400.0
2001-11-01 16:00:00	SPY	ETF	108.71	108.71	108.43	108.51	1655800.0
2001-11-01 17:00:00	SPY	ETF	108.47	108.48	108.2	108.45	41200.0
2001-11-01 09:00:00	QQQ	ETF	34.44	34.6	34.2	34.42	9329400.0
2001-11-01 10:00:00	QQQ	ETF	34.42	34.86	33.78	34.82	23524900.0
2001-11-01 11:00:00	QQQ	ETF	34.82	34.9	34.54	34.64	8723200.0
2001-11-01 12:00:00	QQQ	ETF	34.65	34.86	34.49	34.69	5752900.0
2001-11-01 13:00:00	QQQ	ETF	34.72	35.3	34.3	35.13	17426800.0
2001-11-01 14:00:00	QQQ	ETF	35.13	35.42	35.05	35.05	9581300.0
2001-11-01 15:00:00	QQQ	ETF	35.07	35.56	35.02	35.44	14781200.0
2001-11-01 16:00:00	QQQ	ETF	35.45	35.48	35.2	35.37	2095200.0
2001-11-01 17:00:00	QQQ	ETF	35.31	35.35	35.14	35.2	107100.0
2001-11-01 18:00:00	QQQ	ETF	35.24	35.3	35.24	35.28	39800.0
2001-11-01 09:00:00	IWM	ETF	42.67	42.8	42.6	42.6	23200.0
2001-11-01 10:00:00	IWM	ETF	42.695	42.745	42.25	42.74	174800.0
2001-11-01 11:00:00	IWM	ETF	42.75	42.9	42.73	42.75	81600.0
2001-11-01 12:00:00	IWM	ETF	42.815	42.9	42.8	42.84	256600.0
2001-11-01 13:00:00	IWM	ETF	42.85	43.175	42.85	43.05	111600.0
2001-11-01 14:00:00	IWM	ETF	43.03	43.1	42.925	42.955	70000.0
2001-11-01 15:00:00	IWM	ETF	42.94	43.3	42.8	43.3	68200.0
2001-11-01 16:00:00	IWM	ETF	42.575	42.575	42.575	42.575	3600.0
2001-11-01 09:00:00	DIA	ETF	91.15	91.34	90.66	90.93	555000.0
2001-11-01 10:00:00	DIA	ETF	91.04	91.65	90.15	91.61	1069700.0
2001-11-01 11:00:00	DIA	ETF	91.62	91.76	91.25	91.5	408700.0
2001-11-01 12:00:00	DIA	ETF	91.53	92.08	91.45	91.95	239200.0
2001-11-01 13:00:00	DIA	ETF	91.97	92.78	91.97	92.54	596400.0
2001-11-01 14:00:00	DIA	ETF	92.52	92.8	92.2	92.22	347000.0
2001-11-01 15:00:00	DIA	ETF	92.24	92.99	92.2	92.69	648100.0
2001-11-01 16:00:00	DIA	ETF	92.69	92.69	92.46	92.5	58100.0
2001-11-01 17:00:00	DIA	ETF	92.31	92.31	92.31	92.31	100.0
2001-11-01 18:00:00	DIA	ETF	92.48	92.48	92.48	92.48	100.0

> showing 37 of 259 rows — these rows as CSV

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