PREVIEW / etf_1hour / 2003-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-03-18.parquet
  size:    16 KB
  rows:    395

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-03-18 08:00:00	SPY	ETF	87.8	87.84	87.31	87.35	229800.0
2003-03-18 09:00:00	SPY	ETF	87.36	87.36	86.28	86.33	9171900.0
2003-03-18 10:00:00	SPY	ETF	86.3	87.24	86.29	86.71	9786000.0
2003-03-18 11:00:00	SPY	ETF	86.73	87.05	86.54	86.64	3535300.0
2003-03-18 12:00:00	SPY	ETF	86.63	86.9	86.52	86.83	3927700.0
2003-03-18 13:00:00	SPY	ETF	86.85	87.32	86.81	87.1	7223500.0
2003-03-18 14:00:00	SPY	ETF	87.1	87.16	86.42	86.71	6930800.0
2003-03-18 15:00:00	SPY	ETF	86.74	87.19	86.52	87.19	5499500.0
2003-03-18 16:00:00	SPY	ETF	87.19	87.37	86.73	87.37	1708500.0
2003-03-18 17:00:00	SPY	ETF	87.34	87.36	87.0	87.0	540000.0
2003-03-18 18:00:00	SPY	ETF	87.0	87.15	87.0	87.06	22600.0
2003-03-18 19:00:00	SPY	ETF	87.04	87.04	87.0	87.0	8600.0
2003-03-18 08:00:00	QQQ	ETF	26.98	27.01	26.76	26.81	327200.0
2003-03-18 09:00:00	QQQ	ETF	26.8	26.88	26.42	26.46	23266500.0
2003-03-18 10:00:00	QQQ	ETF	26.46	26.9	26.43	26.62	18817000.0
2003-03-18 11:00:00	QQQ	ETF	26.63	26.73	26.5	26.63	9788700.0
2003-03-18 12:00:00	QQQ	ETF	26.61	26.74	26.58	26.67	5333300.0
2003-03-18 13:00:00	QQQ	ETF	26.66	26.85	26.66	26.77	8126300.0
2003-03-18 14:00:00	QQQ	ETF	26.77	26.81	26.55	26.69	13622700.0
2003-03-18 15:00:00	QQQ	ETF	26.68	26.89	26.6	26.85	8631300.0
2003-03-18 16:00:00	QQQ	ETF	26.86	26.97	26.81	26.91	3604300.0
2003-03-18 17:00:00	QQQ	ETF	26.91	26.92	26.75	26.77	1321900.0
2003-03-18 18:00:00	QQQ	ETF	26.77	26.81	26.74	26.81	367600.0
2003-03-18 19:00:00	QQQ	ETF	26.81	26.84	26.75	26.79	17400.0
2003-03-18 09:00:00	IWM	ETF	36.45	36.495	36.12	36.12	295400.0
2003-03-18 10:00:00	IWM	ETF	36.125	36.485	36.115	36.315	298200.0
2003-03-18 11:00:00	IWM	ETF	36.335	36.4	36.265	36.33	82400.0
2003-03-18 12:00:00	IWM	ETF	36.275	36.375	36.265	36.365	703600.0
2003-03-18 13:00:00	IWM	ETF	36.375	36.605	36.365	36.575	666800.0
2003-03-18 14:00:00	IWM	ETF	36.55	36.55	36.39	36.5	322600.0
2003-03-18 15:00:00	IWM	ETF	36.465	36.615	36.375	36.615	846200.0
2003-03-18 16:00:00	IWM	ETF	36.625	36.72	36.58	36.72	36600.0
2003-03-18 08:00:00	DIA	ETF	82.53	82.6	82.0	82.03	38900.0
2003-03-18 09:00:00	DIA	ETF	82.1	82.1	81.1	81.22	2846300.0
2003-03-18 10:00:00	DIA	ETF	81.18	82.13	81.11	81.68	2226100.0
2003-03-18 11:00:00	DIA	ETF	81.7	81.99	81.52	81.58	680700.0
2003-03-18 12:00:00	DIA	ETF	81.61	81.88	81.5	81.83	473000.0
2003-03-18 13:00:00	DIA	ETF	81.82	82.35	81.77	82.15	1023900.0
2003-03-18 14:00:00	DIA	ETF	82.09	82.2	81.48	81.75	1835700.0
2003-03-18 15:00:00	DIA	ETF	81.79	82.2	81.55	82.13	1116300.0
2003-03-18 16:00:00	DIA	ETF	82.14	82.22	82.0	82.2	218300.0
2003-03-18 17:00:00	DIA	ETF	82.06	82.07	82.0	82.03	3200.0
2003-03-18 18:00:00	DIA	ETF	82.0	82.1	82.0	82.02	1800.0
2003-03-18 19:00:00	DIA	ETF	82.02	82.02	81.9	81.9	800.0
2003-03-18 09:00:00	TLT	ETF	88.96	89.2	88.88	89.17	103000.0
2003-03-18 10:00:00	TLT	ETF	89.15	89.17	88.87	89.08	23800.0
2003-03-18 11:00:00	TLT	ETF	88.94	88.96	88.63	88.8	11900.0
2003-03-18 12:00:00	TLT	ETF	88.8	88.84	88.68	88.68	52200.0
2003-03-18 13:00:00	TLT	ETF	88.69	88.69	88.25	88.39	66900.0
2003-03-18 14:00:00	TLT	ETF	88.35	88.58	88.18	88.18	100300.0

> showing 50 of 395 rows — these rows as CSV

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