PREVIEW / etf_1hour / 2008-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-17.parquet
  size:    113 KB
  rows:    3,744

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-17 04:00:00	SPY	ETF	87.7	87.81	86.99	86.99	14000.0
2008-11-17 05:00:00	SPY	ETF	86.89	86.98	86.25	86.25	28600.0
2008-11-17 06:00:00	SPY	ETF	86.3	86.3	85.79	86.06	90471.0
2008-11-17 07:00:00	SPY	ETF	86.09	86.1	85.47	85.74	2156152.0
2008-11-17 08:00:00	SPY	ETF	85.72	87.3	85.4	85.58	3854854.0
2008-11-17 09:00:00	SPY	ETF	85.58	87.02	85.58	86.791	51231835.0
2008-11-17 10:00:00	SPY	ETF	86.79	86.84	85.16	85.4	61056074.0
2008-11-17 11:00:00	SPY	ETF	85.4	87.62	85.36	87.4	46554858.0
2008-11-17 12:00:00	SPY	ETF	87.39	88.56	87.11	87.71	58728716.0
2008-11-17 13:00:00	SPY	ETF	87.71	87.9	86.52	87.29	40572314.0
2008-11-17 14:00:00	SPY	ETF	87.28	87.8	86.49	86.7801	54118495.0
2008-11-17 15:00:00	SPY	ETF	86.79	87.65	85.2	85.39	77043524.0
2008-11-17 16:00:00	SPY	ETF	85.38	87.6224	85.2	85.2	17989271.0
2008-11-17 17:00:00	SPY	ETF	85.2	87.62	85.19	85.34	528758.0
2008-11-17 18:00:00	SPY	ETF	85.34	85.34	85.1	85.3	161017.0
2008-11-17 19:00:00	SPY	ETF	85.32	85.46	85.19	85.29	64626.0
2008-11-17 04:00:00	QQQ	ETF	28.79	28.86	28.66	28.66	5100.0
2008-11-17 05:00:00	QQQ	ETF	28.54	28.54	28.48	28.48	300.0
2008-11-17 06:00:00	QQQ	ETF	28.36	28.36	28.18	28.27	75700.0
2008-11-17 07:00:00	QQQ	ETF	28.26	28.39	28.16	28.36	433948.0
2008-11-17 08:00:00	QQQ	ETF	28.34	28.75	28.2	28.22	1422380.0
2008-11-17 09:00:00	QQQ	ETF	28.22	28.83	28.22	28.75	29035851.0
2008-11-17 10:00:00	QQQ	ETF	28.76	28.78	28.26	28.37	28780342.0
2008-11-17 11:00:00	QQQ	ETF	28.36	28.98	28.36	28.9	20190885.0
2008-11-17 12:00:00	QQQ	ETF	28.8999	29.23	28.83	29.07	24574921.0
2008-11-17 13:00:00	QQQ	ETF	29.07	29.1	28.6	28.818	25308786.0
2008-11-17 14:00:00	QQQ	ETF	28.81	28.97	28.6	28.77	31617902.0
2008-11-17 15:00:00	QQQ	ETF	28.77	29.06	28.32	28.4	37101619.0
2008-11-17 16:00:00	QQQ	ETF	28.39	28.7433	28.37	28.41	3608639.0
2008-11-17 17:00:00	QQQ	ETF	28.41	28.96	28.37	28.42	215896.0
2008-11-17 18:00:00	QQQ	ETF	28.42	28.42	28.36	28.4	65731.0
2008-11-17 19:00:00	QQQ	ETF	28.39	28.45	28.39	28.39	49845.0
2008-11-17 07:00:00	IWM	ETF	44.77	44.8	44.52	44.66	44200.0
2008-11-17 08:00:00	IWM	ETF	44.66	45.64	44.61	44.68	261725.0
2008-11-17 09:00:00	IWM	ETF	44.66	46.01	44.66	45.87	11337762.0
2008-11-17 10:00:00	IWM	ETF	45.87	45.87	44.89	45.05	13846539.0
2008-11-17 11:00:00	IWM	ETF	45.05	46.15	45.02	46.1	8492771.0
2008-11-17 12:00:00	IWM	ETF	46.1	46.58	45.88	46.02	9869513.0
2008-11-17 13:00:00	IWM	ETF	46.02	46.23	45.68	45.98	8517156.0
2008-11-17 14:00:00	IWM	ETF	45.99	46.24	45.48	45.75	11145741.0
2008-11-17 15:00:00	IWM	ETF	45.76	46.14	45.12	45.23	14915101.0
2008-11-17 16:00:00	IWM	ETF	45.24	45.62	44.97	45.1	4518271.0
2008-11-17 17:00:00	IWM	ETF	45.14	45.14	45.14	45.14	100.0
2008-11-17 18:00:00	IWM	ETF	45.18	45.18	45.18	45.18	1000.0
2008-11-17 19:00:00	IWM	ETF	45.24	45.24	45.05	45.05	250.0
2008-11-17 06:00:00	DIA	ETF	83.47	83.75	83.47	83.64	3100.0
2008-11-17 07:00:00	DIA	ETF	83.64	83.64	83.24	83.53	27635.0
2008-11-17 08:00:00	DIA	ETF	83.41	83.74	83.23	83.33	103261.0
2008-11-17 09:00:00	DIA	ETF	83.31	84.51	83.27	84.29	5665412.0
2008-11-17 10:00:00	DIA	ETF	84.3	84.36	82.72	82.98	5057699.0

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

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