PREVIEW / stock_1hour / 2020-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-21.parquet
  size:    1.2 MB
  rows:    53,004
  symbols: 2,488

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-01-21 04:00:00	AAPL	Stock	79.2425	79.31	79.085	79.225	25868.0
2020-01-21 05:00:00	AAPL	Stock	79.2	79.25	79.125	79.1575	24324.0
2020-01-21 06:00:00	AAPL	Stock	79.25	79.285	79.1025	79.25	21044.0
2020-01-21 07:00:00	AAPL	Stock	79.25	79.3725	79.2025	79.25	280672.0
2020-01-21 08:00:00	AAPL	Stock	79.3125	79.34	79.195	79.2	451680.0
2020-01-21 09:00:00	AAPL	Stock	79.205	79.715	79.1625	79.5475	15201380.0
2020-01-21 10:00:00	AAPL	Stock	79.5575	79.755	79.2725	79.345	13499272.0
2020-01-21 11:00:00	AAPL	Stock	79.3425	79.75	79.32	79.615	8498040.0
2020-01-21 12:00:00	AAPL	Stock	79.617	79.6258	79.45	79.49	6728136.0
2020-01-21 13:00:00	AAPL	Stock	79.4975	79.55	79.085	79.14	10138416.0
2020-01-21 14:00:00	AAPL	Stock	79.1415	79.3175	79.0642	79.2228	8220456.0
2020-01-21 15:00:00	AAPL	Stock	79.2225	79.3075	79.0	79.1375	11778840.0
2020-01-21 16:00:00	AAPL	Stock	79.1425	79.363	79.06	79.15	19294704.0
2020-01-21 17:00:00	AAPL	Stock	79.1425	79.175	79.125	79.125	87664.0
2020-01-21 18:00:00	AAPL	Stock	79.1625	79.3075	79.1325	79.2875	57700.0
2020-01-21 19:00:00	AAPL	Stock	79.2875	79.35	79.25	79.3075	102472.0
2020-01-21 04:00:00	MSFT	Stock	166.43	166.81	166.0	166.04	7272.0
2020-01-21 05:00:00	MSFT	Stock	166.55	166.94	166.5	166.51	3880.0
2020-01-21 06:00:00	MSFT	Stock	166.51	166.69	166.5	166.63	5631.0
2020-01-21 07:00:00	MSFT	Stock	166.6	166.89	166.55	166.65	44666.0
2020-01-21 08:00:00	MSFT	Stock	166.73	166.8	166.61	166.615	37824.0
2020-01-21 09:00:00	MSFT	Stock	166.7	167.485	166.5	167.4	2847594.0
2020-01-21 10:00:00	MSFT	Stock	167.37	167.96	166.85	167.3	2662602.0
2020-01-21 11:00:00	MSFT	Stock	167.29	168.19	167.26	167.605	2052803.0
2020-01-21 12:00:00	MSFT	Stock	167.6	167.79	167.47	167.493	1348028.0
2020-01-21 13:00:00	MSFT	Stock	167.49	167.52	166.648	166.79	2050218.0
2020-01-21 14:00:00	MSFT	Stock	166.79	167.1	166.5	166.79	1529890.0
2020-01-21 15:00:00	MSFT	Stock	166.785	167.1	166.43	166.49	3112540.0
2020-01-21 16:00:00	MSFT	Stock	166.5	167.535	166.23	166.571	9459248.0
2020-01-21 17:00:00	MSFT	Stock	166.58	166.61	166.5	166.55	12684.0
2020-01-21 18:00:00	MSFT	Stock	166.57	166.69	166.53	166.66	5150.0
2020-01-21 19:00:00	MSFT	Stock	166.64	166.8	166.56	166.75	8728.0
2020-01-21 04:00:00	NVDA	Stock	6.1975	6.1975	6.1528	6.17	29400.0
2020-01-21 05:00:00	NVDA	Stock	6.1752	6.1812	6.1752	6.1812	8720.0
2020-01-21 06:00:00	NVDA	Stock	6.1812	6.1843	6.1568	6.1825	23120.0
2020-01-21 07:00:00	NVDA	Stock	6.1875	6.2028	6.1658	6.1925	224440.0
2020-01-21 08:00:00	NVDA	Stock	6.1765	6.205	6.1628	6.1925	686840.0
2020-01-21 09:00:00	NVDA	Stock	6.1938	6.2158	6.1642	6.2097	28610200.0
2020-01-21 10:00:00	NVDA	Stock	6.2091	6.225	6.1895	6.2022	24650000.0
2020-01-21 11:00:00	NVDA	Stock	6.2015	6.2323	6.1975	6.2193	18290280.0
2020-01-21 12:00:00	NVDA	Stock	6.22	6.2293	6.2112	6.2285	13794760.0
2020-01-21 13:00:00	NVDA	Stock	6.2285	6.2298	6.1812	6.1815	16291040.0
2020-01-21 14:00:00	NVDA	Stock	6.1824	6.2005	6.1771	6.1978	16153400.0
2020-01-21 15:00:00	NVDA	Stock	6.1975	6.2125	6.1798	6.199	25288120.0
2020-01-21 16:00:00	NVDA	Stock	6.1985	6.2112	6.191	6.1975	48784160.0
2020-01-21 17:00:00	NVDA	Stock	6.1962	6.208	6.1962	6.2048	34880.0
2020-01-21 18:00:00	NVDA	Stock	6.1908	6.1908	6.1908	6.1908	4000.0
2020-01-21 19:00:00	NVDA	Stock	6.2038	6.2038	6.2038	6.2038	4000.0
2020-01-21 04:00:00	AMZN	Stock	92.9	92.9	92.8	92.8	9320.0
2020-01-21 07:00:00	AMZN	Stock	92.85	93.0	92.8155	92.9085	70200.0

> showing 50 of 53,004 rows — these rows as CSV

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