PREVIEW / stock_1hour / 2018-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-12.parquet
  size:    1.1 MB
  rows:    50,142
  symbols: 2,756

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-10-12 04:00:00	AAPL	Stock	54.805	54.9675	54.685	54.775	38700.0
2018-10-12 05:00:00	AAPL	Stock	54.7	54.84	54.61	54.8225	32172.0
2018-10-12 06:00:00	AAPL	Stock	54.825	54.825	54.655	54.8	39744.0
2018-10-12 07:00:00	AAPL	Stock	54.775	54.9625	54.69	54.775	427148.0
2018-10-12 08:00:00	AAPL	Stock	54.925	54.97	54.6325	54.7425	787384.0
2018-10-12 09:00:00	AAPL	Stock	54.72	55.46	54.715	55.1975	24983112.0
2018-10-12 10:00:00	AAPL	Stock	55.1875	55.5625	55.025	55.0435	20853040.0
2018-10-12 11:00:00	AAPL	Stock	55.05	55.2025	54.5	54.755	14367112.0
2018-10-12 12:00:00	AAPL	Stock	54.755	54.82	54.21	54.6425	11465036.0
2018-10-12 13:00:00	AAPL	Stock	54.6435	54.9875	54.4218	54.645	9820928.0
2018-10-12 14:00:00	AAPL	Stock	54.645	55.0325	54.3625	54.96	7953204.0
2018-10-12 15:00:00	AAPL	Stock	54.9475	55.72	54.86	55.5275	25493332.0
2018-10-12 16:00:00	AAPL	Stock	55.5275	55.6425	55.525	55.6265	15603936.0
2018-10-12 17:00:00	AAPL	Stock	55.62	55.645	55.5275	55.5925	146648.0
2018-10-12 18:00:00	AAPL	Stock	55.6025	55.6175	55.5875	55.605	75288.0
2018-10-12 19:00:00	AAPL	Stock	55.5875	55.7375	55.5875	55.7	92496.0
2018-10-12 04:00:00	MSFT	Stock	108.8	108.8	108.05	108.3	5448.0
2018-10-12 05:00:00	MSFT	Stock	108.4	109.4	108.4	109.15	34155.0
2018-10-12 06:00:00	MSFT	Stock	109.16	109.43	109.0	109.4	8323.0
2018-10-12 07:00:00	MSFT	Stock	109.29	109.47	108.79	109.03	60989.0
2018-10-12 08:00:00	MSFT	Stock	109.1	109.49	108.69	108.84	198300.0
2018-10-12 09:00:00	MSFT	Stock	108.9	109.43	107.58	108.46	6300868.0
2018-10-12 10:00:00	MSFT	Stock	108.45	109.28	108.1	108.69	5781034.0
2018-10-12 11:00:00	MSFT	Stock	108.71	108.945	108.05	108.41	3825087.0
2018-10-12 12:00:00	MSFT	Stock	108.41	108.49	107.12	107.83	4094476.0
2018-10-12 13:00:00	MSFT	Stock	107.83	108.42	107.52	108.01	3079489.0
2018-10-12 14:00:00	MSFT	Stock	108.01	108.72	107.28	108.48	3579963.0
2018-10-12 15:00:00	MSFT	Stock	108.47	110.01	108.266	109.54	9045623.0
2018-10-12 16:00:00	MSFT	Stock	109.57	109.95	109.47	109.68	5640946.0
2018-10-12 17:00:00	MSFT	Stock	109.69	109.69	109.41	109.41	153655.0
2018-10-12 18:00:00	MSFT	Stock	109.41	109.49	109.0	109.4	36988.0
2018-10-12 19:00:00	MSFT	Stock	109.4	109.85	109.3	109.8	40973.0
2018-10-12 04:00:00	NVDA	Stock	6.074	6.1	6.04	6.0443	218280.0
2018-10-12 05:00:00	NVDA	Stock	6.0443	6.0625	6.0375	6.056	173360.0
2018-10-12 06:00:00	NVDA	Stock	6.0723	6.0745	6.05	6.0648	200080.0
2018-10-12 07:00:00	NVDA	Stock	6.07	6.1135	6.07	6.0763	1701800.0
2018-10-12 08:00:00	NVDA	Stock	6.095	6.1238	6.075	6.0998	4072080.0
2018-10-12 09:00:00	NVDA	Stock	6.0965	6.2188	6.0965	6.1569	97688040.0
2018-10-12 10:00:00	NVDA	Stock	6.1555	6.2385	6.1528	6.162	95156520.0
2018-10-12 11:00:00	NVDA	Stock	6.1645	6.191	6.0836	6.0982	57460240.0
2018-10-12 12:00:00	NVDA	Stock	6.095	6.1062	5.9913	6.0572	61604560.0
2018-10-12 13:00:00	NVDA	Stock	6.0515	6.0979	6.0198	6.0456	31829760.0
2018-10-12 14:00:00	NVDA	Stock	6.0451	6.0805	6.0088	6.0642	32210520.0
2018-10-12 15:00:00	NVDA	Stock	6.0638	6.1745	6.0478	6.1642	95337560.0
2018-10-12 16:00:00	NVDA	Stock	6.1638	6.2	6.1008	6.1888	36242480.0
2018-10-12 17:00:00	NVDA	Stock	6.1925	6.205	6.192	6.192	1255760.0
2018-10-12 18:00:00	NVDA	Stock	6.1962	6.1983	6.1803	6.1803	264680.0
2018-10-12 19:00:00	NVDA	Stock	6.1803	6.197	6.1803	6.1938	230160.0
2018-10-12 04:00:00	AMZN	Stock	88.475	89.0	88.4	88.5	100880.0
2018-10-12 05:00:00	AMZN	Stock	88.492	88.6	88.2505	88.54	58580.0

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

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