PREVIEW / etf_1hour / 2004-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-15.parquet
  size:    24 KB
  rows:    639

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-15 08:00:00	SPY	ETF	113.31	113.66	113.25	113.54	54900.0
2004-01-15 09:00:00	SPY	ETF	113.56	113.69	113.11	113.15	4878000.0
2004-01-15 10:00:00	SPY	ETF	113.15	113.24	112.73	113.02	6350800.0
2004-01-15 11:00:00	SPY	ETF	113.02	113.5	112.93	113.37	3566300.0
2004-01-15 12:00:00	SPY	ETF	113.39	113.87	113.26	113.78	7883500.0
2004-01-15 13:00:00	SPY	ETF	113.77	114.06	113.65	113.91	4333000.0
2004-01-15 14:00:00	SPY	ETF	113.89	113.93	113.47	113.6	3480500.0
2004-01-15 15:00:00	SPY	ETF	113.6	113.61	113.28	113.53	4461700.0
2004-01-15 16:00:00	SPY	ETF	113.55	113.8	113.5	113.73	991200.0
2004-01-15 17:00:00	SPY	ETF	113.76	113.82	113.69	113.82	76900.0
2004-01-15 18:00:00	SPY	ETF	113.76	113.85	113.68	113.85	18400.0
2004-01-15 19:00:00	SPY	ETF	113.85	113.88	113.85	113.88	1900.0
2004-01-15 08:00:00	QQQ	ETF	37.88	38.02	37.85	37.91	289500.0
2004-01-15 09:00:00	QQQ	ETF	37.92	38.07	37.77	37.78	12333700.0
2004-01-15 10:00:00	QQQ	ETF	37.78	37.91	37.63	37.77	17544200.0
2004-01-15 11:00:00	QQQ	ETF	37.77	38.11	37.704	38.03	9927500.0
2004-01-15 12:00:00	QQQ	ETF	38.02	38.38	37.9	38.271	23249700.0
2004-01-15 13:00:00	QQQ	ETF	38.27	38.46	38.23	38.359	8392200.0
2004-01-15 14:00:00	QQQ	ETF	38.4	38.4	38.11	38.181	11408000.0
2004-01-15 15:00:00	QQQ	ETF	38.18	38.23	38.02	38.12	13385200.0
2004-01-15 16:00:00	QQQ	ETF	38.121	38.22	38.073	38.18	3099500.0
2004-01-15 17:00:00	QQQ	ETF	38.173	38.34	38.17	38.3	156800.0
2004-01-15 18:00:00	QQQ	ETF	38.3	38.35	38.24	38.31	129600.0
2004-01-15 19:00:00	QQQ	ETF	38.31	38.31	38.29	38.31	33600.0
2004-01-15 08:00:00	IWM	ETF	58.205	58.205	58.205	58.205	2000.0
2004-01-15 09:00:00	IWM	ETF	58.295	58.505	58.01	58.025	765200.0
2004-01-15 10:00:00	IWM	ETF	58.015	58.1015	57.64	57.85	1360400.0
2004-01-15 11:00:00	IWM	ETF	57.825	58.25	57.75	58.225	911600.0
2004-01-15 12:00:00	IWM	ETF	58.24	58.4045	58.142	58.34	913200.0
2004-01-15 13:00:00	IWM	ETF	58.31	58.5515	58.27	58.5	427400.0
2004-01-15 14:00:00	IWM	ETF	58.475	58.525	58.305	58.365	408600.0
2004-01-15 15:00:00	IWM	ETF	58.36	58.471	58.25	58.42	797000.0
2004-01-15 16:00:00	IWM	ETF	58.405	58.5275	58.39	58.44	490600.0
2004-01-15 08:00:00	DIA	ETF	105.74	106.06	105.65	106.06	36500.0
2004-01-15 09:00:00	DIA	ETF	106.06	106.18	105.42	105.42	1616400.0
2004-01-15 10:00:00	DIA	ETF	105.42	105.58	104.97	105.24	2365600.0
2004-01-15 11:00:00	DIA	ETF	105.2	105.66	105.16	105.6	1000300.0
2004-01-15 12:00:00	DIA	ETF	105.59	105.97	105.43	105.83	1460500.0
2004-01-15 13:00:00	DIA	ETF	105.84	106.12	105.79	105.99	664500.0
2004-01-15 14:00:00	DIA	ETF	105.98	106.0	105.673	105.76	681300.0
2004-01-15 15:00:00	DIA	ETF	105.75	105.8	105.401	105.74	1145800.0
2004-01-15 16:00:00	DIA	ETF	105.8	105.97	105.74	105.94	293800.0
2004-01-15 17:00:00	DIA	ETF	106.0	106.02	106.0	106.0	1200.0
2004-01-15 18:00:00	DIA	ETF	106.0	106.05	106.0	106.05	8600.0
2004-01-15 19:00:00	DIA	ETF	106.08	106.08	106.08	106.08	100.0
2004-01-15 09:00:00	TLT	ETF	87.95	87.95	87.6	87.74	531800.0
2004-01-15 10:00:00	TLT	ETF	87.81	88.1	87.74	88.1	158400.0
2004-01-15 11:00:00	TLT	ETF	88.09	88.2	88.0	88.04	77100.0
2004-01-15 12:00:00	TLT	ETF	88.05	88.1	87.8	87.87	108700.0
2004-01-15 13:00:00	TLT	ETF	87.88	88.04	87.86	88.0	71400.0

> showing 50 of 639 rows — these rows as CSV

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