PREVIEW / stock_1hour / 2018-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-31.parquet
  size:    1.1 MB
  rows:    50,376
  symbols: 2,914

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-01-31 04:00:00	AAPL	Stock	41.625	41.625	41.3875	41.4275	117072.0
2018-01-31 05:00:00	AAPL	Stock	41.415	41.495	41.415	41.455	48196.0
2018-01-31 06:00:00	AAPL	Stock	41.475	41.475	41.4	41.4625	124616.0
2018-01-31 07:00:00	AAPL	Stock	41.4625	41.6225	41.4375	41.5675	543456.0
2018-01-31 08:00:00	AAPL	Stock	41.4625	41.9975	41.45	41.6725	1236620.0
2018-01-31 09:00:00	AAPL	Stock	41.69	42.1105	41.6625	41.8975	20096748.0
2018-01-31 10:00:00	AAPL	Stock	41.8925	42.0575	41.84	41.885	15057344.0
2018-01-31 11:00:00	AAPL	Stock	41.8875	41.9275	41.68	41.6948	10275880.0
2018-01-31 12:00:00	AAPL	Stock	41.6975	41.8125	41.6625	41.6765	9340096.0
2018-01-31 13:00:00	AAPL	Stock	41.6775	41.79	41.67	41.7572	7468856.0
2018-01-31 14:00:00	AAPL	Stock	41.7575	41.8475	41.625	41.7225	13282256.0
2018-01-31 15:00:00	AAPL	Stock	41.7225	41.9138	41.6875	41.8675	21420456.0
2018-01-31 16:00:00	AAPL	Stock	41.8675	41.875	41.625	41.6375	13960772.0
2018-01-31 17:00:00	AAPL	Stock	41.67	41.7975	41.6375	41.725	383444.0
2018-01-31 18:00:00	AAPL	Stock	41.735	41.8	41.5825	41.665	253676.0
2018-01-31 19:00:00	AAPL	Stock	41.675	41.715	41.6	41.715	283016.0
2018-01-31 04:00:00	MSFT	Stock	93.48	93.55	93.4	93.54	5641.0
2018-01-31 05:00:00	MSFT	Stock	93.53	93.55	93.4	93.55	5731.0
2018-01-31 06:00:00	MSFT	Stock	93.66	93.82	93.45	93.49	11347.0
2018-01-31 07:00:00	MSFT	Stock	93.55	93.7	93.45	93.7	50885.0
2018-01-31 08:00:00	MSFT	Stock	93.55	93.85	92.94	93.62	169181.0
2018-01-31 09:00:00	MSFT	Stock	93.6	94.0	93.4	93.751	3664937.0
2018-01-31 10:00:00	MSFT	Stock	93.75	94.48	93.51	94.09	4771252.0
2018-01-31 11:00:00	MSFT	Stock	94.09	94.32	93.81	93.846	3584062.0
2018-01-31 12:00:00	MSFT	Stock	93.85	94.35	93.81	94.25	3487332.0
2018-01-31 13:00:00	MSFT	Stock	94.25	94.76	94.2	94.349	3742096.0
2018-01-31 14:00:00	MSFT	Stock	94.35	94.66	93.83	93.86	4883897.0
2018-01-31 15:00:00	MSFT	Stock	93.86	95.4	93.51	95.2	10630653.0
2018-01-31 16:00:00	MSFT	Stock	95.01	96.12	92.0	94.4	8189653.0
2018-01-31 17:00:00	MSFT	Stock	94.4	95.7	93.3	95.0	1020463.0
2018-01-31 18:00:00	MSFT	Stock	95.13	95.59	94.0	94.67	463205.0
2018-01-31 19:00:00	MSFT	Stock	94.67	95.35	94.67	95.12	115204.0
2018-01-31 04:00:00	NVDA	Stock	6.095	6.1	6.095	6.0975	61520.0
2018-01-31 05:00:00	NVDA	Stock	6.1193	6.1193	6.1193	6.1193	9120.0
2018-01-31 06:00:00	NVDA	Stock	6.129	6.1472	6.1248	6.1305	77480.0
2018-01-31 07:00:00	NVDA	Stock	6.125	6.1438	6.1108	6.1438	1002120.0
2018-01-31 08:00:00	NVDA	Stock	6.1449	6.1462	6.1108	6.1462	2059440.0
2018-01-31 09:00:00	NVDA	Stock	6.1462	6.1973	6.1313	6.185	71652240.0
2018-01-31 10:00:00	NVDA	Stock	6.184	6.2318	6.1808	6.1976	76178880.0
2018-01-31 11:00:00	NVDA	Stock	6.2	6.2025	6.1654	6.1714	39538400.0
2018-01-31 12:00:00	NVDA	Stock	6.173	6.215	6.1655	6.1976	27894720.0
2018-01-31 13:00:00	NVDA	Stock	6.1973	6.2072	6.1882	6.1909	18044200.0
2018-01-31 14:00:00	NVDA	Stock	6.1903	6.2138	6.157	6.1755	47407560.0
2018-01-31 15:00:00	NVDA	Stock	6.1753	6.1788	6.1112	6.1458	74706040.0
2018-01-31 16:00:00	NVDA	Stock	6.145	6.1488	6.075	6.1068	33014040.0
2018-01-31 17:00:00	NVDA	Stock	6.106	6.1625	6.0952	6.1622	1189480.0
2018-01-31 18:00:00	NVDA	Stock	6.155	6.1693	6.15	6.1528	550920.0
2018-01-31 19:00:00	NVDA	Stock	6.1532	6.17	6.1532	6.1625	115880.0
2018-01-31 04:00:00	AMZN	Stock	72.4	72.4375	72.251	72.251	68860.0
2018-01-31 05:00:00	AMZN	Stock	72.3245	72.3665	72.3245	72.3665	41460.0

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

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