PREVIEW / stock_1hour / 2020-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-05.parquet
  size:    1.3 MB
  rows:    57,728
  symbols: 2,438

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
2020-08-05 04:00:00	AAPL	Stock	110.205	110.41	110.04	110.325	29796.0
2020-08-05 05:00:00	AAPL	Stock	110.325	110.745	110.25	110.705	35832.0
2020-08-05 06:00:00	AAPL	Stock	110.6325	110.6325	109.1875	109.3075	280884.0
2020-08-05 07:00:00	AAPL	Stock	109.5	109.75	109.3625	109.4125	395508.0
2020-08-05 08:00:00	AAPL	Stock	109.4125	109.9375	109.0625	109.185	908788.0
2020-08-05 09:00:00	AAPL	Stock	109.2	110.3925	108.8975	110.0875	18792100.0
2020-08-05 10:00:00	AAPL	Stock	110.0875	110.2425	109.2325	109.242	17230688.0
2020-08-05 11:00:00	AAPL	Stock	109.2438	109.7475	109.2325	109.4255	9506144.0
2020-08-05 12:00:00	AAPL	Stock	109.4325	109.6075	109.015	109.2232	8786296.0
2020-08-05 13:00:00	AAPL	Stock	109.23	109.475	109.21	109.2812	6110876.0
2020-08-05 14:00:00	AAPL	Stock	109.28	109.9175	109.1525	109.8425	9947644.0
2020-08-05 15:00:00	AAPL	Stock	109.835	110.1225	109.4425	110.0848	15973880.0
2020-08-05 16:00:00	AAPL	Stock	110.075	110.075	109.9025	110.0	7480916.0
2020-08-05 17:00:00	AAPL	Stock	109.9875	109.9875	109.8	109.86	54632.0
2020-08-05 18:00:00	AAPL	Stock	109.8375	109.85	109.75	109.8175	68096.0
2020-08-05 19:00:00	AAPL	Stock	109.825	109.9375	109.8175	109.85	89772.0
2020-08-05 04:00:00	MSFT	Stock	214.02	214.63	214.02	214.21	4452.0
2020-08-05 05:00:00	MSFT	Stock	214.3	214.48	214.21	214.21	6029.0
2020-08-05 06:00:00	MSFT	Stock	214.34	214.35	214.0	214.0	7583.0
2020-08-05 07:00:00	MSFT	Stock	213.98	214.3	213.63	214.05	37773.0
2020-08-05 08:00:00	MSFT	Stock	213.779	214.3	212.75	212.9	115013.0
2020-08-05 09:00:00	MSFT	Stock	212.92	216.35	212.075	214.19	4999257.0
2020-08-05 10:00:00	MSFT	Stock	214.21	214.4	212.88	213.09	3599047.0
2020-08-05 11:00:00	MSFT	Stock	213.09	213.9	212.28	212.4	2781576.0
2020-08-05 12:00:00	MSFT	Stock	212.4	213.08	212.31	213.03	1810393.0
2020-08-05 13:00:00	MSFT	Stock	213.05	213.53	212.97	213.24	1599339.0
2020-08-05 14:00:00	MSFT	Stock	213.24	213.4	212.69	212.9	1337315.0
2020-08-05 15:00:00	MSFT	Stock	212.904	213.02	211.57	212.95	3461485.0
2020-08-05 16:00:00	MSFT	Stock	212.94	212.992	212.41	212.51	2211878.0
2020-08-05 17:00:00	MSFT	Stock	212.54	212.69	212.41	212.48	16731.0
2020-08-05 18:00:00	MSFT	Stock	212.5	212.55	212.31	212.32	20979.0
2020-08-05 19:00:00	MSFT	Stock	212.4	212.66	212.35	212.52	18962.0
2020-08-05 04:00:00	NVDA	Stock	11.27	11.3103	11.27	11.2995	12000.0
2020-08-05 05:00:00	NVDA	Stock	11.325	11.3278	11.325	11.3278	16000.0
2020-08-05 06:00:00	NVDA	Stock	11.3083	11.3135	11.3	11.301	22800.0
2020-08-05 07:00:00	NVDA	Stock	11.2875	11.3338	11.2875	11.3245	505720.0
2020-08-05 08:00:00	NVDA	Stock	11.33	11.3373	11.2135	11.23	1274560.0
2020-08-05 09:00:00	NVDA	Stock	11.23	11.313	11.1662	11.3056	39147400.0
2020-08-05 10:00:00	NVDA	Stock	11.3083	11.3717	11.2705	11.2952	37542160.0
2020-08-05 11:00:00	NVDA	Stock	11.294	11.341	11.2715	11.2734	20268560.0
2020-08-05 12:00:00	NVDA	Stock	11.2707	11.3115	11.2375	11.2491	20992560.0
2020-08-05 13:00:00	NVDA	Stock	11.249	11.3244	11.2482	11.3095	22447680.0
2020-08-05 14:00:00	NVDA	Stock	11.3091	11.325	11.2782	11.3001	17838720.0
2020-08-05 15:00:00	NVDA	Stock	11.3002	11.3045	11.2278	11.2923	33687720.0
2020-08-05 16:00:00	NVDA	Stock	11.2868	11.294	11.25	11.2725	2661880.0
2020-08-05 17:00:00	NVDA	Stock	11.2703	11.275	11.2665	11.275	47640.0
2020-08-05 18:00:00	NVDA	Stock	11.2688	11.28	11.2672	11.2798	53920.0
2020-08-05 19:00:00	NVDA	Stock	11.2788	11.305	11.2788	11.2962	409800.0
2020-08-05 04:00:00	AMZN	Stock	158.025	158.025	158.01	158.01	15100.0
2020-08-05 05:00:00	AMZN	Stock	157.79	158.1	157.79	158.1	31860.0

> showing 50 of 57,728 rows — these rows as CSV

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