PREVIEW / etf_1hour / 2008-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-23.parquet
  size:    114 KB
  rows:    3,770

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-10-23 04:00:00	SPY	ETF	92.3	92.4	91.12	91.12	20585.0
2008-10-23 05:00:00	SPY	ETF	91.0	91.0	89.95	90.19	19902.0
2008-10-23 06:00:00	SPY	ETF	90.45	91.06	89.75	89.75	109006.0
2008-10-23 07:00:00	SPY	ETF	89.9	90.42	88.5	88.67	1278250.0
2008-10-23 08:00:00	SPY	ETF	88.64	92.25	88.58	89.88	7440176.0
2008-10-23 09:00:00	SPY	ETF	89.88	91.08	88.35	89.71	55809819.0
2008-10-23 10:00:00	SPY	ETF	89.7	92.25	89.45	92.1	91539155.0
2008-10-23 11:00:00	SPY	ETF	92.1	92.45	90.75	91.41	52350552.0
2008-10-23 12:00:00	SPY	ETF	91.4	91.42	88.15	88.35	67661662.0
2008-10-23 13:00:00	SPY	ETF	88.34	89.28	87.45	87.91	69207561.0
2008-10-23 14:00:00	SPY	ETF	87.9	88.22	85.81	86.91	97798153.0
2008-10-23 15:00:00	SPY	ETF	86.89	91.87	86.39	91.05	158498579.0
2008-10-23 16:00:00	SPY	ETF	91.04	91.73	89.7769	91.67	23305917.0
2008-10-23 17:00:00	SPY	ETF	91.67	91.67	89.7398	91.5	5489408.0
2008-10-23 18:00:00	SPY	ETF	91.45	91.6	91.3	91.4	108651.0
2008-10-23 19:00:00	SPY	ETF	91.38	91.7	91.37	91.45	89366.0
2008-10-23 04:00:00	QQQ	ETF	31.09	31.09	30.61	30.61	6400.0
2008-10-23 05:00:00	QQQ	ETF	30.55	30.55	30.45	30.55	3675.0
2008-10-23 06:00:00	QQQ	ETF	30.55	30.77	30.54	30.54	3500.0
2008-10-23 07:00:00	QQQ	ETF	30.49	30.64	30.12	30.17	429846.0
2008-10-23 08:00:00	QQQ	ETF	30.17	30.77	30.04	30.32	2332112.0
2008-10-23 09:00:00	QQQ	ETF	30.32	30.8	29.87	30.32	36357182.0
2008-10-23 10:00:00	QQQ	ETF	30.3	31.0	30.17	30.94	52160955.0
2008-10-23 11:00:00	QQQ	ETF	30.94	31.09	30.44	30.603	29565630.0
2008-10-23 12:00:00	QQQ	ETF	30.6	30.62	29.77	29.8	33957885.0
2008-10-23 13:00:00	QQQ	ETF	29.79	30.07	29.5	29.64	46537078.0
2008-10-23 14:00:00	QQQ	ETF	29.63	29.69	28.9	29.33	65588496.0
2008-10-23 15:00:00	QQQ	ETF	29.33	30.53	29.17	30.5	91867069.0
2008-10-23 16:00:00	QQQ	ETF	30.5	30.9	29.82	30.77	9222056.0
2008-10-23 17:00:00	QQQ	ETF	30.77	30.77	30.4143	30.68	3730437.0
2008-10-23 18:00:00	QQQ	ETF	30.66	30.76	30.6	30.69	563333.0
2008-10-23 19:00:00	QQQ	ETF	30.68	30.75	30.62	30.63	122366.0
2008-10-23 07:00:00	IWM	ETF	50.5	50.5	49.59	49.6	70642.0
2008-10-23 08:00:00	IWM	ETF	49.83	51.9	49.76	50.46	400416.0
2008-10-23 09:00:00	IWM	ETF	50.42	50.94	49.07	49.74	8621027.0
2008-10-23 10:00:00	IWM	ETF	49.72	50.78	49.43	50.69	17811184.0
2008-10-23 11:00:00	IWM	ETF	50.69	50.87	49.86	50.13	10456720.0
2008-10-23 12:00:00	IWM	ETF	50.12	50.13	48.03	48.06	12692595.0
2008-10-23 13:00:00	IWM	ETF	48.05	48.26	47.38	47.66	17611861.0
2008-10-23 14:00:00	IWM	ETF	47.65	48.3	46.68	47.53	20865941.0
2008-10-23 15:00:00	IWM	ETF	47.53	50.0	47.28	49.08	35011048.0
2008-10-23 16:00:00	IWM	ETF	49.07	50.17	48.33	49.03	6244839.0
2008-10-23 17:00:00	IWM	ETF	48.9	49.0	48.9	49.0	3000.0
2008-10-23 18:00:00	IWM	ETF	48.85	48.85	48.85	48.85	10000.0
2008-10-23 19:00:00	IWM	ETF	48.86	48.86	48.86	48.86	200.0
2008-10-23 05:00:00	DIA	ETF	85.0	85.0	85.0	85.0	100.0
2008-10-23 06:00:00	DIA	ETF	86.0	86.0	86.0	86.0	100.0
2008-10-23 07:00:00	DIA	ETF	85.6	85.6	84.25	84.25	19800.0
2008-10-23 08:00:00	DIA	ETF	86.45	86.45	84.31	85.35	142221.0
2008-10-23 09:00:00	DIA	ETF	85.31	86.52	83.89	85.23	7189680.0

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

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