PREVIEW / etf_1hour / 2005-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-18.parquet
  size:    28 KB
  rows:    807

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-18 08:00:00	SPY	ETF	118.11	118.15	118.06	118.12	60400.0
2005-01-18 09:00:00	SPY	ETF	118.12	118.16	117.95	118.1	6721900.0
2005-01-18 10:00:00	SPY	ETF	118.1	119.05	118.03	118.93	12834800.0
2005-01-18 11:00:00	SPY	ETF	118.93	119.3	118.83	119.15	8284200.0
2005-01-18 12:00:00	SPY	ETF	119.16	119.35	119.14	119.22	3835700.0
2005-01-18 13:00:00	SPY	ETF	119.23	119.43	119.15	119.33	3735100.0
2005-01-18 14:00:00	SPY	ETF	119.33	119.52	119.2	119.3	4514800.0
2005-01-18 15:00:00	SPY	ETF	119.3	119.6	119.21	119.57	9547100.0
2005-01-18 16:00:00	SPY	ETF	119.54	119.63	119.43	119.5	4158700.0
2005-01-18 17:00:00	SPY	ETF	119.5	119.53	119.45	119.51	42000.0
2005-01-18 18:00:00	SPY	ETF	119.49	119.5	119.49	119.5	7000.0
2005-01-18 19:00:00	SPY	ETF	119.52	119.6	119.48	119.51	14700.0
2005-01-18 09:00:00	QQQ	ETF	38.29	38.34	38.22	38.27	11390800.0
2005-01-18 10:00:00	QQQ	ETF	38.27	38.64	38.23	38.57	21051200.0
2005-01-18 11:00:00	QQQ	ETF	38.57	38.7	38.53	38.65	11832700.0
2005-01-18 12:00:00	QQQ	ETF	38.64	38.75	38.63	38.69	7966600.0
2005-01-18 13:00:00	QQQ	ETF	38.69	38.76	38.63	38.72	5251200.0
2005-01-18 14:00:00	QQQ	ETF	38.72	38.79	38.62	38.67	9158300.0
2005-01-18 15:00:00	QQQ	ETF	38.67	38.78	38.62	38.74	16250700.0
2005-01-18 09:00:00	IWM	ETF	61.295	61.55	61.21	61.52	2735200.0
2005-01-18 10:00:00	IWM	ETF	61.52	62.0	61.385	61.885	4072000.0
2005-01-18 11:00:00	IWM	ETF	61.885	62.085	61.755	62.015	2113600.0
2005-01-18 12:00:00	IWM	ETF	62.02	62.19	62.01	62.065	1281800.0
2005-01-18 13:00:00	IWM	ETF	62.065	62.235	61.925	62.1	1329400.0
2005-01-18 14:00:00	IWM	ETF	62.105	62.255	61.955	62.085	1737600.0
2005-01-18 15:00:00	IWM	ETF	62.085	62.405	62.035	62.32	2937600.0
2005-01-18 16:00:00	IWM	ETF	62.275	62.3	62.125	62.215	547200.0
2005-01-18 17:00:00	IWM	ETF	62.185	62.185	62.185	62.185	9000.0
2005-01-18 08:00:00	DIA	ETF	105.3	105.3	105.24	105.24	3400.0
2005-01-18 09:00:00	DIA	ETF	105.26	105.3	105.0	105.14	536500.0
2005-01-18 10:00:00	DIA	ETF	105.14	105.95	105.01	105.83	1901200.0
2005-01-18 11:00:00	DIA	ETF	105.83	106.11	105.74	106.01	1136400.0
2005-01-18 12:00:00	DIA	ETF	106.01	106.18	105.92	106.0	698400.0
2005-01-18 13:00:00	DIA	ETF	106.0	106.13	105.91	106.06	311000.0
2005-01-18 14:00:00	DIA	ETF	106.051	106.19	105.92	106.02	871500.0
2005-01-18 15:00:00	DIA	ETF	106.02	106.27	105.95	106.21	957600.0
2005-01-18 16:00:00	DIA	ETF	106.22	106.33	106.17	106.26	89000.0
2005-01-18 18:00:00	DIA	ETF	106.17	106.17	106.17	106.17	200.0
2005-01-18 09:00:00	GLD	ETF	42.22	42.23	42.15	42.18	148100.0
2005-01-18 10:00:00	GLD	ETF	42.2	42.31	42.17	42.29	72700.0
2005-01-18 11:00:00	GLD	ETF	42.3	42.38	42.28	42.33	129400.0
2005-01-18 12:00:00	GLD	ETF	42.35	42.37	42.32	42.35	117100.0
2005-01-18 13:00:00	GLD	ETF	42.36	42.36	42.31	42.32	22700.0
2005-01-18 14:00:00	GLD	ETF	42.31	42.33	42.27	42.29	37900.0
2005-01-18 15:00:00	GLD	ETF	42.29	42.37	42.27	42.34	137700.0
2005-01-18 16:00:00	GLD	ETF	42.34	42.35	42.34	42.35	700.0
2005-01-18 08:00:00	TLT	ETF	90.0	90.03	90.0	90.03	10200.0
2005-01-18 09:00:00	TLT	ETF	90.0	90.01	89.78	89.8	111200.0
2005-01-18 10:00:00	TLT	ETF	89.73	89.88	89.73	89.85	281000.0
2005-01-18 11:00:00	TLT	ETF	89.85	89.97	89.85	89.94	56000.0

> showing 50 of 807 rows — these rows as CSV

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