PREVIEW / stock_1hour / 2021-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-07.parquet
  size:    1.4 MB
  rows:    65,611
  symbols: 2,955

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
2021-04-07 04:00:00	AAPL	Stock	126.51	126.52	126.22	126.3	5968.0
2021-04-07 05:00:00	AAPL	Stock	126.35	126.48	126.19	126.27	11854.0
2021-04-07 06:00:00	AAPL	Stock	126.22	126.5	126.21	126.4	13342.0
2021-04-07 07:00:00	AAPL	Stock	126.36	126.5	126.2	126.3	108686.0
2021-04-07 08:00:00	AAPL	Stock	126.4694	126.525	125.86	125.9	311187.0
2021-04-07 09:00:00	AAPL	Stock	125.9	126.21	125.14	126.12	9970169.0
2021-04-07 10:00:00	AAPL	Stock	126.12	127.24	126.04	126.89	11982872.0
2021-04-07 11:00:00	AAPL	Stock	126.9	127.47	126.75	127.3199	10216832.0
2021-04-07 12:00:00	AAPL	Stock	127.31	127.48	127.03	127.09	7480660.0
2021-04-07 13:00:00	AAPL	Stock	127.0864	127.3	126.8528	127.2401	6368192.0
2021-04-07 14:00:00	AAPL	Stock	127.2499	127.78	127.24	127.58	8416866.0
2021-04-07 15:00:00	AAPL	Stock	127.58	127.92	127.21	127.91	12821243.0
2021-04-07 16:00:00	AAPL	Stock	127.9	128.12	127.474	128.1	5331381.0
2021-04-07 17:00:00	AAPL	Stock	128.11	128.2	128.03	128.12	122556.0
2021-04-07 18:00:00	AAPL	Stock	128.12	128.29	128.08	128.22	120408.0
2021-04-07 19:00:00	AAPL	Stock	128.22	128.4	128.0	128.4	131153.0
2021-04-07 04:00:00	MSFT	Stock	248.48	248.48	248.45	248.45	841.0
2021-04-07 05:00:00	MSFT	Stock	248.45	248.45	248.3	248.3	732.0
2021-04-07 06:00:00	MSFT	Stock	248.41	248.5	248.11	248.11	1280.0
2021-04-07 07:00:00	MSFT	Stock	248.12	248.41	247.84	247.98	12338.0
2021-04-07 08:00:00	MSFT	Stock	248.3	248.4	247.35	247.35	12992.0
2021-04-07 09:00:00	MSFT	Stock	247.39	249.09	247.19	248.71	1815368.0
2021-04-07 10:00:00	MSFT	Stock	248.695	250.83	248.51	250.51	3452098.0
2021-04-07 11:00:00	MSFT	Stock	250.53	250.93	249.6	250.07	2475651.0
2021-04-07 12:00:00	MSFT	Stock	250.07	250.42	249.69	249.8371	1410059.0
2021-04-07 13:00:00	MSFT	Stock	249.82	250.08	249.4	249.9499	1142754.0
2021-04-07 14:00:00	MSFT	Stock	249.96	250.72	249.9	250.09	1801889.0
2021-04-07 15:00:00	MSFT	Stock	250.09	250.25	248.91	249.89	2903810.0
2021-04-07 16:00:00	MSFT	Stock	249.9	250.49	249.4	250.1	2629588.0
2021-04-07 17:00:00	MSFT	Stock	250.14	250.24	250.0464	250.15	2790.0
2021-04-07 18:00:00	MSFT	Stock	250.15	250.23	250.12	250.15	3307.0
2021-04-07 19:00:00	MSFT	Stock	250.18	250.45	250.12	250.38	4657.0
2021-04-07 05:00:00	NVDA	Stock	13.8688	13.8688	13.8688	13.8688	11280.0
2021-04-07 06:00:00	NVDA	Stock	13.8743	13.875	13.8743	13.875	19920.0
2021-04-07 07:00:00	NVDA	Stock	13.8888	13.9	13.8758	13.8993	105880.0
2021-04-07 08:00:00	NVDA	Stock	13.9	13.9	13.82	13.8275	128000.0
2021-04-07 09:00:00	NVDA	Stock	13.8375	13.9038	13.7115	13.8888	16840280.0
2021-04-07 10:00:00	NVDA	Stock	13.889	13.993	13.8677	13.905	14866120.0
2021-04-07 11:00:00	NVDA	Stock	13.9042	14.0745	13.9032	14.0445	20787120.0
2021-04-07 12:00:00	NVDA	Stock	14.043	14.0572	13.9689	14.0199	10525840.0
2021-04-07 13:00:00	NVDA	Stock	14.0188	14.1412	14.0069	14.1308	17853960.0
2021-04-07 14:00:00	NVDA	Stock	14.1285	14.2435	14.1228	14.2118	24107440.0
2021-04-07 15:00:00	NVDA	Stock	14.2173	14.237	14.1	14.1435	28849360.0
2021-04-07 16:00:00	NVDA	Stock	14.1435	14.175	14.0646	14.15	18960240.0
2021-04-07 17:00:00	NVDA	Stock	14.1562	14.1562	14.1445	14.1562	36000.0
2021-04-07 18:00:00	NVDA	Stock	14.1738	14.1738	14.1538	14.1538	33880.0
2021-04-07 19:00:00	NVDA	Stock	14.1568	14.1875	14.1502	14.1875	129760.0
2021-04-07 06:00:00	AMZN	Stock	161.147	161.3095	161.147	161.3095	4000.0
2021-04-07 07:00:00	AMZN	Stock	161.25	161.25	161.25	161.25	2000.0
2021-04-07 08:00:00	AMZN	Stock	161.2185	161.292	161.026	161.026	92680.0

> showing 50 of 65,611 rows — these rows as CSV

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