PREVIEW / etf_1hour / 2006-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-26.parquet
  size:    54 KB
  rows:    1,728

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-12-26 07:00:00	SPY	ETF	140.83	140.9	140.8	140.9	23500.0
2006-12-26 08:00:00	SPY	ETF	140.89	140.9	140.8	140.86	1053800.0
2006-12-26 09:00:00	SPY	ETF	140.85	141.43	140.78	141.22	7040200.0
2006-12-26 10:00:00	SPY	ETF	141.21	141.3	141.05	141.08	3710500.0
2006-12-26 11:00:00	SPY	ETF	141.08	141.28	141.06	141.27	3412700.0
2006-12-26 12:00:00	SPY	ETF	141.27	141.27	141.14	141.18	3418400.0
2006-12-26 13:00:00	SPY	ETF	141.18	141.4	141.14	141.36	2043700.0
2006-12-26 14:00:00	SPY	ETF	141.36	141.4	141.24	141.28	1655100.0
2006-12-26 15:00:00	SPY	ETF	141.28	141.58	141.25	141.54	4782100.0
2006-12-26 16:00:00	SPY	ETF	141.54	141.66	141.5	141.6	566400.0
2006-12-26 17:00:00	SPY	ETF	141.59	141.61	141.55	141.61	12700.0
2006-12-26 18:00:00	SPY	ETF	141.58	141.6	141.58	141.6	700.0
2006-12-26 19:00:00	SPY	ETF	141.58	141.6	141.58	141.6	2500.0
2006-12-26 09:00:00	QQQ	ETF	42.93	43.12	42.88	43.01	11030600.0
2006-12-26 10:00:00	QQQ	ETF	43.01	43.07	42.93	42.95	7076700.0
2006-12-26 11:00:00	QQQ	ETF	42.95	43.06	42.94	43.03	8180000.0
2006-12-26 12:00:00	QQQ	ETF	43.03	43.05	42.97	42.99	2395600.0
2006-12-26 13:00:00	QQQ	ETF	42.99	43.06	42.99	43.04	3448400.0
2006-12-26 14:00:00	QQQ	ETF	43.03	43.05	42.99	43.0	4561600.0
2006-12-26 15:00:00	QQQ	ETF	43.0	43.12	42.99	43.12	6756400.0
2006-12-26 08:00:00	IWM	ETF	77.39	77.39	77.29	77.29	11500.0
2006-12-26 09:00:00	IWM	ETF	77.28	78.13	77.27	78.0	4534000.0
2006-12-26 10:00:00	IWM	ETF	78.0	78.03	77.86	77.88	2951200.0
2006-12-26 11:00:00	IWM	ETF	77.89	78.05	77.88	77.97	2544600.0
2006-12-26 12:00:00	IWM	ETF	77.97	77.98	77.82	77.88	1389900.0
2006-12-26 13:00:00	IWM	ETF	77.87	78.09	77.86	78.02	2804700.0
2006-12-26 14:00:00	IWM	ETF	78.03	78.04	77.95	77.95	1278900.0
2006-12-26 15:00:00	IWM	ETF	77.96	78.22	77.92	78.18	5926800.0
2006-12-26 16:00:00	IWM	ETF	78.16	78.53	78.13	78.2	126500.0
2006-12-26 17:00:00	IWM	ETF	78.22	78.22	78.22	78.22	100.0
2006-12-26 19:00:00	IWM	ETF	78.23	78.25	78.23	78.25	7000.0
2006-12-26 08:00:00	DIA	ETF	123.37	123.37	123.34	123.34	900.0
2006-12-26 09:00:00	DIA	ETF	123.3	123.66	123.17	123.53	877800.0
2006-12-26 10:00:00	DIA	ETF	123.54	123.62	123.4	123.4	563900.0
2006-12-26 11:00:00	DIA	ETF	123.4	123.67	123.39	123.66	498100.0
2006-12-26 12:00:00	DIA	ETF	123.66	123.67	123.56	123.6	168300.0
2006-12-26 13:00:00	DIA	ETF	123.6	123.8	123.57	123.78	601600.0
2006-12-26 14:00:00	DIA	ETF	123.78	123.84	123.74	123.75	361600.0
2006-12-26 15:00:00	DIA	ETF	123.75	124.01	123.75	123.94	922700.0
2006-12-26 16:00:00	DIA	ETF	123.93	123.98	123.91	123.97	45200.0
2006-12-26 17:00:00	DIA	ETF	123.92	123.92	123.92	123.92	100.0
2006-12-26 18:00:00	DIA	ETF	123.92	123.92	123.92	123.92	100.0
2006-12-26 20:00:00	DIA	ETF	123.92	123.92	123.92	123.92	100.0
2006-12-26 08:00:00	GLD	ETF	61.91	62.32	61.87	62.2	79700.0
2006-12-26 09:00:00	GLD	ETF	62.22	62.36	62.18	62.34	287200.0
2006-12-26 10:00:00	GLD	ETF	62.36	62.45	62.06	62.2	381100.0
2006-12-26 11:00:00	GLD	ETF	62.18	62.23	62.1	62.18	259000.0
2006-12-26 12:00:00	GLD	ETF	62.18	62.18	61.95	61.95	290300.0
2006-12-26 13:00:00	GLD	ETF	61.96	62.01	61.89	61.98	339000.0
2006-12-26 14:00:00	GLD	ETF	61.99	61.99	61.87	61.919	156700.0

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

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