PREVIEW / etf_1hour / 2015-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-22.parquet
  size:    239 KB
  rows:    7,638

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-07-22 04:00:00	SPY	ETF	211.29	211.36	211.28	211.3	6200.0
2015-07-22 05:00:00	SPY	ETF	211.33	211.35	211.19	211.21	21245.0
2015-07-22 06:00:00	SPY	ETF	211.21	211.23	211.13	211.16	89084.0
2015-07-22 07:00:00	SPY	ETF	211.18	211.3	211.03	211.06	253328.0
2015-07-22 08:00:00	SPY	ETF	211.03	211.27	210.88	210.95	903866.0
2015-07-22 09:00:00	SPY	ETF	211.0	211.64	210.81	211.59	14717048.0
2015-07-22 10:00:00	SPY	ETF	211.61	211.77	211.125	211.505	19463861.0
2015-07-22 11:00:00	SPY	ETF	211.51	211.54	211.055	211.245	8108552.0
2015-07-22 12:00:00	SPY	ETF	211.24	211.36	210.97	211.1387	8194745.0
2015-07-22 13:00:00	SPY	ETF	211.13	211.621	211.1	211.25	4865334.0
2015-07-22 14:00:00	SPY	ETF	211.25	211.485	211.14	211.46	6175267.0
2015-07-22 15:00:00	SPY	ETF	211.46	211.49	210.89	211.34	17736638.0
2015-07-22 16:00:00	SPY	ETF	211.33	211.62	211.18	211.62	6894662.0
2015-07-22 17:00:00	SPY	ETF	211.59	211.6	211.52	211.52	207157.0
2015-07-22 18:00:00	SPY	ETF	211.55	211.6	211.5	211.55	141742.0
2015-07-22 19:00:00	SPY	ETF	211.55	211.65	211.54	211.63	152739.0
2015-07-22 04:00:00	QQQ	ETF	112.55	112.73	112.55	112.73	16295.0
2015-07-22 05:00:00	QQQ	ETF	112.7	112.7	112.7	112.7	10300.0
2015-07-22 06:00:00	QQQ	ETF	112.7	112.71	112.64	112.64	13930.0
2015-07-22 07:00:00	QQQ	ETF	112.65	112.66	112.44	112.44	181224.0
2015-07-22 08:00:00	QQQ	ETF	112.44	112.6	112.23	112.28	293644.0
2015-07-22 09:00:00	QQQ	ETF	112.28	113.06	112.01	113.03	7902520.0
2015-07-22 10:00:00	QQQ	ETF	113.039	113.169	112.621	112.905	4866765.0
2015-07-22 11:00:00	QQQ	ETF	112.91	112.93	112.54	112.67	2666605.0
2015-07-22 12:00:00	QQQ	ETF	112.67	112.72	112.41	112.62	2062049.0
2015-07-22 13:00:00	QQQ	ETF	112.62	112.76	112.59	112.6894	1995452.0
2015-07-22 14:00:00	QQQ	ETF	112.685	112.8594	112.59	112.83	2109969.0
2015-07-22 15:00:00	QQQ	ETF	112.825	112.85	112.42	112.64	5188903.0
2015-07-22 16:00:00	QQQ	ETF	112.64	112.81	112.557	112.81	1794486.0
2015-07-22 17:00:00	QQQ	ETF	112.82	112.87	112.8	112.82	60843.0
2015-07-22 18:00:00	QQQ	ETF	112.86	112.9	112.78	112.83	21309.0
2015-07-22 19:00:00	QQQ	ETF	112.85	112.91	112.85	112.91	10773.0
2015-07-22 07:00:00	IWM	ETF	124.04	124.2	124.04	124.1	38916.0
2015-07-22 08:00:00	IWM	ETF	124.2	124.2	123.94	124.0	162495.0
2015-07-22 09:00:00	IWM	ETF	124.0	124.7	123.88	124.575	3407020.0
2015-07-22 10:00:00	IWM	ETF	124.6	124.85	124.31	124.76	2960553.0
2015-07-22 11:00:00	IWM	ETF	124.77	124.775	124.41	124.675	1488745.0
2015-07-22 12:00:00	IWM	ETF	124.67	124.755	124.46	124.65	1190289.0
2015-07-22 13:00:00	IWM	ETF	124.65	125.01	124.6401	124.805	1570892.0
2015-07-22 14:00:00	IWM	ETF	124.81	125.09	124.76	125.03	1713664.0
2015-07-22 15:00:00	IWM	ETF	125.03	125.07	124.54	124.94	3992609.0
2015-07-22 16:00:00	IWM	ETF	124.95	125.22	124.82	125.22	1683131.0
2015-07-22 17:00:00	IWM	ETF	125.22	125.23	125.1	125.14	131575.0
2015-07-22 19:00:00	IWM	ETF	125.1	125.15	125.1	125.15	1500.0
2015-07-22 06:00:00	DIA	ETF	178.4	178.4	178.4	178.4	1632.0
2015-07-22 07:00:00	DIA	ETF	178.5	178.65	178.5	178.64	17094.0
2015-07-22 08:00:00	DIA	ETF	178.39	178.56	178.38	178.44	29297.0
2015-07-22 09:00:00	DIA	ETF	178.39	178.91	178.38	178.89	680375.0
2015-07-22 10:00:00	DIA	ETF	178.91	178.92	178.25	178.42	608590.0
2015-07-22 11:00:00	DIA	ETF	178.43	178.45	177.98	178.16	485860.0

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

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