PREVIEW / etf_1hour / 2005-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-17.parquet
  size:    29 KB
  rows:    859

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-03-17 08:00:00	SPY	ETF	119.08	119.3	119.08	119.28	145100.0
2005-03-17 09:00:00	SPY	ETF	119.29	119.41	119.04	119.07	8840500.0
2005-03-17 10:00:00	SPY	ETF	119.07	119.55	118.98	119.52	13449900.0
2005-03-17 11:00:00	SPY	ETF	119.52	119.65	119.42	119.54	6501500.0
2005-03-17 12:00:00	SPY	ETF	119.54	119.74	119.38	119.53	8274600.0
2005-03-17 13:00:00	SPY	ETF	119.52	119.6	119.32	119.34	4947900.0
2005-03-17 14:00:00	SPY	ETF	119.36	119.61	119.17	119.58	10224500.0
2005-03-17 15:00:00	SPY	ETF	119.59	119.71	119.38	119.43	8855100.0
2005-03-17 16:00:00	SPY	ETF	119.4	119.44	119.25	119.36	273900.0
2005-03-17 17:00:00	SPY	ETF	119.33	119.36	119.32	119.35	146600.0
2005-03-17 18:00:00	SPY	ETF	119.35	119.42	119.33	119.38	135900.0
2005-03-17 19:00:00	SPY	ETF	119.41	119.51	119.41	119.51	14100.0
2005-03-17 09:00:00	QQQ	ETF	36.63	36.7	36.55	36.58	21082700.0
2005-03-17 10:00:00	QQQ	ETF	36.58	36.83	36.54	36.82	18634600.0
2005-03-17 11:00:00	QQQ	ETF	36.81	36.89	36.78	36.84	11047700.0
2005-03-17 12:00:00	QQQ	ETF	36.85	36.89	36.77	36.79	8397700.0
2005-03-17 13:00:00	QQQ	ETF	36.8	36.81	36.68	36.71	7098700.0
2005-03-17 14:00:00	QQQ	ETF	36.71	36.85	36.63	36.84	11043800.0
2005-03-17 15:00:00	QQQ	ETF	36.84	36.88	36.68	36.69	13762700.0
2005-03-17 08:00:00	IWM	ETF	62.18	62.26	62.18	62.25	5600.0
2005-03-17 09:00:00	IWM	ETF	62.25	62.29	61.945	61.955	2607200.0
2005-03-17 10:00:00	IWM	ETF	61.96	62.425	61.92	62.405	3512600.0
2005-03-17 11:00:00	IWM	ETF	62.41	62.45	62.275	62.32	4294600.0
2005-03-17 12:00:00	IWM	ETF	62.315	62.4	62.23	62.33	995400.0
2005-03-17 13:00:00	IWM	ETF	62.33	62.33	62.1	62.165	2050000.0
2005-03-17 14:00:00	IWM	ETF	62.15	62.415	62.1	62.4	1874400.0
2005-03-17 15:00:00	IWM	ETF	62.385	62.62	62.335	62.365	3430000.0
2005-03-17 16:00:00	IWM	ETF	62.34	62.405	62.2	62.225	574600.0
2005-03-17 08:00:00	DIA	ETF	106.35	106.46	106.35	106.45	5300.0
2005-03-17 09:00:00	DIA	ETF	106.44	106.61	106.13	106.16	547100.0
2005-03-17 10:00:00	DIA	ETF	106.16	106.57	106.04	106.52	826800.0
2005-03-17 11:00:00	DIA	ETF	106.52	106.62	106.46	106.48	593000.0
2005-03-17 12:00:00	DIA	ETF	106.49	106.68	106.36	106.5	435700.0
2005-03-17 13:00:00	DIA	ETF	106.51	106.53	106.29	106.36	328400.0
2005-03-17 14:00:00	DIA	ETF	106.33	106.56	106.19	106.48	496200.0
2005-03-17 15:00:00	DIA	ETF	106.47	106.6	106.3	106.35	1179200.0
2005-03-17 16:00:00	DIA	ETF	106.35	106.35	106.27	106.29	28800.0
2005-03-17 17:00:00	DIA	ETF	106.35	106.35	106.35	106.35	100.0
2005-03-17 08:00:00	GLD	ETF	43.94	43.94	43.94	43.94	1000.0
2005-03-17 09:00:00	GLD	ETF	43.97	43.97	43.674	43.79	691900.0
2005-03-17 10:00:00	GLD	ETF	43.78	43.9	43.76	43.85	178700.0
2005-03-17 11:00:00	GLD	ETF	43.86	43.86	43.77	43.8	164500.0
2005-03-17 12:00:00	GLD	ETF	43.8	43.92	43.77	43.79	99200.0
2005-03-17 13:00:00	GLD	ETF	43.8	43.86	43.76	43.84	86500.0
2005-03-17 14:00:00	GLD	ETF	43.84	43.85	43.79	43.84	37000.0
2005-03-17 15:00:00	GLD	ETF	43.84	43.86	43.8	43.81	266100.0
2005-03-17 08:00:00	TLT	ETF	89.23	89.23	89.15	89.15	41000.0
2005-03-17 09:00:00	TLT	ETF	89.14	89.48	89.14	89.48	150700.0
2005-03-17 10:00:00	TLT	ETF	89.48	89.48	89.12	89.24	112500.0
2005-03-17 11:00:00	TLT	ETF	89.21	89.26	89.12	89.26	137800.0

> showing 50 of 859 rows — these rows as CSV

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