PREVIEW / etf_1hour / 2001-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-21.parquet
  size:    11 KB
  rows:    229

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-06-21 09:00:00	SPY	ETF	122.22	122.8	122.15	122.47	2092200.0
2001-06-21 10:00:00	SPY	ETF	122.51	123.44	122.46	122.85	2009700.0
2001-06-21 11:00:00	SPY	ETF	122.91	123.39	122.51	123.32	878500.0
2001-06-21 12:00:00	SPY	ETF	123.31	123.85	123.09	123.85	1279700.0
2001-06-21 13:00:00	SPY	ETF	123.8	124.3	123.57	124.22	1391300.0
2001-06-21 14:00:00	SPY	ETF	124.31	124.31	123.86	123.96	1236100.0
2001-06-21 15:00:00	SPY	ETF	124.05	124.28	123.65	123.88	2264000.0
2001-06-21 16:00:00	SPY	ETF	123.86	124.04	123.51	123.9	726200.0
2001-06-21 17:00:00	SPY	ETF	123.61	123.61	123.52	123.55	6700.0
2001-06-21 09:00:00	QQQ	ETF	42.67	43.1	42.3	42.57	9690300.0
2001-06-21 10:00:00	QQQ	ETF	42.54	43.17	42.51	42.68	10751000.0
2001-06-21 11:00:00	QQQ	ETF	42.72	43.3	42.49	43.26	5967800.0
2001-06-21 12:00:00	QQQ	ETF	43.23	43.53	43.01	43.49	5637900.0
2001-06-21 13:00:00	QQQ	ETF	43.52	44.08	43.3	44.01	10637100.0
2001-06-21 14:00:00	QQQ	ETF	44.0	44.07	43.7	43.88	9143700.0
2001-06-21 15:00:00	QQQ	ETF	43.88	44.23	43.37	43.65	10736500.0
2001-06-21 16:00:00	QQQ	ETF	43.66	43.72	43.25	43.26	2650200.0
2001-06-21 17:00:00	QQQ	ETF	43.32	43.5	43.2	43.21	323200.0
2001-06-21 18:00:00	QQQ	ETF	43.28	43.32	43.17	43.29	12100.0
2001-06-21 09:00:00	IWM	ETF	49.325	49.7	49.325	49.445	68400.0
2001-06-21 10:00:00	IWM	ETF	49.45	49.69	49.4	49.415	75800.0
2001-06-21 11:00:00	IWM	ETF	49.425	49.425	49.275	49.3	88600.0
2001-06-21 12:00:00	IWM	ETF	49.425	49.51	49.375	49.5	86600.0
2001-06-21 13:00:00	IWM	ETF	49.55	49.75	49.505	49.74	183800.0
2001-06-21 14:00:00	IWM	ETF	49.75	49.75	49.605	49.63	47000.0
2001-06-21 15:00:00	IWM	ETF	49.625	49.8	49.4	49.605	147400.0
2001-06-21 16:00:00	IWM	ETF	49.6	49.655	49.495	49.495	20400.0
2001-06-21 09:00:00	DIA	ETF	106.35	106.56	106.0	106.3	234400.0
2001-06-21 10:00:00	DIA	ETF	106.17	106.99	106.17	106.52	402700.0
2001-06-21 11:00:00	DIA	ETF	106.5	106.9	106.34	106.9	188100.0
2001-06-21 12:00:00	DIA	ETF	106.85	107.15	106.68	107.15	296600.0
2001-06-21 13:00:00	DIA	ETF	107.15	107.7	106.98	107.58	1698300.0
2001-06-21 14:00:00	DIA	ETF	107.67	107.75	107.34	107.46	347600.0
2001-06-21 15:00:00	DIA	ETF	107.45	107.64	107.11	107.25	380800.0
2001-06-21 16:00:00	DIA	ETF	107.25	107.26	107.0	107.14	78600.0

> showing 35 of 229 rows — these rows as CSV

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