PREVIEW / etf_1hour / 2004-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-01.parquet
  size:    25 KB
  rows:    694

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-04-01 08:00:00	SPY	ETF	112.87	113.15	112.87	113.13	84700.0
2004-04-01 09:00:00	SPY	ETF	113.11	113.32	113.05	113.17	5151100.0
2004-04-01 10:00:00	SPY	ETF	113.17	113.87	113.16	113.76	13812800.0
2004-04-01 11:00:00	SPY	ETF	113.76	113.84	113.57	113.6	4369800.0
2004-04-01 12:00:00	SPY	ETF	113.62	113.68	113.26	113.34	4007500.0
2004-04-01 13:00:00	SPY	ETF	113.36	113.7	113.34	113.61	2110600.0
2004-04-01 14:00:00	SPY	ETF	113.62	113.73	113.4	113.43	3148500.0
2004-04-01 15:00:00	SPY	ETF	113.43	113.6	113.21	113.49	7585700.0
2004-04-01 16:00:00	SPY	ETF	113.5	113.78	113.4605	113.7	2404500.0
2004-04-01 17:00:00	SPY	ETF	113.69	113.72	113.65	113.65	29000.0
2004-04-01 18:00:00	SPY	ETF	113.73	113.75	113.69	113.72	10500.0
2004-04-01 19:00:00	SPY	ETF	113.72	113.78	113.72	113.78	25000.0
2004-04-01 08:00:00	QQQ	ETF	35.74	35.85	35.72	35.85	191100.0
2004-04-01 09:00:00	QQQ	ETF	35.85	35.94	35.78	35.821	9918400.0
2004-04-01 10:00:00	QQQ	ETF	35.824	36.25	35.824	36.17	29356900.0
2004-04-01 11:00:00	QQQ	ETF	36.18	36.23	36.02	36.04	9816600.0
2004-04-01 12:00:00	QQQ	ETF	36.04	36.08	35.92	35.95	8734800.0
2004-04-01 13:00:00	QQQ	ETF	35.95	36.09	35.95	36.06	5407800.0
2004-04-01 14:00:00	QQQ	ETF	36.06	36.16	35.97	36.032	7824900.0
2004-04-01 15:00:00	QQQ	ETF	36.032	36.113	35.96	36.08	14461600.0
2004-04-01 16:00:00	QQQ	ETF	36.1	36.2	36.08	36.19	3811100.0
2004-04-01 17:00:00	QQQ	ETF	36.18	36.2	36.15	36.15	112400.0
2004-04-01 18:00:00	QQQ	ETF	36.19	36.21	36.17	36.2	42500.0
2004-04-01 19:00:00	QQQ	ETF	36.2	36.21	36.2	36.2	5600.0
2004-04-01 08:00:00	IWM	ETF	58.745	58.79	58.745	58.745	9400.0
2004-04-01 09:00:00	IWM	ETF	58.88	59.2	58.695	59.005	1576600.0
2004-04-01 10:00:00	IWM	ETF	58.995	59.47	58.99	59.405	2121800.0
2004-04-01 11:00:00	IWM	ETF	59.395	59.45	59.07	59.19	754400.0
2004-04-01 12:00:00	IWM	ETF	59.175	59.2	59.0	59.04	630800.0
2004-04-01 13:00:00	IWM	ETF	59.03	59.23	59.01	59.15	332000.0
2004-04-01 14:00:00	IWM	ETF	59.15	59.25	59.08	59.1	627200.0
2004-04-01 15:00:00	IWM	ETF	59.105	59.25	59.02	59.21	2079200.0
2004-04-01 16:00:00	IWM	ETF	59.22	59.445	59.175	59.375	703400.0
2004-04-01 17:00:00	IWM	ETF	59.305	59.305	59.305	59.305	67600.0
2004-04-01 18:00:00	IWM	ETF	59.375	59.425	59.375	59.425	6600.0
2004-04-01 19:00:00	IWM	ETF	59.45	59.475	59.385	59.385	2000.0
2004-04-01 08:00:00	DIA	ETF	103.73	103.81	103.7	103.81	7500.0
2004-04-01 09:00:00	DIA	ETF	103.85	103.87	103.59	103.61	482400.0
2004-04-01 10:00:00	DIA	ETF	103.6	104.37	103.56	104.29	1471500.0
2004-04-01 11:00:00	DIA	ETF	104.28	104.35	104.05	104.08	695000.0
2004-04-01 12:00:00	DIA	ETF	104.1	104.1	103.76	103.81	369700.0
2004-04-01 13:00:00	DIA	ETF	103.81	104.12	103.81	104.0	663300.0
2004-04-01 14:00:00	DIA	ETF	104.02	104.16	103.84	103.89	325900.0
2004-04-01 15:00:00	DIA	ETF	103.89	104.03	103.62	103.93	1652600.0
2004-04-01 16:00:00	DIA	ETF	103.88	104.13	103.88	104.07	105200.0
2004-04-01 17:00:00	DIA	ETF	104.01	104.01	104.01	104.01	400.0
2004-04-01 18:00:00	DIA	ETF	104.08	104.09	104.08	104.09	300.0
2004-04-01 09:00:00	TLT	ETF	88.98	89.06	88.93	89.03	129300.0
2004-04-01 10:00:00	TLT	ETF	89.0	89.0	88.55	88.56	350800.0
2004-04-01 11:00:00	TLT	ETF	88.57	88.84	88.56	88.73	319600.0

> showing 50 of 694 rows — these rows as CSV

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