PREVIEW / etf_1hour / 2004-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-25.parquet
  size:    25 KB
  rows:    675

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-06-25 08:00:00	SPY	ETF	114.52	114.53	114.36	114.39	232300.0
2004-06-25 09:00:00	SPY	ETF	114.39	114.7	114.32	114.65	4894500.0
2004-06-25 10:00:00	SPY	ETF	114.66	114.94	114.5	114.74	5639300.0
2004-06-25 11:00:00	SPY	ETF	114.74	114.82	114.5	114.54	2834400.0
2004-06-25 12:00:00	SPY	ETF	114.55	114.58	114.33	114.48	2583500.0
2004-06-25 13:00:00	SPY	ETF	114.47	114.58	114.36	114.4	1969800.0
2004-06-25 14:00:00	SPY	ETF	114.39	114.42	113.95	114.02	5689400.0
2004-06-25 15:00:00	SPY	ETF	114.02	114.23	113.97	114.13	3390700.0
2004-06-25 16:00:00	SPY	ETF	114.13	114.178	113.68	114.01	4475600.0
2004-06-25 17:00:00	SPY	ETF	113.95	114.02	113.9	114.0	151900.0
2004-06-25 18:00:00	SPY	ETF	114.0	114.03	113.96	113.96	3000.0
2004-06-25 19:00:00	SPY	ETF	113.96	113.99	113.96	113.96	700.0
2004-06-25 08:00:00	QQQ	ETF	37.12	37.12	37.0	37.0	167600.0
2004-06-25 09:00:00	QQQ	ETF	37.02	37.25	36.98	37.22	10485600.0
2004-06-25 10:00:00	QQQ	ETF	37.2	37.39	37.15	37.31	15603400.0
2004-06-25 11:00:00	QQQ	ETF	37.32	37.39	37.21	37.26	9401300.0
2004-06-25 12:00:00	QQQ	ETF	37.26	37.28	37.18	37.244	6928700.0
2004-06-25 13:00:00	QQQ	ETF	37.25	37.3	37.2	37.209	4352700.0
2004-06-25 14:00:00	QQQ	ETF	37.2	37.21	36.98	37.065	16662300.0
2004-06-25 15:00:00	QQQ	ETF	37.07	37.28	37.05	37.24	10370400.0
2004-06-25 16:00:00	QQQ	ETF	37.24	37.342	37.19	37.25	5608600.0
2004-06-25 17:00:00	QQQ	ETF	37.25	37.31	37.22	37.26	151600.0
2004-06-25 18:00:00	QQQ	ETF	37.29	37.29	37.26	37.28	5900.0
2004-06-25 19:00:00	QQQ	ETF	37.28	37.3	37.28	37.3	1400.0
2004-06-25 09:00:00	IWM	ETF	57.59	58.05	57.365	57.975	1210400.0
2004-06-25 10:00:00	IWM	ETF	57.985	58.19	57.85	58.08	1184800.0
2004-06-25 11:00:00	IWM	ETF	58.08	58.13	57.975	57.98	460800.0
2004-06-25 12:00:00	IWM	ETF	58.0	58.04	57.835	57.995	632400.0
2004-06-25 13:00:00	IWM	ETF	58.0	58.125	57.95	58.01	546400.0
2004-06-25 14:00:00	IWM	ETF	57.995	58.005	57.705	57.76	1352000.0
2004-06-25 15:00:00	IWM	ETF	57.725	58.175	57.7	58.135	3750200.0
2004-06-25 16:00:00	IWM	ETF	58.135	58.5	57.86	58.068	2669400.0
2004-06-25 17:00:00	IWM	ETF	58.25	58.25	58.25	58.25	100000.0
2004-06-25 08:00:00	DIA	ETF	104.66	104.66	104.58	104.58	6000.0
2004-06-25 09:00:00	DIA	ETF	104.59	104.81	104.54	104.75	337600.0
2004-06-25 10:00:00	DIA	ETF	104.77	104.99	104.67	104.85	396700.0
2004-06-25 11:00:00	DIA	ETF	104.83	104.89	104.65	104.67	436300.0
2004-06-25 12:00:00	DIA	ETF	104.67	104.69	104.5115	104.61	339100.0
2004-06-25 13:00:00	DIA	ETF	104.6	104.69	104.54	104.59	165200.0
2004-06-25 14:00:00	DIA	ETF	104.6	104.6	104.12	104.19	430600.0
2004-06-25 15:00:00	DIA	ETF	104.16	104.37	104.09	104.26	961400.0
2004-06-25 16:00:00	DIA	ETF	104.29	104.3	103.92	104.05	97600.0
2004-06-25 17:00:00	DIA	ETF	104.4	104.4	104.08	104.14	3300.0
2004-06-25 19:00:00	DIA	ETF	104.1	104.1	104.1	104.1	900.0
2004-06-25 08:00:00	TLT	ETF	83.02	83.02	83.02	83.02	100.0
2004-06-25 09:00:00	TLT	ETF	82.92	82.99	82.87	82.91	17200.0
2004-06-25 10:00:00	TLT	ETF	82.88	83.01	82.88	83.0	18700.0
2004-06-25 11:00:00	TLT	ETF	83.03	83.05	82.98	83.02	14000.0
2004-06-25 12:00:00	TLT	ETF	83.02	83.06	83.0	83.0	18700.0
2004-06-25 13:00:00	TLT	ETF	82.95	83.07	82.94	83.07	158000.0

> showing 50 of 675 rows — these rows as CSV

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