PREVIEW / etf_1hour / 2004-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-01.parquet
  size:    25 KB
  rows:    701

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-07-01 08:00:00	SPY	ETF	114.51	114.51	114.3	114.39	53500.0
2004-07-01 09:00:00	SPY	ETF	114.39	114.47	114.04	114.09	4192500.0
2004-07-01 10:00:00	SPY	ETF	114.09	114.28	113.53	113.55	6576300.0
2004-07-01 11:00:00	SPY	ETF	113.53	113.57	112.85	113.09	12360400.0
2004-07-01 12:00:00	SPY	ETF	113.08	113.23	112.91	113.19	3993800.0
2004-07-01 13:00:00	SPY	ETF	113.18	113.23	112.58	112.76	6515300.0
2004-07-01 14:00:00	SPY	ETF	112.77	113.16	112.71	113.08	6531100.0
2004-07-01 15:00:00	SPY	ETF	113.09	113.4	112.91	113.2	10058500.0
2004-07-01 16:00:00	SPY	ETF	113.19	113.59	112.9	113.06	2459700.0
2004-07-01 17:00:00	SPY	ETF	113.0	113.0	112.95	113.0	13600.0
2004-07-01 18:00:00	SPY	ETF	112.97	113.01	112.93	112.98	34900.0
2004-07-01 08:00:00	QQQ	ETF	37.76	37.76	37.62	37.64	158700.0
2004-07-01 09:00:00	QQQ	ETF	37.64	37.67	37.43	37.483	9481200.0
2004-07-01 10:00:00	QQQ	ETF	37.48	37.531	37.19	37.2	21571200.0
2004-07-01 11:00:00	QQQ	ETF	37.2	37.22	36.98	37.021	23337300.0
2004-07-01 12:00:00	QQQ	ETF	37.02	37.1	36.94	37.08	12301100.0
2004-07-01 13:00:00	QQQ	ETF	37.09	37.09	36.77	36.88	13823500.0
2004-07-01 14:00:00	QQQ	ETF	36.881	37.054	36.86	37.025	13682700.0
2004-07-01 15:00:00	QQQ	ETF	37.02	37.12	36.9	37.04	17552700.0
2004-07-01 16:00:00	QQQ	ETF	37.06	37.105	37.0	37.04	2592100.0
2004-07-01 17:00:00	QQQ	ETF	37.04	37.043	37.01	37.02	45800.0
2004-07-01 18:00:00	QQQ	ETF	37.04	37.05	37.04	37.05	23700.0
2004-07-01 19:00:00	QQQ	ETF	37.04	37.09	37.02	37.05	10500.0
2004-07-01 08:00:00	IWM	ETF	58.82	58.82	58.81	58.81	3000.0
2004-07-01 09:00:00	IWM	ETF	58.91	59.04	58.7	58.745	1547000.0
2004-07-01 10:00:00	IWM	ETF	58.745	58.76	58.305	58.315	2735400.0
2004-07-01 11:00:00	IWM	ETF	58.275	58.28	58.06	58.19	2838600.0
2004-07-01 12:00:00	IWM	ETF	58.16	58.29	58.085	58.29	740600.0
2004-07-01 13:00:00	IWM	ETF	58.28	58.34	57.99	58.015	2273000.0
2004-07-01 14:00:00	IWM	ETF	58.04	58.205	57.975	58.1493	1707400.0
2004-07-01 15:00:00	IWM	ETF	58.15	58.25	58.0	58.085	2947800.0
2004-07-01 16:00:00	IWM	ETF	58.09	58.165	57.92	57.995	490800.0
2004-07-01 17:00:00	IWM	ETF	58.0	58.025	57.92	57.92	69600.0
2004-07-01 08:00:00	DIA	ETF	104.57	104.59	104.48	104.55	23700.0
2004-07-01 09:00:00	DIA	ETF	104.55	104.65	104.43	104.47	1078300.0
2004-07-01 10:00:00	DIA	ETF	104.47	104.62	103.93	103.93	891100.0
2004-07-01 11:00:00	DIA	ETF	103.96	103.97	103.32	103.47	1835800.0
2004-07-01 12:00:00	DIA	ETF	103.47	103.6	103.33	103.59	1062700.0
2004-07-01 13:00:00	DIA	ETF	103.58	103.59	102.94	103.03	1252700.0
2004-07-01 14:00:00	DIA	ETF	103.04	103.41	103.0	103.36	926800.0
2004-07-01 15:00:00	DIA	ETF	103.34	103.67	103.22	103.45	2100800.0
2004-07-01 16:00:00	DIA	ETF	103.48	103.53	103.26	103.31	52600.0
2004-07-01 17:00:00	DIA	ETF	103.26	103.26	103.22	103.22	600.0
2004-07-01 09:00:00	TLT	ETF	83.35	83.42	83.29	83.4	108400.0
2004-07-01 10:00:00	TLT	ETF	83.4	83.4	83.06	83.2	136100.0
2004-07-01 11:00:00	TLT	ETF	83.19	83.19	82.93	82.93	73000.0
2004-07-01 12:00:00	TLT	ETF	82.93	83.15	82.93	83.12	121200.0
2004-07-01 13:00:00	TLT	ETF	83.09	83.3	83.09	83.29	85700.0
2004-07-01 14:00:00	TLT	ETF	83.31	83.45	83.26	83.4	137200.0
2004-07-01 15:00:00	TLT	ETF	83.42	83.56	83.4	83.43	256200.0

> showing 50 of 701 rows — these rows as CSV

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