PREVIEW / etf_1hour / 2015-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-23.parquet
  size:    242 KB
  rows:    7,664

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-23 04:00:00	SPY	ETF	210.35	210.55	209.28	209.5	24188.0
2015-04-23 05:00:00	SPY	ETF	209.85	210.31	209.78	210.17	88275.0
2015-04-23 06:00:00	SPY	ETF	210.06	210.14	209.85	209.95	37210.0
2015-04-23 07:00:00	SPY	ETF	209.99	210.12	209.71	209.94	191087.0
2015-04-23 08:00:00	SPY	ETF	209.93	210.18	209.84	209.98	608379.0
2015-04-23 09:00:00	SPY	ETF	209.99	210.65	209.95	210.62	9250516.0
2015-04-23 10:00:00	SPY	ETF	210.62	210.86	210.165	210.32	11499544.0
2015-04-23 11:00:00	SPY	ETF	210.31	211.4	210.29	211.22	12200069.0
2015-04-23 12:00:00	SPY	ETF	211.22	211.78	211.11	211.735	10958028.0
2015-04-23 13:00:00	SPY	ETF	211.73	211.77	211.45	211.65	8691564.0
2015-04-23 14:00:00	SPY	ETF	211.65	211.72	211.41	211.57	9621112.0
2015-04-23 15:00:00	SPY	ETF	211.57	211.94	211.16	211.18	22062245.0
2015-04-23 16:00:00	SPY	ETF	211.17	211.37	210.3825	211.25	9028778.0
2015-04-23 17:00:00	SPY	ETF	211.25	211.36	211.09	211.31	122193.0
2015-04-23 18:00:00	SPY	ETF	211.3	211.32	210.95	211.04	233477.0
2015-04-23 19:00:00	SPY	ETF	211.07	211.17	211.05	211.15	71354.0
2015-04-23 04:00:00	QQQ	ETF	108.02	108.09	107.84	108.09	30400.0
2015-04-23 05:00:00	QQQ	ETF	108.14	108.34	108.11	108.34	19400.0
2015-04-23 06:00:00	QQQ	ETF	108.31	108.31	108.12	108.22	6399.0
2015-04-23 07:00:00	QQQ	ETF	108.24	108.28	108.1	108.19	52197.0
2015-04-23 08:00:00	QQQ	ETF	108.13	108.36	108.13	108.22	190293.0
2015-04-23 09:00:00	QQQ	ETF	108.23	108.7	108.23	108.688	2886187.0
2015-04-23 10:00:00	QQQ	ETF	108.69	108.86	108.43	108.44	4171181.0
2015-04-23 11:00:00	QQQ	ETF	108.435	109.0	108.43	108.905	2919889.0
2015-04-23 12:00:00	QQQ	ETF	108.9	109.23	108.8	109.22	3165628.0
2015-04-23 13:00:00	QQQ	ETF	109.23	109.26	109.12	109.21	1565780.0
2015-04-23 14:00:00	QQQ	ETF	109.21	109.42	109.1849	109.31	3171861.0
2015-04-23 15:00:00	QQQ	ETF	109.315	109.55	109.06	109.07	5149506.0
2015-04-23 16:00:00	QQQ	ETF	109.06	109.7	108.93	109.63	1988757.0
2015-04-23 17:00:00	QQQ	ETF	109.64	109.72	109.63	109.65	137056.0
2015-04-23 18:00:00	QQQ	ETF	109.65	109.66	109.55	109.56	69636.0
2015-04-23 19:00:00	QQQ	ETF	109.6	109.62	109.56	109.6	17144.0
2015-04-23 06:00:00	IWM	ETF	125.48	125.48	125.48	125.48	100.0
2015-04-23 07:00:00	IWM	ETF	125.5	125.52	125.32	125.41	16400.0
2015-04-23 08:00:00	IWM	ETF	125.42	125.57	125.29	125.39	89632.0
2015-04-23 09:00:00	IWM	ETF	125.48	125.75	125.34	125.73	1745716.0
2015-04-23 10:00:00	IWM	ETF	125.72	125.78	125.26	125.58	1803024.0
2015-04-23 11:00:00	IWM	ETF	125.58	126.1	125.51	126.02	2041388.0
2015-04-23 12:00:00	IWM	ETF	126.015	126.24	125.88	126.23	1763420.0
2015-04-23 13:00:00	IWM	ETF	126.23	126.47	126.21	126.37	1665723.0
2015-04-23 14:00:00	IWM	ETF	126.38	126.46	126.35	126.38	1287198.0
2015-04-23 15:00:00	IWM	ETF	126.38	126.535	126.18	126.26	3378108.0
2015-04-23 16:00:00	IWM	ETF	126.25	126.34	125.7011	126.21	2415911.0
2015-04-23 17:00:00	IWM	ETF	126.21	126.31	126.21	126.28	42047.0
2015-04-23 18:00:00	IWM	ETF	126.27	126.27	126.27	126.27	1000.0
2015-04-23 19:00:00	IWM	ETF	126.29	126.35	126.28	126.32	4100.0
2015-04-23 08:00:00	DIA	ETF	179.31	179.4	179.2	179.4	8400.0
2015-04-23 09:00:00	DIA	ETF	179.37	179.88	179.15	179.82	478678.0
2015-04-23 10:00:00	DIA	ETF	179.86	180.09	179.5	179.78	859940.0
2015-04-23 11:00:00	DIA	ETF	179.77	180.73	179.77	180.58	638572.0

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

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