PREVIEW / etf_1hour / 2004-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-09.parquet
  size:    24 KB
  rows:    689

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-08-09 08:00:00	SPY	ETF	107.16	107.19	106.99	107.14	239000.0
2004-08-09 09:00:00	SPY	ETF	107.1	107.29	106.97	107.07	6425400.0
2004-08-09 10:00:00	SPY	ETF	107.11	107.37	106.87	107.37	7801800.0
2004-08-09 11:00:00	SPY	ETF	107.36	107.38	107.17	107.2	3621700.0
2004-08-09 12:00:00	SPY	ETF	107.2	107.25	107.04	107.1	4231600.0
2004-08-09 13:00:00	SPY	ETF	107.12	107.27	107.09	107.17	2349500.0
2004-08-09 14:00:00	SPY	ETF	107.18	107.48	107.07	107.28	5235900.0
2004-08-09 15:00:00	SPY	ETF	107.27	107.39	106.99	107.01	4345400.0
2004-08-09 16:00:00	SPY	ETF	107.01	107.04	106.924	106.97	1477400.0
2004-08-09 17:00:00	SPY	ETF	107.01	107.04	106.97	107.0	4800.0
2004-08-09 18:00:00	SPY	ETF	107.05	107.12	107.05	107.12	900.0
2004-08-09 08:00:00	QQQ	ETF	32.83	32.88	32.82	32.87	141100.0
2004-08-09 09:00:00	QQQ	ETF	32.86	32.94	32.78	32.78	11767200.0
2004-08-09 10:00:00	QQQ	ETF	32.785	32.93	32.67	32.93	18866600.0
2004-08-09 11:00:00	QQQ	ETF	32.93	32.938	32.82	32.86	7731400.0
2004-08-09 12:00:00	QQQ	ETF	32.86	32.87	32.77	32.8	8947400.0
2004-08-09 13:00:00	QQQ	ETF	32.8	32.92	32.78	32.874	6324200.0
2004-08-09 14:00:00	QQQ	ETF	32.874	32.96	32.79	32.911	8898100.0
2004-08-09 15:00:00	QQQ	ETF	32.91	32.93	32.75	32.8	11012400.0
2004-08-09 16:00:00	QQQ	ETF	32.79	32.85	32.78	32.82	1812700.0
2004-08-09 17:00:00	QQQ	ETF	32.821	32.86	32.82	32.849	1030600.0
2004-08-09 18:00:00	QQQ	ETF	32.848	32.86	32.83	32.84	34500.0
2004-08-09 19:00:00	QQQ	ETF	32.84	32.84	32.84	32.84	900.0
2004-08-09 08:00:00	IWM	ETF	51.985	51.985	51.985	51.985	200.0
2004-08-09 09:00:00	IWM	ETF	51.995	52.055	51.885	51.94	1784000.0
2004-08-09 10:00:00	IWM	ETF	51.945	52.12	51.665	51.98	2363800.0
2004-08-09 11:00:00	IWM	ETF	51.98	52.05	51.765	51.765	915200.0
2004-08-09 12:00:00	IWM	ETF	51.75	51.85	51.675	51.74	769400.0
2004-08-09 13:00:00	IWM	ETF	51.715	51.85	51.71	51.79	488400.0
2004-08-09 14:00:00	IWM	ETF	51.775	51.775	51.62	51.725	1830600.0
2004-08-09 15:00:00	IWM	ETF	51.7	51.805	51.55	51.595	1345600.0
2004-08-09 16:00:00	IWM	ETF	51.6	51.75	51.585	51.655	481400.0
2004-08-09 17:00:00	IWM	ETF	51.7	51.7	51.7	51.7	60000.0
2004-08-09 18:00:00	IWM	ETF	51.715	51.715	51.715	51.715	1000.0
2004-08-09 08:00:00	DIA	ETF	98.55	98.61	98.43	98.5	34100.0
2004-08-09 09:00:00	DIA	ETF	98.53	98.7	98.43	98.51	818200.0
2004-08-09 10:00:00	DIA	ETF	98.52	98.8	98.31	98.78	1092500.0
2004-08-09 11:00:00	DIA	ETF	98.78	98.79	98.57	98.6	495900.0
2004-08-09 12:00:00	DIA	ETF	98.58	98.61	98.45	98.51	392500.0
2004-08-09 13:00:00	DIA	ETF	98.5	98.62	98.48	98.54	137100.0
2004-08-09 14:00:00	DIA	ETF	98.53	98.84	98.44	98.69	1032700.0
2004-08-09 15:00:00	DIA	ETF	98.71	98.73	98.42	98.43	489400.0
2004-08-09 16:00:00	DIA	ETF	98.45	98.46	98.36	98.45	157100.0
2004-08-09 08:00:00	TLT	ETF	86.18	86.2	86.15	86.16	7100.0
2004-08-09 09:00:00	TLT	ETF	86.16	86.25	86.15	86.24	111000.0
2004-08-09 10:00:00	TLT	ETF	86.23	86.34	86.22	86.28	26500.0
2004-08-09 11:00:00	TLT	ETF	86.26	86.29	86.19	86.26	35100.0
2004-08-09 12:00:00	TLT	ETF	86.26	86.26	86.18	86.18	41000.0
2004-08-09 13:00:00	TLT	ETF	86.2	86.24	86.16	86.18	23800.0
2004-08-09 14:00:00	TLT	ETF	86.18	86.26	86.18	86.26	33900.0

> showing 50 of 689 rows — these rows as CSV

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