PREVIEW / etf_1hour / 2009-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-28.parquet
  size:    134 KB
  rows:    4,131

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-04-28 04:00:00	SPY	ETF	84.77	84.82	84.58	84.82	7030.0
2009-04-28 05:00:00	SPY	ETF	84.8	84.8	84.65	84.67	5200.0
2009-04-28 06:00:00	SPY	ETF	84.63	84.75	84.51	84.71	130521.0
2009-04-28 07:00:00	SPY	ETF	84.7	84.81	84.58	84.75	1468970.0
2009-04-28 08:00:00	SPY	ETF	84.62	85.84	84.6	84.98	3749177.0
2009-04-28 09:00:00	SPY	ETF	84.99	85.54	84.18	85.48	32374027.0
2009-04-28 10:00:00	SPY	ETF	85.49	86.31	85.3586	86.0074	48179621.0
2009-04-28 11:00:00	SPY	ETF	86.01	86.11	85.59	85.76	25723392.0
2009-04-28 12:00:00	SPY	ETF	85.76	86.18	85.76	86.09	20866973.0
2009-04-28 13:00:00	SPY	ETF	86.08	86.25	85.72	85.89	26334349.0
2009-04-28 14:00:00	SPY	ETF	85.89	86.59	85.88	86.24	29863438.0
2009-04-28 15:00:00	SPY	ETF	86.24	86.45	85.53	85.59	47765837.0
2009-04-28 16:00:00	SPY	ETF	85.59	86.0	84.94	85.43	7257729.0
2009-04-28 17:00:00	SPY	ETF	85.43	85.8625	85.39	85.5	2778451.0
2009-04-28 18:00:00	SPY	ETF	85.5	85.51	85.42	85.5	130804.0
2009-04-28 19:00:00	SPY	ETF	85.5	85.58	85.48	85.53	205942.0
2009-04-28 04:00:00	QQQ	ETF	33.39	33.39	33.35	33.38	3500.0
2009-04-28 05:00:00	QQQ	ETF	33.43	33.43	33.43	33.43	100.0
2009-04-28 06:00:00	QQQ	ETF	33.39	33.39	33.33	33.37	1800.0
2009-04-28 07:00:00	QQQ	ETF	33.38	33.41	33.33	33.4	49918.0
2009-04-28 08:00:00	QQQ	ETF	33.41	33.57	33.35	33.5	1844560.0
2009-04-28 09:00:00	QQQ	ETF	33.51	33.61	33.36	33.61	13026667.0
2009-04-28 10:00:00	QQQ	ETF	33.61	33.91	33.6	33.8101	18238779.0
2009-04-28 11:00:00	QQQ	ETF	33.81	33.9	33.66	33.7	9188588.0
2009-04-28 12:00:00	QQQ	ETF	33.71	33.87	33.71	33.8	7747138.0
2009-04-28 13:00:00	QQQ	ETF	33.8	33.85	33.52	33.54	12479260.0
2009-04-28 14:00:00	QQQ	ETF	33.54	33.8301	33.53	33.72	14418668.0
2009-04-28 15:00:00	QQQ	ETF	33.72	33.79	33.46	33.48	24650844.0
2009-04-28 16:00:00	QQQ	ETF	33.48	33.6953	33.39	33.4	4333491.0
2009-04-28 17:00:00	QQQ	ETF	33.42	33.45	33.36	33.41	1272596.0
2009-04-28 18:00:00	QQQ	ETF	33.41	33.42	33.37	33.42	57500.0
2009-04-28 19:00:00	QQQ	ETF	33.42	33.46	33.41	33.41	47783.0
2009-04-28 04:00:00	IWM	ETF	46.51	46.51	46.51	46.51	300.0
2009-04-28 07:00:00	IWM	ETF	46.53	46.53	46.29	46.46	67400.0
2009-04-28 08:00:00	IWM	ETF	46.42	47.1	46.35	46.61	204843.0
2009-04-28 09:00:00	IWM	ETF	46.58	46.94	46.38	46.93	5449904.0
2009-04-28 10:00:00	IWM	ETF	46.93	47.72	46.93	47.42	9000039.0
2009-04-28 11:00:00	IWM	ETF	47.43	47.5	47.24	47.42	5663210.0
2009-04-28 12:00:00	IWM	ETF	47.43	47.85	47.43	47.77	5120579.0
2009-04-28 13:00:00	IWM	ETF	47.77	47.8	47.33	47.4291	3869704.0
2009-04-28 14:00:00	IWM	ETF	47.43	47.99	47.43	47.72	6704674.0
2009-04-28 15:00:00	IWM	ETF	47.72	47.83	47.12	47.21	12356147.0
2009-04-28 16:00:00	IWM	ETF	47.19	47.7219	47.08	47.35	1676266.0
2009-04-28 17:00:00	IWM	ETF	47.14	47.14	47.06	47.13	11677.0
2009-04-28 18:00:00	IWM	ETF	47.19	47.19	47.19	47.19	100.0
2009-04-28 19:00:00	IWM	ETF	47.16	47.16	47.14	47.14	200.0
2009-04-28 06:00:00	DIA	ETF	79.26	79.33	79.26	79.33	16100.0
2009-04-28 07:00:00	DIA	ETF	79.42	79.42	79.29	79.39	6325.0
2009-04-28 08:00:00	DIA	ETF	79.42	79.57	79.2	79.52	77241.0
2009-04-28 09:00:00	DIA	ETF	79.47	80.0	79.3	79.95	2238154.0

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

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