PREVIEW / etf_1hour / 2004-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-01.parquet
  size:    26 KB
  rows:    751

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-11-01 08:00:00	SPY	ETF	113.48	113.59	113.48	113.58	27300.0
2004-11-01 09:00:00	SPY	ETF	113.53	113.59	113.37	113.45	3290700.0
2004-11-01 10:00:00	SPY	ETF	113.45	113.52	113.2	113.46	5086300.0
2004-11-01 11:00:00	SPY	ETF	113.46	113.84	113.43	113.64	7443500.0
2004-11-01 12:00:00	SPY	ETF	113.64	113.71	113.49	113.57	3655600.0
2004-11-01 13:00:00	SPY	ETF	113.58	113.59	113.2	113.37	3573500.0
2004-11-01 14:00:00	SPY	ETF	113.37	113.6	113.22	113.51	3112700.0
2004-11-01 15:00:00	SPY	ETF	113.53	113.57	113.35	113.49	3586400.0
2004-11-01 16:00:00	SPY	ETF	113.49	113.58	113.45	113.48	3392700.0
2004-11-01 17:00:00	SPY	ETF	113.46	113.52	113.44	113.51	52700.0
2004-11-01 18:00:00	SPY	ETF	113.47	113.47	113.42	113.42	3200.0
2004-11-01 19:00:00	SPY	ETF	113.45	113.46	113.45	113.46	10000.0
2004-11-01 08:00:00	QQQ	ETF	36.93	36.96	36.92	36.94	109100.0
2004-11-01 09:00:00	QQQ	ETF	36.94	36.99	36.88	36.901	8250200.0
2004-11-01 10:00:00	QQQ	ETF	36.91	37.09	36.8	37.02	12840300.0
2004-11-01 11:00:00	QQQ	ETF	37.01	37.18	37.0	37.1	14680600.0
2004-11-01 12:00:00	QQQ	ETF	37.1	37.165	37.01	37.09	6924200.0
2004-11-01 13:00:00	QQQ	ETF	37.08	37.1	36.86	36.986	9051900.0
2004-11-01 14:00:00	QQQ	ETF	36.99	37.07	36.92	37.033	8177400.0
2004-11-01 15:00:00	QQQ	ETF	37.04	37.042	36.94	37.02	7684900.0
2004-11-01 16:00:00	QQQ	ETF	37.024	37.05	36.92	36.932	3277200.0
2004-11-01 17:00:00	QQQ	ETF	36.936	37.01	36.92	37.01	116000.0
2004-11-01 18:00:00	QQQ	ETF	36.932	36.96	36.92	36.93	116700.0
2004-11-01 19:00:00	QQQ	ETF	36.94	36.95	36.93	36.95	33400.0
2004-11-01 08:00:00	IWM	ETF	58.12	58.17	58.12	58.17	1600.0
2004-11-01 09:00:00	IWM	ETF	58.2	58.35	57.86	58.1	1548200.0
2004-11-01 10:00:00	IWM	ETF	58.1	58.25	57.975	58.15	1281200.0
2004-11-01 11:00:00	IWM	ETF	58.15	58.4	58.15	58.265	1824800.0
2004-11-01 12:00:00	IWM	ETF	58.265	58.335	58.17	58.175	661600.0
2004-11-01 13:00:00	IWM	ETF	58.18	58.28	58.0707	58.225	1577200.0
2004-11-01 14:00:00	IWM	ETF	58.23	58.615	58.2	58.525	2114800.0
2004-11-01 15:00:00	IWM	ETF	58.535	58.625	58.45	58.55	2815600.0
2004-11-01 16:00:00	IWM	ETF	58.515	58.6	58.46	58.6	850400.0
2004-11-01 17:00:00	IWM	ETF	58.475	58.56	58.475	58.56	101000.0
2004-11-01 08:00:00	DIA	ETF	100.51	100.54	100.35	100.49	15300.0
2004-11-01 09:00:00	DIA	ETF	100.47	100.59	100.37	100.51	1095300.0
2004-11-01 10:00:00	DIA	ETF	100.51	100.55	100.3	100.5	738800.0
2004-11-01 11:00:00	DIA	ETF	100.49	100.97	100.48	100.83	1053500.0
2004-11-01 12:00:00	DIA	ETF	100.83	100.87	100.66	100.79	320500.0
2004-11-01 13:00:00	DIA	ETF	100.76	100.77	100.45	100.63	469100.0
2004-11-01 14:00:00	DIA	ETF	100.62	100.8	100.5	100.73	607200.0
2004-11-01 15:00:00	DIA	ETF	100.72	100.79	100.61	100.75	1261800.0
2004-11-01 16:00:00	DIA	ETF	100.75	100.77	100.71	100.76	56200.0
2004-11-01 17:00:00	DIA	ETF	100.75	100.75	100.75	100.75	800.0
2004-11-01 08:00:00	TLT	ETF	88.89	88.89	88.8	88.8	21200.0
2004-11-01 09:00:00	TLT	ETF	88.84	88.85	88.75	88.85	286200.0
2004-11-01 10:00:00	TLT	ETF	88.9	89.0	88.74	88.74	119100.0
2004-11-01 11:00:00	TLT	ETF	88.76	88.76	88.51	88.55	320400.0
2004-11-01 12:00:00	TLT	ETF	88.55	88.61	88.43	88.46	48000.0
2004-11-01 13:00:00	TLT	ETF	88.45	88.58	88.44	88.51	49300.0

> showing 50 of 751 rows — these rows as CSV

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