PREVIEW / etf_1hour / 2004-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-01.parquet
  size:    25 KB
  rows:    698

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-01 08:00:00	SPY	ETF	115.4	115.45	115.36	115.44	31000.0
2004-03-01 09:00:00	SPY	ETF	115.43	115.69	115.38	115.54	3237500.0
2004-03-01 10:00:00	SPY	ETF	115.54	115.83	115.41	115.43	6992600.0
2004-03-01 11:00:00	SPY	ETF	115.42	115.66	115.25	115.66	1963200.0
2004-03-01 12:00:00	SPY	ETF	115.66	115.92	115.64	115.78	1980700.0
2004-03-01 13:00:00	SPY	ETF	115.78	115.95	115.68	115.89	2099100.0
2004-03-01 14:00:00	SPY	ETF	115.89	116.34	115.88	116.23	3546800.0
2004-03-01 15:00:00	SPY	ETF	116.25	116.26	116.08	116.11	3274000.0
2004-03-01 16:00:00	SPY	ETF	116.12	116.26	116.08	116.2	1759700.0
2004-03-01 17:00:00	SPY	ETF	116.23	116.24	115.7341	116.24	64500.0
2004-03-01 18:00:00	SPY	ETF	116.19	116.22	116.15	116.22	7400.0
2004-03-01 19:00:00	SPY	ETF	116.22	116.24	116.22	116.22	600.0
2004-03-01 08:00:00	QQQ	ETF	36.67	36.67	36.62	36.65	208500.0
2004-03-01 09:00:00	QQQ	ETF	36.66	36.74	36.58	36.69	5369600.0
2004-03-01 10:00:00	QQQ	ETF	36.67	36.83	36.589	36.61	12449500.0
2004-03-01 11:00:00	QQQ	ETF	36.63	36.64	36.47	36.64	6526300.0
2004-03-01 12:00:00	QQQ	ETF	36.65	36.76	36.62	36.7	6249700.0
2004-03-01 13:00:00	QQQ	ETF	36.71	36.8	36.66	36.76	5896400.0
2004-03-01 14:00:00	QQQ	ETF	36.77	37.0	36.75	36.95	14235500.0
2004-03-01 15:00:00	QQQ	ETF	36.95	37.07	36.92	36.98	14268000.0
2004-03-01 16:00:00	QQQ	ETF	36.98	37.08	36.98	37.06	2975000.0
2004-03-01 17:00:00	QQQ	ETF	37.05	37.07	37.02	37.06	60400.0
2004-03-01 18:00:00	QQQ	ETF	37.06	37.08	37.05	37.06	33400.0
2004-03-01 19:00:00	QQQ	ETF	37.05	37.09	37.05	37.05	8500.0
2004-03-01 09:00:00	IWM	ETF	58.535	58.655	58.405	58.575	691000.0
2004-03-01 10:00:00	IWM	ETF	58.545	58.855	58.495	58.685	2523200.0
2004-03-01 11:00:00	IWM	ETF	58.685	58.85	58.585	58.85	919800.0
2004-03-01 12:00:00	IWM	ETF	58.86	58.985	58.85	58.9	586400.0
2004-03-01 13:00:00	IWM	ETF	58.91	59.125	58.84	59.115	976800.0
2004-03-01 14:00:00	IWM	ETF	59.125	59.215	59.07	59.195	830400.0
2004-03-01 15:00:00	IWM	ETF	59.185	59.295	59.085	59.205	2223200.0
2004-03-01 16:00:00	IWM	ETF	59.195	59.275	59.18	59.205	543800.0
2004-03-01 08:00:00	DIA	ETF	106.32	106.47	106.32	106.41	34400.0
2004-03-01 09:00:00	DIA	ETF	106.44	106.53	106.28	106.45	806800.0
2004-03-01 10:00:00	DIA	ETF	106.42	106.68	106.334	106.36	782100.0
2004-03-01 11:00:00	DIA	ETF	106.35	106.53	106.17	106.53	185100.0
2004-03-01 12:00:00	DIA	ETF	106.53	106.74	106.5	106.65	455100.0
2004-03-01 13:00:00	DIA	ETF	106.63	106.78	106.53	106.71	288800.0
2004-03-01 14:00:00	DIA	ETF	106.74	107.09	106.72	107.0	761000.0
2004-03-01 15:00:00	DIA	ETF	107.0	107.01	106.89	106.92	905300.0
2004-03-01 16:00:00	DIA	ETF	106.93	106.96	106.89	106.945	336000.0
2004-03-01 19:00:00	DIA	ETF	107.04	107.04	107.04	107.04	100.0
2004-03-01 09:00:00	TLT	ETF	88.46	88.49	88.38	88.46	64900.0
2004-03-01 10:00:00	TLT	ETF	88.46	88.49	88.04	88.1	324100.0
2004-03-01 11:00:00	TLT	ETF	88.05	88.22	88.05	88.08	36600.0
2004-03-01 12:00:00	TLT	ETF	88.15	88.3	88.12	88.22	54200.0
2004-03-01 13:00:00	TLT	ETF	88.25	88.28	88.15	88.2	95600.0
2004-03-01 14:00:00	TLT	ETF	88.16	88.29	88.06	88.2	60300.0
2004-03-01 15:00:00	TLT	ETF	88.18	88.28	88.12	88.26	54200.0
2004-03-01 16:00:00	TLT	ETF	88.28	88.28	88.26	88.27	2500.0

> showing 50 of 698 rows — these rows as CSV

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