PREVIEW / stock_1hour / 2019-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-28.parquet
  size:    1.1 MB
  rows:    50,453
  symbols: 2,554

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-08-28 04:00:00	AAPL	Stock	51.1625	51.27	50.97	51.03	45084.0
2019-08-28 05:00:00	AAPL	Stock	51.1275	51.1525	51.01	51.065	15200.0
2019-08-28 06:00:00	AAPL	Stock	51.16	51.2	51.04	51.04	8640.0
2019-08-28 07:00:00	AAPL	Stock	51.075	51.1225	50.82	50.9	94632.0
2019-08-28 08:00:00	AAPL	Stock	50.925	51.275	50.7275	50.9575	274396.0
2019-08-28 09:00:00	AAPL	Stock	50.96	51.31	50.83	51.215	10953956.0
2019-08-28 10:00:00	AAPL	Stock	51.2325	51.3625	51.075	51.24	8780200.0
2019-08-28 11:00:00	AAPL	Stock	51.24	51.4225	51.1238	51.33	6956604.0
2019-08-28 12:00:00	AAPL	Stock	51.3275	51.335	51.19	51.256	3995868.0
2019-08-28 13:00:00	AAPL	Stock	51.2575	51.2875	51.0875	51.2038	4050636.0
2019-08-28 14:00:00	AAPL	Stock	51.205	51.3525	51.1475	51.3312	4425684.0
2019-08-28 15:00:00	AAPL	Stock	51.33	51.43	51.2225	51.38	8009792.0
2019-08-28 16:00:00	AAPL	Stock	51.3825	51.425	51.2775	51.28	3507112.0
2019-08-28 17:00:00	AAPL	Stock	51.275	51.3825	51.275	51.3525	66484.0
2019-08-28 18:00:00	AAPL	Stock	51.33	51.375	51.33	51.35	44192.0
2019-08-28 19:00:00	AAPL	Stock	51.3425	51.36	51.2775	51.3125	31140.0
2019-08-28 04:00:00	MSFT	Stock	135.83	136.08	135.82	136.0	871.0
2019-08-28 05:00:00	MSFT	Stock	135.84	135.84	135.84	135.84	100.0
2019-08-28 07:00:00	MSFT	Stock	135.6	135.62	135.11	135.4	3739.0
2019-08-28 08:00:00	MSFT	Stock	135.62	135.74	134.55	135.3	16052.0
2019-08-28 09:00:00	MSFT	Stock	135.39	135.6	133.55	134.43	2495675.0
2019-08-28 10:00:00	MSFT	Stock	134.42	135.05	134.18	134.91	2290218.0
2019-08-28 11:00:00	MSFT	Stock	134.92	135.298	134.57	135.103	1727430.0
2019-08-28 12:00:00	MSFT	Stock	135.11	135.315	134.87	135.173	1149659.0
2019-08-28 13:00:00	MSFT	Stock	135.18	135.39	134.835	135.2	1144790.0
2019-08-28 14:00:00	MSFT	Stock	135.2	135.63	135.105	135.585	991481.0
2019-08-28 15:00:00	MSFT	Stock	135.58	135.76	135.24	135.55	2481334.0
2019-08-28 16:00:00	MSFT	Stock	135.56	135.89	135.0	135.3	2062821.0
2019-08-28 17:00:00	MSFT	Stock	135.54	135.57	135.33	135.4	9061.0
2019-08-28 18:00:00	MSFT	Stock	135.56	135.56	135.34	135.34	20106.0
2019-08-28 19:00:00	MSFT	Stock	135.45	135.45	135.26	135.26	6870.0
2019-08-28 04:00:00	NVDA	Stock	4.0468	4.056	4.0258	4.0258	44280.0
2019-08-28 05:00:00	NVDA	Stock	4.0388	4.0462	4.0362	4.0368	40000.0
2019-08-28 07:00:00	NVDA	Stock	4.0252	4.0362	4.0085	4.0112	104320.0
2019-08-28 08:00:00	NVDA	Stock	4.03	4.0393	4.0	4.017	598640.0
2019-08-28 09:00:00	NVDA	Stock	4.0123	4.0379	3.975	4.0182	37312560.0
2019-08-28 10:00:00	NVDA	Stock	4.0178	4.0558	4.0072	4.041	29587600.0
2019-08-28 11:00:00	NVDA	Stock	4.042	4.0835	4.0315	4.0733	26655320.0
2019-08-28 12:00:00	NVDA	Stock	4.0745	4.075	4.053	4.0635	20039520.0
2019-08-28 13:00:00	NVDA	Stock	4.064	4.0722	4.038	4.057	21799880.0
2019-08-28 14:00:00	NVDA	Stock	4.0562	4.0606	4.0435	4.0525	21380920.0
2019-08-28 15:00:00	NVDA	Stock	4.0522	4.0525	4.0168	4.0303	57849920.0
2019-08-28 16:00:00	NVDA	Stock	4.0305	4.0348	4.022	4.022	3631280.0
2019-08-28 17:00:00	NVDA	Stock	4.0193	4.0285	4.0193	4.0285	75880.0
2019-08-28 18:00:00	NVDA	Stock	4.0305	4.0305	4.0285	4.0298	78680.0
2019-08-28 19:00:00	NVDA	Stock	4.0305	4.0305	4.022	4.0288	121720.0
2019-08-28 04:00:00	AMZN	Stock	88.2	88.2	88.0	88.0	8120.0
2019-08-28 05:00:00	AMZN	Stock	88.2	88.2	88.2	88.2	11700.0
2019-08-28 07:00:00	AMZN	Stock	88.0	88.0	87.815	87.85	60320.0
2019-08-28 08:00:00	AMZN	Stock	88.05	88.05	87.518	87.7575	149300.0

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

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