PREVIEW / etf_1hour / 2006-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-06.parquet
  size:    52 KB
  rows:    1,664

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-06 06:00:00	SPY	ETF	135.17	135.17	135.1	135.1	1500.0
2006-10-06 07:00:00	SPY	ETF	135.07	135.07	134.97	135.04	75900.0
2006-10-06 08:00:00	SPY	ETF	135.01	135.19	134.8	134.88	3086900.0
2006-10-06 09:00:00	SPY	ETF	134.88	135.0	134.5	134.61	11133800.0
2006-10-06 10:00:00	SPY	ETF	134.58	134.93	134.46	134.87	13136000.0
2006-10-06 11:00:00	SPY	ETF	134.87	134.92	134.57	134.66	8159800.0
2006-10-06 12:00:00	SPY	ETF	134.66	134.71	134.4	134.69	8246200.0
2006-10-06 13:00:00	SPY	ETF	134.71	134.84	134.57	134.79	3796800.0
2006-10-06 14:00:00	SPY	ETF	134.79	135.09	134.74	134.99	6823500.0
2006-10-06 15:00:00	SPY	ETF	134.99	135.05	134.72	135.03	8081600.0
2006-10-06 16:00:00	SPY	ETF	135.03	135.11	134.95	135.0	646900.0
2006-10-06 17:00:00	SPY	ETF	134.94	135.05	134.94	135.05	15400.0
2006-10-06 18:00:00	SPY	ETF	134.95	134.95	134.88	134.88	9100.0
2006-10-06 09:00:00	QQQ	ETF	41.38	41.5	41.24	41.35	14899900.0
2006-10-06 10:00:00	QQQ	ETF	41.35	41.49	41.27	41.45	18377700.0
2006-10-06 11:00:00	QQQ	ETF	41.45	41.48	41.3	41.35	11509100.0
2006-10-06 12:00:00	QQQ	ETF	41.34	41.4	41.24	41.4	8433500.0
2006-10-06 13:00:00	QQQ	ETF	41.39	41.45	41.34	41.43	3631400.0
2006-10-06 14:00:00	QQQ	ETF	41.43	41.56	41.38	41.49	8205000.0
2006-10-06 15:00:00	QQQ	ETF	41.49	41.49	41.32	41.42	11084200.0
2006-10-06 07:00:00	IWM	ETF	73.55	73.75	73.55	73.75	3000.0
2006-10-06 08:00:00	IWM	ETF	73.79	73.98	73.56	73.59	327100.0
2006-10-06 09:00:00	IWM	ETF	73.53	73.67	73.15	73.28	5849000.0
2006-10-06 10:00:00	IWM	ETF	73.29	73.58	73.0	73.46	8178000.0
2006-10-06 11:00:00	IWM	ETF	73.46	73.5	73.21	73.3	2364500.0
2006-10-06 12:00:00	IWM	ETF	73.3	73.4	73.0	73.4	3603100.0
2006-10-06 13:00:00	IWM	ETF	73.4	73.55	73.3	73.44	3426900.0
2006-10-06 14:00:00	IWM	ETF	73.44	73.86	73.37	73.78	5167500.0
2006-10-06 15:00:00	IWM	ETF	73.78	73.82	73.41	73.48	5235700.0
2006-10-06 16:00:00	IWM	ETF	73.45	73.5	73.37	73.45	173000.0
2006-10-06 07:00:00	DIA	ETF	118.45	118.45	118.45	118.45	200.0
2006-10-06 08:00:00	DIA	ETF	118.47	118.66	118.35	118.38	250700.0
2006-10-06 09:00:00	DIA	ETF	118.32	118.45	118.08	118.21	1916400.0
2006-10-06 10:00:00	DIA	ETF	118.2	118.47	118.06	118.42	1635500.0
2006-10-06 11:00:00	DIA	ETF	118.41	118.5	118.27	118.35	538100.0
2006-10-06 12:00:00	DIA	ETF	118.36	118.4	117.97	118.24	1040100.0
2006-10-06 13:00:00	DIA	ETF	118.23	118.34	118.09	118.27	601000.0
2006-10-06 14:00:00	DIA	ETF	118.27	118.57	118.22	118.45	1845700.0
2006-10-06 15:00:00	DIA	ETF	118.43	118.53	118.26	118.5	947200.0
2006-10-06 16:00:00	DIA	ETF	118.5	118.54	118.46	118.53	39100.0
2006-10-06 17:00:00	DIA	ETF	118.53	118.53	118.53	118.53	500.0
2006-10-06 08:00:00	GLD	ETF	56.64	56.8	56.31	56.37	128500.0
2006-10-06 09:00:00	GLD	ETF	56.37	56.4	55.71	55.76	706800.0
2006-10-06 10:00:00	GLD	ETF	55.74	56.79	55.63	56.324	1910200.0
2006-10-06 11:00:00	GLD	ETF	56.32	56.59	56.1	56.43	429400.0
2006-10-06 12:00:00	GLD	ETF	56.44	56.71	56.41	56.66	332200.0
2006-10-06 13:00:00	GLD	ETF	56.67	56.96	56.54	56.84	359100.0
2006-10-06 14:00:00	GLD	ETF	56.84	57.02	56.84	56.96	185400.0
2006-10-06 15:00:00	GLD	ETF	56.96	57.02	56.85	57.01	219500.0
2006-10-06 16:00:00	GLD	ETF	57.0173	57.02	57.01	57.02	2300.0

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

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