PREVIEW / etf_1hour / 2017-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-03.parquet
  size:    273 KB
  rows:    8,897

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
2017-05-03 04:00:00	SPY	ETF	238.39	238.39	238.24	238.32	5720.0
2017-05-03 05:00:00	SPY	ETF	238.35	238.35	238.27	238.32	35985.0
2017-05-03 06:00:00	SPY	ETF	238.31	238.39	238.25	238.35	55722.0
2017-05-03 07:00:00	SPY	ETF	238.35	238.48	238.33	238.41	282577.0
2017-05-03 08:00:00	SPY	ETF	238.3	238.48	238.3	238.4	179113.0
2017-05-03 09:00:00	SPY	ETF	238.42	238.49	238.17	238.375	5987939.0
2017-05-03 10:00:00	SPY	ETF	238.37	238.47	237.7	237.86	9555141.0
2017-05-03 11:00:00	SPY	ETF	237.8699	238.44	237.86	238.31	7630818.0
2017-05-03 12:00:00	SPY	ETF	238.315	238.37	238.15	238.2557	5330069.0
2017-05-03 13:00:00	SPY	ETF	238.25	238.8775	238.01	238.21	7969343.0
2017-05-03 14:00:00	SPY	ETF	238.19	238.55	238.045	238.44	9401463.0
2017-05-03 15:00:00	SPY	ETF	238.44	238.74	238.32	238.52	13461390.0
2017-05-03 16:00:00	SPY	ETF	238.54	238.6	238.2971	238.38	8888842.0
2017-05-03 17:00:00	SPY	ETF	238.4	238.58	238.37	238.38	2151390.0
2017-05-03 18:00:00	SPY	ETF	238.38	238.4	238.32	238.36	60234.0
2017-05-03 19:00:00	SPY	ETF	238.36	238.75	238.34	238.67	215486.0
2017-05-03 04:00:00	QQQ	ETF	136.92	137.01	136.92	137.01	6500.0
2017-05-03 05:00:00	QQQ	ETF	137.03	137.04	137.03	137.04	3554.0
2017-05-03 06:00:00	QQQ	ETF	136.99	137.07	136.99	137.06	6899.0
2017-05-03 07:00:00	QQQ	ETF	137.06	137.15	137.03	137.11	22071.0
2017-05-03 08:00:00	QQQ	ETF	137.13	137.2	137.06	137.2	60207.0
2017-05-03 09:00:00	QQQ	ETF	137.2	137.22	136.86	136.945	2864771.0
2017-05-03 10:00:00	QQQ	ETF	136.94	136.99	136.63	136.68	4068562.0
2017-05-03 11:00:00	QQQ	ETF	136.68	136.93	136.615	136.85	1855766.0
2017-05-03 12:00:00	QQQ	ETF	136.85	136.98	136.8	136.9125	874869.0
2017-05-03 13:00:00	QQQ	ETF	136.92	136.97	136.765	136.83	920971.0
2017-05-03 14:00:00	QQQ	ETF	136.84	137.02	136.7045	136.87	2115968.0
2017-05-03 15:00:00	QQQ	ETF	136.88	137.15	136.77	136.98	3285054.0
2017-05-03 16:00:00	QQQ	ETF	136.99	137.04	136.65	136.72	711511.0
2017-05-03 17:00:00	QQQ	ETF	136.71	136.98	136.63	136.64	510747.0
2017-05-03 18:00:00	QQQ	ETF	136.7	136.76	136.65	136.76	13661.0
2017-05-03 19:00:00	QQQ	ETF	136.77	137.03	136.77	136.98	31748.0
2017-05-03 04:00:00	IWM	ETF	138.68	138.68	138.61	138.61	400.0
2017-05-03 06:00:00	IWM	ETF	138.6	138.7	138.6	138.7	1500.0
2017-05-03 07:00:00	IWM	ETF	138.67	138.82	138.67	138.76	10936.0
2017-05-03 08:00:00	IWM	ETF	138.68	138.68	138.42	138.53	56020.0
2017-05-03 09:00:00	IWM	ETF	138.52	138.76	138.16	138.4	2846091.0
2017-05-03 10:00:00	IWM	ETF	138.41	138.53	137.75	137.91	3890079.0
2017-05-03 11:00:00	IWM	ETF	137.85	138.43	137.8	138.16	2825356.0
2017-05-03 12:00:00	IWM	ETF	138.15	138.24	137.99	138.11	1412013.0
2017-05-03 13:00:00	IWM	ETF	138.115	138.24	137.98	138.12	1031750.0
2017-05-03 14:00:00	IWM	ETF	138.12	138.39	137.69	138.08	3304538.0
2017-05-03 15:00:00	IWM	ETF	138.08	138.39	137.97	138.34	4721007.0
2017-05-03 16:00:00	IWM	ETF	138.29	138.34	137.995	138.14	1662841.0
2017-05-03 17:00:00	IWM	ETF	138.29	138.29	138.03	138.03	269467.0
2017-05-03 18:00:00	IWM	ETF	138.09	138.13	138.05	138.13	6600.0
2017-05-03 19:00:00	IWM	ETF	138.12	138.3	138.12	138.29	108104.0
2017-05-03 07:00:00	DIA	ETF	208.83	208.92	208.83	208.92	400.0
2017-05-03 08:00:00	DIA	ETF	208.89	208.91	208.83	208.85	6032.0
2017-05-03 09:00:00	DIA	ETF	208.9	208.96	208.73	208.92	170549.0

> showing 50 of 8,897 rows — these rows as CSV

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