PREVIEW / etf_1hour / 2001-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-25.parquet
  size:    11 KB
  rows:    222

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-04-25 09:00:00	SPY	ETF	121.42	121.65	120.95	121.5	1020600.0
2001-04-25 10:00:00	SPY	ETF	121.44	122.26	121.4	121.85	1528200.0
2001-04-25 11:00:00	SPY	ETF	121.78	122.39	121.57	122.02	809400.0
2001-04-25 12:00:00	SPY	ETF	122.0	122.13	121.65	121.75	363700.0
2001-04-25 13:00:00	SPY	ETF	121.71	122.37	121.53	122.3	372700.0
2001-04-25 14:00:00	SPY	ETF	122.34	123.36	122.0	123.2	1301200.0
2001-04-25 15:00:00	SPY	ETF	123.3	123.67	123.02	123.24	2043100.0
2001-04-25 16:00:00	SPY	ETF	123.29	123.3	122.84	122.94	302700.0
2001-04-25 17:00:00	SPY	ETF	123.0	123.0	122.67	122.8	4600.0
2001-04-25 18:00:00	SPY	ETF	122.82	122.82	122.82	122.82	500.0
2001-04-25 09:00:00	QQQ	ETF	43.9	44.33	43.43	43.71	8865700.0
2001-04-25 10:00:00	QQQ	ETF	43.7	44.72	43.65	44.45	11407300.0
2001-04-25 11:00:00	QQQ	ETF	44.45	44.73	44.15	44.31	6969300.0
2001-04-25 12:00:00	QQQ	ETF	44.29	44.38	43.8	43.83	4526300.0
2001-04-25 13:00:00	QQQ	ETF	43.86	44.49	43.69	44.49	6241800.0
2001-04-25 14:00:00	QQQ	ETF	44.49	45.42	44.24	45.33	13914300.0
2001-04-25 15:00:00	QQQ	ETF	45.31	45.58	45.07	45.2	8363400.0
2001-04-25 16:00:00	QQQ	ETF	45.23	45.4	44.66	44.8	1945400.0
2001-04-25 17:00:00	QQQ	ETF	44.84	45.3	44.45	44.68	678500.0
2001-04-25 18:00:00	QQQ	ETF	44.7	44.8	44.66	44.75	83100.0
2001-04-25 09:00:00	IWM	ETF	46.25	46.25	45.955	46.195	27400.0
2001-04-25 10:00:00	IWM	ETF	46.145	46.7	46.145	46.6	133400.0
2001-04-25 11:00:00	IWM	ETF	46.75	46.85	46.7	46.85	65600.0
2001-04-25 12:00:00	IWM	ETF	46.8	46.8	46.61	46.725	6200.0
2001-04-25 13:00:00	IWM	ETF	46.61	46.825	46.61	46.8	18800.0
2001-04-25 14:00:00	IWM	ETF	46.8	47.025	46.7	47.0	10400.0
2001-04-25 15:00:00	IWM	ETF	46.995	47.2	46.995	47.09	108600.0
2001-04-25 16:00:00	IWM	ETF	47.05	47.175	47.05	47.15	11800.0
2001-04-25 09:00:00	DIA	ETF	105.1	105.1	104.45	104.91	503300.0
2001-04-25 10:00:00	DIA	ETF	104.95	105.45	104.87	105.01	363600.0
2001-04-25 11:00:00	DIA	ETF	105.0	105.4	104.89	105.11	123700.0
2001-04-25 12:00:00	DIA	ETF	105.23	105.23	104.85	104.88	52500.0
2001-04-25 13:00:00	DIA	ETF	104.81	105.4	104.74	105.25	92300.0
2001-04-25 14:00:00	DIA	ETF	105.3	106.3	105.11	106.06	621500.0
2001-04-25 15:00:00	DIA	ETF	106.01	106.54	106.01	106.36	363200.0
2001-04-25 16:00:00	DIA	ETF	106.39	106.5	106.3	106.3	42400.0

> showing 36 of 222 rows — these rows as CSV

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