PREVIEW / stock_1hour / 2018-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-10.parquet
  size:    1.1 MB
  rows:    48,897
  symbols: 2,773

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-08-10 04:00:00	AAPL	Stock	51.975	51.975	51.75	51.8475	43360.0
2018-08-10 05:00:00	AAPL	Stock	51.8475	51.8725	51.8125	51.825	27972.0
2018-08-10 06:00:00	AAPL	Stock	51.8	51.9	51.8	51.8875	43344.0
2018-08-10 07:00:00	AAPL	Stock	51.9175	51.9675	51.85	51.85	176068.0
2018-08-10 08:00:00	AAPL	Stock	51.9105	51.9625	51.8375	51.8625	424084.0
2018-08-10 09:00:00	AAPL	Stock	51.8575	52.275	51.8	52.0125	14340680.0
2018-08-10 10:00:00	AAPL	Stock	52.0125	52.2475	51.9675	51.9975	15147964.0
2018-08-10 11:00:00	AAPL	Stock	51.995	52.125	51.9625	51.995	9491176.0
2018-08-10 12:00:00	AAPL	Stock	51.9925	52.0415	51.9375	51.972	5250136.0
2018-08-10 13:00:00	AAPL	Stock	51.97	51.985	51.6675	51.7325	7610056.0
2018-08-10 14:00:00	AAPL	Stock	51.7325	51.8375	51.67	51.8062	8181248.0
2018-08-10 15:00:00	AAPL	Stock	51.8075	51.985	51.7682	51.8875	13249492.0
2018-08-10 16:00:00	AAPL	Stock	51.8825	51.94	51.8825	51.925	6245500.0
2018-08-10 17:00:00	AAPL	Stock	51.905	51.9125	51.8825	51.8825	42036.0
2018-08-10 18:00:00	AAPL	Stock	51.9075	51.935	51.9075	51.935	11660.0
2018-08-10 19:00:00	AAPL	Stock	51.9375	51.945	51.915	51.925	31284.0
2018-08-10 04:00:00	MSFT	Stock	109.0	109.01	109.0	109.01	1000.0
2018-08-10 07:00:00	MSFT	Stock	109.45	109.46	109.15	109.15	3259.0
2018-08-10 08:00:00	MSFT	Stock	109.034	109.5	109.03	109.31	24491.0
2018-08-10 09:00:00	MSFT	Stock	109.3	109.69	109.0	109.27	2242564.0
2018-08-10 10:00:00	MSFT	Stock	109.27	109.66	109.1	109.415	2159643.0
2018-08-10 11:00:00	MSFT	Stock	109.43	109.6	109.31	109.37	1249675.0
2018-08-10 12:00:00	MSFT	Stock	109.37	109.47	109.25	109.38	976700.0
2018-08-10 13:00:00	MSFT	Stock	109.37	109.375	108.77	108.9	1323667.0
2018-08-10 14:00:00	MSFT	Stock	108.9	108.985	108.38	108.626	1967807.0
2018-08-10 15:00:00	MSFT	Stock	108.62	109.13	108.5	109.01	2812849.0
2018-08-10 16:00:00	MSFT	Stock	109.01	109.24	108.767	109.1	3559724.0
2018-08-10 17:00:00	MSFT	Stock	109.21	109.21	109.0	109.12	8337.0
2018-08-10 18:00:00	MSFT	Stock	109.17	109.17	109.1	109.12	860.0
2018-08-10 19:00:00	MSFT	Stock	109.12	109.12	109.04	109.07	2704.0
2018-08-10 05:00:00	NVDA	Stock	6.3562	6.3562	6.35	6.35	61840.0
2018-08-10 06:00:00	NVDA	Stock	6.3592	6.3592	6.3502	6.3502	12360.0
2018-08-10 07:00:00	NVDA	Stock	6.357	6.365	6.338	6.3413	344080.0
2018-08-10 08:00:00	NVDA	Stock	6.35	6.3678	6.3255	6.3415	971280.0
2018-08-10 09:00:00	NVDA	Stock	6.35	6.4025	6.3175	6.364	35574080.0
2018-08-10 10:00:00	NVDA	Stock	6.3608	6.3818	6.3352	6.353	38551680.0
2018-08-10 11:00:00	NVDA	Stock	6.3512	6.366	6.3418	6.3548	18362480.0
2018-08-10 12:00:00	NVDA	Stock	6.3559	6.368	6.3422	6.3568	13296520.0
2018-08-10 13:00:00	NVDA	Stock	6.3565	6.3588	6.3218	6.3225	19844400.0
2018-08-10 14:00:00	NVDA	Stock	6.3218	6.3409	6.3218	6.332	25141800.0
2018-08-10 15:00:00	NVDA	Stock	6.3325	6.37	6.3253	6.3698	51360120.0
2018-08-10 16:00:00	NVDA	Stock	6.3698	6.3848	6.3583	6.3792	23634320.0
2018-08-10 17:00:00	NVDA	Stock	6.375	6.3788	6.3385	6.3498	544040.0
2018-08-10 18:00:00	NVDA	Stock	6.35	6.3595	6.3458	6.3588	421360.0
2018-08-10 19:00:00	NVDA	Stock	6.3565	6.3575	6.3502	6.3575	65360.0
2018-08-10 04:00:00	AMZN	Stock	94.6	94.609	94.6	94.609	4000.0
2018-08-10 05:00:00	AMZN	Stock	94.516	94.516	94.506	94.506	4000.0
2018-08-10 06:00:00	AMZN	Stock	94.504	94.504	94.504	94.504	2520.0
2018-08-10 07:00:00	AMZN	Stock	94.6735	94.822	94.53	94.53	139580.0
2018-08-10 08:00:00	AMZN	Stock	94.6451	94.65	94.466	94.5	330220.0

> showing 50 of 48,897 rows — these rows as CSV

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