PREVIEW / etf_1hour / 2015-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-16.parquet
  size:    243 KB
  rows:    7,654

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
2015-04-16 04:00:00	SPY	ETF	210.32	210.49	210.3	210.39	2200.0
2015-04-16 05:00:00	SPY	ETF	210.37	210.43	210.23	210.23	7803.0
2015-04-16 06:00:00	SPY	ETF	210.24	210.25	209.7	209.75	130450.0
2015-04-16 07:00:00	SPY	ETF	209.75	209.78	209.43	209.62	783184.0
2015-04-16 08:00:00	SPY	ETF	209.62	209.83	209.53	209.59	747418.0
2015-04-16 09:00:00	SPY	ETF	209.6	210.25	209.57	210.0	9854419.0
2015-04-16 10:00:00	SPY	ETF	210.0	210.4	209.7928	210.22	10086479.0
2015-04-16 11:00:00	SPY	ETF	210.21	210.46	210.02	210.2027	6978297.0
2015-04-16 12:00:00	SPY	ETF	210.2	210.48	210.19	210.36	4206281.0
2015-04-16 13:00:00	SPY	ETF	210.365	210.97	210.28	210.94	6541296.0
2015-04-16 14:00:00	SPY	ETF	210.945	210.98	210.65	210.6535	6361302.0
2015-04-16 15:00:00	SPY	ETF	210.66	210.72	210.24	210.36	16285466.0
2015-04-16 16:00:00	SPY	ETF	210.37	210.62	210.0258	210.56	5989148.0
2015-04-16 17:00:00	SPY	ETF	210.57	210.61	210.53	210.61	203511.0
2015-04-16 18:00:00	SPY	ETF	210.61	210.66	210.57	210.61	69061.0
2015-04-16 19:00:00	SPY	ETF	210.61	210.64	210.59	210.62	37613.0
2015-04-16 05:00:00	QQQ	ETF	107.84	107.84	107.79	107.79	3500.0
2015-04-16 06:00:00	QQQ	ETF	107.76	107.76	107.62	107.68	24800.0
2015-04-16 07:00:00	QQQ	ETF	107.65	107.65	107.32	107.44	60897.0
2015-04-16 08:00:00	QQQ	ETF	107.45	107.51	107.42	107.46	153593.0
2015-04-16 09:00:00	QQQ	ETF	107.46	107.84	107.45	107.6832	3013465.0
2015-04-16 10:00:00	QQQ	ETF	107.68	107.79	107.4	107.62	3208703.0
2015-04-16 11:00:00	QQQ	ETF	107.62	107.74	107.54	107.65	1388585.0
2015-04-16 12:00:00	QQQ	ETF	107.66	107.735	107.6	107.65	857915.0
2015-04-16 13:00:00	QQQ	ETF	107.65	107.87	107.56	107.83	1319627.0
2015-04-16 14:00:00	QQQ	ETF	107.845	107.88	107.69	107.69	1073176.0
2015-04-16 15:00:00	QQQ	ETF	107.7	107.79	107.57	107.68	3174942.0
2015-04-16 16:00:00	QQQ	ETF	107.68	107.76	107.575	107.72	548871.0
2015-04-16 17:00:00	QQQ	ETF	107.72	107.73	107.69	107.73	11587.0
2015-04-16 18:00:00	QQQ	ETF	107.76	107.77	107.74	107.76	20642.0
2015-04-16 19:00:00	QQQ	ETF	107.74	107.75	107.74	107.74	4269.0
2015-04-16 06:00:00	IWM	ETF	126.29	126.29	126.29	126.29	5000.0
2015-04-16 07:00:00	IWM	ETF	126.25	126.48	126.19	126.35	49576.0
2015-04-16 08:00:00	IWM	ETF	126.41	126.5	126.24	126.24	105523.0
2015-04-16 09:00:00	IWM	ETF	126.21	126.64	126.21	126.23	1793279.0
2015-04-16 10:00:00	IWM	ETF	126.24	126.58	126.16	126.47	3062373.0
2015-04-16 11:00:00	IWM	ETF	126.47	126.66	126.43	126.46	1895901.0
2015-04-16 12:00:00	IWM	ETF	126.47	126.56	126.43	126.46	940929.0
2015-04-16 13:00:00	IWM	ETF	126.46	126.75	126.4401	126.66	1127227.0
2015-04-16 14:00:00	IWM	ETF	126.67	126.71	126.575	126.61	1666983.0
2015-04-16 15:00:00	IWM	ETF	126.62	126.655	126.425	126.46	3159266.0
2015-04-16 16:00:00	IWM	ETF	126.46	126.61	126.4	126.47	1832332.0
2015-04-16 17:00:00	IWM	ETF	126.45	126.45	126.45	126.45	1000.0
2015-04-16 19:00:00	IWM	ETF	126.48	126.48	126.48	126.48	191.0
2015-04-16 08:00:00	DIA	ETF	180.41	180.49	180.21	180.21	2700.0
2015-04-16 09:00:00	DIA	ETF	180.29	180.92	180.29	180.7499	578820.0
2015-04-16 10:00:00	DIA	ETF	180.74	180.9	180.43	180.71	569999.0
2015-04-16 11:00:00	DIA	ETF	180.71	180.99	180.58	180.74	360397.0
2015-04-16 12:00:00	DIA	ETF	180.76	181.02	180.74	180.84	268618.0
2015-04-16 13:00:00	DIA	ETF	180.83	181.48	180.77	181.45	589983.0

> showing 50 of 7,654 rows — these rows as CSV

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