PREVIEW / stock_1hour / 2019-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-01.parquet
  size:    1.1 MB
  rows:    51,149
  symbols: 2,639

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-04-01 04:00:00	AAPL	Stock	47.885	48.07	47.885	48.0125	42308.0
2019-04-01 05:00:00	AAPL	Stock	48.0	48.0375	47.955	47.9775	7760.0
2019-04-01 06:00:00	AAPL	Stock	48.0	48.035	47.955	48.035	16660.0
2019-04-01 07:00:00	AAPL	Stock	48.005	48.0375	47.89	47.9375	111036.0
2019-04-01 08:00:00	AAPL	Stock	47.95	48.0	47.6075	47.86	379188.0
2019-04-01 09:00:00	AAPL	Stock	47.837	47.92	47.425	47.5372	14350544.0
2019-04-01 10:00:00	AAPL	Stock	47.5375	47.6225	47.095	47.35	21350372.0
2019-04-01 11:00:00	AAPL	Stock	47.35	47.6	47.35	47.5525	11592636.0
2019-04-01 12:00:00	AAPL	Stock	47.5515	47.645	47.4625	47.64	6682992.0
2019-04-01 13:00:00	AAPL	Stock	47.6425	47.695	47.4825	47.6805	6771156.0
2019-04-01 14:00:00	AAPL	Stock	47.68	47.7725	47.62	47.7712	7069620.0
2019-04-01 15:00:00	AAPL	Stock	47.772	47.865	47.69	47.81	14619420.0
2019-04-01 16:00:00	AAPL	Stock	47.81	47.8475	47.7625	47.825	13034740.0
2019-04-01 17:00:00	AAPL	Stock	47.8075	47.8075	47.775	47.78	20060.0
2019-04-01 18:00:00	AAPL	Stock	47.79	47.8125	47.765	47.7825	26116.0
2019-04-01 19:00:00	AAPL	Stock	47.795	47.85	47.785	47.85	42412.0
2019-04-01 04:00:00	MSFT	Stock	118.81	119.31	118.81	119.31	3273.0
2019-04-01 05:00:00	MSFT	Stock	119.48	119.48	119.02	119.02	2204.0
2019-04-01 06:00:00	MSFT	Stock	118.9	119.4	118.9	119.4	5216.0
2019-04-01 07:00:00	MSFT	Stock	119.17	119.3	119.0	119.0	9930.0
2019-04-01 08:00:00	MSFT	Stock	119.25	119.3	117.94	118.99	43959.0
2019-04-01 09:00:00	MSFT	Stock	118.809	119.02	118.3	118.565	2605237.0
2019-04-01 10:00:00	MSFT	Stock	118.57	118.81	118.1	118.45	2072736.0
2019-04-01 11:00:00	MSFT	Stock	118.46	118.89	118.43	118.667	1714599.0
2019-04-01 12:00:00	MSFT	Stock	118.666	118.94	118.495	118.915	1282695.0
2019-04-01 13:00:00	MSFT	Stock	118.92	119.05	118.81	118.95	1229762.0
2019-04-01 14:00:00	MSFT	Stock	118.95	119.08	118.825	118.99	1498656.0
2019-04-01 15:00:00	MSFT	Stock	118.99	119.108	118.815	119.02	3949528.0
2019-04-01 16:00:00	MSFT	Stock	119.02	119.15	118.85	119.03	2852704.0
2019-04-01 17:00:00	MSFT	Stock	119.05	119.07	119.02	119.04	4363.0
2019-04-01 18:00:00	MSFT	Stock	119.0	119.02	118.95	119.02	3222.0
2019-04-01 19:00:00	MSFT	Stock	119.01	119.14	119.0	119.14	7617.0
2019-04-01 04:00:00	NVDA	Stock	4.5325	4.5575	4.5325	4.5575	203080.0
2019-04-01 05:00:00	NVDA	Stock	4.5628	4.5675	4.56	4.5625	76640.0
2019-04-01 06:00:00	NVDA	Stock	4.5625	4.5628	4.5575	4.5625	51200.0
2019-04-01 07:00:00	NVDA	Stock	4.557	4.575	4.555	4.5737	780120.0
2019-04-01 08:00:00	NVDA	Stock	4.5641	4.5825	4.489	4.575	2681000.0
2019-04-01 09:00:00	NVDA	Stock	4.575	4.5838	4.5094	4.5177	110356360.0
2019-04-01 10:00:00	NVDA	Stock	4.5193	4.5438	4.512	4.5389	69583840.0
2019-04-01 11:00:00	NVDA	Stock	4.5395	4.5638	4.5328	4.5452	58907920.0
2019-04-01 12:00:00	NVDA	Stock	4.5458	4.5742	4.532	4.5737	43980320.0
2019-04-01 13:00:00	NVDA	Stock	4.5728	4.5788	4.5628	4.5767	32823000.0
2019-04-01 14:00:00	NVDA	Stock	4.5763	4.5875	4.5658	4.5732	38774360.0
2019-04-01 15:00:00	NVDA	Stock	4.5725	4.5728	4.5508	4.5578	76885360.0
2019-04-01 16:00:00	NVDA	Stock	4.557	4.567	4.5538	4.5618	23116440.0
2019-04-01 17:00:00	NVDA	Stock	4.556	4.5588	4.555	4.5562	73600.0
2019-04-01 18:00:00	NVDA	Stock	4.5562	4.56	4.555	4.555	131800.0
2019-04-01 19:00:00	NVDA	Stock	4.557	4.5578	4.5528	4.5565	370520.0
2019-04-01 04:00:00	AMZN	Stock	90.267	90.373	90.19	90.19	43880.0
2019-04-01 05:00:00	AMZN	Stock	90.2465	90.25	90.1075	90.1075	18000.0

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

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