PREVIEW / etf_1hour / 2005-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-09.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-02-09 08:00:00	SPY	ETF	120.33	120.5	120.33	120.42	173600.0
2005-02-09 09:00:00	SPY	ETF	120.43	120.49	120.2	120.3	5108300.0
2005-02-09 10:00:00	SPY	ETF	120.29	120.43	119.59	119.77	14597100.0
2005-02-09 11:00:00	SPY	ETF	119.78	119.83	119.61	119.69	4118700.0
2005-02-09 12:00:00	SPY	ETF	119.69	119.77	119.68	119.73	2554300.0
2005-02-09 13:00:00	SPY	ETF	119.73	119.95	119.72	119.81	5961700.0
2005-02-09 14:00:00	SPY	ETF	119.8	119.88	119.37	119.5	9532500.0
2005-02-09 15:00:00	SPY	ETF	119.5	119.65	119.25	119.3	9524100.0
2005-02-09 16:00:00	SPY	ETF	119.33	119.39	119.28	119.35	987500.0
2005-02-09 17:00:00	SPY	ETF	119.31	120.38	119.31	119.35	19600.0
2005-02-09 18:00:00	SPY	ETF	119.38	119.4	119.35	119.35	8500.0
2005-02-09 19:00:00	SPY	ETF	119.35	119.35	119.35	119.35	100.0
2005-02-09 09:00:00	QQQ	ETF	37.77	37.8	37.62	37.67	8541200.0
2005-02-09 10:00:00	QQQ	ETF	37.67	37.72	37.25	37.32	25269700.0
2005-02-09 11:00:00	QQQ	ETF	37.32	37.37	37.28	37.33	7329900.0
2005-02-09 12:00:00	QQQ	ETF	37.34	37.38	37.32	37.35	3326800.0
2005-02-09 13:00:00	QQQ	ETF	37.35	37.42	37.34	37.34	6126800.0
2005-02-09 14:00:00	QQQ	ETF	37.34	37.35	37.15	37.16	13765500.0
2005-02-09 15:00:00	QQQ	ETF	37.16	37.23	37.06	37.11	21045200.0
2005-02-09 08:00:00	IWM	ETF	63.67	63.67	63.67	63.67	4000.0
2005-02-09 09:00:00	IWM	ETF	63.635	63.75	63.41	63.435	1146600.0
2005-02-09 10:00:00	IWM	ETF	63.435	63.49	62.83	62.94	6526800.0
2005-02-09 11:00:00	IWM	ETF	62.95	63.025	62.885	62.925	2113000.0
2005-02-09 12:00:00	IWM	ETF	62.925	63.025	62.905	62.935	2082200.0
2005-02-09 13:00:00	IWM	ETF	62.94	63.015	62.875	62.915	1837200.0
2005-02-09 14:00:00	IWM	ETF	62.915	62.92	62.66	62.74	4423000.0
2005-02-09 15:00:00	IWM	ETF	62.735	62.75	62.175	62.32	7230200.0
2005-02-09 16:00:00	IWM	ETF	62.35	62.385	62.175	62.21	1174400.0
2005-02-09 17:00:00	IWM	ETF	62.21	62.21	62.21	62.21	1800.0
2005-02-09 18:00:00	IWM	ETF	62.2	62.2	62.2	62.2	2000.0
2005-02-09 19:00:00	IWM	ETF	62.25	62.25	62.25	62.25	400.0
2005-02-09 08:00:00	DIA	ETF	107.41	107.51	107.41	107.48	700.0
2005-02-09 09:00:00	DIA	ETF	107.44	107.48	107.25	107.32	369100.0
2005-02-09 10:00:00	DIA	ETF	107.33	107.43	106.76	106.92	1814800.0
2005-02-09 11:00:00	DIA	ETF	106.93	106.96	106.83	106.91	542200.0
2005-02-09 12:00:00	DIA	ETF	106.91	106.94	106.88	106.92	628200.0
2005-02-09 13:00:00	DIA	ETF	106.93	107.11	106.9	107.01	511500.0
2005-02-09 14:00:00	DIA	ETF	107.02	107.02	106.72	106.82	710300.0
2005-02-09 15:00:00	DIA	ETF	106.82	106.95	106.63	106.69	2145700.0
2005-02-09 16:00:00	DIA	ETF	106.68	106.75	106.68	106.74	708300.0
2005-02-09 17:00:00	DIA	ETF	106.85	106.85	106.72	106.72	700.0
2005-02-09 18:00:00	DIA	ETF	106.69	106.69	106.69	106.69	300.0
2005-02-09 09:00:00	GLD	ETF	41.03	41.12	41.02	41.11	296800.0
2005-02-09 10:00:00	GLD	ETF	41.11	41.19	41.1	41.17	375700.0
2005-02-09 11:00:00	GLD	ETF	41.19	41.27	41.16	41.22	218300.0
2005-02-09 12:00:00	GLD	ETF	41.22	41.26	41.2	41.23	109300.0
2005-02-09 13:00:00	GLD	ETF	41.23	41.35	41.22	41.3	663300.0
2005-02-09 14:00:00	GLD	ETF	41.28	41.31	41.23	41.28	842000.0
2005-02-09 15:00:00	GLD	ETF	41.27	41.36	41.27	41.34	683100.0
2005-02-09 16:00:00	GLD	ETF	41.32	41.32	41.29	41.29	900.0

> showing 50 of 828 rows — these rows as CSV

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