PREVIEW / etf_1hour / 2005-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-20.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-05-20 07:00:00	SPY	ETF	119.15	119.18	119.08	119.08	49500.0
2005-05-20 08:00:00	SPY	ETF	119.1	119.14	119.06	119.14	36300.0
2005-05-20 09:00:00	SPY	ETF	119.17	119.42	118.93	119.1	7088900.0
2005-05-20 10:00:00	SPY	ETF	119.1	119.19	118.9	119.06	7855700.0
2005-05-20 11:00:00	SPY	ETF	119.05	119.11	118.74	118.97	9336600.0
2005-05-20 12:00:00	SPY	ETF	118.96	119.14	118.85	119.1	3773600.0
2005-05-20 13:00:00	SPY	ETF	119.1	119.24	118.9	119.11	3894600.0
2005-05-20 14:00:00	SPY	ETF	119.12	119.34	119.11	119.15	3977000.0
2005-05-20 15:00:00	SPY	ETF	119.14	119.29	119.03	119.15	7957000.0
2005-05-20 16:00:00	SPY	ETF	119.14	119.28	119.1	119.19	627800.0
2005-05-20 17:00:00	SPY	ETF	119.2	119.33	119.17	119.17	22900.0
2005-05-20 09:00:00	QQQ	ETF	37.45	37.48	37.35	37.41	9334300.0
2005-05-20 10:00:00	QQQ	ETF	37.41	37.59	37.4	37.55	12868300.0
2005-05-20 11:00:00	QQQ	ETF	37.55	37.56	37.46	37.55	8212800.0
2005-05-20 12:00:00	QQQ	ETF	37.56	37.6	35.56	37.57	6091100.0
2005-05-20 13:00:00	QQQ	ETF	37.56	37.61	37.47	37.55	5872700.0
2005-05-20 14:00:00	QQQ	ETF	37.55	37.69	37.55	37.65	9964900.0
2005-05-20 15:00:00	QQQ	ETF	37.65	37.67	37.6	37.66	8901200.0
2005-05-20 07:00:00	IWM	ETF	60.545	60.545	60.545	60.545	200.0
2005-05-20 09:00:00	IWM	ETF	60.65	60.72	60.32	60.445	2508000.0
2005-05-20 10:00:00	IWM	ETF	60.36	60.52	60.3	60.335	5165000.0
2005-05-20 11:00:00	IWM	ETF	60.315	60.355	60.185	60.315	1892800.0
2005-05-20 12:00:00	IWM	ETF	60.315	60.56	60.26	60.535	2078400.0
2005-05-20 13:00:00	IWM	ETF	60.54	60.575	60.43	60.515	3307600.0
2005-05-20 14:00:00	IWM	ETF	60.52	60.72	60.52	60.6	2711200.0
2005-05-20 15:00:00	IWM	ETF	60.6	60.66	60.525	60.565	4188400.0
2005-05-20 16:00:00	IWM	ETF	60.545	60.65	60.505	60.55	698800.0
2005-05-20 17:00:00	IWM	ETF	60.575	60.575	60.575	60.575	200.0
2005-05-20 08:00:00	DIA	ETF	104.63	104.66	104.6	104.65	4200.0
2005-05-20 09:00:00	DIA	ETF	104.69	104.85	104.43	104.6	931900.0
2005-05-20 10:00:00	DIA	ETF	104.59	104.66	104.38	104.44	1078000.0
2005-05-20 11:00:00	DIA	ETF	104.46	104.48	104.12	104.36	1110800.0
2005-05-20 12:00:00	DIA	ETF	104.36	104.6	104.32	104.55	330700.0
2005-05-20 13:00:00	DIA	ETF	104.57	104.69	104.4	104.59	991400.0
2005-05-20 14:00:00	DIA	ETF	104.6	104.82	104.59	104.63	851700.0
2005-05-20 15:00:00	DIA	ETF	104.64	104.75	104.51	104.64	549100.0
2005-05-20 16:00:00	DIA	ETF	104.64	104.71	104.59	104.71	50100.0
2005-05-20 17:00:00	DIA	ETF	104.71	104.75	104.7	104.7	5200.0
2005-05-20 18:00:00	DIA	ETF	104.69	104.7	104.69	104.7	200.0
2005-05-20 08:00:00	GLD	ETF	41.89	41.89	41.89	41.89	200.0
2005-05-20 09:00:00	GLD	ETF	41.82	41.84	41.76	41.77	201700.0
2005-05-20 10:00:00	GLD	ETF	41.79	41.79	41.61	41.65	198800.0
2005-05-20 11:00:00	GLD	ETF	41.66	41.69	41.62	41.66	98300.0
2005-05-20 12:00:00	GLD	ETF	41.66	41.69	41.65	41.66	29700.0
2005-05-20 13:00:00	GLD	ETF	41.65	41.73	41.64	41.71	39500.0
2005-05-20 14:00:00	GLD	ETF	41.71	41.71	41.67	41.71	98000.0
2005-05-20 15:00:00	GLD	ETF	41.71	41.71	41.65	41.66	87600.0
2005-05-20 16:00:00	GLD	ETF	41.68	41.68	41.65	41.65	1100.0
2005-05-20 08:00:00	TLT	ETF	93.28	93.28	93.28	93.28	100.0
2005-05-20 09:00:00	TLT	ETF	93.2	93.33	93.2	93.27	73500.0

> showing 50 of 859 rows — these rows as CSV

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