PREVIEW / etf_1hour / 2005-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-06.parquet
  size:    29 KB
  rows:    828

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-06 08:00:00	SPY	ETF	118.49	118.49	118.35	118.43	297400.0
2005-01-06 09:00:00	SPY	ETF	118.44	118.69	118.39	118.54	5316500.0
2005-01-06 10:00:00	SPY	ETF	118.55	118.7	118.26	118.35	9307000.0
2005-01-06 11:00:00	SPY	ETF	118.34	118.98	118.3	118.74	8963300.0
2005-01-06 12:00:00	SPY	ETF	118.75	118.87	118.6	118.61	2722400.0
2005-01-06 13:00:00	SPY	ETF	118.62	119.14	118.55	119.08	5717400.0
2005-01-06 14:00:00	SPY	ETF	119.08	119.15	118.8	118.8	4988000.0
2005-01-06 15:00:00	SPY	ETF	118.83	118.91	118.59	118.71	8215800.0
2005-01-06 16:00:00	SPY	ETF	118.73	118.79	118.58	118.65	1414700.0
2005-01-06 17:00:00	SPY	ETF	118.64	118.7	118.6	118.63	27800.0
2005-01-06 18:00:00	SPY	ETF	118.66	118.73	118.63	118.73	459700.0
2005-01-06 19:00:00	SPY	ETF	118.62	118.62	118.61	118.61	9200.0
2005-01-06 09:00:00	QQQ	ETF	38.62	38.71	38.54	38.63	15092100.0
2005-01-06 10:00:00	QQQ	ETF	38.64	38.67	38.38	38.43	19818700.0
2005-01-06 11:00:00	QQQ	ETF	38.43	38.7	38.39	38.56	15806100.0
2005-01-06 12:00:00	QQQ	ETF	38.57	38.6	38.49	38.5	6832700.0
2005-01-06 13:00:00	QQQ	ETF	38.5	38.7	38.44	38.66	10377500.0
2005-01-06 14:00:00	QQQ	ETF	38.65	38.67	38.5	38.51	7582800.0
2005-01-06 15:00:00	QQQ	ETF	38.51	38.55	38.35	38.35	16517300.0
2005-01-06 08:00:00	IWM	ETF	61.605	61.85	61.565	61.695	71400.0
2005-01-06 09:00:00	IWM	ETF	61.675	61.9	61.225	61.735	4913000.0
2005-01-06 10:00:00	IWM	ETF	61.74	61.875	61.425	61.455	4048000.0
2005-01-06 11:00:00	IWM	ETF	61.445	62.0	61.34	61.86	4667800.0
2005-01-06 12:00:00	IWM	ETF	61.87	61.92	61.725	61.725	1247600.0
2005-01-06 13:00:00	IWM	ETF	61.735	62.2	61.66	62.06	2216000.0
2005-01-06 14:00:00	IWM	ETF	62.065	62.1	61.865	61.875	1604000.0
2005-01-06 15:00:00	IWM	ETF	61.87	61.985	61.665	61.69	3103400.0
2005-01-06 16:00:00	IWM	ETF	61.73	61.745	61.495	61.495	898600.0
2005-01-06 17:00:00	IWM	ETF	61.6475	61.6475	61.57	61.57	104000.0
2005-01-06 18:00:00	IWM	ETF	61.585	61.585	61.585	61.585	600.0
2005-01-06 08:00:00	DIA	ETF	106.07	106.09	106.03	106.09	31700.0
2005-01-06 09:00:00	DIA	ETF	106.12	106.28	106.09	106.16	965600.0
2005-01-06 10:00:00	DIA	ETF	106.14	106.24	105.83	105.93	1670100.0
2005-01-06 11:00:00	DIA	ETF	105.92	106.52	105.85	106.38	1584000.0
2005-01-06 12:00:00	DIA	ETF	106.39	106.47	106.2	106.21	584100.0
2005-01-06 13:00:00	DIA	ETF	106.21	106.66	106.16	106.55	1321900.0
2005-01-06 14:00:00	DIA	ETF	106.56	106.61	106.32	106.34	781300.0
2005-01-06 15:00:00	DIA	ETF	106.34	106.39	106.07	106.19	1129300.0
2005-01-06 16:00:00	DIA	ETF	106.19	106.24	106.06	106.13	23200.0
2005-01-06 17:00:00	DIA	ETF	106.05	106.15	106.04	106.15	140900.0
2005-01-06 18:00:00	DIA	ETF	106.15	106.15	106.15	106.15	190000.0
2005-01-06 09:00:00	GLD	ETF	42.48	42.56	42.47	42.47	248200.0
2005-01-06 10:00:00	GLD	ETF	42.49	42.51	42.18	42.26	743200.0
2005-01-06 11:00:00	GLD	ETF	42.26	42.35	42.22	42.26	354600.0
2005-01-06 12:00:00	GLD	ETF	42.26	42.27	42.07	42.18	315900.0
2005-01-06 13:00:00	GLD	ETF	42.2	42.2	42.08	42.18	426900.0
2005-01-06 14:00:00	GLD	ETF	42.18	42.23	42.15	42.18	176700.0
2005-01-06 15:00:00	GLD	ETF	42.17	42.19	42.14	42.18	180600.0
2005-01-06 08:00:00	TLT	ETF	88.29	88.39	88.29	88.37	4500.0
2005-01-06 09:00:00	TLT	ETF	88.19	88.32	88.19	88.27	79400.0

> showing 50 of 828 rows — these rows as CSV

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