PREVIEW / etf_1hour / 2005-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-14.parquet
  size:    28 KB
  rows:    810

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-01-14 08:00:00	SPY	ETF	117.83	118.08	117.77	117.97	214500.0
2005-01-14 09:00:00	SPY	ETF	117.97	118.09	117.76	118.05	7123000.0
2005-01-14 10:00:00	SPY	ETF	118.03	118.4	117.8	118.2	9302800.0
2005-01-14 11:00:00	SPY	ETF	118.2	118.32	118.04	118.11	3489900.0
2005-01-14 12:00:00	SPY	ETF	118.12	118.5	118.09	118.33	5578900.0
2005-01-14 13:00:00	SPY	ETF	118.33	118.39	118.2	118.22	3164400.0
2005-01-14 14:00:00	SPY	ETF	118.22	118.48	118.12	118.42	4016700.0
2005-01-14 15:00:00	SPY	ETF	118.42	118.53	118.29	118.42	5922000.0
2005-01-14 16:00:00	SPY	ETF	118.4	118.45	118.2	118.29	2007600.0
2005-01-14 17:00:00	SPY	ETF	118.33	118.38	118.33	118.38	2000.0
2005-01-14 18:00:00	SPY	ETF	118.36	118.36	118.36	118.36	300.0
2005-01-14 19:00:00	SPY	ETF	118.33	118.33	118.33	118.33	300.0
2005-01-14 09:00:00	QQQ	ETF	38.19	38.33	38.19	38.27	12454300.0
2005-01-14 10:00:00	QQQ	ETF	38.27	38.52	38.19	38.42	22821100.0
2005-01-14 11:00:00	QQQ	ETF	38.42	38.46	38.34	38.36	7671900.0
2005-01-14 12:00:00	QQQ	ETF	38.36	38.51	38.36	38.41	7118500.0
2005-01-14 13:00:00	QQQ	ETF	38.42	38.44	38.15	38.36	6480700.0
2005-01-14 14:00:00	QQQ	ETF	38.36	38.5	38.34	38.47	9053900.0
2005-01-14 15:00:00	QQQ	ETF	38.47	38.48	38.37	38.44	10225800.0
2005-01-14 08:00:00	IWM	ETF	61.035	61.115	61.035	61.115	1000.0
2005-01-14 09:00:00	IWM	ETF	61.06	61.25	60.915	61.15	2305400.0
2005-01-14 10:00:00	IWM	ETF	61.17	61.39	60.965	61.105	2822400.0
2005-01-14 11:00:00	IWM	ETF	61.1	61.215	61.08	61.11	990600.0
2005-01-14 12:00:00	IWM	ETF	61.13	61.36	61.13	61.23	1242600.0
2005-01-14 13:00:00	IWM	ETF	61.22	61.315	61.135	61.135	484400.0
2005-01-14 14:00:00	IWM	ETF	61.125	61.325	61.03	61.27	1427400.0
2005-01-14 15:00:00	IWM	ETF	61.28	61.55	61.175	61.515	3702000.0
2005-01-14 16:00:00	IWM	ETF	61.49	61.51	61.39	61.5	404000.0
2005-01-14 08:00:00	DIA	ETF	105.21	105.26	105.18	105.2	32200.0
2005-01-14 09:00:00	DIA	ETF	105.2	105.31	105.06	105.27	931600.0
2005-01-14 10:00:00	DIA	ETF	105.28	105.63	105.05	105.44	2165500.0
2005-01-14 11:00:00	DIA	ETF	105.45	105.51	105.26	105.31	517200.0
2005-01-14 12:00:00	DIA	ETF	105.31	105.59	105.3	105.44	445400.0
2005-01-14 13:00:00	DIA	ETF	105.43	105.47	105.33	105.37	285700.0
2005-01-14 14:00:00	DIA	ETF	105.37	105.65	105.25	105.58	536900.0
2005-01-14 15:00:00	DIA	ETF	105.58	105.65	105.49	105.53	894500.0
2005-01-14 16:00:00	DIA	ETF	105.52	105.55	105.4	105.55	137300.0
2005-01-14 19:00:00	DIA	ETF	105.51	105.51	105.51	105.51	400.0
2005-01-14 09:00:00	GLD	ETF	42.19	42.32	42.13	42.27	255300.0
2005-01-14 10:00:00	GLD	ETF	42.29	42.3	42.16	42.2	287800.0
2005-01-14 11:00:00	GLD	ETF	42.18	42.28	42.16	42.27	470200.0
2005-01-14 12:00:00	GLD	ETF	42.27	42.32	42.2	42.29	65200.0
2005-01-14 13:00:00	GLD	ETF	42.28	42.32	42.25	42.31	84900.0
2005-01-14 14:00:00	GLD	ETF	42.31	42.32	42.27	42.29	37300.0
2005-01-14 15:00:00	GLD	ETF	42.27	42.32	42.25	42.32	61100.0
2005-01-14 08:00:00	TLT	ETF	90.21	90.48	90.13	90.3	28400.0
2005-01-14 09:00:00	TLT	ETF	90.21	90.21	89.8	89.93	154800.0
2005-01-14 10:00:00	TLT	ETF	89.93	90.01	89.83	89.98	77700.0
2005-01-14 11:00:00	TLT	ETF	90.01	90.04	89.91	90.0	34600.0
2005-01-14 12:00:00	TLT	ETF	90.0	90.01	89.85	89.95	87700.0

> showing 50 of 810 rows — these rows as CSV

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