PREVIEW / etf_1hour / 2004-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-16.parquet
  size:    25 KB
  rows:    674

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-07-16 08:00:00	SPY	ETF	111.2	111.42	111.09	111.4	822100.0
2004-07-16 09:00:00	SPY	ETF	111.42	111.67	111.32	111.45	6479900.0
2004-07-16 10:00:00	SPY	ETF	111.47	111.53	110.85	110.93	7853200.0
2004-07-16 11:00:00	SPY	ETF	110.92	111.29	110.89	111.11	3122700.0
2004-07-16 12:00:00	SPY	ETF	111.11	111.2	111.0	111.15	2842500.0
2004-07-16 13:00:00	SPY	ETF	111.17	111.21	111.02	111.15	1251100.0
2004-07-16 14:00:00	SPY	ETF	111.15	111.16	110.58	110.62	4152400.0
2004-07-16 15:00:00	SPY	ETF	110.62	110.89	110.44	110.53	7613400.0
2004-07-16 16:00:00	SPY	ETF	110.54	110.78	110.47	110.76	4137300.0
2004-07-16 17:00:00	SPY	ETF	110.75	110.9	110.75	110.77	39400.0
2004-07-16 18:00:00	SPY	ETF	110.76	110.84	110.76	110.84	2200.0
2004-07-16 19:00:00	SPY	ETF	110.82	110.82	110.82	110.82	100.0
2004-07-16 08:00:00	QQQ	ETF	35.32	35.45	35.28	35.4	883300.0
2004-07-16 09:00:00	QQQ	ETF	35.4	35.45	35.18	35.28	16403100.0
2004-07-16 10:00:00	QQQ	ETF	35.28	35.31	34.94	35.0	24569600.0
2004-07-16 11:00:00	QQQ	ETF	35.002	35.17	34.97	35.013	12139400.0
2004-07-16 12:00:00	QQQ	ETF	35.014	35.07	34.93	35.04	11674400.0
2004-07-16 13:00:00	QQQ	ETF	35.04	35.07	34.952	35.01	8109200.0
2004-07-16 14:00:00	QQQ	ETF	35.009	35.018	34.71	34.769	18854300.0
2004-07-16 15:00:00	QQQ	ETF	34.76	34.89	34.64	34.68	21379400.0
2004-07-16 16:00:00	QQQ	ETF	34.68	34.7	34.61	34.68	3645400.0
2004-07-16 17:00:00	QQQ	ETF	34.67	34.73	34.65	34.71	72600.0
2004-07-16 18:00:00	QQQ	ETF	34.71	34.76	34.69	34.72	41500.0
2004-07-16 19:00:00	QQQ	ETF	34.71	34.71	34.69	34.71	4800.0
2004-07-16 08:00:00	IWM	ETF	56.12	56.2	56.12	56.2	7000.0
2004-07-16 09:00:00	IWM	ETF	56.2	56.31	55.965	56.03	1376400.0
2004-07-16 10:00:00	IWM	ETF	56.04	56.085	55.56	55.695	2599000.0
2004-07-16 11:00:00	IWM	ETF	55.69	55.955	55.69	55.83	1120600.0
2004-07-16 12:00:00	IWM	ETF	55.83	55.9	55.78	55.9	566600.0
2004-07-16 13:00:00	IWM	ETF	55.885	55.89	55.795	55.855	176200.0
2004-07-16 14:00:00	IWM	ETF	55.845	55.845	55.43	55.455	1444000.0
2004-07-16 15:00:00	IWM	ETF	55.445	55.61	55.2	55.245	2983000.0
2004-07-16 16:00:00	IWM	ETF	55.23	55.5	55.215	55.25	1367800.0
2004-07-16 17:00:00	IWM	ETF	55.36	55.36	55.36	55.36	268400.0
2004-07-16 08:00:00	DIA	ETF	101.93	102.14	101.73	102.14	32200.0
2004-07-16 09:00:00	DIA	ETF	102.12	102.49	102.1	102.36	911500.0
2004-07-16 10:00:00	DIA	ETF	102.32	102.38	101.79	101.88	1357300.0
2004-07-16 11:00:00	DIA	ETF	101.84	102.09	101.81	102.0	477300.0
2004-07-16 12:00:00	DIA	ETF	102.01	102.1	101.91	102.0	176000.0
2004-07-16 13:00:00	DIA	ETF	102.0	102.04	101.94	102.01	145600.0
2004-07-16 14:00:00	DIA	ETF	102.02	102.03	101.59	101.64	1054900.0
2004-07-16 15:00:00	DIA	ETF	101.63	101.85	101.46	101.6	983100.0
2004-07-16 16:00:00	DIA	ETF	101.6	101.7	101.53	101.69	344800.0
2004-07-16 17:00:00	DIA	ETF	101.7	101.85	101.7	101.85	10300.0
2004-07-16 08:00:00	TLT	ETF	84.52	84.52	84.5	84.5	20000.0
2004-07-16 09:00:00	TLT	ETF	84.81	85.09	84.81	85.07	157900.0
2004-07-16 10:00:00	TLT	ETF	85.11	85.19	84.99	85.16	232700.0
2004-07-16 11:00:00	TLT	ETF	85.16	85.38	85.16	85.3	1357400.0
2004-07-16 12:00:00	TLT	ETF	85.33	85.38	85.29	85.31	155100.0
2004-07-16 13:00:00	TLT	ETF	85.31	85.38	85.28	85.34	96900.0

> showing 50 of 674 rows — these rows as CSV

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