PREVIEW / etf_1hour / 2008-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-16.parquet
  size:    119 KB
  rows:    3,908

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-12-16 04:00:00	SPY	ETF	88.02	88.56	88.02	88.34	800.0
2008-12-16 05:00:00	SPY	ETF	88.25	88.4	88.2	88.4	1300.0
2008-12-16 06:00:00	SPY	ETF	88.01	88.1	87.98	88.08	105400.0
2008-12-16 07:00:00	SPY	ETF	88.14	88.8	88.03	88.41	1035928.0
2008-12-16 08:00:00	SPY	ETF	88.43	88.89	87.65	88.6	6035480.0
2008-12-16 09:00:00	SPY	ETF	88.61	89.0	88.18	88.58	35306830.0
2008-12-16 10:00:00	SPY	ETF	88.59	89.09	88.34	88.67	34239105.0
2008-12-16 11:00:00	SPY	ETF	88.67	89.15	88.59	89.048	19908859.0
2008-12-16 12:00:00	SPY	ETF	89.04	89.09	88.72	88.72	12749029.0
2008-12-16 13:00:00	SPY	ETF	88.71	89.05	88.65	88.81	18341186.0
2008-12-16 14:00:00	SPY	ETF	88.81	90.5	88.75	90.266	96471815.0
2008-12-16 15:00:00	SPY	ETF	90.27	92.02	89.7	91.84	117496253.0
2008-12-16 16:00:00	SPY	ETF	91.89	92.03	87.3731	91.75	27476368.0
2008-12-16 17:00:00	SPY	ETF	91.75	91.88	91.6	91.7	2184077.0
2008-12-16 18:00:00	SPY	ETF	91.7	91.98	91.7	91.92	215145.0
2008-12-16 19:00:00	SPY	ETF	91.87	91.87	91.53	91.53	1160376.0
2008-12-16 04:00:00	QQQ	ETF	29.46	29.59	29.46	29.59	300.0
2008-12-16 05:00:00	QQQ	ETF	29.5	29.5	29.5	29.5	300.0
2008-12-16 06:00:00	QQQ	ETF	29.42	29.52	29.42	29.52	3754.0
2008-12-16 07:00:00	QQQ	ETF	29.49	29.73	29.49	29.56	122404.0
2008-12-16 08:00:00	QQQ	ETF	29.56	29.69	29.46	29.59	2355210.0
2008-12-16 09:00:00	QQQ	ETF	29.59	29.68	29.4	29.62	17769355.0
2008-12-16 10:00:00	QQQ	ETF	29.62	29.72	29.53	29.68	15009821.0
2008-12-16 11:00:00	QQQ	ETF	29.67	29.93	29.6	29.87	11612405.0
2008-12-16 12:00:00	QQQ	ETF	29.88	29.89	29.76	29.76	5151882.0
2008-12-16 13:00:00	QQQ	ETF	29.7601	29.85	29.71	29.7304	5932480.0
2008-12-16 14:00:00	QQQ	ETF	29.73	30.32	29.71	30.14	39481523.0
2008-12-16 15:00:00	QQQ	ETF	30.15	30.66	29.96	30.56	61291054.0
2008-12-16 16:00:00	QQQ	ETF	30.56	30.59	29.85	30.43	7035507.0
2008-12-16 17:00:00	QQQ	ETF	30.42	30.45	30.33	30.39	181274.0
2008-12-16 18:00:00	QQQ	ETF	30.4	30.55	30.4	30.53	2616506.0
2008-12-16 19:00:00	QQQ	ETF	30.53	30.53	30.46	30.51	111748.0
2008-12-16 04:00:00	IWM	ETF	46.2	46.2	46.2	46.2	100.0
2008-12-16 07:00:00	IWM	ETF	46.04	46.43	46.04	46.34	55622.0
2008-12-16 08:00:00	IWM	ETF	46.34	46.7	46.2	46.35	412152.0
2008-12-16 09:00:00	IWM	ETF	46.35	46.58	46.1	46.23	8187377.0
2008-12-16 10:00:00	IWM	ETF	46.25	46.62	46.19	46.47	9375664.0
2008-12-16 11:00:00	IWM	ETF	46.47	46.88	46.45	46.82	7613978.0
2008-12-16 12:00:00	IWM	ETF	46.81	46.84	46.68	46.68	4542212.0
2008-12-16 13:00:00	IWM	ETF	46.68	46.82	46.52	46.65	5419471.0
2008-12-16 14:00:00	IWM	ETF	46.66	47.29	46.34	47.05	26353279.0
2008-12-16 15:00:00	IWM	ETF	47.05	48.48	46.85	48.31	37474646.0
2008-12-16 16:00:00	IWM	ETF	48.25	48.51	45.4	48.25	7859397.0
2008-12-16 17:00:00	IWM	ETF	48.25	48.5	45.4	48.23	1536210.0
2008-12-16 18:00:00	IWM	ETF	48.23	48.5	48.23	48.5	1640.0
2008-12-16 19:00:00	IWM	ETF	48.3	48.33	48.2	48.2	2347.0
2008-12-16 07:00:00	DIA	ETF	86.73	86.75	86.7	86.74	4721.0
2008-12-16 08:00:00	DIA	ETF	86.56	87.02	86.42	86.77	106974.0
2008-12-16 09:00:00	DIA	ETF	86.76	87.0	86.34	86.67	3680107.0
2008-12-16 10:00:00	DIA	ETF	86.68	87.03	86.33	86.72	3712202.0

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

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