PREVIEW / stock_1hour / 2019-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-30.parquet
  size:    1.1 MB
  rows:    50,828
  symbols: 2,624

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-30 04:00:00	AAPL	Stock	50.7525	50.8375	50.6925	50.8375	67976.0
2019-04-30 05:00:00	AAPL	Stock	50.85	50.9125	50.8125	50.875	28248.0
2019-04-30 06:00:00	AAPL	Stock	50.875	50.925	50.85	50.925	9396.0
2019-04-30 07:00:00	AAPL	Stock	50.88	50.9475	50.84	50.9125	145000.0
2019-04-30 08:00:00	AAPL	Stock	50.9125	50.9625	50.8125	50.825	491448.0
2019-04-30 09:00:00	AAPL	Stock	50.815	50.9	50.1525	50.1612	18672160.0
2019-04-30 10:00:00	AAPL	Stock	50.1675	50.3625	50.0825	50.157	21879932.0
2019-04-30 11:00:00	AAPL	Stock	50.1525	50.1925	49.7775	50.1088	23478796.0
2019-04-30 12:00:00	AAPL	Stock	50.1125	50.2225	50.0425	50.1975	11337412.0
2019-04-30 13:00:00	AAPL	Stock	50.1975	50.3325	50.05	50.3158	11148940.0
2019-04-30 14:00:00	AAPL	Stock	50.315	50.375	50.255	50.2788	12486068.0
2019-04-30 15:00:00	AAPL	Stock	50.2775	50.32	50.125	50.1425	25074488.0
2019-04-30 16:00:00	AAPL	Stock	50.1375	53.25	50.0025	52.875	27325184.0
2019-04-30 17:00:00	AAPL	Stock	52.875	52.975	52.4725	52.7375	5229488.0
2019-04-30 18:00:00	AAPL	Stock	52.7325	52.7325	52.45	52.5575	826992.0
2019-04-30 19:00:00	AAPL	Stock	52.55	52.7125	52.525	52.6975	550996.0
2019-04-30 04:00:00	MSFT	Stock	129.68	129.68	129.59	129.6	596.0
2019-04-30 05:00:00	MSFT	Stock	129.6	129.8	129.6	129.71	2498.0
2019-04-30 06:00:00	MSFT	Stock	129.76	129.98	129.7	129.85	3979.0
2019-04-30 07:00:00	MSFT	Stock	129.89	130.09	129.89	129.96	13000.0
2019-04-30 08:00:00	MSFT	Stock	129.83	130.15	129.7	129.8	18362.0
2019-04-30 09:00:00	MSFT	Stock	129.8	130.493	129.41	130.455	2539579.0
2019-04-30 10:00:00	MSFT	Stock	130.45	130.68	129.74	129.86	3286778.0
2019-04-30 11:00:00	MSFT	Stock	129.85	130.03	129.395	129.9	2751945.0
2019-04-30 12:00:00	MSFT	Stock	129.9	130.45	129.89	130.365	1658375.0
2019-04-30 13:00:00	MSFT	Stock	130.37	130.64	130.084	130.575	1602485.0
2019-04-30 14:00:00	MSFT	Stock	130.58	130.6	130.1	130.105	1913114.0
2019-04-30 15:00:00	MSFT	Stock	130.11	130.7	130.04	130.58	3826689.0
2019-04-30 16:00:00	MSFT	Stock	130.59	130.98	130.4	130.879	3582559.0
2019-04-30 17:00:00	MSFT	Stock	130.78	130.95	130.78	130.88	41444.0
2019-04-30 18:00:00	MSFT	Stock	130.89	130.99	130.88	130.95	4676.0
2019-04-30 19:00:00	MSFT	Stock	130.95	130.99	130.78	130.99	5879.0
2019-04-30 04:00:00	NVDA	Stock	4.445	4.445	4.4418	4.4418	12000.0
2019-04-30 06:00:00	NVDA	Stock	4.4502	4.4735	4.4502	4.4718	34640.0
2019-04-30 07:00:00	NVDA	Stock	4.466	4.466	4.4562	4.46	67200.0
2019-04-30 08:00:00	NVDA	Stock	4.4538	4.4747	4.445	4.445	432680.0
2019-04-30 09:00:00	NVDA	Stock	4.4452	4.4945	4.4315	4.4839	63282520.0
2019-04-30 10:00:00	NVDA	Stock	4.4852	4.5303	4.4748	4.5084	64190000.0
2019-04-30 11:00:00	NVDA	Stock	4.5082	4.5198	4.479	4.5118	41637360.0
2019-04-30 12:00:00	NVDA	Stock	4.513	4.5345	4.504	4.5142	36744880.0
2019-04-30 13:00:00	NVDA	Stock	4.5145	4.5415	4.5145	4.5402	28254160.0
2019-04-30 14:00:00	NVDA	Stock	4.5405	4.5508	4.52	4.521	36707640.0
2019-04-30 15:00:00	NVDA	Stock	4.5206	4.5348	4.5125	4.5273	52389760.0
2019-04-30 16:00:00	NVDA	Stock	4.525	4.5833	4.5202	4.5645	5996400.0
2019-04-30 17:00:00	NVDA	Stock	4.568	4.5745	4.5515	4.5515	1241360.0
2019-04-30 18:00:00	NVDA	Stock	4.5562	4.5612	4.553	4.5588	86040.0
2019-04-30 19:00:00	NVDA	Stock	4.5615	4.575	4.56	4.575	215640.0
2019-04-30 04:00:00	AMZN	Stock	96.5	96.5	96.5	96.5	2840.0
2019-04-30 05:00:00	AMZN	Stock	96.5295	96.5615	96.5295	96.5615	21800.0
2019-04-30 07:00:00	AMZN	Stock	96.575	96.575	96.565	96.565	14640.0

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

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