PREVIEW / stock_1hour / 2018-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-13.parquet
  size:    1.1 MB
  rows:    48,947
  symbols: 2,819

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-13 04:00:00	AAPL	Stock	51.675	51.7775	51.65	51.7775	1200.0
2018-08-13 05:00:00	AAPL	Stock	51.795	51.795	51.795	51.795	1780.0
2018-08-13 06:00:00	AAPL	Stock	51.795	51.82	51.795	51.8125	4000.0
2018-08-13 07:00:00	AAPL	Stock	51.8425	51.9625	51.825	51.935	104092.0
2018-08-13 08:00:00	AAPL	Stock	51.8375	52.0125	51.79	51.9375	283964.0
2018-08-13 09:00:00	AAPL	Stock	51.9425	52.3725	51.91	52.3525	11248944.0
2018-08-13 10:00:00	AAPL	Stock	52.355	52.738	52.3425	52.585	24008284.0
2018-08-13 11:00:00	AAPL	Stock	52.5875	52.6275	52.3125	52.315	13254472.0
2018-08-13 12:00:00	AAPL	Stock	52.315	52.439	52.2475	52.31	9685836.0
2018-08-13 13:00:00	AAPL	Stock	52.31	52.4115	52.1875	52.38	6842644.0
2018-08-13 14:00:00	AAPL	Stock	52.38	52.4975	52.315	52.3425	7220528.0
2018-08-13 15:00:00	AAPL	Stock	52.3402	52.39	52.215	52.215	12861948.0
2018-08-13 16:00:00	AAPL	Stock	52.2175	52.2975	52.2175	52.25	6348344.0
2018-08-13 17:00:00	AAPL	Stock	52.2475	52.27	52.235	52.235	11636.0
2018-08-13 18:00:00	AAPL	Stock	52.2375	52.285	52.2175	52.28	38520.0
2018-08-13 19:00:00	AAPL	Stock	52.29	52.315	52.255	52.275	42536.0
2018-08-13 04:00:00	MSFT	Stock	108.88	108.98	108.72	108.89	1564.0
2018-08-13 05:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	2531.0
2018-08-13 06:00:00	MSFT	Stock	108.89	108.9	108.89	108.9	700.0
2018-08-13 07:00:00	MSFT	Stock	108.9	109.04	108.79	109.04	24435.0
2018-08-13 08:00:00	MSFT	Stock	108.95	109.21	108.75	109.1	30519.0
2018-08-13 09:00:00	MSFT	Stock	109.06	109.37	108.72	109.07	1851928.0
2018-08-13 10:00:00	MSFT	Stock	109.07	109.58	108.89	109.302	2415586.0
2018-08-13 11:00:00	MSFT	Stock	109.305	109.37	108.38	108.55	1921977.0
2018-08-13 12:00:00	MSFT	Stock	108.54	108.71	108.235	108.39	1545832.0
2018-08-13 13:00:00	MSFT	Stock	108.38	108.55	108.16	108.45	1515638.0
2018-08-13 14:00:00	MSFT	Stock	108.46	108.71	108.21	108.285	1747483.0
2018-08-13 15:00:00	MSFT	Stock	108.28	108.53	108.1	108.22	2834571.0
2018-08-13 16:00:00	MSFT	Stock	108.21	108.751	108.21	108.31	2393904.0
2018-08-13 17:00:00	MSFT	Stock	108.3	108.38	108.25	108.26	1424.0
2018-08-13 18:00:00	MSFT	Stock	108.3	108.39	108.3	108.39	870.0
2018-08-13 19:00:00	MSFT	Stock	108.32	108.47	108.32	108.47	1197.0
2018-08-13 04:00:00	NVDA	Stock	6.3448	6.3448	6.3448	6.3448	8320.0
2018-08-13 05:00:00	NVDA	Stock	6.3525	6.3525	6.3525	6.3525	5040.0
2018-08-13 07:00:00	NVDA	Stock	6.37	6.3798	6.35	6.3798	201800.0
2018-08-13 08:00:00	NVDA	Stock	6.3529	6.3968	6.3525	6.3698	820800.0
2018-08-13 09:00:00	NVDA	Stock	6.3936	6.5244	6.3768	6.5055	76927320.0
2018-08-13 10:00:00	NVDA	Stock	6.5055	6.525	6.4919	6.5078	58762720.0
2018-08-13 11:00:00	NVDA	Stock	6.508	6.523	6.4162	6.434	58093400.0
2018-08-13 12:00:00	NVDA	Stock	6.4354	6.4608	6.4202	6.4382	25858080.0
2018-08-13 13:00:00	NVDA	Stock	6.4368	6.4368	6.4035	6.4117	23391280.0
2018-08-13 14:00:00	NVDA	Stock	6.411	6.4338	6.3875	6.388	25394720.0
2018-08-13 15:00:00	NVDA	Stock	6.3889	6.4209	6.3838	6.403	45934640.0
2018-08-13 16:00:00	NVDA	Stock	6.403	6.4235	6.403	6.4175	5292320.0
2018-08-13 17:00:00	NVDA	Stock	6.4213	6.4213	6.415	6.4175	158440.0
2018-08-13 18:00:00	NVDA	Stock	6.4225	6.4225	6.4105	6.4175	497520.0
2018-08-13 19:00:00	NVDA	Stock	6.4128	6.4453	6.411	6.4453	770040.0
2018-08-13 04:00:00	AMZN	Stock	94.1955	94.1955	94.1625	94.1625	5100.0
2018-08-13 06:00:00	AMZN	Stock	94.27	94.35	94.27	94.35	9020.0
2018-08-13 07:00:00	AMZN	Stock	94.35	94.55	94.318	94.549	205000.0

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

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