PREVIEW / stock_1hour / 2019-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-28.parquet
  size:    1.1 MB
  rows:    50,736
  symbols: 2,601

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
2019-05-28 04:00:00	AAPL	Stock	44.6875	44.6975	44.5225	44.545	25104.0
2019-05-28 05:00:00	AAPL	Stock	44.625	44.7425	44.5375	44.725	18256.0
2019-05-28 06:00:00	AAPL	Stock	44.6425	44.6425	44.4725	44.6	27704.0
2019-05-28 07:00:00	AAPL	Stock	44.525	44.8525	44.525	44.8	70180.0
2019-05-28 08:00:00	AAPL	Stock	44.531	44.8425	44.525	44.6625	341720.0
2019-05-28 09:00:00	AAPL	Stock	44.66	45.1475	44.625	44.8825	14313648.0
2019-05-28 10:00:00	AAPL	Stock	44.881	44.9425	44.4775	44.715	15446504.0
2019-05-28 11:00:00	AAPL	Stock	44.71	44.8575	44.575	44.76	10116076.0
2019-05-28 12:00:00	AAPL	Stock	44.7625	44.835	44.69	44.7025	5882692.0
2019-05-28 13:00:00	AAPL	Stock	44.7025	44.8225	44.64	44.8	6267556.0
2019-05-28 14:00:00	AAPL	Stock	44.8	44.8825	44.6825	44.7325	8741784.0
2019-05-28 15:00:00	AAPL	Stock	44.73	44.8075	44.5225	44.5425	19235216.0
2019-05-28 16:00:00	AAPL	Stock	44.54	44.665	44.5025	44.565	15102356.0
2019-05-28 17:00:00	AAPL	Stock	44.55	44.6025	44.55	44.5575	94496.0
2019-05-28 18:00:00	AAPL	Stock	44.5575	44.625	44.5575	44.6225	313596.0
2019-05-28 19:00:00	AAPL	Stock	44.6	44.62	44.5625	44.5875	25724.0
2019-05-28 04:00:00	MSFT	Stock	126.29	126.29	126.0	126.16	1257.0
2019-05-28 05:00:00	MSFT	Stock	126.25	126.52	126.25	126.47	1434.0
2019-05-28 06:00:00	MSFT	Stock	126.47	126.47	126.18	126.18	1567.0
2019-05-28 07:00:00	MSFT	Stock	126.25	126.66	126.22	126.55	5125.0
2019-05-28 08:00:00	MSFT	Stock	126.23	126.73	126.22	126.5	18091.0
2019-05-28 09:00:00	MSFT	Stock	126.47	128.0	126.47	127.9	1995537.0
2019-05-28 10:00:00	MSFT	Stock	127.9	127.97	126.93	127.402	2359293.0
2019-05-28 11:00:00	MSFT	Stock	127.39	127.661	127.02	127.48	1517972.0
2019-05-28 12:00:00	MSFT	Stock	127.48	127.63	127.34	127.42	1170743.0
2019-05-28 13:00:00	MSFT	Stock	127.4	127.43	127.12	127.2	1008536.0
2019-05-28 14:00:00	MSFT	Stock	127.21	127.21	126.58	126.8	1472331.0
2019-05-28 15:00:00	MSFT	Stock	126.8	126.83	126.05	126.05	4236387.0
2019-05-28 16:00:00	MSFT	Stock	126.16	126.6	126.07	126.35	4868738.0
2019-05-28 17:00:00	MSFT	Stock	126.35	126.39	126.16	126.16	17180.0
2019-05-28 18:00:00	MSFT	Stock	126.16	126.47	126.16	126.39	127385.0
2019-05-28 19:00:00	MSFT	Stock	126.35	126.39	126.25	126.38	2728.0
2019-05-28 04:00:00	NVDA	Stock	3.626	3.626	3.626	3.626	20120.0
2019-05-28 06:00:00	NVDA	Stock	3.6332	3.6468	3.6252	3.6468	61760.0
2019-05-28 07:00:00	NVDA	Stock	3.6388	3.65	3.6325	3.6475	160160.0
2019-05-28 08:00:00	NVDA	Stock	3.6375	3.65	3.6332	3.6425	1506920.0
2019-05-28 09:00:00	NVDA	Stock	3.6405	3.6795	3.6263	3.6322	59797840.0
2019-05-28 10:00:00	NVDA	Stock	3.6322	3.6465	3.5888	3.604	87027480.0
2019-05-28 11:00:00	NVDA	Stock	3.6038	3.6328	3.6005	3.6112	50271800.0
2019-05-28 12:00:00	NVDA	Stock	3.6108	3.634	3.6071	3.6076	30290840.0
2019-05-28 13:00:00	NVDA	Stock	3.6072	3.6332	3.6065	3.6259	27450080.0
2019-05-28 14:00:00	NVDA	Stock	3.6259	3.6265	3.5955	3.6052	33026160.0
2019-05-28 15:00:00	NVDA	Stock	3.605	3.605	3.5812	3.5825	58955560.0
2019-05-28 16:00:00	NVDA	Stock	3.5833	3.59	3.5825	3.5838	21942600.0
2019-05-28 17:00:00	NVDA	Stock	3.585	3.5862	3.575	3.5765	390080.0
2019-05-28 18:00:00	NVDA	Stock	3.5833	3.5833	3.575	3.5785	1402720.0
2019-05-28 19:00:00	NVDA	Stock	3.5785	3.5818	3.5712	3.5712	630920.0
2019-05-28 04:00:00	AMZN	Stock	91.606	91.606	91.549	91.549	10400.0
2019-05-28 05:00:00	AMZN	Stock	91.1645	91.1645	91.1645	91.1645	5000.0
2019-05-28 06:00:00	AMZN	Stock	91.5435	91.5435	91.3175	91.3175	15060.0

> showing 50 of 50,736 rows — these rows as CSV

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