PREVIEW / etf_1hour / 2006-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-11.parquet
  size:    53 KB
  rows:    1,676

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-10-11 07:00:00	SPY	ETF	134.95	134.97	134.85	134.88	126700.0
2006-10-11 08:00:00	SPY	ETF	134.89	135.3446	134.82	134.92	3282800.0
2006-10-11 09:00:00	SPY	ETF	134.92	134.95	134.76	134.86	6256900.0
2006-10-11 10:00:00	SPY	ETF	134.87	135.12	134.8	135.02	11400600.0
2006-10-11 11:00:00	SPY	ETF	135.03	135.24	134.97	135.16	7352800.0
2006-10-11 12:00:00	SPY	ETF	135.16	135.35	135.03	135.25	6940100.0
2006-10-11 13:00:00	SPY	ETF	135.25	135.43	135.12	135.2	7353700.0
2006-10-11 14:00:00	SPY	ETF	135.2	135.23	134.3	134.76	28955400.0
2006-10-11 15:00:00	SPY	ETF	134.76	135.07	134.61	134.99	19122900.0
2006-10-11 16:00:00	SPY	ETF	134.99	135.361	134.97	135.14	6263400.0
2006-10-11 17:00:00	SPY	ETF	135.15	135.17	135.1	135.1	1247300.0
2006-10-11 18:00:00	SPY	ETF	135.12	135.15	135.1	135.15	9200.0
2006-10-11 19:00:00	SPY	ETF	135.14	135.14	135.1	135.1	1300.0
2006-10-11 09:00:00	QQQ	ETF	41.43	41.48	41.37	41.45	9743700.0
2006-10-11 10:00:00	QQQ	ETF	41.45	41.63	41.4	41.58	14637700.0
2006-10-11 11:00:00	QQQ	ETF	41.58	41.78	41.57	41.7	12988700.0
2006-10-11 12:00:00	QQQ	ETF	41.7	41.79	41.65	41.75	10354800.0
2006-10-11 13:00:00	QQQ	ETF	41.75	41.83	41.68	41.73	5472000.0
2006-10-11 14:00:00	QQQ	ETF	41.74	41.75	41.17	41.41	51584700.0
2006-10-11 15:00:00	QQQ	ETF	41.41	41.6	41.33	41.53	21339100.0
2006-10-11 08:00:00	IWM	ETF	73.8	73.8	73.66	73.79	411600.0
2006-10-11 09:00:00	IWM	ETF	73.78	73.89	73.55	73.83	3199100.0
2006-10-11 10:00:00	IWM	ETF	73.84	73.98	73.69	73.82	4044000.0
2006-10-11 11:00:00	IWM	ETF	73.82	74.17	73.78	74.08	3355600.0
2006-10-11 12:00:00	IWM	ETF	74.08	74.24	73.9	74.15	2372700.0
2006-10-11 13:00:00	IWM	ETF	74.15	74.29	73.94	74.02	3609100.0
2006-10-11 14:00:00	IWM	ETF	74.03	74.05	73.11	73.46	15146700.0
2006-10-11 15:00:00	IWM	ETF	73.48	73.88	73.36	73.65	9785000.0
2006-10-11 16:00:00	IWM	ETF	73.66	73.81	73.65	73.81	5273500.0
2006-10-11 17:00:00	IWM	ETF	73.84	73.85	73.76	73.81	32000.0
2006-10-11 08:00:00	DIA	ETF	118.19	118.26	118.19	118.23	20200.0
2006-10-11 09:00:00	DIA	ETF	118.29	118.35	118.13	118.28	913600.0
2006-10-11 10:00:00	DIA	ETF	118.29	118.42	118.23	118.35	716300.0
2006-10-11 11:00:00	DIA	ETF	118.35	118.48	118.31	118.41	462200.0
2006-10-11 12:00:00	DIA	ETF	118.42	118.66	118.35	118.62	395500.0
2006-10-11 13:00:00	DIA	ETF	118.61	118.78	118.53	118.59	910000.0
2006-10-11 14:00:00	DIA	ETF	118.6	118.67	117.91	118.16	3419900.0
2006-10-11 15:00:00	DIA	ETF	118.16	118.54	118.05	118.51	1421500.0
2006-10-11 16:00:00	DIA	ETF	118.52	118.63	118.51	118.62	37700.0
2006-10-11 17:00:00	DIA	ETF	118.57	118.57	118.57	118.57	1400.0
2006-10-11 19:00:00	DIA	ETF	118.57	118.57	118.57	118.57	100.0
2006-10-11 07:00:00	GLD	ETF	56.89	56.89	56.89	56.89	4000.0
2006-10-11 08:00:00	GLD	ETF	56.95	57.07	56.89	57.02	14600.0
2006-10-11 09:00:00	GLD	ETF	57.05	57.38	57.05	57.16	541500.0
2006-10-11 10:00:00	GLD	ETF	57.16	57.52	56.92	57.28	557800.0
2006-10-11 11:00:00	GLD	ETF	57.28	57.48	57.11	57.36	350300.0
2006-10-11 12:00:00	GLD	ETF	57.3502	57.43	56.9	56.96	612600.0
2006-10-11 13:00:00	GLD	ETF	56.96	57.02	56.79	56.84	216300.0
2006-10-11 14:00:00	GLD	ETF	56.83	57.11	56.7	56.89	406000.0
2006-10-11 15:00:00	GLD	ETF	56.87	57.0	56.77	56.8	219400.0

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

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