PREVIEW / etf_1hour / 2005-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-12.parquet
  size:    29 KB
  rows:    814

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-12 08:00:00	SPY	ETF	118.49	118.6	118.37	118.38	178400.0
2005-01-12 09:00:00	SPY	ETF	118.38	118.45	117.91	117.98	9645200.0
2005-01-12 10:00:00	SPY	ETF	117.98	118.33	117.52	117.69	16756300.0
2005-01-12 11:00:00	SPY	ETF	117.68	118.41	117.63	118.27	11824700.0
2005-01-12 12:00:00	SPY	ETF	118.27	118.46	118.13	118.17	6647800.0
2005-01-12 13:00:00	SPY	ETF	118.16	118.39	117.9	118.03	4984400.0
2005-01-12 14:00:00	SPY	ETF	118.03	118.35	117.97	118.24	5660400.0
2005-01-12 15:00:00	SPY	ETF	118.24	118.84	118.15	118.8	12656600.0
2005-01-12 16:00:00	SPY	ETF	118.77	118.87	118.53	118.79	2524400.0
2005-01-12 17:00:00	SPY	ETF	118.81	118.85	118.57	118.79	1695900.0
2005-01-12 18:00:00	SPY	ETF	118.78	118.81	118.75	118.75	19000.0
2005-01-12 09:00:00	QQQ	ETF	38.43	38.5	38.2	38.27	20428200.0
2005-01-12 10:00:00	QQQ	ETF	38.27	38.45	38.01	38.07	26793000.0
2005-01-12 11:00:00	QQQ	ETF	38.07	38.38	38.02	38.31	18449300.0
2005-01-12 12:00:00	QQQ	ETF	38.31	38.4	38.15	38.26	10601700.0
2005-01-12 13:00:00	QQQ	ETF	38.25	38.4	38.15	38.19	8145200.0
2005-01-12 14:00:00	QQQ	ETF	38.19	38.34	38.17	38.29	8517700.0
2005-01-12 15:00:00	QQQ	ETF	38.29	38.6	38.25	38.58	21235800.0
2005-01-12 08:00:00	IWM	ETF	61.04	61.04	60.935	60.935	29400.0
2005-01-12 09:00:00	IWM	ETF	60.915	61.06	60.53	60.53	3411200.0
2005-01-12 10:00:00	IWM	ETF	60.53	60.755	60.13	60.21	4104000.0
2005-01-12 11:00:00	IWM	ETF	60.205	60.71	60.165	60.605	3988800.0
2005-01-12 12:00:00	IWM	ETF	60.6	60.735	60.485	60.54	3349600.0
2005-01-12 13:00:00	IWM	ETF	60.525	60.61	60.33	60.395	1988400.0
2005-01-12 14:00:00	IWM	ETF	60.38	60.625	60.375	60.525	2222800.0
2005-01-12 15:00:00	IWM	ETF	60.525	61.25	60.495	61.17	4710400.0
2005-01-12 16:00:00	IWM	ETF	61.14	61.225	61.0	61.175	498000.0
2005-01-12 17:00:00	IWM	ETF	61.16	61.17	61.12	61.12	12400.0
2005-01-12 19:00:00	IWM	ETF	61.175	61.175	61.175	61.175	2000.0
2005-01-12 08:00:00	DIA	ETF	105.79	105.8	105.6	105.6	11300.0
2005-01-12 09:00:00	DIA	ETF	105.58	105.7	105.25	105.29	1156700.0
2005-01-12 10:00:00	DIA	ETF	105.29	105.57	104.96	105.09	1631000.0
2005-01-12 11:00:00	DIA	ETF	105.1	105.77	105.05	105.68	1840100.0
2005-01-12 12:00:00	DIA	ETF	105.69	105.88	105.54	105.64	1082600.0
2005-01-12 13:00:00	DIA	ETF	105.64	105.75	105.34	105.48	1240500.0
2005-01-12 14:00:00	DIA	ETF	105.48	105.75	105.42	105.57	983500.0
2005-01-12 15:00:00	DIA	ETF	105.6	106.23	105.51	106.2	2346000.0
2005-01-12 16:00:00	DIA	ETF	106.18	106.23	105.5966	106.21	119100.0
2005-01-12 17:00:00	DIA	ETF	106.2	106.27	106.13	106.13	700.0
2005-01-12 18:00:00	DIA	ETF	106.15	106.27	106.15	106.27	400.0
2005-01-12 09:00:00	GLD	ETF	42.52	42.72	42.48	42.72	473700.0
2005-01-12 10:00:00	GLD	ETF	42.71	42.79	42.62	42.71	513200.0
2005-01-12 11:00:00	GLD	ETF	42.71	42.71	42.61	42.64	162700.0
2005-01-12 12:00:00	GLD	ETF	42.64	42.65	42.55	42.63	78400.0
2005-01-12 13:00:00	GLD	ETF	42.63	42.67	42.58	42.6	339600.0
2005-01-12 14:00:00	GLD	ETF	42.62	42.67	42.6	42.63	80200.0
2005-01-12 15:00:00	GLD	ETF	42.64	42.64	42.58	42.62	79800.0
2005-01-12 16:00:00	GLD	ETF	42.59	42.59	42.58	42.58	8100.0
2005-01-12 08:00:00	TLT	ETF	89.05	89.05	89.05	89.05	1000.0
2005-01-12 09:00:00	TLT	ETF	88.9	88.92	88.8	88.915	117700.0

> showing 50 of 814 rows — these rows as CSV

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