PREVIEW / stock_1hour / 2017-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-15.parquet
  size:    1.0 MB
  rows:    47,619
  symbols: 2,990

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-08-15 04:00:00	AAPL	Stock	40.0825	40.0875	40.0825	40.0875	4616.0
2017-08-15 05:00:00	AAPL	Stock	40.0275	40.0275	40.0275	40.0275	800.0
2017-08-15 06:00:00	AAPL	Stock	40.0825	40.0875	40.03	40.0875	23208.0
2017-08-15 07:00:00	AAPL	Stock	40.0925	40.175	40.075	40.1225	87708.0
2017-08-15 08:00:00	AAPL	Stock	40.125	40.215	40.1125	40.2	518560.0
2017-08-15 09:00:00	AAPL	Stock	40.2	40.2925	40.035	40.186	15011648.0
2017-08-15 10:00:00	AAPL	Stock	40.185	40.335	40.1025	40.3	17021112.0
2017-08-15 11:00:00	AAPL	Stock	40.3	40.4125	40.2375	40.3188	12586328.0
2017-08-15 12:00:00	AAPL	Stock	40.3188	40.545	40.3052	40.5388	14764168.0
2017-08-15 13:00:00	AAPL	Stock	40.5388	40.5488	40.365	40.4075	13942752.0
2017-08-15 14:00:00	AAPL	Stock	40.405	40.47	40.375	40.4125	8451592.0
2017-08-15 15:00:00	AAPL	Stock	40.411	40.505	40.385	40.41	16389648.0
2017-08-15 16:00:00	AAPL	Stock	40.4	40.4225	40.375	40.375	5756200.0
2017-08-15 17:00:00	AAPL	Stock	40.41	40.4125	40.3825	40.4125	32816.0
2017-08-15 18:00:00	AAPL	Stock	40.415	40.415	40.375	40.3975	253696.0
2017-08-15 19:00:00	AAPL	Stock	40.3925	40.395	40.35	40.35	21324.0
2017-08-15 04:00:00	MSFT	Stock	73.4	73.4	73.4	73.4	1459.0
2017-08-15 06:00:00	MSFT	Stock	73.52	73.52	73.5	73.5	897.0
2017-08-15 07:00:00	MSFT	Stock	73.3	73.45	73.3	73.45	789.0
2017-08-15 08:00:00	MSFT	Stock	73.5	73.5	73.32	73.41	24799.0
2017-08-15 09:00:00	MSFT	Stock	73.35	73.59	73.103	73.33	1798083.0
2017-08-15 10:00:00	MSFT	Stock	73.32	73.4	73.04	73.23	1846941.0
2017-08-15 11:00:00	MSFT	Stock	73.23	73.37	73.07	73.085	1532305.0
2017-08-15 12:00:00	MSFT	Stock	73.091	73.275	73.075	73.19	985460.0
2017-08-15 13:00:00	MSFT	Stock	73.2	73.2	73.04	73.13	1108188.0
2017-08-15 14:00:00	MSFT	Stock	73.12	73.24	73.11	73.18	919574.0
2017-08-15 15:00:00	MSFT	Stock	73.19	73.41	73.185	73.23	2779995.0
2017-08-15 16:00:00	MSFT	Stock	73.22	73.22	73.042	73.18	5054485.0
2017-08-15 17:00:00	MSFT	Stock	73.11	73.11	73.11	73.11	446.0
2017-08-15 18:00:00	MSFT	Stock	73.22	73.22	73.13	73.13	1660.0
2017-08-15 19:00:00	MSFT	Stock	73.15	73.2	73.15	73.2	600.0
2017-08-15 04:00:00	NVDA	Stock	4.2163	4.2405	4.2163	4.231	80800.0
2017-08-15 06:00:00	NVDA	Stock	4.231	4.2368	4.2013	4.225	385240.0
2017-08-15 07:00:00	NVDA	Stock	4.2248	4.2425	4.2225	4.237	2590120.0
2017-08-15 08:00:00	NVDA	Stock	4.2375	4.2432	4.2112	4.22	7714480.0
2017-08-15 09:00:00	NVDA	Stock	4.2225	4.2418	4.1398	4.167	192289680.0
2017-08-15 10:00:00	NVDA	Stock	4.1673	4.1998	4.143	4.1814	165195360.0
2017-08-15 11:00:00	NVDA	Stock	4.1816	4.2243	4.175	4.1928	95863200.0
2017-08-15 12:00:00	NVDA	Stock	4.1928	4.207	4.182	4.1957	55844160.0
2017-08-15 13:00:00	NVDA	Stock	4.1957	4.1962	4.1718	4.187	49033560.0
2017-08-15 14:00:00	NVDA	Stock	4.1865	4.1987	4.184	4.1932	39575680.0
2017-08-15 15:00:00	NVDA	Stock	4.1925	4.2	4.1735	4.174	74368240.0
2017-08-15 16:00:00	NVDA	Stock	4.1745	4.1758	4.17	4.1725	14851800.0
2017-08-15 17:00:00	NVDA	Stock	4.1722	4.175	4.17	4.175	397480.0
2017-08-15 18:00:00	NVDA	Stock	4.1758	4.1782	4.1715	4.1725	398800.0
2017-08-15 19:00:00	NVDA	Stock	4.1718	4.1738	4.17	4.17	528680.0
2017-08-15 04:00:00	AMZN	Stock	49.3675	49.3675	49.3675	49.3675	2000.0
2017-08-15 05:00:00	AMZN	Stock	49.4	49.4	49.3875	49.3875	6760.0
2017-08-15 06:00:00	AMZN	Stock	49.366	49.366	49.3	49.325	33060.0
2017-08-15 07:00:00	AMZN	Stock	49.375	49.375	49.3	49.3	34520.0

> showing 50 of 47,619 rows — these rows as CSV

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