PREVIEW / etf_1hour / 2004-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-19.parquet
  size:    24 KB
  rows:    680

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-03-19 08:00:00	SPY	ETF	112.8	112.8	112.71	112.75	77200.0
2004-03-19 09:00:00	SPY	ETF	112.79	112.8	111.94	112.15	6265100.0
2004-03-19 10:00:00	SPY	ETF	112.15	112.4	111.93	112.27	7030900.0
2004-03-19 11:00:00	SPY	ETF	112.27	112.57	112.14	112.26	3780500.0
2004-03-19 12:00:00	SPY	ETF	112.26	112.38	112.1	112.19	2294900.0
2004-03-19 13:00:00	SPY	ETF	112.2	112.29	111.9	112.07	3604000.0
2004-03-19 14:00:00	SPY	ETF	112.07	112.21	111.76	111.79	2407200.0
2004-03-19 15:00:00	SPY	ETF	111.78	111.9	111.16	111.28	10459300.0
2004-03-19 16:00:00	SPY	ETF	111.29	111.31	110.92	111.0	6381600.0
2004-03-19 17:00:00	SPY	ETF	111.0	111.08	111.0	111.06	108700.0
2004-03-19 18:00:00	SPY	ETF	111.08	111.13	111.07	111.13	7000.0
2004-03-19 19:00:00	SPY	ETF	111.12	111.13	111.12	111.13	900.0
2004-03-19 08:00:00	QQQ	ETF	35.43	35.45	35.37	35.38	117100.0
2004-03-19 09:00:00	QQQ	ETF	35.4	35.43	35.05	35.15	10829800.0
2004-03-19 10:00:00	QQQ	ETF	35.13	35.28	35.04	35.25	16039400.0
2004-03-19 11:00:00	QQQ	ETF	35.26	35.456	35.22	35.329	9451200.0
2004-03-19 12:00:00	QQQ	ETF	35.33	35.39	35.25	35.276	5896900.0
2004-03-19 13:00:00	QQQ	ETF	35.276	35.34	35.1	35.171	11249600.0
2004-03-19 14:00:00	QQQ	ETF	35.17	35.23	34.987	34.988	8486600.0
2004-03-19 15:00:00	QQQ	ETF	34.99	35.03	34.82	34.827	26297300.0
2004-03-19 16:00:00	QQQ	ETF	34.827	34.85	34.69	34.73	4221700.0
2004-03-19 17:00:00	QQQ	ETF	34.72	34.79	34.68	34.69	1010000.0
2004-03-19 18:00:00	QQQ	ETF	34.69	34.7	34.68	34.69	37300.0
2004-03-19 19:00:00	QQQ	ETF	34.69	34.69	34.68	34.68	28500.0
2004-03-19 08:00:00	IWM	ETF	57.415	57.415	57.35	57.38	2600.0
2004-03-19 09:00:00	IWM	ETF	57.435	57.45	56.855	57.025	1683600.0
2004-03-19 10:00:00	IWM	ETF	57.015	57.37	56.91	57.235	2000000.0
2004-03-19 11:00:00	IWM	ETF	57.22	57.56	57.155	57.4	1424600.0
2004-03-19 12:00:00	IWM	ETF	57.4	57.455	57.25	57.285	694200.0
2004-03-19 13:00:00	IWM	ETF	57.285	57.44	57.15	57.285	1201000.0
2004-03-19 14:00:00	IWM	ETF	57.28	57.44	57.18	57.225	1279800.0
2004-03-19 15:00:00	IWM	ETF	57.225	57.245	56.735	56.815	4105200.0
2004-03-19 16:00:00	IWM	ETF	56.79	56.93	56.645	56.75	1267800.0
2004-03-19 08:00:00	DIA	ETF	103.39	103.39	103.29	103.34	18200.0
2004-03-19 09:00:00	DIA	ETF	103.41	103.45	102.62	102.81	769000.0
2004-03-19 10:00:00	DIA	ETF	102.82	103.13	102.69	103.03	1001900.0
2004-03-19 11:00:00	DIA	ETF	103.0	103.28	102.88	102.99	581000.0
2004-03-19 12:00:00	DIA	ETF	102.99	103.06	102.77	102.81	489000.0
2004-03-19 13:00:00	DIA	ETF	102.83	102.9	102.61	102.78	920900.0
2004-03-19 14:00:00	DIA	ETF	102.78	102.89	102.45	102.47	733000.0
2004-03-19 15:00:00	DIA	ETF	102.45	102.56	101.93	102.04	1938000.0
2004-03-19 16:00:00	DIA	ETF	102.0	102.09	101.8	102.0	360000.0
2004-03-19 17:00:00	DIA	ETF	102.0	102.1	101.9	101.94	2800.0
2004-03-19 08:00:00	TLT	ETF	90.43	90.43	90.43	90.43	500.0
2004-03-19 09:00:00	TLT	ETF	90.47	90.47	90.39	90.44	14700.0
2004-03-19 10:00:00	TLT	ETF	90.37	90.55	90.37	90.53	52300.0
2004-03-19 11:00:00	TLT	ETF	90.53	90.6	90.35	90.35	23900.0
2004-03-19 12:00:00	TLT	ETF	90.37	90.4	90.23	90.34	51900.0
2004-03-19 13:00:00	TLT	ETF	90.34	90.36	90.23	90.35	30800.0
2004-03-19 14:00:00	TLT	ETF	90.35	90.35	90.21	90.25	38200.0

> showing 50 of 680 rows — these rows as CSV

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