PREVIEW / etf_1hour / 2006-02-28

all etf 1-hour files

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

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-28 06:00:00	SPY	ETF	129.5	129.51	129.43	129.43	25600.0
2006-02-28 07:00:00	SPY	ETF	129.44	129.53	129.42	129.53	13900.0
2006-02-28 08:00:00	SPY	ETF	129.5	129.51	129.29	129.3	654000.0
2006-02-28 09:00:00	SPY	ETF	129.33	129.33	129.11	129.24	5778400.0
2006-02-28 10:00:00	SPY	ETF	129.25	129.91	128.35	128.37	16838100.0
2006-02-28 11:00:00	SPY	ETF	128.37	129.46	128.28	128.43	9305300.0
2006-02-28 12:00:00	SPY	ETF	128.43	129.26	128.17	128.38	9548500.0
2006-02-28 13:00:00	SPY	ETF	128.39	128.73	128.35	128.39	6721500.0
2006-02-28 14:00:00	SPY	ETF	128.39	128.46	128.24	128.31	7348200.0
2006-02-28 15:00:00	SPY	ETF	128.32	129.6842	128.13	128.265	12120600.0
2006-02-28 16:00:00	SPY	ETF	128.24	128.55	128.23	128.3	1644500.0
2006-02-28 17:00:00	SPY	ETF	128.28	128.31	128.27	128.28	10700.0
2006-02-28 18:00:00	SPY	ETF	128.28	128.31	128.28	128.31	2200.0
2006-02-28 19:00:00	SPY	ETF	128.32	128.35	128.32	128.35	5500.0
2006-02-28 09:00:00	QQQ	ETF	41.59	41.72	41.38	41.67	8516500.0
2006-02-28 10:00:00	QQQ	ETF	41.68	41.7	41.07	41.07	35986300.0
2006-02-28 11:00:00	QQQ	ETF	41.07	41.22	41.03	41.18	17791100.0
2006-02-28 12:00:00	QQQ	ETF	41.18	41.26	41.09	41.2	8243600.0
2006-02-28 13:00:00	QQQ	ETF	41.2	41.33	41.16	41.19	8418300.0
2006-02-28 14:00:00	QQQ	ETF	41.18	41.23	41.05	41.11	8135900.0
2006-02-28 15:00:00	QQQ	ETF	41.11	41.24	40.97	41.1	21177900.0
2006-02-28 08:00:00	IWM	ETF	73.53	73.54	73.44	73.45	49600.0
2006-02-28 09:00:00	IWM	ETF	73.46	73.47	73.14	73.19	4504800.0
2006-02-28 10:00:00	IWM	ETF	73.19	73.2	72.7	72.71	5589700.0
2006-02-28 11:00:00	IWM	ETF	72.71	72.8	72.61	72.7	2728600.0
2006-02-28 12:00:00	IWM	ETF	72.7	72.74	72.45	72.64	2410100.0
2006-02-28 13:00:00	IWM	ETF	72.65	72.96	72.6	72.76	2004500.0
2006-02-28 14:00:00	IWM	ETF	72.76	72.78	72.49	72.53	8623400.0
2006-02-28 15:00:00	IWM	ETF	72.54	72.75	72.45	72.52	6665300.0
2006-02-28 16:00:00	IWM	ETF	72.51	72.65	72.45	72.57	350400.0
2006-02-28 17:00:00	IWM	ETF	72.65	72.65	72.58	72.58	573200.0
2006-02-28 18:00:00	IWM	ETF	72.58	72.58	72.58	72.58	4700.0
2006-02-28 08:00:00	DIA	ETF	110.85	110.85	110.67	110.67	4600.0
2006-02-28 09:00:00	DIA	ETF	110.72	110.76	110.57	110.76	338800.0
2006-02-28 10:00:00	DIA	ETF	110.74	110.74	109.98	110.0	1700800.0
2006-02-28 11:00:00	DIA	ETF	109.97	110.14	109.87	110.05	1753500.0
2006-02-28 12:00:00	DIA	ETF	110.06	110.15	109.88	110.03	609000.0
2006-02-28 13:00:00	DIA	ETF	110.02	110.24	109.97	109.98	521300.0
2006-02-28 14:00:00	DIA	ETF	109.97	110.08	109.9	109.97	356100.0
2006-02-28 15:00:00	DIA	ETF	109.96	110.09	109.78	109.94	1219300.0
2006-02-28 16:00:00	DIA	ETF	109.95	109.97	109.9	109.94	25200.0
2006-02-28 17:00:00	DIA	ETF	109.97	109.97	109.97	109.97	2000.0
2006-02-28 18:00:00	DIA	ETF	109.95	109.95	109.95	109.95	500.0
2006-02-28 07:00:00	GLD	ETF	55.35	55.35	55.35	55.35	2000.0
2006-02-28 08:00:00	GLD	ETF	55.34	55.62	55.34	55.52	81100.0
2006-02-28 09:00:00	GLD	ETF	55.53	55.59	55.31	55.35	277100.0
2006-02-28 10:00:00	GLD	ETF	55.34	55.65	55.3	55.63	575600.0
2006-02-28 11:00:00	GLD	ETF	55.59	55.85	55.58	55.78	491400.0
2006-02-28 12:00:00	GLD	ETF	55.8	55.85	55.73	55.83	382100.0
2006-02-28 13:00:00	GLD	ETF	55.83	55.94	55.8	55.92	298400.0

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

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