PREVIEW / etf_1hour / 2008-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-12.parquet
  size:    115 KB
  rows:    3,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
2008-11-12 04:00:00	SPY	ETF	90.0	90.13	89.6	89.6	2700.0
2008-11-12 05:00:00	SPY	ETF	89.7	89.7	89.5	89.69	8549.0
2008-11-12 06:00:00	SPY	ETF	89.8	90.56	89.79	90.56	47900.0
2008-11-12 07:00:00	SPY	ETF	90.6	90.75	89.16	89.25	1490933.0
2008-11-12 08:00:00	SPY	ETF	89.27	90.9	88.54	88.74	5633164.0
2008-11-12 09:00:00	SPY	ETF	88.76	88.95	87.91	88.4975	50769346.0
2008-11-12 10:00:00	SPY	ETF	88.49	89.77	86.97	87.46	83838766.0
2008-11-12 11:00:00	SPY	ETF	87.46	87.76	86.81	87.39	51521489.0
2008-11-12 12:00:00	SPY	ETF	87.4	87.91	86.92	87.82	40746443.0
2008-11-12 13:00:00	SPY	ETF	87.815	87.97	86.5	86.69	32961395.0
2008-11-12 14:00:00	SPY	ETF	86.68	87.35	86.1	86.31	50759905.0
2008-11-12 15:00:00	SPY	ETF	86.3	90.1516	85.12	85.68	107270554.0
2008-11-12 16:00:00	SPY	ETF	85.66	88.02	85.45	85.72	24859201.0
2008-11-12 17:00:00	SPY	ETF	85.77	86.9285	84.49	84.7	3410973.0
2008-11-12 18:00:00	SPY	ETF	84.71	85.02	84.7	84.95	152521.0
2008-11-12 19:00:00	SPY	ETF	84.95	85.19	84.83	84.84	169683.0
2008-11-12 04:00:00	QQQ	ETF	29.99	29.99	29.81	29.81	200.0
2008-11-12 05:00:00	QQQ	ETF	29.88	29.88	29.88	29.88	100.0
2008-11-12 06:00:00	QQQ	ETF	30.02	30.24	30.02	30.2	1600.0
2008-11-12 07:00:00	QQQ	ETF	30.28	30.3	29.82	29.85	123335.0
2008-11-12 08:00:00	QQQ	ETF	29.85	29.87	29.64	29.71	2214649.0
2008-11-12 09:00:00	QQQ	ETF	29.72	29.8	29.42	29.6005	21673684.0
2008-11-12 10:00:00	QQQ	ETF	29.6	29.75	29.29	29.5001	33001086.0
2008-11-12 11:00:00	QQQ	ETF	29.5	29.5399	29.22	29.34	20132005.0
2008-11-12 12:00:00	QQQ	ETF	29.34	29.47	29.15	29.46	15237722.0
2008-11-12 13:00:00	QQQ	ETF	29.46	29.5	29.06	29.12	17068361.0
2008-11-12 14:00:00	QQQ	ETF	29.1	29.15	28.87	28.8799	20441527.0
2008-11-12 15:00:00	QQQ	ETF	28.87	28.99	28.65	28.74	45928270.0
2008-11-12 16:00:00	QQQ	ETF	28.73	29.5037	28.53	28.55	5675747.0
2008-11-12 17:00:00	QQQ	ETF	28.55	28.55	28.06	28.14	1857411.0
2008-11-12 18:00:00	QQQ	ETF	28.14	28.19	28.11	28.16	92364.0
2008-11-12 19:00:00	QQQ	ETF	28.16	28.25	28.16	28.2	82783.0
2008-11-12 07:00:00	IWM	ETF	48.5	48.52	47.91	47.91	25500.0
2008-11-12 08:00:00	IWM	ETF	48.2	48.38	47.61	47.71	584006.0
2008-11-12 09:00:00	IWM	ETF	47.74	48.38	47.03	47.59	8807926.0
2008-11-12 10:00:00	IWM	ETF	47.6	48.38	46.67	47.0	12427196.0
2008-11-12 11:00:00	IWM	ETF	47.02	47.53	46.65	46.88	10238742.0
2008-11-12 12:00:00	IWM	ETF	46.88	46.94	46.28	46.7	6690302.0
2008-11-12 13:00:00	IWM	ETF	46.7	46.78	46.19	46.25	5727543.0
2008-11-12 14:00:00	IWM	ETF	46.25	46.35	45.74	45.74	9601093.0
2008-11-12 15:00:00	IWM	ETF	45.74	46.17	45.32	45.51	15226073.0
2008-11-12 16:00:00	IWM	ETF	45.5	45.8	45.23	45.5	3890132.0
2008-11-12 17:00:00	IWM	ETF	45.3	45.3	44.68	44.68	64402.0
2008-11-12 18:00:00	IWM	ETF	44.76	44.79	44.76	44.79	300.0
2008-11-12 07:00:00	DIA	ETF	87.41	87.41	86.54	86.54	2162.0
2008-11-12 08:00:00	DIA	ETF	86.31	86.44	85.75	85.84	127323.0
2008-11-12 09:00:00	DIA	ETF	85.9	86.0	85.01	85.56	3950799.0
2008-11-12 10:00:00	DIA	ETF	85.54	85.9	84.04	84.4	7874141.0
2008-11-12 11:00:00	DIA	ETF	84.41	84.83	83.95	84.53	5467066.0
2008-11-12 12:00:00	DIA	ETF	84.53	85.11	84.2	85.08	2560452.0

> showing 50 of 3,751 rows — these rows as CSV

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