PREVIEW / etf_1hour / 2001-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-12.parquet
  size:    11 KB
  rows:    225

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-03-12 09:00:00	SPY	ETF	122.34	122.5	120.8	121.7	1854700.0
2001-03-12 10:00:00	SPY	ETF	121.84	121.84	120.8	121.02	1163300.0
2001-03-12 11:00:00	SPY	ETF	121.0	121.02	120.31	120.57	1134500.0
2001-03-12 12:00:00	SPY	ETF	120.45	121.02	120.3	120.83	797900.0
2001-03-12 13:00:00	SPY	ETF	121.07	121.4	120.05	120.09	1021500.0
2001-03-12 14:00:00	SPY	ETF	120.17	120.83	119.71	120.04	1113500.0
2001-03-12 15:00:00	SPY	ETF	120.0	120.45	117.75	118.44	4183600.0
2001-03-12 16:00:00	SPY	ETF	118.44	121.0	117.55	118.0	957000.0
2001-03-12 17:00:00	SPY	ETF	119.34	119.34	118.0	118.18	1153000.0
2001-03-12 18:00:00	SPY	ETF	118.43	118.43	118.43	118.43	200.0
2001-03-12 09:00:00	QQQ	ETF	44.0	44.95	43.2	43.83	11719600.0
2001-03-12 10:00:00	QQQ	ETF	43.84	43.9	42.83	42.99	10254900.0
2001-03-12 11:00:00	QQQ	ETF	42.99	43.1	42.28	42.75	10711700.0
2001-03-12 12:00:00	QQQ	ETF	42.66	43.29	42.47	43.28	5606200.0
2001-03-12 13:00:00	QQQ	ETF	43.22	43.81	42.75	42.75	11986800.0
2001-03-12 14:00:00	QQQ	ETF	42.82	43.72	42.68	43.04	9497400.0
2001-03-12 15:00:00	QQQ	ETF	43.0	43.36	41.8	41.95	14604200.0
2001-03-12 16:00:00	QQQ	ETF	41.85	42.5	41.8	42.15	2771600.0
2001-03-12 17:00:00	QQQ	ETF	42.11	42.3	42.0	42.05	73900.0
2001-03-12 18:00:00	QQQ	ETF	42.09	42.1	42.0	42.05	26700.0
2001-03-12 09:00:00	IWM	ETF	46.625	46.625	46.205	46.4	119200.0
2001-03-12 10:00:00	IWM	ETF	46.5	46.55	46.175	46.175	100200.0
2001-03-12 11:00:00	IWM	ETF	46.345	46.395	46.175	46.185	97200.0
2001-03-12 12:00:00	IWM	ETF	46.245	46.29	45.975	46.29	40600.0
2001-03-12 13:00:00	IWM	ETF	46.37	46.6	46.25	46.25	56000.0
2001-03-12 14:00:00	IWM	ETF	46.22	46.255	46.0	46.0	229800.0
2001-03-12 15:00:00	IWM	ETF	46.025	46.075	45.33	45.5	352800.0
2001-03-12 16:00:00	IWM	ETF	45.525	45.625	45.525	45.625	1200.0
2001-03-12 09:00:00	DIA	ETF	105.45	105.52	104.25	104.9	495900.0
2001-03-12 10:00:00	DIA	ETF	104.94	104.94	104.25	104.77	513100.0
2001-03-12 11:00:00	DIA	ETF	104.78	104.79	104.18	104.42	591500.0
2001-03-12 12:00:00	DIA	ETF	104.35	104.8	104.15	104.66	360400.0
2001-03-12 13:00:00	DIA	ETF	104.84	105.05	103.78	103.9	772800.0
2001-03-12 14:00:00	DIA	ETF	103.93	104.4	103.4	103.82	387400.0
2001-03-12 15:00:00	DIA	ETF	103.86	104.1	101.4	102.45	1434800.0
2001-03-12 16:00:00	DIA	ETF	102.35	103.98	101.5	101.5	47200.0
2001-03-12 17:00:00	DIA	ETF	101.75	102.0	101.75	102.0	1500.0
2001-03-12 18:00:00	DIA	ETF	101.65	101.65	101.65	101.65	1500.0

> showing 38 of 225 rows — these rows as CSV

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