PREVIEW / stock_1hour / 2020-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-14.parquet
  size:    1.2 MB
  rows:    51,920
  symbols: 2,471

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
2020-01-14 04:00:00	AAPL	Stock	79.125	79.1825	78.93	79.125	158712.0
2020-01-14 05:00:00	AAPL	Stock	79.0875	79.175	79.0025	79.005	66608.0
2020-01-14 06:00:00	AAPL	Stock	79.095	79.1225	78.9125	79.08	85248.0
2020-01-14 07:00:00	AAPL	Stock	79.12	79.4425	79.0525	79.3125	630080.0
2020-01-14 08:00:00	AAPL	Stock	79.255	79.4425	79.1075	79.21	1268524.0
2020-01-14 09:00:00	AAPL	Stock	79.2	79.31	78.3378	78.4425	23620652.0
2020-01-14 10:00:00	AAPL	Stock	78.4475	79.3925	78.3675	78.9382	26105476.0
2020-01-14 11:00:00	AAPL	Stock	78.94	79.15	78.65	79.135	12674252.0
2020-01-14 12:00:00	AAPL	Stock	79.1325	79.17	78.65	78.68	11118588.0
2020-01-14 13:00:00	AAPL	Stock	78.6825	78.9675	78.1875	78.345	17629932.0
2020-01-14 14:00:00	AAPL	Stock	78.35	78.75	78.0425	78.376	17425716.0
2020-01-14 15:00:00	AAPL	Stock	78.3775	78.55	78.055	78.1725	16932284.0
2020-01-14 16:00:00	AAPL	Stock	78.17	78.9463	78.1125	78.2425	9572536.0
2020-01-14 17:00:00	AAPL	Stock	78.25	78.3	78.1675	78.1875	1524780.0
2020-01-14 18:00:00	AAPL	Stock	78.185	78.1925	77.745	77.745	425472.0
2020-01-14 19:00:00	AAPL	Stock	77.745	77.995	77.6975	77.9375	220384.0
2020-01-14 04:00:00	MSFT	Stock	162.98	163.6	162.98	163.6	1617.0
2020-01-14 05:00:00	MSFT	Stock	163.59	163.6	163.2	163.2	1172.0
2020-01-14 06:00:00	MSFT	Stock	163.39	163.39	162.9	163.0	7207.0
2020-01-14 07:00:00	MSFT	Stock	163.0	163.2	162.85	163.09	27925.0
2020-01-14 08:00:00	MSFT	Stock	163.15	163.68	163.0	163.246	221971.0
2020-01-14 09:00:00	MSFT	Stock	163.17	163.46	162.52	162.85	2794039.0
2020-01-14 10:00:00	MSFT	Stock	162.85	163.6	162.77	163.183	2436492.0
2020-01-14 11:00:00	MSFT	Stock	163.2	163.24	162.82	163.196	1234823.0
2020-01-14 12:00:00	MSFT	Stock	163.195	163.45	163.12	163.21	892949.0
2020-01-14 13:00:00	MSFT	Stock	163.21	163.56	162.74	162.78	2072823.0
2020-01-14 14:00:00	MSFT	Stock	162.79	162.88	162.3	162.54	2230812.0
2020-01-14 15:00:00	MSFT	Stock	162.54	162.61	161.72	162.15	3406543.0
2020-01-14 16:00:00	MSFT	Stock	162.17	163.245	162.12	162.26	4089829.0
2020-01-14 17:00:00	MSFT	Stock	162.27	162.4	162.13	162.37	648797.0
2020-01-14 18:00:00	MSFT	Stock	162.37	162.37	161.91	161.91	15852.0
2020-01-14 19:00:00	MSFT	Stock	161.93	162.1	161.93	161.98	6415.0
2020-01-14 04:00:00	NVDA	Stock	6.2933	6.3028	6.2875	6.2875	40040.0
2020-01-14 05:00:00	NVDA	Stock	6.3175	6.322	6.2945	6.2945	154160.0
2020-01-14 06:00:00	NVDA	Stock	6.2925	6.295	6.2872	6.2872	119120.0
2020-01-14 07:00:00	NVDA	Stock	6.287	6.3023	6.28	6.2975	302440.0
2020-01-14 08:00:00	NVDA	Stock	6.2804	6.306	6.28	6.2928	862600.0
2020-01-14 09:00:00	NVDA	Stock	6.2913	6.293	6.1875	6.1908	68021040.0
2020-01-14 10:00:00	NVDA	Stock	6.1912	6.2385	6.1821	6.1949	48682000.0
2020-01-14 11:00:00	NVDA	Stock	6.1962	6.2232	6.1935	6.2178	32794560.0
2020-01-14 12:00:00	NVDA	Stock	6.2178	6.247	6.2155	6.2366	32390360.0
2020-01-14 13:00:00	NVDA	Stock	6.2375	6.2518	6.1912	6.193	33387760.0
2020-01-14 14:00:00	NVDA	Stock	6.1935	6.215	6.1702	6.2013	29569160.0
2020-01-14 15:00:00	NVDA	Stock	6.2028	6.2075	6.1688	6.1822	39636360.0
2020-01-14 16:00:00	NVDA	Stock	6.182	6.2308	6.1788	6.1935	8569840.0
2020-01-14 17:00:00	NVDA	Stock	6.1875	6.1878	6.182	6.1865	2289000.0
2020-01-14 18:00:00	NVDA	Stock	6.186	6.1875	6.167	6.1672	261360.0
2020-01-14 19:00:00	NVDA	Stock	6.1713	6.174	6.1675	6.1675	168960.0
2020-01-14 04:00:00	AMZN	Stock	94.25	94.25	94.25	94.25	5780.0
2020-01-14 05:00:00	AMZN	Stock	94.4765	94.4765	94.4765	94.4765	2000.0

> showing 50 of 51,920 rows — these rows as CSV

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