PREVIEW / stock_1hour / 2018-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-16.parquet
  size:    1.1 MB
  rows:    49,655
  symbols: 2,851

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
2018-05-16 04:00:00	AAPL	Stock	46.54	46.605	46.54	46.605	4104.0
2018-05-16 06:00:00	AAPL	Stock	46.4875	46.4875	46.4875	46.4875	800.0
2018-05-16 07:00:00	AAPL	Stock	46.56	46.625	46.5275	46.57	65828.0
2018-05-16 08:00:00	AAPL	Stock	46.639	46.64	46.375	46.435	320036.0
2018-05-16 09:00:00	AAPL	Stock	46.4225	46.7675	46.4025	46.7522	9677564.0
2018-05-16 10:00:00	AAPL	Stock	46.75	47.0938	46.714	46.965	15547500.0
2018-05-16 11:00:00	AAPL	Stock	46.965	46.9725	46.77	46.9672	8762632.0
2018-05-16 12:00:00	AAPL	Stock	46.9675	47.065	46.9525	47.0225	6556224.0
2018-05-16 13:00:00	AAPL	Stock	47.025	47.0525	46.955	47.0298	4849380.0
2018-05-16 14:00:00	AAPL	Stock	47.025	47.115	46.99	47.0975	4982492.0
2018-05-16 15:00:00	AAPL	Stock	47.095	47.0975	46.8975	47.0475	10625332.0
2018-05-16 16:00:00	AAPL	Stock	47.045	47.045	47.0125	47.035	7183884.0
2018-05-16 17:00:00	AAPL	Stock	47.0338	47.035	47.0	47.0	30432.0
2018-05-16 18:00:00	AAPL	Stock	47.0075	47.0175	47.0	47.0175	10872.0
2018-05-16 19:00:00	AAPL	Stock	47.015	47.0425	47.015	47.0375	27224.0
2018-05-16 05:00:00	MSFT	Stock	96.85	96.85	96.8	96.81	1599.0
2018-05-16 06:00:00	MSFT	Stock	97.15	97.3	97.05	97.1	6595.0
2018-05-16 07:00:00	MSFT	Stock	97.18	97.18	96.98	96.98	11945.0
2018-05-16 08:00:00	MSFT	Stock	97.1	97.18	96.9	97.05	11827.0
2018-05-16 09:00:00	MSFT	Stock	96.95	97.38	96.615	97.14	1967846.0
2018-05-16 10:00:00	MSFT	Stock	97.15	97.34	96.87	97.005	2537774.0
2018-05-16 11:00:00	MSFT	Stock	97.005	97.02	96.66	96.95	1598894.0
2018-05-16 12:00:00	MSFT	Stock	96.96	97.4	96.95	97.25	1579823.0
2018-05-16 13:00:00	MSFT	Stock	97.243	97.27	96.8	96.935	1184717.0
2018-05-16 14:00:00	MSFT	Stock	96.935	97.074	96.77	97.05	1204499.0
2018-05-16 15:00:00	MSFT	Stock	97.04	97.15	96.67	97.15	3012027.0
2018-05-16 16:00:00	MSFT	Stock	97.15	97.24	96.95	97.02	2698127.0
2018-05-16 17:00:00	MSFT	Stock	97.08	97.18	97.08	97.18	2509.0
2018-05-16 18:00:00	MSFT	Stock	97.16	97.17	97.05	97.1	1500.0
2018-05-16 19:00:00	MSFT	Stock	97.1	97.2	97.1	97.2	1255.0
2018-05-16 04:00:00	NVDA	Stock	6.1438	6.1438	6.1343	6.1343	34160.0
2018-05-16 05:00:00	NVDA	Stock	6.1343	6.1375	6.1062	6.1125	107160.0
2018-05-16 06:00:00	NVDA	Stock	6.1225	6.1275	6.1225	6.1275	33800.0
2018-05-16 07:00:00	NVDA	Stock	6.1225	6.133	6.1125	6.115	896680.0
2018-05-16 08:00:00	NVDA	Stock	6.1225	6.1513	6.0865	6.095	2537840.0
2018-05-16 09:00:00	NVDA	Stock	6.095	6.1875	6.0628	6.1839	113308320.0
2018-05-16 10:00:00	NVDA	Stock	6.1823	6.213	6.1615	6.1905	89907960.0
2018-05-16 11:00:00	NVDA	Stock	6.1896	6.1915	6.1318	6.1565	57674760.0
2018-05-16 12:00:00	NVDA	Stock	6.1568	6.1612	6.1363	6.151	32727960.0
2018-05-16 13:00:00	NVDA	Stock	6.1512	6.1525	6.118	6.1322	36000720.0
2018-05-16 14:00:00	NVDA	Stock	6.1315	6.1708	6.1264	6.1672	37929600.0
2018-05-16 15:00:00	NVDA	Stock	6.1675	6.1685	6.1268	6.1525	56463960.0
2018-05-16 16:00:00	NVDA	Stock	6.1492	6.1502	6.1378	6.1453	24861720.0
2018-05-16 17:00:00	NVDA	Stock	6.1462	6.15	6.1453	6.1453	194200.0
2018-05-16 18:00:00	NVDA	Stock	6.1462	6.1595	6.1462	6.1578	308960.0
2018-05-16 19:00:00	NVDA	Stock	6.1562	6.1562	6.1518	6.155	97880.0
2018-05-16 07:00:00	AMZN	Stock	78.925	78.95	78.925	78.9315	6000.0
2018-05-16 08:00:00	AMZN	Stock	78.95	79.025	78.7	78.7	160360.0
2018-05-16 09:00:00	AMZN	Stock	78.6847	79.504	78.6847	79.4605	12081660.0
2018-05-16 10:00:00	AMZN	Stock	79.4605	79.4945	79.2734	79.4008	7942780.0

> showing 50 of 49,655 rows — these rows as CSV

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