PREVIEW / etf_1hour / 2009-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-15.parquet
  size:    131 KB
  rows:    4,059

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-15 04:00:00	SPY	ETF	89.5	89.54	89.39	89.39	4100.0
2009-05-15 05:00:00	SPY	ETF	89.54	89.62	89.43	89.44	21411.0
2009-05-15 06:00:00	SPY	ETF	89.44	89.44	89.03	89.1	73165.0
2009-05-15 07:00:00	SPY	ETF	89.04	89.06	88.68	88.8	1937393.0
2009-05-15 08:00:00	SPY	ETF	88.8	89.45	88.69	89.1	4917823.0
2009-05-15 09:00:00	SPY	ETF	89.12	89.85	89.03	89.43	31310994.0
2009-05-15 10:00:00	SPY	ETF	89.43	90.0	89.09	89.7	37954616.0
2009-05-15 11:00:00	SPY	ETF	89.7	89.81	88.75	88.77	27367293.0
2009-05-15 12:00:00	SPY	ETF	88.77	88.96	88.59	88.67	23449265.0
2009-05-15 13:00:00	SPY	ETF	88.67	88.88	88.51	88.65	18971988.0
2009-05-15 14:00:00	SPY	ETF	88.64	88.84	88.26	88.39	29127587.0
2009-05-15 15:00:00	SPY	ETF	88.3896	88.76	88.15	88.7	53108971.0
2009-05-15 16:00:00	SPY	ETF	88.69	89.5808	88.3	88.9	23641536.0
2009-05-15 17:00:00	SPY	ETF	88.9	88.95	88.88	88.91	87508.0
2009-05-15 18:00:00	SPY	ETF	88.89	88.94	88.83	88.83	24956.0
2009-05-15 19:00:00	SPY	ETF	88.83	88.9	88.82	88.85	36168.0
2009-05-15 04:00:00	QQQ	ETF	33.39	33.39	33.39	33.39	2000.0
2009-05-15 05:00:00	QQQ	ETF	33.42	33.42	33.42	33.42	100.0
2009-05-15 06:00:00	QQQ	ETF	33.3	33.3	33.19	33.19	35513.0
2009-05-15 07:00:00	QQQ	ETF	33.19	33.19	33.04	33.09	1273413.0
2009-05-15 08:00:00	QQQ	ETF	33.09	33.25	33.05	33.22	3138642.0
2009-05-15 09:00:00	QQQ	ETF	33.22	33.68	33.19	33.6	18930288.0
2009-05-15 10:00:00	QQQ	ETF	33.61	33.82	33.52	33.76	16847556.0
2009-05-15 11:00:00	QQQ	ETF	33.75	33.78	33.45	33.45	14680308.0
2009-05-15 12:00:00	QQQ	ETF	33.45	33.55	33.4	33.46	8086448.0
2009-05-15 13:00:00	QQQ	ETF	33.45	33.53	33.36	33.42	9231967.0
2009-05-15 14:00:00	QQQ	ETF	33.42	33.51	33.33	33.38	12288230.0
2009-05-15 15:00:00	QQQ	ETF	33.37	33.49	33.29	33.36	21954494.0
2009-05-15 16:00:00	QQQ	ETF	33.36	33.6	33.3	33.37	8150369.0
2009-05-15 17:00:00	QQQ	ETF	33.37	33.39	33.35	33.39	289702.0
2009-05-15 18:00:00	QQQ	ETF	33.37	33.42	33.35	33.42	7025.0
2009-05-15 19:00:00	QQQ	ETF	33.4	33.42	33.37	33.42	6775.0
2009-05-15 05:00:00	IWM	ETF	48.04	48.04	48.04	48.04	100.0
2009-05-15 06:00:00	IWM	ETF	47.84	47.84	47.7	47.7	1400.0
2009-05-15 07:00:00	IWM	ETF	47.7	47.7	47.47	47.53	51783.0
2009-05-15 08:00:00	IWM	ETF	47.58	47.99	47.5	47.65	1748777.0
2009-05-15 09:00:00	IWM	ETF	47.63	48.27	47.58	48.03	9437454.0
2009-05-15 10:00:00	IWM	ETF	48.04	48.42	47.8	48.3	6524220.0
2009-05-15 11:00:00	IWM	ETF	48.3	48.38	47.68	47.7	4805457.0
2009-05-15 12:00:00	IWM	ETF	47.69	47.89	47.63	47.71	3959620.0
2009-05-15 13:00:00	IWM	ETF	47.71	47.7801	47.44	47.55	3992096.0
2009-05-15 14:00:00	IWM	ETF	47.54	47.75	47.37	47.47	5729496.0
2009-05-15 15:00:00	IWM	ETF	47.47	47.76	47.28	47.69	12564243.0
2009-05-15 16:00:00	IWM	ETF	47.69	48.3	47.58	47.71	1488995.0
2009-05-15 17:00:00	IWM	ETF	47.68	47.75	47.68	47.75	900.0
2009-05-15 18:00:00	IWM	ETF	47.75	47.75	47.75	47.75	300.0
2009-05-15 06:00:00	DIA	ETF	83.21	83.21	83.04	83.04	600.0
2009-05-15 07:00:00	DIA	ETF	82.93	82.93	82.72	82.72	25018.0
2009-05-15 08:00:00	DIA	ETF	82.73	83.05	82.6	82.97	92458.0
2009-05-15 09:00:00	DIA	ETF	82.99	83.64	82.88	83.43	3411162.0

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

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