PREVIEW / etf_1hour / 2003-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-14.parquet
  size:    16 KB
  rows:    390

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
2003-01-14 08:00:00	SPY	ETF	93.24	93.34	92.6	92.77	158100.0
2003-01-14 09:00:00	SPY	ETF	92.7	92.97	92.41	92.8	4058800.0
2003-01-14 10:00:00	SPY	ETF	92.81	93.28	92.52	92.9	6015600.0
2003-01-14 11:00:00	SPY	ETF	92.95	93.25	92.88	93.16	2050900.0
2003-01-14 12:00:00	SPY	ETF	93.13	93.26	93.01	93.11	1303300.0
2003-01-14 13:00:00	SPY	ETF	93.08	93.34	93.07	93.27	1909100.0
2003-01-14 14:00:00	SPY	ETF	93.28	93.37	92.92	93.01	1849800.0
2003-01-14 15:00:00	SPY	ETF	93.05	93.49	92.99	93.43	3230100.0
2003-01-14 16:00:00	SPY	ETF	93.47	93.7	92.45	93.22	1521100.0
2003-01-14 17:00:00	SPY	ETF	93.28	93.37	92.32	93.27	245200.0
2003-01-14 18:00:00	SPY	ETF	93.26	93.4	93.23	93.36	23800.0
2003-01-14 19:00:00	SPY	ETF	93.44	93.55	93.44	93.51	2600.0
2003-01-14 08:00:00	QQQ	ETF	27.09	27.13	26.86	26.88	150800.0
2003-01-14 09:00:00	QQQ	ETF	26.88	27.17	26.85	27.14	7303000.0
2003-01-14 10:00:00	QQQ	ETF	27.15	27.32	26.95	27.06	11025500.0
2003-01-14 11:00:00	QQQ	ETF	27.06	27.2	27.04	27.18	4136600.0
2003-01-14 12:00:00	QQQ	ETF	27.17	27.2	27.08	27.09	2245300.0
2003-01-14 13:00:00	QQQ	ETF	27.1	27.15	27.03	27.12	2794600.0
2003-01-14 14:00:00	QQQ	ETF	27.13	27.19	26.98	27.06	3621400.0
2003-01-14 15:00:00	QQQ	ETF	27.06	27.21	27.05	27.19	6744100.0
2003-01-14 16:00:00	QQQ	ETF	27.17	27.28	26.94	27.08	4524600.0
2003-01-14 17:00:00	QQQ	ETF	27.1	27.22	27.06	27.11	519100.0
2003-01-14 18:00:00	QQQ	ETF	27.15	27.2	27.12	27.2	35100.0
2003-01-14 19:00:00	QQQ	ETF	27.21	27.24	27.18	27.24	37700.0
2003-01-14 09:00:00	IWM	ETF	39.45	39.54	39.32	39.445	181200.0
2003-01-14 10:00:00	IWM	ETF	39.495	39.535	39.26	39.37	644600.0
2003-01-14 11:00:00	IWM	ETF	39.36	39.445	39.35	39.395	72800.0
2003-01-14 12:00:00	IWM	ETF	39.39	39.475	39.38	39.405	83800.0
2003-01-14 13:00:00	IWM	ETF	39.415	39.45	39.39	39.45	55600.0
2003-01-14 14:00:00	IWM	ETF	39.45	39.45	39.37	39.425	94200.0
2003-01-14 15:00:00	IWM	ETF	39.37	39.665	39.37	39.65	319800.0
2003-01-14 16:00:00	IWM	ETF	39.71	39.725	39.515	39.515	47600.0
2003-01-14 08:00:00	DIA	ETF	88.3	88.3	87.76	87.88	6300.0
2003-01-14 09:00:00	DIA	ETF	87.83	88.1	87.58	87.91	705700.0
2003-01-14 10:00:00	DIA	ETF	87.91	88.37	87.6	87.94	1128500.0
2003-01-14 11:00:00	DIA	ETF	87.96	88.28	87.88	88.18	350700.0
2003-01-14 12:00:00	DIA	ETF	88.18	88.27	88.05	88.1	165400.0
2003-01-14 13:00:00	DIA	ETF	88.15	88.4	88.11	88.26	343300.0
2003-01-14 14:00:00	DIA	ETF	88.32	88.37	87.95	88.1	487500.0
2003-01-14 15:00:00	DIA	ETF	88.04	88.56	88.01	88.53	412200.0
2003-01-14 16:00:00	DIA	ETF	88.55	88.6	88.3	88.4	96300.0
2003-01-14 17:00:00	DIA	ETF	88.47	88.54	88.35	88.49	301300.0
2003-01-14 18:00:00	DIA	ETF	88.42	88.44	88.42	88.44	300.0
2003-01-14 19:00:00	DIA	ETF	88.5	88.6	88.5	88.6	300.0
2003-01-14 09:00:00	TLT	ETF	86.0	86.28	86.0	86.07	22400.0
2003-01-14 10:00:00	TLT	ETF	86.07	86.19	85.99	86.12	10400.0
2003-01-14 11:00:00	TLT	ETF	86.14	86.21	86.09	86.09	10400.0
2003-01-14 12:00:00	TLT	ETF	86.22	86.22	86.13	86.2	600.0
2003-01-14 13:00:00	TLT	ETF	86.15	86.15	86.02	86.14	1600.0
2003-01-14 14:00:00	TLT	ETF	86.01	86.14	86.01	86.14	500.0

> showing 50 of 390 rows — these rows as CSV

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