PREVIEW / etf_1hour / 2012-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-30.parquet
  size:    187 KB
  rows:    5,792

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
2012-01-30 04:00:00	SPY	ETF	131.08	131.08	130.68	130.7	4530.0
2012-01-30 05:00:00	SPY	ETF	130.81	130.99	130.69	130.92	57475.0
2012-01-30 06:00:00	SPY	ETF	130.86	131.02	130.84	131.01	60750.0
2012-01-30 07:00:00	SPY	ETF	130.98	130.98	130.65	130.75	302298.0
2012-01-30 08:00:00	SPY	ETF	130.77	130.88	130.39	130.41	1876791.0
2012-01-30 09:00:00	SPY	ETF	130.41	130.6	130.15	130.42	21981468.0
2012-01-30 10:00:00	SPY	ETF	130.41	130.61	130.06	130.52	23146551.0
2012-01-30 11:00:00	SPY	ETF	130.53	130.87	130.525	130.73	18648616.0
2012-01-30 12:00:00	SPY	ETF	130.71	130.89	130.68	130.8	12267366.0
2012-01-30 13:00:00	SPY	ETF	130.8	131.24	130.61	131.13	15323410.0
2012-01-30 14:00:00	SPY	ETF	131.13	131.44	131.06	131.24	13293083.0
2012-01-30 15:00:00	SPY	ETF	131.24	131.38	131.02	131.36	25697869.0
2012-01-30 16:00:00	SPY	ETF	131.37	131.43	130.5	131.38	11476937.0
2012-01-30 17:00:00	SPY	ETF	131.37	131.43	131.34	131.41	85685.0
2012-01-30 18:00:00	SPY	ETF	131.4	131.46	131.34	131.45	176163.0
2012-01-30 19:00:00	SPY	ETF	131.45	131.76	131.39	131.72	388006.0
2012-01-30 04:00:00	QQQ	ETF	60.04	60.04	59.82	59.88	1010.0
2012-01-30 05:00:00	QQQ	ETF	59.9	59.93	59.9	59.93	200.0
2012-01-30 06:00:00	QQQ	ETF	59.95	59.95	59.93	59.93	200.0
2012-01-30 07:00:00	QQQ	ETF	59.98	59.99	59.88	59.93	25703.0
2012-01-30 08:00:00	QQQ	ETF	59.93	59.96	59.77	59.77	455435.0
2012-01-30 09:00:00	QQQ	ETF	59.8	59.98	59.72	59.84	5692384.0
2012-01-30 10:00:00	QQQ	ETF	59.84	60.1	59.66	60.0899	7914430.0
2012-01-30 11:00:00	QQQ	ETF	60.09	60.356	60.09	60.2401	5671314.0
2012-01-30 12:00:00	QQQ	ETF	60.25	60.35	60.21	60.27	3228780.0
2012-01-30 13:00:00	QQQ	ETF	60.27	60.52	60.18	60.4496	4932208.0
2012-01-30 14:00:00	QQQ	ETF	60.4498	60.54	60.39	60.42	3225732.0
2012-01-30 15:00:00	QQQ	ETF	60.415	60.46	60.29	60.44	6217020.0
2012-01-30 16:00:00	QQQ	ETF	60.435	60.49	60.3414	60.48	2268854.0
2012-01-30 17:00:00	QQQ	ETF	60.47	60.5	60.44	60.48	18499.0
2012-01-30 18:00:00	QQQ	ETF	60.47	60.49	60.43	60.49	20009.0
2012-01-30 19:00:00	QQQ	ETF	60.49	60.63	60.47	60.61	39420.0
2012-01-30 04:00:00	IWM	ETF	79.4	79.4	78.96	78.96	1226.0
2012-01-30 05:00:00	IWM	ETF	78.99	79.12	78.99	79.12	700.0
2012-01-30 06:00:00	IWM	ETF	79.28	79.28	79.28	79.28	100.0
2012-01-30 07:00:00	IWM	ETF	79.26	79.26	79.07	79.14	64981.0
2012-01-30 08:00:00	IWM	ETF	79.18	79.27	78.9	78.9	574574.0
2012-01-30 09:00:00	IWM	ETF	78.87	79.14	78.72	78.86	8125888.0
2012-01-30 10:00:00	IWM	ETF	78.85	79.13	78.52	78.99	9125676.0
2012-01-30 11:00:00	IWM	ETF	78.99	79.32	78.99	79.15	3971037.0
2012-01-30 12:00:00	IWM	ETF	79.14	79.21	78.86	78.96	3234340.0
2012-01-30 13:00:00	IWM	ETF	78.96	79.38	78.79	79.23	3873712.0
2012-01-30 14:00:00	IWM	ETF	79.23	79.43	79.16	79.25	3026485.0
2012-01-30 15:00:00	IWM	ETF	79.245	79.315	79.0	79.11	6695973.0
2012-01-30 16:00:00	IWM	ETF	79.1	79.21	79.05	79.15	3313257.0
2012-01-30 17:00:00	IWM	ETF	79.13	79.7261	79.09	79.22	585234.0
2012-01-30 18:00:00	IWM	ETF	79.2	79.28	79.2	79.27	117239.0
2012-01-30 19:00:00	IWM	ETF	79.21	79.35	79.21	79.33	11630.0
2012-01-30 07:00:00	DIA	ETF	125.51	125.51	125.5	125.5	400.0
2012-01-30 08:00:00	DIA	ETF	125.99	126.0	125.35	125.35	10640.0

> showing 50 of 5,792 rows — these rows as CSV

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