PREVIEW / stock_1hour / 2019-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-03.parquet
  size:    778 KB
  rows:    31,975
  symbols: 2,520

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-07-03 04:00:00	AAPL	Stock	50.7625	50.925	50.7625	50.925	2480.0
2019-07-03 05:00:00	AAPL	Stock	50.935	50.935	50.935	50.935	800.0
2019-07-03 06:00:00	AAPL	Stock	50.9	50.9325	50.8825	50.89	21916.0
2019-07-03 07:00:00	AAPL	Stock	50.8725	50.925	50.85	50.87	49116.0
2019-07-03 08:00:00	AAPL	Stock	50.8925	50.925	50.8375	50.8475	142672.0
2019-07-03 09:00:00	AAPL	Stock	50.8225	50.875	50.6725	50.83	6825152.0
2019-07-03 10:00:00	AAPL	Stock	50.8225	50.9558	50.7425	50.92	7323236.0
2019-07-03 11:00:00	AAPL	Stock	50.92	50.9675	50.8575	50.9265	5384380.0
2019-07-03 12:00:00	AAPL	Stock	50.9263	51.11	50.9175	51.1025	11180964.0
2019-07-03 13:00:00	AAPL	Stock	51.1025	51.1475	51.0625	51.1	6843592.0
2019-07-03 14:00:00	AAPL	Stock	51.1	51.106	50.98	51.0762	77660.0
2019-07-03 15:00:00	AAPL	Stock	51.077	51.12	51.0575	51.0825	15132.0
2019-07-03 16:00:00	AAPL	Stock	51.0825	51.1	51.0375	51.1	19764.0
2019-07-03 04:00:00	MSFT	Stock	136.75	136.75	136.75	136.75	250.0
2019-07-03 05:00:00	MSFT	Stock	137.2	137.2	137.11	137.11	460.0
2019-07-03 06:00:00	MSFT	Stock	137.38	137.38	137.3	137.3	1376.0
2019-07-03 07:00:00	MSFT	Stock	137.35	137.48	137.03	137.05	8865.0
2019-07-03 08:00:00	MSFT	Stock	137.205	137.486	136.9	137.02	33509.0
2019-07-03 09:00:00	MSFT	Stock	136.99	137.01	136.295	136.88	2041505.0
2019-07-03 10:00:00	MSFT	Stock	136.87	137.57	136.69	137.54	2514255.0
2019-07-03 11:00:00	MSFT	Stock	137.54	137.74	137.05	137.273	2216037.0
2019-07-03 12:00:00	MSFT	Stock	137.28	137.6	137.125	137.45	2562460.0
2019-07-03 13:00:00	MSFT	Stock	137.45	137.57	137.206	137.46	2555858.0
2019-07-03 14:00:00	MSFT	Stock	137.38	137.48	137.37	137.48	37081.0
2019-07-03 15:00:00	MSFT	Stock	137.48	137.48	137.46	137.46	1162.0
2019-07-03 16:00:00	MSFT	Stock	137.46	137.48	137.46	137.48	2393.0
2019-07-03 04:00:00	NVDA	Stock	4.1045	4.105	4.1038	4.1048	28600.0
2019-07-03 05:00:00	NVDA	Stock	4.1	4.1	4.0905	4.0905	51560.0
2019-07-03 06:00:00	NVDA	Stock	4.0875	4.09	4.0825	4.09	135520.0
2019-07-03 07:00:00	NVDA	Stock	4.0888	4.09	4.0782	4.085	350280.0
2019-07-03 08:00:00	NVDA	Stock	4.08	4.095	4.078	4.0875	1551320.0
2019-07-03 09:00:00	NVDA	Stock	4.0875	4.0875	4.0215	4.0298	67320840.0
2019-07-03 10:00:00	NVDA	Stock	4.0292	4.0395	4.0086	4.03	59715160.0
2019-07-03 11:00:00	NVDA	Stock	4.0298	4.047	4.0178	4.045	32996800.0
2019-07-03 12:00:00	NVDA	Stock	4.0455	4.069	4.0407	4.069	50529520.0
2019-07-03 13:00:00	NVDA	Stock	4.0688	4.0692	4.0588	4.0598	10613480.0
2019-07-03 14:00:00	NVDA	Stock	4.06	4.0628	4.06	4.0618	199080.0
2019-07-03 15:00:00	NVDA	Stock	4.062	4.0625	4.06	4.0624	106200.0
2019-07-03 16:00:00	NVDA	Stock	4.0602	4.0625	4.0602	4.0625	13960.0
2019-07-03 04:00:00	AMZN	Stock	96.9	96.9	96.9	96.9	4000.0
2019-07-03 05:00:00	AMZN	Stock	96.925	96.925	96.925	96.925	4120.0
2019-07-03 06:00:00	AMZN	Stock	96.999	96.999	96.999	96.999	3000.0
2019-07-03 07:00:00	AMZN	Stock	96.995	97.044	96.875	96.875	110300.0
2019-07-03 08:00:00	AMZN	Stock	96.9945	97.035	96.474	96.7995	180040.0
2019-07-03 09:00:00	AMZN	Stock	96.7815	96.999	96.525	96.8804	4542280.0
2019-07-03 10:00:00	AMZN	Stock	96.865	97.0795	96.8195	97.0104	6838500.0
2019-07-03 11:00:00	AMZN	Stock	97.0115	97.0325	96.868	96.9325	3792260.0
2019-07-03 12:00:00	AMZN	Stock	96.9328	97.009	96.82	96.95	5893980.0
2019-07-03 13:00:00	AMZN	Stock	96.935	96.961	96.905	96.905	2775040.0
2019-07-03 14:00:00	AMZN	Stock	96.9	96.9	96.8559	96.8559	14900.0

> showing 50 of 31,975 rows — these rows as CSV

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