PREVIEW / etf_1hour / 2003-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-14.parquet
  size:    16 KB
  rows:    376

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-04-14 08:00:00	SPY	ETF	87.76	87.76	87.51	87.51	59400.0
2003-04-14 09:00:00	SPY	ETF	87.53	87.72	87.22	87.4	2840300.0
2003-04-14 10:00:00	SPY	ETF	87.38	87.8	87.25	87.7	3183200.0
2003-04-14 11:00:00	SPY	ETF	87.69	88.31	87.53	88.23	5338500.0
2003-04-14 12:00:00	SPY	ETF	88.23	88.48	88.17	88.43	4256300.0
2003-04-14 13:00:00	SPY	ETF	88.45	88.57	88.2	88.4	3396000.0
2003-04-14 14:00:00	SPY	ETF	88.4	88.58	88.1	88.23	3555900.0
2003-04-14 15:00:00	SPY	ETF	88.26	88.87	88.22	88.84	8554900.0
2003-04-14 16:00:00	SPY	ETF	88.85	89.16	88.8	89.01	3295100.0
2003-04-14 17:00:00	SPY	ETF	89.01	89.07	88.85	88.86	228600.0
2003-04-14 18:00:00	SPY	ETF	88.87	88.99	88.87	88.95	65000.0
2003-04-14 19:00:00	SPY	ETF	88.99	89.0	88.89	88.95	10700.0
2003-04-14 08:00:00	QQQ	ETF	25.67	25.67	25.59	25.59	73500.0
2003-04-14 09:00:00	QQQ	ETF	25.59	25.7	25.49	25.64	6359000.0
2003-04-14 10:00:00	QQQ	ETF	25.64	25.71	25.56	25.68	5050200.0
2003-04-14 11:00:00	QQQ	ETF	25.67	25.91	25.62	25.91	7490500.0
2003-04-14 12:00:00	QQQ	ETF	25.9	26.05	25.87	26.04	8988700.0
2003-04-14 13:00:00	QQQ	ETF	26.03	26.07	25.93	26.0	4924600.0
2003-04-14 14:00:00	QQQ	ETF	26.0	26.02	25.87	25.91	5085600.0
2003-04-14 15:00:00	QQQ	ETF	25.91	26.14	25.9	26.05	8717000.0
2003-04-14 16:00:00	QQQ	ETF	26.09	26.18	25.94	26.04	2489200.0
2003-04-14 17:00:00	QQQ	ETF	26.05	26.1	25.94	25.96	1068100.0
2003-04-14 18:00:00	QQQ	ETF	25.95	25.99	25.93	25.96	174700.0
2003-04-14 19:00:00	QQQ	ETF	25.94	26.0	25.94	25.99	11100.0
2003-04-14 09:00:00	IWM	ETF	37.01	37.205	37.01	37.14	250600.0
2003-04-14 10:00:00	IWM	ETF	37.115	37.205	37.095	37.205	230400.0
2003-04-14 11:00:00	IWM	ETF	37.195	37.41	37.175	37.41	412600.0
2003-04-14 12:00:00	IWM	ETF	37.4	37.49	37.4	37.475	110800.0
2003-04-14 13:00:00	IWM	ETF	37.485	37.525	37.4	37.47	62400.0
2003-04-14 14:00:00	IWM	ETF	37.465	37.525	37.39	37.485	106000.0
2003-04-14 15:00:00	IWM	ETF	37.455	37.59	37.4	37.56	291800.0
2003-04-14 16:00:00	IWM	ETF	37.575	37.625	37.575	37.625	80400.0
2003-04-14 17:00:00	IWM	ETF	37.59	37.59	37.59	37.59	1200.0
2003-04-14 08:00:00	DIA	ETF	82.65	82.7	82.54	82.54	8500.0
2003-04-14 09:00:00	DIA	ETF	82.55	82.6	82.25	82.42	618100.0
2003-04-14 10:00:00	DIA	ETF	82.42	82.75	82.34	82.7	760000.0
2003-04-14 11:00:00	DIA	ETF	82.72	83.3	82.56	83.23	1016500.0
2003-04-14 12:00:00	DIA	ETF	83.24	83.47	83.13	83.46	834600.0
2003-04-14 13:00:00	DIA	ETF	83.43	83.5	83.17	83.34	744300.0
2003-04-14 14:00:00	DIA	ETF	83.35	83.49	83.05	83.17	653400.0
2003-04-14 15:00:00	DIA	ETF	83.17	83.69	83.11	83.69	1146600.0
2003-04-14 16:00:00	DIA	ETF	83.68	84.1	83.66	83.95	188200.0
2003-04-14 17:00:00	DIA	ETF	83.9	83.98	83.8	83.8	55600.0
2003-04-14 18:00:00	DIA	ETF	83.82	83.86	83.81	83.85	4500.0
2003-04-14 19:00:00	DIA	ETF	83.9	83.93	83.9	83.93	3500.0
2003-04-14 09:00:00	TLT	ETF	87.1	87.1	87.09	87.09	1500.0
2003-04-14 10:00:00	TLT	ETF	87.1	87.11	86.95	87.0	68900.0
2003-04-14 11:00:00	TLT	ETF	86.91	86.95	86.8	86.84	72000.0
2003-04-14 12:00:00	TLT	ETF	86.76	86.86	86.75	86.85	15600.0
2003-04-14 13:00:00	TLT	ETF	86.8	86.87	86.72	86.87	5500.0

> showing 50 of 376 rows — these rows as CSV

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