PREVIEW / etf_1hour / 2006-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-24.parquet
  size:    38 KB
  rows:    1,209

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
2006-02-24 05:00:00	SPY	ETF	129.2	129.29	129.2	129.29	3000.0
2006-02-24 06:00:00	SPY	ETF	129.29	129.29	129.29	129.29	100.0
2006-02-24 07:00:00	SPY	ETF	129.23	129.3	129.23	129.26	28500.0
2006-02-24 08:00:00	SPY	ETF	129.25	129.3	128.84	129.0	4322900.0
2006-02-24 09:00:00	SPY	ETF	129.0	129.23	128.9	129.08	4169300.0
2006-02-24 10:00:00	SPY	ETF	129.1	129.35	128.76	128.92	7931700.0
2006-02-24 11:00:00	SPY	ETF	128.93	129.2	128.93	129.07	3871800.0
2006-02-24 12:00:00	SPY	ETF	129.08	129.33	129.01	129.24	2201300.0
2006-02-24 13:00:00	SPY	ETF	129.25	129.29	128.96	129.02	2798600.0
2006-02-24 14:00:00	SPY	ETF	129.04	129.42	129.02	129.41	3108600.0
2006-02-24 15:00:00	SPY	ETF	129.41	129.48	129.11	129.23	6049100.0
2006-02-24 16:00:00	SPY	ETF	129.22	129.41	129.16	129.3	666100.0
2006-02-24 17:00:00	SPY	ETF	129.3	129.3	129.3	129.3	1500.0
2006-02-24 18:00:00	SPY	ETF	129.32	129.38	129.1644	129.38	6000.0
2006-02-24 19:00:00	SPY	ETF	129.38	129.38	129.38	129.38	1200.0
2006-02-24 09:00:00	QQQ	ETF	41.15	41.21	41.04	41.14	9862200.0
2006-02-24 10:00:00	QQQ	ETF	41.13	41.29	40.15	41.06	12978800.0
2006-02-24 11:00:00	QQQ	ETF	41.06	41.16	41.05	41.15	5645100.0
2006-02-24 12:00:00	QQQ	ETF	41.15	41.27	41.13	41.25	5342600.0
2006-02-24 13:00:00	QQQ	ETF	41.25	41.27	41.1	41.12	5086400.0
2006-02-24 14:00:00	QQQ	ETF	41.12	41.27	41.1	41.27	5630800.0
2006-02-24 15:00:00	QQQ	ETF	41.26	41.29	41.14	41.25	7610100.0
2006-02-24 08:00:00	IWM	ETF	72.77	72.77	72.61	72.73	19900.0
2006-02-24 09:00:00	IWM	ETF	72.68	72.85	72.45	72.7	1910500.0
2006-02-24 10:00:00	IWM	ETF	72.7	72.9	72.49	72.57	5925500.0
2006-02-24 11:00:00	IWM	ETF	72.58	72.9	72.57	72.88	2685800.0
2006-02-24 12:00:00	IWM	ETF	72.89	73.1	72.85	73.07	1991500.0
2006-02-24 13:00:00	IWM	ETF	73.07	73.14	72.9	72.95	2637900.0
2006-02-24 14:00:00	IWM	ETF	72.95	73.3	72.95	73.29	2881000.0
2006-02-24 15:00:00	IWM	ETF	73.3	73.35	73.11	73.2	4140400.0
2006-02-24 16:00:00	IWM	ETF	73.18	73.35	73.15	73.15	349400.0
2006-02-24 07:00:00	DIA	ETF	110.93	110.93	110.91	110.91	9500.0
2006-02-24 08:00:00	DIA	ETF	110.96	110.96	110.59	110.64	13100.0
2006-02-24 09:00:00	DIA	ETF	110.58	110.7	110.35	110.5	625600.0
2006-02-24 10:00:00	DIA	ETF	110.5	110.7	110.09	110.2	1326500.0
2006-02-24 11:00:00	DIA	ETF	110.21	110.47	110.2	110.4	899000.0
2006-02-24 12:00:00	DIA	ETF	110.4	110.63	110.38	110.58	875300.0
2006-02-24 13:00:00	DIA	ETF	110.59	110.59	110.36	110.4	623800.0
2006-02-24 14:00:00	DIA	ETF	110.4	110.8	110.4	110.78	461600.0
2006-02-24 15:00:00	DIA	ETF	110.77	110.86	110.56	110.65	563700.0
2006-02-24 16:00:00	DIA	ETF	110.64	110.81	110.61	110.76	45100.0
2006-02-24 17:00:00	DIA	ETF	110.8	110.8	110.8	110.8	200.0
2006-02-24 18:00:00	DIA	ETF	110.75	110.75	110.75	110.75	100.0
2006-02-24 07:00:00	GLD	ETF	54.81	54.81	54.81	54.81	500.0
2006-02-24 08:00:00	GLD	ETF	54.75	55.27	54.75	55.25	151100.0
2006-02-24 09:00:00	GLD	ETF	55.3	55.32	55.03	55.11	470800.0
2006-02-24 10:00:00	GLD	ETF	55.13	55.54	55.05	55.51	1469000.0
2006-02-24 11:00:00	GLD	ETF	55.51	55.7	55.45	55.5504	1464500.0
2006-02-24 12:00:00	GLD	ETF	55.54	55.65	55.48	55.6	199100.0
2006-02-24 13:00:00	GLD	ETF	55.59	55.7	55.59	55.65	368700.0

> showing 50 of 1,209 rows — these rows as CSV

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