PREVIEW / etf_1hour / 2003-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-01.parquet
  size:    19 KB
  rows:    501

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-12-01 08:00:00	SPY	ETF	106.9	106.95	106.76	106.76	43200.0
2003-12-01 09:00:00	SPY	ETF	106.8	107.09	106.8	107.02	4631200.0
2003-12-01 10:00:00	SPY	ETF	107.02	107.39	106.95	107.08	6476200.0
2003-12-01 11:00:00	SPY	ETF	107.07	107.35	107.05	107.3	2833100.0
2003-12-01 12:00:00	SPY	ETF	107.31	107.54	107.28	107.44	2574900.0
2003-12-01 13:00:00	SPY	ETF	107.45	107.45	107.25	107.36	2344000.0
2003-12-01 14:00:00	SPY	ETF	107.33	107.37	106.8	107.33	6174800.0
2003-12-01 15:00:00	SPY	ETF	107.33	107.68	107.33	107.57	5137200.0
2003-12-01 16:00:00	SPY	ETF	107.57	107.61	107.51	107.53	3570900.0
2003-12-01 17:00:00	SPY	ETF	107.52	107.53	107.47	107.51	59700.0
2003-12-01 18:00:00	SPY	ETF	107.5	107.5432	107.5	107.53	11200.0
2003-12-01 08:00:00	QQQ	ETF	35.7	35.75	35.69	35.69	145600.0
2003-12-01 09:00:00	QQQ	ETF	35.69	35.8	35.68	35.72	9334400.0
2003-12-01 10:00:00	QQQ	ETF	35.72	36.0	35.66	35.73	16317900.0
2003-12-01 11:00:00	QQQ	ETF	35.73	35.9	35.7	35.86	4455200.0
2003-12-01 12:00:00	QQQ	ETF	35.86	35.95	35.8	35.82	3806400.0
2003-12-01 13:00:00	QQQ	ETF	35.84	35.85	35.71	35.751	5491000.0
2003-12-01 14:00:00	QQQ	ETF	35.756	35.79	35.47	35.78	14401200.0
2003-12-01 15:00:00	QQQ	ETF	35.78	35.9783	35.75	35.92	14272000.0
2003-12-01 16:00:00	QQQ	ETF	35.92	35.93	35.87	35.88	2604700.0
2003-12-01 17:00:00	QQQ	ETF	35.877	35.9	35.86	35.87	70700.0
2003-12-01 18:00:00	QQQ	ETF	35.87	35.9	35.87	35.87	41400.0
2003-12-01 19:00:00	QQQ	ETF	35.89	35.9	35.87	35.87	12700.0
2003-12-01 08:00:00	IWM	ETF	55.0	55.0	55.0	55.0	200.0
2003-12-01 09:00:00	IWM	ETF	54.99	55.195	54.925	55.15	1266800.0
2003-12-01 10:00:00	IWM	ETF	55.185	55.365	55.065	55.16	962000.0
2003-12-01 11:00:00	IWM	ETF	55.145	55.275	55.085	55.25	389400.0
2003-12-01 12:00:00	IWM	ETF	55.255	55.35	55.255	55.295	395400.0
2003-12-01 13:00:00	IWM	ETF	55.285	55.295	55.175	55.185	202800.0
2003-12-01 14:00:00	IWM	ETF	55.17	55.225	54.875	55.175	346800.0
2003-12-01 15:00:00	IWM	ETF	55.15	55.4	55.14	55.4	880600.0
2003-12-01 16:00:00	IWM	ETF	55.4	55.435	55.2373	55.38	49200.0
2003-12-01 08:00:00	DIA	ETF	98.37	98.5	98.32	98.32	6800.0
2003-12-01 09:00:00	DIA	ETF	98.34	98.57	98.33	98.42	685500.0
2003-12-01 10:00:00	DIA	ETF	98.42	98.87	98.4	98.65	1356800.0
2003-12-01 11:00:00	DIA	ETF	98.64	98.88	98.62	98.84	259700.0
2003-12-01 12:00:00	DIA	ETF	98.79	99.09	98.79	98.98	460100.0
2003-12-01 13:00:00	DIA	ETF	98.98	99.01	98.76	98.83	586100.0
2003-12-01 14:00:00	DIA	ETF	98.79	98.932	98.435	98.91	749800.0
2003-12-01 15:00:00	DIA	ETF	98.92	99.16	98.88	99.09	902100.0
2003-12-01 16:00:00	DIA	ETF	99.1	99.136	99.0	99.031	51200.0
2003-12-01 17:00:00	DIA	ETF	99.05	99.08	99.05	99.08	900.0
2003-12-01 09:00:00	TLT	ETF	84.54	84.57	84.33	84.4	122500.0
2003-12-01 10:00:00	TLT	ETF	84.37	84.38	83.8	84.0	189100.0
2003-12-01 11:00:00	TLT	ETF	83.96	84.1	83.83	84.02	387100.0
2003-12-01 12:00:00	TLT	ETF	84.02	84.17	84.02	84.08	31800.0
2003-12-01 13:00:00	TLT	ETF	84.09	84.25	84.09	84.2	57600.0
2003-12-01 14:00:00	TLT	ETF	84.2	84.43	84.18	84.37	82200.0
2003-12-01 15:00:00	TLT	ETF	84.38	84.4	84.2	84.28	114200.0
2003-12-01 16:00:00	TLT	ETF	84.28	84.325	84.24	84.325	6900.0

> showing 50 of 501 rows — these rows as CSV

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