PREVIEW / etf_1hour / 2004-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-03.parquet
  size:    25 KB
  rows:    696

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
2004-05-03 08:00:00	SPY	ETF	111.4	111.43	111.33	111.4	30200.0
2004-05-03 09:00:00	SPY	ETF	111.4	111.82	111.35	111.79	3718500.0
2004-05-03 10:00:00	SPY	ETF	111.79	112.17	111.42	112.04	6414300.0
2004-05-03 11:00:00	SPY	ETF	112.04	112.29	111.94	112.01	3864200.0
2004-05-03 12:00:00	SPY	ETF	111.98	112.11	111.85	112.05	2846900.0
2004-05-03 13:00:00	SPY	ETF	112.06	112.08	111.68	111.79	2843200.0
2004-05-03 14:00:00	SPY	ETF	111.79	112.12	111.56	111.63	4316300.0
2004-05-03 15:00:00	SPY	ETF	111.65	112.22	111.6	112.14	4558400.0
2004-05-03 16:00:00	SPY	ETF	112.16	112.22	112.1	112.14	1116900.0
2004-05-03 17:00:00	SPY	ETF	112.18	112.19	112.14	112.16	30700.0
2004-05-03 18:00:00	SPY	ETF	112.14	112.17	112.12	112.14	6300.0
2004-05-03 08:00:00	QQQ	ETF	34.95	35.85	34.92	34.98	238500.0
2004-05-03 09:00:00	QQQ	ETF	34.98	35.21	34.972	35.17	17235800.0
2004-05-03 10:00:00	QQQ	ETF	35.178	35.42	35.02	35.36	24159000.0
2004-05-03 11:00:00	QQQ	ETF	35.37	35.52	35.33	35.381	15102100.0
2004-05-03 12:00:00	QQQ	ETF	35.389	35.44	35.29	35.35	8078200.0
2004-05-03 13:00:00	QQQ	ETF	35.359	35.362	35.04	35.138	14756700.0
2004-05-03 14:00:00	QQQ	ETF	35.14	35.27	34.89	34.96	14756100.0
2004-05-03 15:00:00	QQQ	ETF	34.958	35.28	34.93	35.18	17968000.0
2004-05-03 16:00:00	QQQ	ETF	35.171	35.19	35.09	35.14	2292100.0
2004-05-03 17:00:00	QQQ	ETF	35.13	35.16	35.12	35.15	109200.0
2004-05-03 18:00:00	QQQ	ETF	35.15	35.16	35.13	35.13	15400.0
2004-05-03 19:00:00	QQQ	ETF	35.15	35.17	35.13	35.17	9300.0
2004-05-03 08:00:00	IWM	ETF	55.875	55.875	55.825	55.825	12400.0
2004-05-03 09:00:00	IWM	ETF	55.8	56.005	55.745	55.94	2384000.0
2004-05-03 10:00:00	IWM	ETF	55.955	56.675	55.745	56.5	2917400.0
2004-05-03 11:00:00	IWM	ETF	56.5	56.685	56.405	56.47	1299600.0
2004-05-03 12:00:00	IWM	ETF	56.49	56.56	56.325	56.5	621400.0
2004-05-03 13:00:00	IWM	ETF	56.505	56.505	56.125	56.185	1341000.0
2004-05-03 14:00:00	IWM	ETF	56.145	56.41	55.95	56.015	2113200.0
2004-05-03 15:00:00	IWM	ETF	56.04	56.465	56.02	56.285	1802000.0
2004-05-03 16:00:00	IWM	ETF	56.35	56.35	56.24	56.275	320400.0
2004-05-03 08:00:00	DIA	ETF	102.7	102.7	102.64	102.7	8300.0
2004-05-03 09:00:00	DIA	ETF	102.7	103.1	102.66	103.09	742700.0
2004-05-03 10:00:00	DIA	ETF	103.08	103.46	102.78	103.32	1506500.0
2004-05-03 11:00:00	DIA	ETF	103.34	103.52	103.151	103.22	672000.0
2004-05-03 12:00:00	DIA	ETF	103.23	103.3	103.13	103.25	254500.0
2004-05-03 13:00:00	DIA	ETF	103.26	103.27	102.9	102.97	387200.0
2004-05-03 14:00:00	DIA	ETF	102.96	103.29	102.8	102.9	850800.0
2004-05-03 15:00:00	DIA	ETF	102.91	103.35	102.89	103.35	627700.0
2004-05-03 16:00:00	DIA	ETF	103.32	103.4	103.3	103.33	306400.0
2004-05-03 17:00:00	DIA	ETF	103.25	103.25	103.25	103.25	500.0
2004-05-03 08:00:00	TLT	ETF	83.2	83.2	83.2	83.2	600.0
2004-05-03 09:00:00	TLT	ETF	83.1	83.42	83.1	83.42	162300.0
2004-05-03 10:00:00	TLT	ETF	83.35	83.57	83.31	83.51	181700.0
2004-05-03 11:00:00	TLT	ETF	83.49	83.54	83.44	83.45	23700.0
2004-05-03 12:00:00	TLT	ETF	83.43	83.49	83.41	83.42	64700.0
2004-05-03 13:00:00	TLT	ETF	83.41	83.47	83.28	83.35	106400.0
2004-05-03 14:00:00	TLT	ETF	83.36	83.54	83.35	83.43	58900.0
2004-05-03 15:00:00	TLT	ETF	83.43	83.43	83.34	83.37	41100.0

> showing 50 of 696 rows — these rows as CSV

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