PREVIEW / etf_1hour / 2006-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-21.parquet
  size:    40 KB
  rows:    1,251

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-21 04:00:00	SPY	ETF	129.0	129.0	129.0	129.0	100.0
2006-02-21 05:00:00	SPY	ETF	129.23	129.23	129.23	129.23	100.0
2006-02-21 06:00:00	SPY	ETF	129.2	129.25	129.2	129.25	50100.0
2006-02-21 07:00:00	SPY	ETF	129.25	129.31	129.2	129.21	158300.0
2006-02-21 08:00:00	SPY	ETF	129.27	129.3	129.15	129.16	679400.0
2006-02-21 09:00:00	SPY	ETF	129.16	129.4	129.06	129.09	5378300.0
2006-02-21 10:00:00	SPY	ETF	129.07	129.2	128.48	128.7	11236700.0
2006-02-21 11:00:00	SPY	ETF	128.7	128.87	128.38	128.43	4188700.0
2006-02-21 12:00:00	SPY	ETF	128.43	128.65	128.34	128.4	4540100.0
2006-02-21 13:00:00	SPY	ETF	128.41	128.62	128.31	128.46	3889400.0
2006-02-21 14:00:00	SPY	ETF	128.46	128.71	128.29	128.41	7229900.0
2006-02-21 15:00:00	SPY	ETF	128.4	128.72	128.39	128.53	4860800.0
2006-02-21 16:00:00	SPY	ETF	128.53	128.59	128.46	128.48	1576500.0
2006-02-21 17:00:00	SPY	ETF	128.47	128.55	128.43	128.55	10800.0
2006-02-21 18:00:00	SPY	ETF	128.5	128.5	128.47	128.47	5500.0
2006-02-21 19:00:00	SPY	ETF	128.56	128.56	128.56	128.56	200.0
2006-02-21 09:00:00	QQQ	ETF	41.21	41.27	41.05	41.06	10524800.0
2006-02-21 10:00:00	QQQ	ETF	41.07	41.08	40.73	40.85	23436000.0
2006-02-21 11:00:00	QQQ	ETF	40.86	40.95	40.73	40.75	7908500.0
2006-02-21 12:00:00	QQQ	ETF	40.74	40.89	40.66	40.72	9475500.0
2006-02-21 13:00:00	QQQ	ETF	40.71	40.76	40.61	40.67	7846200.0
2006-02-21 14:00:00	QQQ	ETF	40.68	40.79	40.64	40.74	8997600.0
2006-02-21 15:00:00	QQQ	ETF	40.75	40.86	40.73	40.73	9561000.0
2006-02-21 08:00:00	IWM	ETF	72.74	72.74	72.74	72.74	200.0
2006-02-21 09:00:00	IWM	ETF	72.75	72.93	72.65	72.65	1774000.0
2006-02-21 10:00:00	IWM	ETF	72.66	72.73	72.24	72.35	5855500.0
2006-02-21 11:00:00	IWM	ETF	72.35	72.46	72.05	72.07	3178000.0
2006-02-21 12:00:00	IWM	ETF	72.07	72.11	71.85	71.95	2409400.0
2006-02-21 13:00:00	IWM	ETF	71.95	72.09	71.92	72.04	1837700.0
2006-02-21 14:00:00	IWM	ETF	72.04	72.16	71.87	72.0	2772400.0
2006-02-21 15:00:00	IWM	ETF	72.02	72.29	72.0	72.25	2648200.0
2006-02-21 16:00:00	IWM	ETF	72.25	72.4	72.23	72.25	321900.0
2006-02-21 17:00:00	IWM	ETF	72.33	72.37	72.33	72.37	46100.0
2006-02-21 18:00:00	IWM	ETF	72.33	72.33	72.33	72.33	400.0
2006-02-21 04:00:00	DIA	ETF	111.07	111.07	111.07	111.07	200.0
2006-02-21 07:00:00	DIA	ETF	111.34	111.38	111.32	111.33	14400.0
2006-02-21 08:00:00	DIA	ETF	111.33	111.35	111.23	111.23	40500.0
2006-02-21 09:00:00	DIA	ETF	111.24	111.32	111.04	111.06	1084100.0
2006-02-21 10:00:00	DIA	ETF	111.05	111.15	110.5	110.69	4693300.0
2006-02-21 11:00:00	DIA	ETF	110.71	110.88	110.57	110.6	553700.0
2006-02-21 12:00:00	DIA	ETF	110.62	110.72	110.54	110.54	563200.0
2006-02-21 13:00:00	DIA	ETF	110.54	110.69	110.5	110.55	369700.0
2006-02-21 14:00:00	DIA	ETF	110.55	110.76	110.4	110.54	995800.0
2006-02-21 15:00:00	DIA	ETF	110.55	110.75	110.49	110.62	603200.0
2006-02-21 16:00:00	DIA	ETF	110.61	110.65	110.58	110.6	131200.0
2006-02-21 07:00:00	GLD	ETF	55.08	55.1	55.08	55.09	3800.0
2006-02-21 08:00:00	GLD	ETF	55.09	55.15	54.98	55.04	34100.0
2006-02-21 09:00:00	GLD	ETF	55.03	55.3	55.03	55.23	489100.0
2006-02-21 10:00:00	GLD	ETF	55.24	55.34	55.1	55.21	529400.0
2006-02-21 11:00:00	GLD	ETF	55.21	55.26	55.14	55.26	432300.0

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

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