PREVIEW / etf_1hour / 2005-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-05.parquet
  size:    31 KB
  rows:    937

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-08-05 07:00:00	SPY	ETF	123.99	124.0	123.93	123.93	39000.0
2005-08-05 08:00:00	SPY	ETF	123.92	123.98	123.37	123.41	3723800.0
2005-08-05 09:00:00	SPY	ETF	123.43	123.55	123.26	123.27	5707300.0
2005-08-05 10:00:00	SPY	ETF	123.27	123.98	122.92	123.06	10774700.0
2005-08-05 11:00:00	SPY	ETF	123.05	123.46	122.69	122.7	6533900.0
2005-08-05 12:00:00	SPY	ETF	122.69	123.31	122.67	122.82	3545800.0
2005-08-05 13:00:00	SPY	ETF	122.81	123.03	122.78	122.89	4052400.0
2005-08-05 14:00:00	SPY	ETF	122.9	122.92	122.68	122.75	3908700.0
2005-08-05 15:00:00	SPY	ETF	122.74	122.98	122.71	122.77	11661200.0
2005-08-05 16:00:00	SPY	ETF	122.79	122.95	122.7	122.86	739000.0
2005-08-05 17:00:00	SPY	ETF	122.82	122.88	122.81	122.82	5400.0
2005-08-05 18:00:00	SPY	ETF	122.81	122.81	122.75	122.75	7900.0
2005-08-05 19:00:00	SPY	ETF	122.82	122.82	122.82	122.82	1800.0
2005-08-05 09:00:00	QQQ	ETF	39.61	39.79	39.6	39.66	11649000.0
2005-08-05 10:00:00	QQQ	ETF	39.65	39.69	39.45	39.51	14999800.0
2005-08-05 11:00:00	QQQ	ETF	39.51	39.54	39.43	39.45	9428700.0
2005-08-05 12:00:00	QQQ	ETF	39.45	39.55	39.43	39.5	5198400.0
2005-08-05 13:00:00	QQQ	ETF	39.51	39.64	39.49	39.53	6409200.0
2005-08-05 14:00:00	QQQ	ETF	39.53	39.59	39.47	39.5	3899600.0
2005-08-05 15:00:00	QQQ	ETF	39.5	39.6	39.48	39.48	8855600.0
2005-08-05 08:00:00	IWM	ETF	67.0	67.03	66.65	66.65	27100.0
2005-08-05 09:00:00	IWM	ETF	66.69	66.82	66.35	66.36	6413800.0
2005-08-05 10:00:00	IWM	ETF	66.36	66.37	66.05	66.16	8182300.0
2005-08-05 11:00:00	IWM	ETF	66.16	66.2	65.71	65.73	4082500.0
2005-08-05 12:00:00	IWM	ETF	65.73	65.88	65.66	65.82	3900100.0
2005-08-05 13:00:00	IWM	ETF	65.8	65.98	65.8	65.84	2679000.0
2005-08-05 14:00:00	IWM	ETF	65.84	66.01	65.74	65.84	2753400.0
2005-08-05 15:00:00	IWM	ETF	65.84	66.03	65.82	65.97	4053700.0
2005-08-05 16:00:00	IWM	ETF	65.98	66.01	65.94	65.99	504900.0
2005-08-05 17:00:00	IWM	ETF	66.0	66.0	66.0	66.0	500.0
2005-08-05 19:00:00	IWM	ETF	65.95	66.0	65.95	66.0	300.0
2005-08-05 08:00:00	DIA	ETF	106.24	106.24	105.83	105.86	6500.0
2005-08-05 09:00:00	DIA	ETF	105.84	106.09	105.74	105.94	1512300.0
2005-08-05 10:00:00	DIA	ETF	105.91	105.95	105.65	105.79	2505300.0
2005-08-05 11:00:00	DIA	ETF	105.8	105.85	105.54	105.56	1008700.0
2005-08-05 12:00:00	DIA	ETF	105.57	105.65	105.55	105.62	400800.0
2005-08-05 13:00:00	DIA	ETF	105.62	105.84	105.62	105.76	592900.0
2005-08-05 14:00:00	DIA	ETF	105.74	105.75	105.55	105.57	318900.0
2005-08-05 15:00:00	DIA	ETF	105.57	105.76	105.56	105.64	623300.0
2005-08-05 16:00:00	DIA	ETF	105.64	105.72	105.55	105.66	17600.0
2005-08-05 17:00:00	DIA	ETF	105.66	105.69	105.64	105.64	500.0
2005-08-05 18:00:00	DIA	ETF	105.63	105.63	105.6	105.6	1900.0
2005-08-05 08:00:00	GLD	ETF	43.72	43.72	43.65	43.65	700.0
2005-08-05 09:00:00	GLD	ETF	43.7	43.75	43.7	43.7	102100.0
2005-08-05 10:00:00	GLD	ETF	43.7	43.74	43.69	43.724	291200.0
2005-08-05 11:00:00	GLD	ETF	43.72	43.72	43.59	43.65	351900.0
2005-08-05 12:00:00	GLD	ETF	43.67	43.7	43.62	43.66	94800.0
2005-08-05 13:00:00	GLD	ETF	43.658	43.67	43.6	43.6	61000.0
2005-08-05 14:00:00	GLD	ETF	43.61	43.63	43.56	43.6	80400.0
2005-08-05 15:00:00	GLD	ETF	43.588	43.61	43.58	43.6	115500.0

> showing 50 of 937 rows — these rows as CSV

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