PREVIEW / etf_1hour / 2009-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-08.parquet
  size:    139 KB
  rows:    4,295

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
2009-05-08 04:00:00	SPY	ETF	91.83	91.95	91.83	91.95	1750.0
2009-05-08 05:00:00	SPY	ETF	91.94	92.16	91.94	92.09	26455.0
2009-05-08 06:00:00	SPY	ETF	92.05	92.34	92.0	92.24	55749.0
2009-05-08 07:00:00	SPY	ETF	92.27	92.6	92.2	92.38	1090398.0
2009-05-08 08:00:00	SPY	ETF	92.38	92.75	90.9	92.16	10403530.0
2009-05-08 09:00:00	SPY	ETF	92.15	92.8	91.61	92.43	36574532.0
2009-05-08 10:00:00	SPY	ETF	92.42	92.48	91.44	91.6	54241955.0
2009-05-08 11:00:00	SPY	ETF	91.6	92.3	91.6	92.28	27608315.0
2009-05-08 12:00:00	SPY	ETF	92.29	92.75	92.21	92.7	35956826.0
2009-05-08 13:00:00	SPY	ETF	92.7	92.79	92.25	92.38	22784682.0
2009-05-08 14:00:00	SPY	ETF	92.37	93.22	92.37	93.02	33709902.0
2009-05-08 15:00:00	SPY	ETF	93.01	93.13	92.5	93.03	62261969.0
2009-05-08 16:00:00	SPY	ETF	92.99	93.1	92.82	92.83	10963714.0
2009-05-08 17:00:00	SPY	ETF	92.83	92.91	92.76	92.89	1602855.0
2009-05-08 18:00:00	SPY	ETF	92.9	93.0	92.89	92.94	42809.0
2009-05-08 19:00:00	SPY	ETF	92.97	93.09	92.93	93.08	17998.0
2009-05-08 05:00:00	QQQ	ETF	34.5	34.6	34.5	34.6	6030.0
2009-05-08 06:00:00	QQQ	ETF	34.55	34.6	34.52	34.58	12600.0
2009-05-08 07:00:00	QQQ	ETF	34.61	34.68	34.59	34.67	181682.0
2009-05-08 08:00:00	QQQ	ETF	34.66	34.73	34.51	34.58	2770732.0
2009-05-08 09:00:00	QQQ	ETF	34.59	34.74	34.32	34.49	29427190.0
2009-05-08 10:00:00	QQQ	ETF	34.5	34.7	33.88	33.97	38336019.0
2009-05-08 11:00:00	QQQ	ETF	33.96	34.17	33.96	34.14	16066957.0
2009-05-08 12:00:00	QQQ	ETF	34.13	34.37	34.07	34.35	17617657.0
2009-05-08 13:00:00	QQQ	ETF	34.3411	34.38	34.11	34.14	14389890.0
2009-05-08 14:00:00	QQQ	ETF	34.14	34.51	34.14	34.45	19811672.0
2009-05-08 15:00:00	QQQ	ETF	34.45	34.49	34.19	34.27	31190590.0
2009-05-08 16:00:00	QQQ	ETF	34.27	34.48	34.19	34.24	2781777.0
2009-05-08 17:00:00	QQQ	ETF	34.22	34.25	34.2	34.23	25749.0
2009-05-08 18:00:00	QQQ	ETF	34.21	34.25	34.21	34.25	10310.0
2009-05-08 19:00:00	QQQ	ETF	34.24	34.25	34.22	34.23	13340.0
2009-05-08 06:00:00	IWM	ETF	50.13	50.19	50.13	50.16	5200.0
2009-05-08 07:00:00	IWM	ETF	50.28	50.47	50.27	50.35	136858.0
2009-05-08 08:00:00	IWM	ETF	50.36	50.56	49.97	50.31	728661.0
2009-05-08 09:00:00	IWM	ETF	50.33	50.91	50.025	50.54	9390287.0
2009-05-08 10:00:00	IWM	ETF	50.53	50.55	49.64	49.83	8518369.0
2009-05-08 11:00:00	IWM	ETF	49.85	50.27	49.85	50.26	5915968.0
2009-05-08 12:00:00	IWM	ETF	50.268	50.75	49.9	50.73	7050506.0
2009-05-08 13:00:00	IWM	ETF	50.73	50.86	50.5	50.57	5653195.0
2009-05-08 14:00:00	IWM	ETF	50.58	51.14	50.58	50.96	7378086.0
2009-05-08 15:00:00	IWM	ETF	50.94	51.16	50.67	51.01	10922792.0
2009-05-08 16:00:00	IWM	ETF	51.02	51.22	50.85	50.96	1447370.0
2009-05-08 18:00:00	IWM	ETF	51.0	51.09	50.91	50.91	2300.0
2009-05-08 05:00:00	DIA	ETF	85.09	85.09	85.09	85.09	200.0
2009-05-08 06:00:00	DIA	ETF	85.11	85.28	85.11	85.23	1300.0
2009-05-08 07:00:00	DIA	ETF	85.25	85.5	85.25	85.5	130828.0
2009-05-08 08:00:00	DIA	ETF	85.5	85.56	85.02	85.29	215390.0
2009-05-08 09:00:00	DIA	ETF	85.2	85.63	85.0506	85.37	2702391.0
2009-05-08 10:00:00	DIA	ETF	85.37	85.44	84.61	84.81	4151792.0
2009-05-08 11:00:00	DIA	ETF	84.82	85.34	84.81	85.33	2013241.0

> showing 50 of 4,295 rows — these rows as CSV

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