PREVIEW / etf_1hour / 2005-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-27.parquet
  size:    28 KB
  rows:    819

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
2005-01-27 08:00:00	SPY	ETF	117.36	117.36	117.15	117.15	290800.0
2005-01-27 09:00:00	SPY	ETF	117.18	117.37	117.02	117.33	7183900.0
2005-01-27 10:00:00	SPY	ETF	117.33	117.6	117.19	117.58	10999700.0
2005-01-27 11:00:00	SPY	ETF	117.57	117.75	117.55	117.65	4816300.0
2005-01-27 12:00:00	SPY	ETF	117.65	117.68	117.53	117.54	3878200.0
2005-01-27 13:00:00	SPY	ETF	117.53	117.6	117.07	117.14	7000900.0
2005-01-27 14:00:00	SPY	ETF	117.13	117.7	117.07	117.14	5385700.0
2005-01-27 15:00:00	SPY	ETF	117.14	117.58	116.98	117.46	10613000.0
2005-01-27 16:00:00	SPY	ETF	117.47	117.69	117.35	117.6	2874300.0
2005-01-27 17:00:00	SPY	ETF	117.6	117.68	117.56	117.68	338500.0
2005-01-27 18:00:00	SPY	ETF	117.67	117.71	117.63	117.65	18000.0
2005-01-27 19:00:00	SPY	ETF	117.65	117.66	117.51	117.55	52800.0
2005-01-27 09:00:00	QQQ	ETF	37.08	37.08	36.9	36.99	15661000.0
2005-01-27 10:00:00	QQQ	ETF	36.99	37.09	36.87	37.05	17005800.0
2005-01-27 11:00:00	QQQ	ETF	37.06	37.27	37.05	37.21	12910100.0
2005-01-27 12:00:00	QQQ	ETF	37.21	37.22	37.11	37.12	6656400.0
2005-01-27 13:00:00	QQQ	ETF	37.12	37.13	36.9	36.98	11402300.0
2005-01-27 14:00:00	QQQ	ETF	36.97	37.02	36.93	36.95	6144400.0
2005-01-27 15:00:00	QQQ	ETF	36.94	37.2	36.9	37.11	16204200.0
2005-01-27 08:00:00	IWM	ETF	61.31	61.365	61.25	61.25	14400.0
2005-01-27 09:00:00	IWM	ETF	61.16	61.38	61.075	61.355	2637600.0
2005-01-27 10:00:00	IWM	ETF	61.36	61.725	61.295	61.66	5081800.0
2005-01-27 11:00:00	IWM	ETF	61.66	61.865	61.66	61.8	2247800.0
2005-01-27 12:00:00	IWM	ETF	61.8099	61.8099	61.585	61.665	1181800.0
2005-01-27 13:00:00	IWM	ETF	61.665	61.705	61.325	61.37	2602800.0
2005-01-27 14:00:00	IWM	ETF	61.36	61.5	61.19	61.28	1875400.0
2005-01-27 15:00:00	IWM	ETF	61.255	61.62	61.15	61.49	3134800.0
2005-01-27 16:00:00	IWM	ETF	61.505	61.625	61.45	61.45	2167800.0
2005-01-27 17:00:00	IWM	ETF	61.575	61.625	61.575	61.575	8400.0
2005-01-27 08:00:00	DIA	ETF	104.86	104.86	104.59	104.59	37300.0
2005-01-27 09:00:00	DIA	ETF	104.59	104.63	104.31	104.48	1309300.0
2005-01-27 10:00:00	DIA	ETF	104.47	104.76	104.37	104.7	1940300.0
2005-01-27 11:00:00	DIA	ETF	104.7	104.83	104.68	104.7	1118300.0
2005-01-27 12:00:00	DIA	ETF	104.69	104.72	104.55	104.62	439000.0
2005-01-27 13:00:00	DIA	ETF	104.61	104.65	104.22	104.29	1453500.0
2005-01-27 14:00:00	DIA	ETF	104.28	104.45	104.25	104.3	913500.0
2005-01-27 15:00:00	DIA	ETF	104.27	104.73	104.21	104.62	1130200.0
2005-01-27 16:00:00	DIA	ETF	104.64	104.82	104.55	104.58	48900.0
2005-01-27 17:00:00	DIA	ETF	104.8	104.83	104.72	104.72	1400.0
2005-01-27 18:00:00	DIA	ETF	104.85	104.85	104.85	104.85	100.0
2005-01-27 19:00:00	DIA	ETF	104.85	104.85	104.85	104.85	100.0
2005-01-27 09:00:00	GLD	ETF	42.48	42.51	42.45	42.47	85400.0
2005-01-27 10:00:00	GLD	ETF	42.47	42.53	42.4	42.49	112900.0
2005-01-27 11:00:00	GLD	ETF	42.48	42.56	42.47	42.55	91000.0
2005-01-27 12:00:00	GLD	ETF	42.55	42.64	42.52	42.54	87900.0
2005-01-27 13:00:00	GLD	ETF	42.561	42.64	42.55	42.6	78300.0
2005-01-27 14:00:00	GLD	ETF	42.6	42.65	42.58	42.64	47900.0
2005-01-27 15:00:00	GLD	ETF	42.64	42.64	42.61	42.62	50900.0
2005-01-27 08:00:00	TLT	ETF	90.54	90.54	90.28	90.28	17400.0
2005-01-27 09:00:00	TLT	ETF	90.52	90.55	90.34	90.47	200600.0

> showing 50 of 819 rows — these rows as CSV

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