PREVIEW / stock_1hour / 2018-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-09.parquet
  size:    1.1 MB
  rows:    49,058
  symbols: 2,733

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-11-09 04:00:00	AAPL	Stock	51.72	51.72	51.6	51.6075	13408.0
2018-11-09 05:00:00	AAPL	Stock	51.6175	51.725	51.6	51.625	17856.0
2018-11-09 06:00:00	AAPL	Stock	51.585	51.6225	51.48	51.5125	33708.0
2018-11-09 07:00:00	AAPL	Stock	51.565	51.64	51.395	51.425	444392.0
2018-11-09 08:00:00	AAPL	Stock	51.5375	51.66	51.375	51.485	511760.0
2018-11-09 09:00:00	AAPL	Stock	51.4675	51.5025	51.025	51.3288	18813144.0
2018-11-09 10:00:00	AAPL	Stock	51.3225	51.435	50.98	51.0475	16289132.0
2018-11-09 11:00:00	AAPL	Stock	51.05	51.13	50.79	50.86	16058936.0
2018-11-09 12:00:00	AAPL	Stock	50.86	51.01	50.77	50.8925	9061260.0
2018-11-09 13:00:00	AAPL	Stock	50.8925	50.91	50.6605	50.6625	7456028.0
2018-11-09 14:00:00	AAPL	Stock	50.6625	51.0	50.5625	50.92	11218128.0
2018-11-09 15:00:00	AAPL	Stock	50.93	51.195	50.9	51.1175	16884828.0
2018-11-09 16:00:00	AAPL	Stock	51.1175	51.1425	51.0175	51.0425	20764136.0
2018-11-09 17:00:00	AAPL	Stock	51.04	51.045	50.99	51.0	55176.0
2018-11-09 18:00:00	AAPL	Stock	50.985	50.9975	50.9525	50.955	95340.0
2018-11-09 19:00:00	AAPL	Stock	50.9525	50.96	50.8825	50.925	47824.0
2018-11-09 05:00:00	MSFT	Stock	111.08	111.08	111.08	111.08	100.0
2018-11-09 06:00:00	MSFT	Stock	111.4	111.48	110.87	110.95	3065.0
2018-11-09 07:00:00	MSFT	Stock	110.85	111.06	110.85	110.95	7783.0
2018-11-09 08:00:00	MSFT	Stock	110.93	111.2	110.85	111.0	15995.0
2018-11-09 09:00:00	MSFT	Stock	111.0	111.45	110.26	110.49	3481227.0
2018-11-09 10:00:00	MSFT	Stock	110.49	110.78	109.06	109.336	4369302.0
2018-11-09 11:00:00	MSFT	Stock	109.33	110.03	109.11	109.18	3968819.0
2018-11-09 12:00:00	MSFT	Stock	109.165	109.43	108.95	109.15	2037110.0
2018-11-09 13:00:00	MSFT	Stock	109.16	109.31	108.76	109.05	2338133.0
2018-11-09 14:00:00	MSFT	Stock	109.04	109.63	108.88	109.525	3152299.0
2018-11-09 15:00:00	MSFT	Stock	109.53	109.98	109.495	109.53	4526875.0
2018-11-09 16:00:00	MSFT	Stock	109.57	109.57	109.25	109.45	5103609.0
2018-11-09 17:00:00	MSFT	Stock	109.41	109.42	109.32	109.42	5831.0
2018-11-09 18:00:00	MSFT	Stock	109.39	109.39	109.25	109.25	1500.0
2018-11-09 19:00:00	MSFT	Stock	109.25	109.29	109.17	109.17	3353.0
2018-11-09 04:00:00	NVDA	Stock	5.1	5.1	5.093	5.093	17840.0
2018-11-09 05:00:00	NVDA	Stock	5.0875	5.0875	5.0875	5.0875	8000.0
2018-11-09 06:00:00	NVDA	Stock	5.0875	5.0875	5.073	5.075	16760.0
2018-11-09 07:00:00	NVDA	Stock	5.0848	5.1432	5.0688	5.0862	476720.0
2018-11-09 08:00:00	NVDA	Stock	5.1025	5.118	5.05	5.0625	1434280.0
2018-11-09 09:00:00	NVDA	Stock	5.0625	5.1375	5.026	5.129	67463280.0
2018-11-09 10:00:00	NVDA	Stock	5.127	5.233	5.094	5.2097	78475040.0
2018-11-09 11:00:00	NVDA	Stock	5.2112	5.2208	5.103	5.1172	50938840.0
2018-11-09 12:00:00	NVDA	Stock	5.1168	5.1585	5.1138	5.1427	30479240.0
2018-11-09 13:00:00	NVDA	Stock	5.1415	5.1788	5.1025	5.1098	32728040.0
2018-11-09 14:00:00	NVDA	Stock	5.1088	5.1583	5.0733	5.1457	36717960.0
2018-11-09 15:00:00	NVDA	Stock	5.1488	5.1725	5.1375	5.1403	49288000.0
2018-11-09 16:00:00	NVDA	Stock	5.1418	5.1488	5.1378	5.1435	22711200.0
2018-11-09 17:00:00	NVDA	Stock	5.1425	5.143	5.125	5.127	605280.0
2018-11-09 18:00:00	NVDA	Stock	5.128	5.1313	5.1125	5.1138	454200.0
2018-11-09 19:00:00	NVDA	Stock	5.1195	5.125	5.092	5.0938	131120.0
2018-11-09 05:00:00	AMZN	Stock	87.012	87.012	87.0005	87.0005	5500.0
2018-11-09 06:00:00	AMZN	Stock	86.859	86.859	86.859	86.859	2220.0
2018-11-09 07:00:00	AMZN	Stock	86.8	86.9005	86.6105	86.795	273600.0

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

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