PREVIEW / etf_1hour / 2017-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-16.parquet
  size:    267 KB
  rows:    8,786

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-06-16 04:00:00	SPY	ETF	243.16	243.18	242.94	242.94	12060.0
2017-06-16 05:00:00	SPY	ETF	242.93	243.08	242.92	242.92	15890.0
2017-06-16 06:00:00	SPY	ETF	242.94	243.08	242.94	243.0	26230.0
2017-06-16 07:00:00	SPY	ETF	243.05	243.14	243.02	243.06	283871.0
2017-06-16 08:00:00	SPY	ETF	243.06	243.06	242.65	242.7	461335.0
2017-06-16 09:00:00	SPY	ETF	242.69	242.84	241.77	242.1992	13085862.0
2017-06-16 10:00:00	SPY	ETF	242.18	242.24	241.6337	241.8311	10172452.0
2017-06-16 11:00:00	SPY	ETF	241.84	242.275	241.72	242.275	6441960.0
2017-06-16 12:00:00	SPY	ETF	242.275	242.439	242.24	242.26	10171276.0
2017-06-16 13:00:00	SPY	ETF	242.27	242.83	242.1	242.33	3268325.0
2017-06-16 14:00:00	SPY	ETF	242.33	242.83	242.26	242.43	6704756.0
2017-06-16 15:00:00	SPY	ETF	242.435	242.68	242.195	242.63	16804328.0
2017-06-16 16:00:00	SPY	ETF	242.63	242.99	242.2396	242.98	13449773.0
2017-06-16 17:00:00	SPY	ETF	242.98	243.12	241.8273	243.05	2728638.0
2017-06-16 18:00:00	SPY	ETF	243.06	243.08	243.04	243.05	21658.0
2017-06-16 19:00:00	SPY	ETF	243.07	243.09	243.05	243.09	40541.0
2017-06-16 04:00:00	QQQ	ETF	139.18	139.19	138.8	138.8	21700.0
2017-06-16 05:00:00	QQQ	ETF	138.88	138.97	138.88	138.88	5911.0
2017-06-16 06:00:00	QQQ	ETF	138.9	139.01	138.9	138.95	11173.0
2017-06-16 07:00:00	QQQ	ETF	138.98	139.03	138.97	138.98	30947.0
2017-06-16 08:00:00	QQQ	ETF	138.99	138.99	138.5	138.51	193911.0
2017-06-16 09:00:00	QQQ	ETF	138.5	138.77	138.04	138.6	6330401.0
2017-06-16 10:00:00	QQQ	ETF	138.6	138.605	137.67	137.86	6188816.0
2017-06-16 11:00:00	QQQ	ETF	137.855	138.26	137.638	138.2365	3994786.0
2017-06-16 12:00:00	QQQ	ETF	138.25	138.4	138.17	138.23	2441326.0
2017-06-16 13:00:00	QQQ	ETF	138.23	138.38	138.09	138.38	2127163.0
2017-06-16 14:00:00	QQQ	ETF	138.37	138.5564	138.345	138.43	2650494.0
2017-06-16 15:00:00	QQQ	ETF	138.44	138.5	138.0201	138.22	7238690.0
2017-06-16 16:00:00	QQQ	ETF	138.23	138.36	138.15	138.36	3306693.0
2017-06-16 17:00:00	QQQ	ETF	138.28	138.37	138.23	138.3	1037087.0
2017-06-16 18:00:00	QQQ	ETF	138.3	138.3	138.3	138.3	200.0
2017-06-16 19:00:00	QQQ	ETF	138.37	138.38	138.27	138.33	5588.0
2017-06-16 04:00:00	IWM	ETF	140.86	140.86	140.86	140.86	300.0
2017-06-16 05:00:00	IWM	ETF	140.86	140.86	140.76	140.84	4100.0
2017-06-16 06:00:00	IWM	ETF	140.81	140.87	140.76	140.76	10200.0
2017-06-16 07:00:00	IWM	ETF	140.84	140.87	140.78	140.78	44410.0
2017-06-16 08:00:00	IWM	ETF	140.78	140.78	140.26	140.32	165453.0
2017-06-16 09:00:00	IWM	ETF	140.35	140.46	139.28	139.98	6023395.0
2017-06-16 10:00:00	IWM	ETF	139.985	140.03	139.36	139.57	2969880.0
2017-06-16 11:00:00	IWM	ETF	139.57	139.68	139.32	139.64	1694991.0
2017-06-16 12:00:00	IWM	ETF	139.65	139.88	139.58	139.6	1694030.0
2017-06-16 13:00:00	IWM	ETF	139.61	139.7865	139.545	139.77	1119379.0
2017-06-16 14:00:00	IWM	ETF	139.78	139.81	139.59	139.8	1293839.0
2017-06-16 15:00:00	IWM	ETF	139.8	140.215	139.61	140.19	6363584.0
2017-06-16 16:00:00	IWM	ETF	140.18	140.53	140.08	140.53	1222475.0
2017-06-16 17:00:00	IWM	ETF	140.52	140.52	139.8864	140.19	3829754.0
2017-06-16 18:00:00	IWM	ETF	140.5	140.5	140.5	140.5	100.0
2017-06-16 19:00:00	IWM	ETF	140.52	140.54	140.52	140.54	1600.0
2017-06-16 04:00:00	DIA	ETF	213.76	213.76	213.76	213.76	400.0
2017-06-16 08:00:00	DIA	ETF	213.54	213.54	213.4	213.4	4900.0

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

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