PREVIEW / etf_1hour / 2005-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-27.parquet
  size:    33 KB
  rows:    1,000

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-10-27 05:00:00	SPY	ETF	118.95	118.95	118.95	118.95	500.0
2005-10-27 07:00:00	SPY	ETF	119.06	119.11	119.0	119.05	61000.0
2005-10-27 08:00:00	SPY	ETF	119.06	119.13	118.92	119.09	1252900.0
2005-10-27 09:00:00	SPY	ETF	119.08	119.37	118.93	119.16	6441200.0
2005-10-27 10:00:00	SPY	ETF	119.13	119.19	118.61	118.83	12557900.0
2005-10-27 11:00:00	SPY	ETF	118.81	119.1	118.66	118.8	5875900.0
2005-10-27 12:00:00	SPY	ETF	118.83	119.06	118.75	118.95	4339500.0
2005-10-27 13:00:00	SPY	ETF	118.9501	119.01	118.44	118.78	9176800.0
2005-10-27 14:00:00	SPY	ETF	118.7501	118.77	118.3	118.35	6467700.0
2005-10-27 15:00:00	SPY	ETF	118.36	118.39	117.94	117.98	17561300.0
2005-10-27 16:00:00	SPY	ETF	117.97	118.29	117.85	118.01	3409900.0
2005-10-27 17:00:00	SPY	ETF	118.03	118.03	117.89	117.98	41600.0
2005-10-27 18:00:00	SPY	ETF	117.92	118.2173	117.81	117.81	28100.0
2005-10-27 19:00:00	SPY	ETF	117.81	117.86	117.79	117.84	6900.0
2005-10-27 09:00:00	QQQ	ETF	38.78	38.81	38.66	38.67	12160700.0
2005-10-27 10:00:00	QQQ	ETF	38.67	38.7	38.42	38.46	28776200.0
2005-10-27 11:00:00	QQQ	ETF	38.46	38.56	38.42	38.47	14161200.0
2005-10-27 12:00:00	QQQ	ETF	38.47	38.56	38.47	38.52	5555400.0
2005-10-27 13:00:00	QQQ	ETF	38.52	38.53	38.26	38.41	17884000.0
2005-10-27 14:00:00	QQQ	ETF	38.41	38.42	38.2	38.21	10112200.0
2005-10-27 15:00:00	QQQ	ETF	38.21	39.04	38.03	38.05	33157300.0
2005-10-27 07:00:00	IWM	ETF	63.18	63.18	63.18	63.18	1000.0
2005-10-27 08:00:00	IWM	ETF	63.28	63.28	63.08	63.15	139600.0
2005-10-27 09:00:00	IWM	ETF	63.21	63.33	62.86	62.94	3642300.0
2005-10-27 10:00:00	IWM	ETF	62.94	63.0	62.53	62.67	4940300.0
2005-10-27 11:00:00	IWM	ETF	62.65	62.85	62.56	62.66	2195800.0
2005-10-27 12:00:00	IWM	ETF	62.66	62.83	62.62	62.74	848000.0
2005-10-27 13:00:00	IWM	ETF	62.74	62.74	62.25	62.5	4714900.0
2005-10-27 14:00:00	IWM	ETF	62.481	62.49	62.11	62.12	4255800.0
2005-10-27 15:00:00	IWM	ETF	62.11	62.35	61.94	62.12	5869700.0
2005-10-27 16:00:00	IWM	ETF	62.12	62.22	62.05	62.17	280600.0
2005-10-27 17:00:00	IWM	ETF	62.19	62.22	62.0	62.0	26300.0
2005-10-27 18:00:00	IWM	ETF	62.07	62.09	62.07	62.08	16700.0
2005-10-27 07:00:00	DIA	ETF	103.3	103.3	103.2	103.2	900.0
2005-10-27 08:00:00	DIA	ETF	103.21	103.24	103.08	103.22	25400.0
2005-10-27 09:00:00	DIA	ETF	103.28	103.42	103.01	103.0801	532900.0
2005-10-27 10:00:00	DIA	ETF	103.09	103.12	102.8	102.89	1212900.0
2005-10-27 11:00:00	DIA	ETF	102.88	103.1	102.77	102.82	769700.0
2005-10-27 12:00:00	DIA	ETF	102.83	103.01	102.81	102.93	559400.0
2005-10-27 13:00:00	DIA	ETF	102.92	102.95	102.57	102.83	409800.0
2005-10-27 14:00:00	DIA	ETF	102.84	102.87	102.5	102.55	375600.0
2005-10-27 15:00:00	DIA	ETF	102.53	102.57	102.2	102.26	1366700.0
2005-10-27 16:00:00	DIA	ETF	102.2599	102.3299	102.19	102.28	53000.0
2005-10-27 17:00:00	DIA	ETF	102.34	102.34	102.27	102.27	3600.0
2005-10-27 18:00:00	DIA	ETF	102.28	102.3	102.22	102.22	2500.0
2005-10-27 07:00:00	GLD	ETF	47.15	47.15	47.15	47.15	1000.0
2005-10-27 08:00:00	GLD	ETF	47.25	47.26	47.25	47.25	2200.0
2005-10-27 09:00:00	GLD	ETF	47.3	47.42	47.3	47.37	363900.0
2005-10-27 10:00:00	GLD	ETF	47.37	47.37	47.1301	47.18	557300.0
2005-10-27 11:00:00	GLD	ETF	47.19	47.3	47.14	47.29	287000.0

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

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