PREVIEW / etf_1hour / 2005-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-10.parquet
  size:    32 KB
  rows:    948

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
2005-08-10 06:00:00	SPY	ETF	123.95	123.95	123.95	123.95	1000.0
2005-08-10 07:00:00	SPY	ETF	123.92	123.96	123.87	123.87	83600.0
2005-08-10 08:00:00	SPY	ETF	123.9	123.93	123.82	123.9	294300.0
2005-08-10 09:00:00	SPY	ETF	123.89	124.25	123.82	124.25	6768200.0
2005-08-10 10:00:00	SPY	ETF	124.25	124.5	123.85	124.39	11922400.0
2005-08-10 11:00:00	SPY	ETF	124.38	124.42	124.2	124.27	4966700.0
2005-08-10 12:00:00	SPY	ETF	124.26	124.32	123.67	123.94	11010200.0
2005-08-10 13:00:00	SPY	ETF	123.94	124.06	123.54	123.7	6860400.0
2005-08-10 14:00:00	SPY	ETF	123.7	123.72	123.2	123.33	15195800.0
2005-08-10 15:00:00	SPY	ETF	123.34	123.49	122.82	123.12	12570900.0
2005-08-10 16:00:00	SPY	ETF	123.15	123.38	123.06	123.31	1099700.0
2005-08-10 17:00:00	SPY	ETF	123.33	123.36	123.33	123.33	61700.0
2005-08-10 18:00:00	SPY	ETF	123.36	123.4	123.35	123.35	5800.0
2005-08-10 19:00:00	SPY	ETF	123.34	123.34	123.34	123.34	2100.0
2005-08-10 09:00:00	QQQ	ETF	39.54	39.67	39.53	39.67	11021100.0
2005-08-10 10:00:00	QQQ	ETF	39.66	39.69	39.55	39.64	16539400.0
2005-08-10 11:00:00	QQQ	ETF	39.65	39.67	39.59	39.63	4878600.0
2005-08-10 12:00:00	QQQ	ETF	39.62	39.65	39.38	39.45	10736300.0
2005-08-10 13:00:00	QQQ	ETF	39.46	39.58	38.41	39.39	8777800.0
2005-08-10 14:00:00	QQQ	ETF	39.39	39.39	39.2	39.22	12759900.0
2005-08-10 15:00:00	QQQ	ETF	39.22	39.23	38.97	39.11	28148000.0
2005-08-10 07:00:00	IWM	ETF	66.21	66.21	66.21	66.21	12800.0
2005-08-10 08:00:00	IWM	ETF	66.21	66.25	66.15	66.15	23000.0
2005-08-10 09:00:00	IWM	ETF	66.05	66.34	66.0	66.33	2306300.0
2005-08-10 10:00:00	IWM	ETF	66.33	66.51	66.3	66.402	5511400.0
2005-08-10 11:00:00	IWM	ETF	66.4	66.6	66.3	66.49	2359200.0
2005-08-10 12:00:00	IWM	ETF	66.49	66.552	64.87	66.05	3262700.0
2005-08-10 13:00:00	IWM	ETF	66.06	66.18	65.73	65.84	2861300.0
2005-08-10 14:00:00	IWM	ETF	65.84	65.84	65.52	65.67	3644700.0
2005-08-10 15:00:00	IWM	ETF	65.67	65.7	65.14	65.66	5858300.0
2005-08-10 16:00:00	IWM	ETF	65.66	65.83	65.66	65.78	85000.0
2005-08-10 17:00:00	IWM	ETF	65.79	65.79	65.71	65.71	522000.0
2005-08-10 07:00:00	DIA	ETF	106.77	106.79	106.74	106.74	10300.0
2005-08-10 08:00:00	DIA	ETF	106.74	106.76	106.69	106.76	3300.0
2005-08-10 09:00:00	DIA	ETF	106.75	107.05	106.69	107.04	799600.0
2005-08-10 10:00:00	DIA	ETF	107.03	107.33	106.93	107.2024	1312100.0
2005-08-10 11:00:00	DIA	ETF	107.21	107.23	107.08	107.12	313000.0
2005-08-10 12:00:00	DIA	ETF	107.12	107.15	106.6	106.77	1352100.0
2005-08-10 13:00:00	DIA	ETF	106.78	106.8	106.38	106.52	1798300.0
2005-08-10 14:00:00	DIA	ETF	106.51	106.51	106.17	106.28	1349000.0
2005-08-10 15:00:00	DIA	ETF	106.28	106.28	105.79	106.07	1431900.0
2005-08-10 16:00:00	DIA	ETF	106.08	106.3	106.08	106.27	2800.0
2005-08-10 17:00:00	DIA	ETF	106.27	106.3	106.27	106.3	1200.0
2005-08-10 18:00:00	DIA	ETF	106.32	106.32	106.32	106.32	100.0
2005-08-10 08:00:00	GLD	ETF	43.59	43.59	43.59	43.59	1700.0
2005-08-10 09:00:00	GLD	ETF	43.49	43.52	43.47	43.5	78000.0
2005-08-10 10:00:00	GLD	ETF	43.51	43.61	43.51	43.52	181500.0
2005-08-10 11:00:00	GLD	ETF	43.53	43.56	43.45	43.47	94300.0
2005-08-10 12:00:00	GLD	ETF	43.46	43.54	43.45	43.53	66700.0
2005-08-10 13:00:00	GLD	ETF	43.54	43.56	43.52	43.56	68800.0

> showing 50 of 948 rows — these rows as CSV

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