PREVIEW / etf_1hour / 2008-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-30.parquet
  size:    129 KB
  rows:    3,946

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-30 04:00:00	SPY	ETF	88.04	88.07	87.99	87.99	2914.0
2008-12-30 05:00:00	SPY	ETF	87.98	88.02	87.93	87.93	485.0
2008-12-30 06:00:00	SPY	ETF	87.79	87.79	87.5	87.66	3085.0
2008-12-30 07:00:00	SPY	ETF	87.68	87.81	87.55	87.71	425508.0
2008-12-30 08:00:00	SPY	ETF	87.71	88.06	87.65	87.67	1111239.0
2008-12-30 09:00:00	SPY	ETF	87.67	87.8	87.25	87.28	16617435.0
2008-12-30 10:00:00	SPY	ETF	87.28	87.94	87.09	87.68	25860218.0
2008-12-30 11:00:00	SPY	ETF	87.68	88.47	87.58	88.35	22015445.0
2008-12-30 12:00:00	SPY	ETF	88.36	88.48	87.85	88.18	25724549.0
2008-12-30 13:00:00	SPY	ETF	88.18	88.23	87.79	87.8899	15845789.0
2008-12-30 14:00:00	SPY	ETF	87.89	88.3	87.72	88.03	15438905.0
2008-12-30 15:00:00	SPY	ETF	88.03	89.05	87.32	88.9	38658275.0
2008-12-30 16:00:00	SPY	ETF	88.88	89.21	88.86	89.15	5696979.0
2008-12-30 17:00:00	SPY	ETF	89.14	89.24	88.97	89.15	131328.0
2008-12-30 18:00:00	SPY	ETF	89.17	89.44	89.17	89.32	137019.0
2008-12-30 19:00:00	SPY	ETF	89.32	89.39	89.17	89.35	222519.0
2008-12-30 04:00:00	QQQ	ETF	29.22	29.22	29.22	29.22	575.0
2008-12-30 05:00:00	QQQ	ETF	29.21	29.21	29.21	29.21	100.0
2008-12-30 06:00:00	QQQ	ETF	29.18	29.18	29.01	29.12	82402.0
2008-12-30 07:00:00	QQQ	ETF	29.12	29.17	29.08	29.14	33329.0
2008-12-30 08:00:00	QQQ	ETF	29.15	29.18	29.05	29.05	390593.0
2008-12-30 09:00:00	QQQ	ETF	29.05	29.11	28.94	29.01	7800420.0
2008-12-30 10:00:00	QQQ	ETF	29.01	29.31	28.96	29.2	11632426.0
2008-12-30 11:00:00	QQQ	ETF	29.19	29.59	29.16	29.54	12183943.0
2008-12-30 12:00:00	QQQ	ETF	29.54	29.57	29.29	29.4	10800259.0
2008-12-30 13:00:00	QQQ	ETF	29.3901	29.42	29.26	29.2799	6968675.0
2008-12-30 14:00:00	QQQ	ETF	29.28	29.4	29.21	29.3	6374259.0
2008-12-30 15:00:00	QQQ	ETF	29.29	29.55	29.23	29.47	13862082.0
2008-12-30 16:00:00	QQQ	ETF	29.48	29.67	29.46	29.62	4010502.0
2008-12-30 17:00:00	QQQ	ETF	29.63	29.65	29.61	29.64	18158.0
2008-12-30 18:00:00	QQQ	ETF	29.64	29.7	29.64	29.65	44173.0
2008-12-30 19:00:00	QQQ	ETF	29.66	29.67	29.64	29.66	7200.0
2008-12-30 06:00:00	IWM	ETF	47.03	47.06	47.03	47.06	200.0
2008-12-30 07:00:00	IWM	ETF	47.09	47.12	47.05	47.11	25700.0
2008-12-30 08:00:00	IWM	ETF	47.09	47.45	47.09	47.18	74931.0
2008-12-30 09:00:00	IWM	ETF	47.2	47.29	46.89	46.99	4084200.0
2008-12-30 10:00:00	IWM	ETF	46.99	47.43	46.77	47.17	4737198.0
2008-12-30 11:00:00	IWM	ETF	47.18	47.5	47.16	47.4278	5068524.0
2008-12-30 12:00:00	IWM	ETF	47.42	47.48	47.062	47.25	4150128.0
2008-12-30 13:00:00	IWM	ETF	47.26	47.32	47.09	47.15	2290584.0
2008-12-30 14:00:00	IWM	ETF	47.15	47.46	47.1	47.37	3194426.0
2008-12-30 15:00:00	IWM	ETF	47.37	48.2	47.27	48.07	11142549.0
2008-12-30 16:00:00	IWM	ETF	48.07	48.51	47.4333	48.5	3361279.0
2008-12-30 17:00:00	IWM	ETF	48.5	48.55	48.16	48.54	110890.0
2008-12-30 18:00:00	IWM	ETF	48.5	48.53	48.5	48.5	3180.0
2008-12-30 19:00:00	IWM	ETF	48.5	48.51	48.5	48.51	4445.0
2008-12-30 06:00:00	DIA	ETF	85.54	85.54	85.33	85.33	834.0
2008-12-30 07:00:00	DIA	ETF	85.52	85.57	85.5	85.51	7800.0
2008-12-30 08:00:00	DIA	ETF	85.54	85.68	85.52	85.55	21256.0
2008-12-30 09:00:00	DIA	ETF	85.5	85.59	84.97	85.0	1982863.0

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

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