PREVIEW / etf_1hour / 2015-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-04.parquet
  size:    237 KB
  rows:    7,572

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-08-04 04:00:00	SPY	ETF	209.69	209.92	209.42	209.53	6525.0
2015-08-04 05:00:00	SPY	ETF	209.65	209.82	209.6	209.7	2310.0
2015-08-04 06:00:00	SPY	ETF	209.6	209.6	209.22	209.38	35964.0
2015-08-04 07:00:00	SPY	ETF	209.38	209.4	209.06	209.37	358794.0
2015-08-04 08:00:00	SPY	ETF	209.4	209.83	209.15	209.81	632963.0
2015-08-04 09:00:00	SPY	ETF	209.8	210.03	209.46	209.83	9153517.0
2015-08-04 10:00:00	SPY	ETF	209.84	210.2483	209.36	209.46	14428575.0
2015-08-04 11:00:00	SPY	ETF	209.48	210.0739	209.44	209.655	6224439.0
2015-08-04 12:00:00	SPY	ETF	209.65	209.935	209.31	209.41	5698800.0
2015-08-04 13:00:00	SPY	ETF	209.41	209.88	209.05	209.13	9176726.0
2015-08-04 14:00:00	SPY	ETF	209.13	210.091	208.8	209.51	12554881.0
2015-08-04 15:00:00	SPY	ETF	209.51	210.0	209.05	209.35	18048975.0
2015-08-04 16:00:00	SPY	ETF	209.34	209.4	208.92	209.03	3942226.0
2015-08-04 17:00:00	SPY	ETF	209.033	209.033	208.87	208.9	127891.0
2015-08-04 18:00:00	SPY	ETF	208.9	209.08	208.9	209.08	120548.0
2015-08-04 19:00:00	SPY	ETF	209.08	209.09	208.98	208.99	64895.0
2015-08-04 04:00:00	QQQ	ETF	111.6	111.82	111.52	111.52	2400.0
2015-08-04 05:00:00	QQQ	ETF	111.6	111.68	111.54	111.54	1900.0
2015-08-04 06:00:00	QQQ	ETF	111.52	111.52	111.38	111.39	7300.0
2015-08-04 07:00:00	QQQ	ETF	111.35	111.4	111.26	111.4	100058.0
2015-08-04 08:00:00	QQQ	ETF	111.34	111.58	111.31	111.55	105323.0
2015-08-04 09:00:00	QQQ	ETF	111.57	111.69	111.16	111.44	3395365.0
2015-08-04 10:00:00	QQQ	ETF	111.44	111.745	110.93	111.0	4479596.0
2015-08-04 11:00:00	QQQ	ETF	111.0	111.355	110.975	111.28	1694318.0
2015-08-04 12:00:00	QQQ	ETF	111.28	111.53	111.12	111.1951	1091800.0
2015-08-04 13:00:00	QQQ	ETF	111.2	111.695	111.1	111.18	2011351.0
2015-08-04 14:00:00	QQQ	ETF	111.17	111.635	110.99	111.56	2629381.0
2015-08-04 15:00:00	QQQ	ETF	111.5599	111.66	111.19	111.38	3958479.0
2015-08-04 16:00:00	QQQ	ETF	111.38	111.6318	111.1	111.2	836956.0
2015-08-04 17:00:00	QQQ	ETF	111.39	111.39	111.09	111.09	537750.0
2015-08-04 18:00:00	QQQ	ETF	111.13	111.2	111.12	111.2	8150.0
2015-08-04 19:00:00	QQQ	ETF	111.2	111.21	111.15	111.15	39450.0
2015-08-04 04:00:00	IWM	ETF	122.36	122.36	122.36	122.36	200.0
2015-08-04 06:00:00	IWM	ETF	122.25	122.25	122.25	122.25	100.0
2015-08-04 07:00:00	IWM	ETF	122.13	122.19	122.02	122.19	41550.0
2015-08-04 08:00:00	IWM	ETF	122.2	122.4	122.16	122.4	86129.0
2015-08-04 09:00:00	IWM	ETF	122.37	122.93	122.125	122.76	2994089.0
2015-08-04 10:00:00	IWM	ETF	122.77	122.96	122.47	122.54	4249249.0
2015-08-04 11:00:00	IWM	ETF	122.53	122.69	122.29	122.38	1538175.0
2015-08-04 12:00:00	IWM	ETF	122.37	122.58	121.87	121.97	1526229.0
2015-08-04 13:00:00	IWM	ETF	121.96	122.17	121.76	121.9	1633482.0
2015-08-04 14:00:00	IWM	ETF	121.88	122.12	121.61	122.03	2242322.0
2015-08-04 15:00:00	IWM	ETF	122.03	122.1	121.795	122.03	2909907.0
2015-08-04 16:00:00	IWM	ETF	122.04	122.08	121.75	122.03	1707459.0
2015-08-04 17:00:00	IWM	ETF	121.79	121.79	121.78	121.78	300.0
2015-08-04 19:00:00	IWM	ETF	121.75	121.75	121.75	121.75	600.0
2015-08-04 06:00:00	DIA	ETF	175.4	175.46	175.34	175.46	500.0
2015-08-04 07:00:00	DIA	ETF	175.41	175.41	175.26	175.37	900.0
2015-08-04 08:00:00	DIA	ETF	175.53	175.54	175.45	175.48	3930.0
2015-08-04 09:00:00	DIA	ETF	175.75	176.04	175.5	175.83	415480.0

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

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