PREVIEW / etf_1hour / 2004-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-14.parquet
  size:    24 KB
  rows:    654

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-01-14 08:00:00	SPY	ETF	112.65	112.82	112.63	112.8	17300.0
2004-01-14 09:00:00	SPY	ETF	112.72	112.88	112.67	112.84	3283500.0
2004-01-14 10:00:00	SPY	ETF	112.81	113.03	112.74	112.93	3400000.0
2004-01-14 11:00:00	SPY	ETF	112.94	113.17	112.92	112.95	5059400.0
2004-01-14 12:00:00	SPY	ETF	112.96	113.0	112.71	112.77	2578700.0
2004-01-14 13:00:00	SPY	ETF	112.79	113.0	112.68	112.86	1745900.0
2004-01-14 14:00:00	SPY	ETF	112.88	113.21	112.85	113.19	3552700.0
2004-01-14 15:00:00	SPY	ETF	113.18	113.42	113.13	113.31	5170900.0
2004-01-14 16:00:00	SPY	ETF	113.301	113.66	112.94	113.1	4791600.0
2004-01-14 17:00:00	SPY	ETF	113.09	113.68	113.05	113.22	288500.0
2004-01-14 18:00:00	SPY	ETF	113.2	113.23	113.08	113.09	23500.0
2004-01-14 19:00:00	SPY	ETF	113.12	113.14	113.12	113.14	2700.0
2004-01-14 08:00:00	QQQ	ETF	38.07	38.12	38.05	38.11	135500.0
2004-01-14 09:00:00	QQQ	ETF	38.11	38.123	37.929	38.01	11458900.0
2004-01-14 10:00:00	QQQ	ETF	38.031	38.14	37.969	38.027	9102500.0
2004-01-14 11:00:00	QQQ	ETF	38.03	38.18	38.0	38.02	7617000.0
2004-01-14 12:00:00	QQQ	ETF	38.02	38.05	37.85	37.9	6515200.0
2004-01-14 13:00:00	QQQ	ETF	37.91	38.02	37.84	37.98	4495500.0
2004-01-14 14:00:00	QQQ	ETF	37.98	38.13	37.91	38.1	6877600.0
2004-01-14 15:00:00	QQQ	ETF	38.099	38.221	38.08	38.101	9176800.0
2004-01-14 16:00:00	QQQ	ETF	38.101	38.25	37.7	37.75	9607900.0
2004-01-14 17:00:00	QQQ	ETF	37.74	37.85	37.73	37.78	2195700.0
2004-01-14 18:00:00	QQQ	ETF	37.78	37.78	37.72	37.77	238400.0
2004-01-14 19:00:00	QQQ	ETF	37.77	37.78	37.75	37.75	32800.0
2004-01-14 09:00:00	IWM	ETF	58.085	58.37	58.085	58.215	1290600.0
2004-01-14 10:00:00	IWM	ETF	58.23	58.34	58.0765	58.1	619600.0
2004-01-14 11:00:00	IWM	ETF	58.07	58.265	58.0575	58.15	635600.0
2004-01-14 12:00:00	IWM	ETF	58.12	58.165	57.95	58.005	1068000.0
2004-01-14 13:00:00	IWM	ETF	57.995	58.028	57.885	57.99	917200.0
2004-01-14 14:00:00	IWM	ETF	58.0	58.195	57.9615	58.155	454000.0
2004-01-14 15:00:00	IWM	ETF	58.145	58.35	58.095	58.33	804200.0
2004-01-14 16:00:00	IWM	ETF	58.39	58.395	57.98	57.98	402000.0
2004-01-14 17:00:00	IWM	ETF	57.98	58.065	57.97	58.065	139400.0
2004-01-14 08:00:00	DIA	ETF	104.69	104.9	104.69	104.86	22900.0
2004-01-14 09:00:00	DIA	ETF	104.81	105.0	104.78	104.88	730900.0
2004-01-14 10:00:00	DIA	ETF	104.87	105.09	104.85	105.03	671500.0
2004-01-14 11:00:00	DIA	ETF	105.04	105.29	105.02	105.16	503600.0
2004-01-14 12:00:00	DIA	ETF	105.16	105.24	104.95	105.03	787000.0
2004-01-14 13:00:00	DIA	ETF	105.04	105.24	104.96	105.16	502900.0
2004-01-14 14:00:00	DIA	ETF	105.15	105.46	105.08	105.44	933300.0
2004-01-14 15:00:00	DIA	ETF	105.45	105.68	105.39	105.58	1227200.0
2004-01-14 16:00:00	DIA	ETF	105.55	105.88	105.2	105.3	843900.0
2004-01-14 17:00:00	DIA	ETF	105.27	105.64	105.25	105.6	113200.0
2004-01-14 18:00:00	DIA	ETF	105.6	105.65	105.5	105.51	23300.0
2004-01-14 19:00:00	DIA	ETF	105.57	105.57	105.57	105.57	100.0
2004-01-14 09:00:00	TLT	ETF	87.49	87.5	87.31	87.41	61000.0
2004-01-14 10:00:00	TLT	ETF	87.36	87.36	87.15	87.26	162300.0
2004-01-14 11:00:00	TLT	ETF	87.28	87.6	87.28	87.59	163000.0
2004-01-14 12:00:00	TLT	ETF	87.57	87.9	87.55	87.66	346300.0
2004-01-14 13:00:00	TLT	ETF	87.67	87.8	87.55	87.7	106500.0

> showing 50 of 654 rows — these rows as CSV

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