PREVIEW / etf_1hour / 2004-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-08.parquet
  size:    25 KB
  rows:    720

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-08 08:00:00	SPY	ETF	116.4	116.46	116.4	116.44	12300.0
2004-03-08 09:00:00	SPY	ETF	116.45	116.62	116.2	116.49	3297500.0
2004-03-08 10:00:00	SPY	ETF	116.49	116.55	116.14	116.17	3458700.0
2004-03-08 11:00:00	SPY	ETF	116.2	116.44	116.16	116.43	1786500.0
2004-03-08 12:00:00	SPY	ETF	116.43	116.46	116.18	116.3399	1158100.0
2004-03-08 13:00:00	SPY	ETF	116.34	116.34	115.82	115.88	5307100.0
2004-03-08 14:00:00	SPY	ETF	115.84	115.99	115.5	115.69	7327800.0
2004-03-08 15:00:00	SPY	ETF	115.66	115.69	115.22	115.27	6978200.0
2004-03-08 16:00:00	SPY	ETF	115.26	115.31	114.88	115.06	2594600.0
2004-03-08 17:00:00	SPY	ETF	115.05	115.07	114.99	114.99	439800.0
2004-03-08 18:00:00	SPY	ETF	115.02	115.05	115.02	115.05	6200.0
2004-03-08 08:00:00	QQQ	ETF	36.71	36.73	36.67	36.73	57100.0
2004-03-08 09:00:00	QQQ	ETF	36.74	36.82	36.64	36.75	7421100.0
2004-03-08 10:00:00	QQQ	ETF	36.74	36.769	36.502	36.511	14333500.0
2004-03-08 11:00:00	QQQ	ETF	36.51	36.651	36.49	36.6489	6310200.0
2004-03-08 12:00:00	QQQ	ETF	36.64	36.66	36.4	36.48	7408700.0
2004-03-08 13:00:00	QQQ	ETF	36.47	36.51	36.11	36.12	17856200.0
2004-03-08 14:00:00	QQQ	ETF	36.114	36.17	35.91	35.998	29263500.0
2004-03-08 15:00:00	QQQ	ETF	36.0	36.0	35.8	35.84	19697800.0
2004-03-08 16:00:00	QQQ	ETF	35.83	36.6212	35.71	35.78	5645700.0
2004-03-08 17:00:00	QQQ	ETF	35.78	35.78	35.73	35.731	346200.0
2004-03-08 18:00:00	QQQ	ETF	35.74	35.77	35.73	35.76	65900.0
2004-03-08 19:00:00	QQQ	ETF	35.77	35.79	35.76	35.78	11300.0
2004-03-08 09:00:00	IWM	ETF	59.94	60.16	59.87	60.085	571800.0
2004-03-08 10:00:00	IWM	ETF	59.98	60.025	59.8	59.8	854800.0
2004-03-08 11:00:00	IWM	ETF	59.78	59.97	59.78	59.97	228000.0
2004-03-08 12:00:00	IWM	ETF	59.99	60.0	59.675	59.83	652000.0
2004-03-08 13:00:00	IWM	ETF	59.82	59.865	59.35	59.35	681000.0
2004-03-08 14:00:00	IWM	ETF	59.35	59.4	59.13	59.29	1940600.0
2004-03-08 15:00:00	IWM	ETF	59.295	59.295	58.96	58.98	1766400.0
2004-03-08 16:00:00	IWM	ETF	58.9	59.075	58.865	58.9	452800.0
2004-03-08 08:00:00	DIA	ETF	106.32	106.32	106.32	106.32	500.0
2004-03-08 09:00:00	DIA	ETF	106.32	106.54	106.18	106.44	562700.0
2004-03-08 10:00:00	DIA	ETF	106.42	106.46	106.22	106.23	220300.0
2004-03-08 11:00:00	DIA	ETF	106.25	106.43	106.21	106.37	163100.0
2004-03-08 12:00:00	DIA	ETF	106.38	106.42	106.25	106.35	301200.0
2004-03-08 13:00:00	DIA	ETF	106.37	106.37	106.0	106.05	462500.0
2004-03-08 14:00:00	DIA	ETF	106.03	106.14	105.77	105.86	896200.0
2004-03-08 15:00:00	DIA	ETF	105.87	105.89	105.44	105.46	1074400.0
2004-03-08 16:00:00	DIA	ETF	105.48	105.5	105.16	105.21	200400.0
2004-03-08 17:00:00	DIA	ETF	105.21	105.21	105.16	105.16	700.0
2004-03-08 19:00:00	DIA	ETF	105.26	105.26	105.26	105.26	400.0
2004-03-08 09:00:00	TLT	ETF	89.99	90.26	89.99	90.24	471900.0
2004-03-08 10:00:00	TLT	ETF	90.22	90.32	90.11	90.16	333300.0
2004-03-08 11:00:00	TLT	ETF	90.11	90.23	90.05	90.05	56800.0
2004-03-08 12:00:00	TLT	ETF	90.05	90.12	90.03	90.03	64900.0
2004-03-08 13:00:00	TLT	ETF	90.05	90.16	90.0	90.16	74700.0
2004-03-08 14:00:00	TLT	ETF	90.18	90.22	90.12	90.18	208300.0
2004-03-08 15:00:00	TLT	ETF	90.18	90.21	90.14	90.16	55100.0
2004-03-08 16:00:00	TLT	ETF	90.17	90.19	90.16	90.17	38700.0

> showing 50 of 720 rows — these rows as CSV

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