PREVIEW / etf_1hour / 2008-10-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	92.73	92.73	92.03	92.03	1000.0
2008-10-17 05:00:00	SPY	ETF	92.35	92.35	91.0	91.0	72800.0
2008-10-17 06:00:00	SPY	ETF	91.22	92.68	91.2	92.25	501322.0
2008-10-17 07:00:00	SPY	ETF	92.25	93.27	92.15	93.27	1738285.0
2008-10-17 08:00:00	SPY	ETF	92.4	94.25	91.9	92.7	7770941.0
2008-10-17 09:00:00	SPY	ETF	92.7	94.22	91.55	94.17	59773490.0
2008-10-17 10:00:00	SPY	ETF	94.16	95.28	93.17	94.79	73095222.0
2008-10-17 11:00:00	SPY	ETF	94.78	95.64	93.9	94.49	47236168.0
2008-10-17 12:00:00	SPY	ETF	94.49	96.8	94.44	96.64	35049956.0
2008-10-17 13:00:00	SPY	ETF	96.63	98.59	96.1	97.4425	62089145.0
2008-10-17 14:00:00	SPY	ETF	97.63	98.18	95.0	96.3	66030643.0
2008-10-17 15:00:00	SPY	ETF	96.3	97.09	93.7	94.07	98383178.0
2008-10-17 16:00:00	SPY	ETF	94.09	97.75	92.98	93.34	22302578.0
2008-10-17 17:00:00	SPY	ETF	93.35	93.7	93.21	93.68	831261.0
2008-10-17 18:00:00	SPY	ETF	93.7	93.84	93.29	93.4	135549.0
2008-10-17 19:00:00	SPY	ETF	93.36	93.5	93.3	93.5	18537.0
2008-10-17 04:00:00	QQQ	ETF	31.97	31.97	31.85	31.94	2420.0
2008-10-17 05:00:00	QQQ	ETF	31.79	31.79	31.25	31.25	1900.0
2008-10-17 06:00:00	QQQ	ETF	31.28	31.88	31.25	31.73	53230.0
2008-10-17 07:00:00	QQQ	ETF	31.75	32.03	31.75	32.03	292556.0
2008-10-17 08:00:00	QQQ	ETF	32.02	32.19	31.66	31.82	2532692.0
2008-10-17 09:00:00	QQQ	ETF	31.81	32.33	31.41	32.3101	43164234.0
2008-10-17 10:00:00	QQQ	ETF	32.32	32.63	31.82	32.49	52327226.0
2008-10-17 11:00:00	QQQ	ETF	32.5	32.79	32.2	32.32	30435559.0
2008-10-17 12:00:00	QQQ	ETF	32.32	33.05	32.28	33.01	24189796.0
2008-10-17 13:00:00	QQQ	ETF	33.01	33.65	32.87	33.27	40580109.0
2008-10-17 14:00:00	QQQ	ETF	33.27	33.48	32.4	32.7701	53603167.0
2008-10-17 15:00:00	QQQ	ETF	32.78	33.06	32.13	32.25	63390250.0
2008-10-17 16:00:00	QQQ	ETF	32.27	33.0854	32.07	32.15	7204053.0
2008-10-17 17:00:00	QQQ	ETF	32.18	32.3	32.17	32.25	89549.0
2008-10-17 18:00:00	QQQ	ETF	32.24	32.27	32.19	32.2	8400.0
2008-10-17 19:00:00	QQQ	ETF	32.2	32.26	32.18	32.26	15577.0
2008-10-17 05:00:00	IWM	ETF	51.95	51.95	51.95	51.95	100.0
2008-10-17 07:00:00	IWM	ETF	52.39	52.61	52.26	52.54	5860.0
2008-10-17 08:00:00	IWM	ETF	52.7	53.07	52.44	52.71	648145.0
2008-10-17 09:00:00	IWM	ETF	52.6	53.07	51.34	53.06	17151725.0
2008-10-17 10:00:00	IWM	ETF	53.06	53.3	52.16	53.08	17264666.0
2008-10-17 11:00:00	IWM	ETF	53.09	53.57	52.51	52.87	8984961.0
2008-10-17 12:00:00	IWM	ETF	52.86	54.1	52.82	54.0	8884191.0
2008-10-17 13:00:00	IWM	ETF	54.0	55.45	53.8	54.58	20969839.0
2008-10-17 14:00:00	IWM	ETF	54.58	55.04	53.3	53.86	16146100.0
2008-10-17 15:00:00	IWM	ETF	53.87	54.45	52.35	52.4	22246504.0
2008-10-17 16:00:00	IWM	ETF	52.4	53.71	51.6	51.9	6059637.0
2008-10-17 17:00:00	IWM	ETF	51.9	52.15	51.9	52.04	14794.0
2008-10-17 18:00:00	IWM	ETF	51.98	51.98	51.98	51.98	400.0
2008-10-17 19:00:00	IWM	ETF	51.9	51.9	51.9	51.9	600.0
2008-10-17 05:00:00	DIA	ETF	88.1	88.1	88.1	88.1	100.0
2008-10-17 07:00:00	DIA	ETF	88.43	89.0	88.15	88.87	17900.0
2008-10-17 08:00:00	DIA	ETF	88.86	89.4	88.05	88.27	98378.0
2008-10-17 09:00:00	DIA	ETF	88.23	89.36	87.16	89.31	6513071.0

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

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