PREVIEW / etf_1hour / 2006-02-27

all etf 1-hour files

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

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-27 05:00:00	SPY	ETF	129.49	129.49	129.49	129.49	25000.0
2006-02-27 06:00:00	SPY	ETF	129.41	129.41	129.39	129.39	50000.0
2006-02-27 07:00:00	SPY	ETF	129.36	129.38	129.32	129.32	15000.0
2006-02-27 08:00:00	SPY	ETF	129.35	129.51	129.33	129.49	199100.0
2006-02-27 09:00:00	SPY	ETF	129.48	129.71	129.25	129.68	6939700.0
2006-02-27 10:00:00	SPY	ETF	129.67	129.85	129.41	129.55	5421900.0
2006-02-27 11:00:00	SPY	ETF	129.55	129.94	129.52	129.84	5427100.0
2006-02-27 12:00:00	SPY	ETF	129.84	129.9	129.77	129.83	1888000.0
2006-02-27 13:00:00	SPY	ETF	129.84	129.9	129.77	129.87	1365300.0
2006-02-27 14:00:00	SPY	ETF	129.88	129.98	129.67	129.93	4025500.0
2006-02-27 15:00:00	SPY	ETF	129.93	130.04	129.63	129.69	8157100.0
2006-02-27 16:00:00	SPY	ETF	129.68	129.7467	129.44	129.64	827200.0
2006-02-27 17:00:00	SPY	ETF	129.54	129.58	129.53	129.53	58500.0
2006-02-27 18:00:00	SPY	ETF	129.55	129.6	129.55	129.59	21400.0
2006-02-27 19:00:00	SPY	ETF	129.53	129.53	129.48	129.5	46000.0
2006-02-27 09:00:00	QQQ	ETF	41.37	41.51	41.33	41.5	10095900.0
2006-02-27 10:00:00	QQQ	ETF	41.51	41.59	41.4	41.5	9381600.0
2006-02-27 11:00:00	QQQ	ETF	41.51	41.86	41.5	41.79	14226700.0
2006-02-27 12:00:00	QQQ	ETF	41.79	41.82	41.74	41.77	4856200.0
2006-02-27 13:00:00	QQQ	ETF	41.76	41.8	41.75	41.78	3036700.0
2006-02-27 14:00:00	QQQ	ETF	41.79	41.85	41.72	41.8	7486000.0
2006-02-27 15:00:00	QQQ	ETF	41.81	41.87	41.67	41.72	11567400.0
2006-02-27 08:00:00	IWM	ETF	73.42	73.48	73.42	73.46	16800.0
2006-02-27 09:00:00	IWM	ETF	73.45	73.63	73.33	73.57	3853200.0
2006-02-27 10:00:00	IWM	ETF	73.56	73.66	73.32	73.41	2969000.0
2006-02-27 11:00:00	IWM	ETF	73.4	73.88	73.4	73.72	3811900.0
2006-02-27 12:00:00	IWM	ETF	73.71	73.76	73.58	73.67	1928400.0
2006-02-27 13:00:00	IWM	ETF	73.67	73.81	73.66	73.75	1696700.0
2006-02-27 14:00:00	IWM	ETF	73.74	73.81	73.58	73.71	2181500.0
2006-02-27 15:00:00	IWM	ETF	73.71	73.8	73.54	73.58	3698900.0
2006-02-27 16:00:00	IWM	ETF	73.58	73.6	73.51	73.53	212400.0
2006-02-27 17:00:00	IWM	ETF	73.54	73.57	73.54	73.57	2500.0
2006-02-27 07:00:00	DIA	ETF	110.79	110.79	110.72	110.72	9600.0
2006-02-27 08:00:00	DIA	ETF	110.78	110.87	110.76	110.87	8700.0
2006-02-27 09:00:00	DIA	ETF	110.87	111.15	110.75	111.1	359700.0
2006-02-27 10:00:00	DIA	ETF	111.1	111.23	110.91	110.981	499500.0
2006-02-27 11:00:00	DIA	ETF	110.99	111.33	110.98	111.2	477800.0
2006-02-27 12:00:00	DIA	ETF	111.2	111.26	111.09	111.16	195100.0
2006-02-27 13:00:00	DIA	ETF	111.18	111.23	111.1301	111.22	169300.0
2006-02-27 14:00:00	DIA	ETF	111.23	111.3	111.06	111.22	340200.0
2006-02-27 15:00:00	DIA	ETF	111.21	111.31	110.95	110.96	429000.0
2006-02-27 16:00:00	DIA	ETF	110.95	110.96	110.83	110.83	17300.0
2006-02-27 17:00:00	DIA	ETF	110.9	110.9	110.81	110.81	400.0
2006-02-27 19:00:00	DIA	ETF	110.8	110.8	110.8	110.8	100.0
2006-02-27 07:00:00	GLD	ETF	55.44	55.44	55.38	55.38	1200.0
2006-02-27 08:00:00	GLD	ETF	55.42	55.42	55.15	55.28	132800.0
2006-02-27 09:00:00	GLD	ETF	55.19	55.3	55.04	55.07	584000.0
2006-02-27 10:00:00	GLD	ETF	55.07	55.2299	55.01	55.07	449500.0
2006-02-27 11:00:00	GLD	ETF	55.06	55.12	55.01	55.05	234000.0
2006-02-27 12:00:00	GLD	ETF	55.06	55.18	55.01	55.05	226800.0

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

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