PREVIEW / stock_1hour / 2020-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-18.parquet
  size:    1.2 MB
  rows:    56,827
  symbols: 2,431

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-06-18 04:00:00	AAPL	Stock	87.9275	88.325	87.925	88.2875	35112.0
2020-06-18 05:00:00	AAPL	Stock	88.3075	88.35	88.1225	88.1225	11500.0
2020-06-18 06:00:00	AAPL	Stock	88.0075	88.225	87.94	88.0775	23584.0
2020-06-18 07:00:00	AAPL	Stock	88.015	88.25	87.6125	87.625	237380.0
2020-06-18 08:00:00	AAPL	Stock	87.9125	88.245	87.5	88.0575	442232.0
2020-06-18 09:00:00	AAPL	Stock	88.035	88.2575	87.715	87.8225	11302448.0
2020-06-18 10:00:00	AAPL	Stock	87.82	88.1975	87.58	88.125	12902724.0
2020-06-18 11:00:00	AAPL	Stock	88.125	88.3625	87.9575	88.005	9027920.0
2020-06-18 12:00:00	AAPL	Stock	87.9875	88.1075	87.84	87.9025	6429376.0
2020-06-18 13:00:00	AAPL	Stock	87.9025	88.0775	87.825	87.9825	4831708.0
2020-06-18 14:00:00	AAPL	Stock	87.985	87.9925	87.4475	87.4615	8682252.0
2020-06-18 15:00:00	AAPL	Stock	87.465	88.0275	87.305	87.8975	14944284.0
2020-06-18 16:00:00	AAPL	Stock	87.8962	88.4227	87.8125	87.83	5764472.0
2020-06-18 17:00:00	AAPL	Stock	87.85	87.92	87.8125	87.83	58048.0
2020-06-18 18:00:00	AAPL	Stock	87.83	87.9875	87.8	87.9875	44524.0
2020-06-18 19:00:00	AAPL	Stock	87.98	88.14	87.98	88.1375	106696.0
2020-06-18 04:00:00	MSFT	Stock	195.49	195.49	195.49	195.49	100.0
2020-06-18 06:00:00	MSFT	Stock	194.8	194.8	194.03	194.03	1776.0
2020-06-18 07:00:00	MSFT	Stock	194.19	194.48	193.85	193.85	11402.0
2020-06-18 08:00:00	MSFT	Stock	194.35	194.71	193.24	194.31	38001.0
2020-06-18 09:00:00	MSFT	Stock	194.364	196.49	194.0	195.8	3000118.0
2020-06-18 10:00:00	MSFT	Stock	195.77	195.97	194.25	195.685	3207775.0
2020-06-18 11:00:00	MSFT	Stock	195.685	196.28	195.35	195.522	1905954.0
2020-06-18 12:00:00	MSFT	Stock	195.51	195.62	194.93	195.46	1572803.0
2020-06-18 13:00:00	MSFT	Stock	195.46	196.03	195.22	195.77	1310808.0
2020-06-18 14:00:00	MSFT	Stock	195.79	195.87	195.01	195.06	1818424.0
2020-06-18 15:00:00	MSFT	Stock	195.065	196.42	194.76	196.32	3744362.0
2020-06-18 16:00:00	MSFT	Stock	196.32	196.41	194.955	196.2	2415439.0
2020-06-18 17:00:00	MSFT	Stock	196.2	196.28	196.2	196.21	11346.0
2020-06-18 18:00:00	MSFT	Stock	196.28	196.75	196.28	196.7	26114.0
2020-06-18 19:00:00	MSFT	Stock	196.82	197.31	196.71	197.17	22510.0
2020-06-18 04:00:00	NVDA	Stock	9.1775	9.1775	9.1775	9.1775	8840.0
2020-06-18 05:00:00	NVDA	Stock	9.2722	9.275	9.2722	9.275	11640.0
2020-06-18 07:00:00	NVDA	Stock	9.2403	9.2585	9.2042	9.2042	414840.0
2020-06-18 08:00:00	NVDA	Stock	9.236	9.275	9.175	9.25	1398640.0
2020-06-18 09:00:00	NVDA	Stock	9.2457	9.2825	9.1782	9.2	48367800.0
2020-06-18 10:00:00	NVDA	Stock	9.1978	9.2052	9.1145	9.1968	52413560.0
2020-06-18 11:00:00	NVDA	Stock	9.1963	9.2308	9.1483	9.1722	31432880.0
2020-06-18 12:00:00	NVDA	Stock	9.1715	9.1878	9.1502	9.1775	15032360.0
2020-06-18 13:00:00	NVDA	Stock	9.1772	9.193	9.1545	9.1898	16342720.0
2020-06-18 14:00:00	NVDA	Stock	9.1882	9.1915	9.15	9.1662	17831720.0
2020-06-18 15:00:00	NVDA	Stock	9.168	9.2315	9.1325	9.225	44095360.0
2020-06-18 16:00:00	NVDA	Stock	9.218	9.2313	9.21	9.2218	2392120.0
2020-06-18 17:00:00	NVDA	Stock	9.2188	9.2188	9.205	9.2055	74120.0
2020-06-18 18:00:00	NVDA	Stock	9.2123	9.2275	9.2123	9.2275	159880.0
2020-06-18 19:00:00	NVDA	Stock	9.2313	9.2685	9.225	9.2625	443240.0
2020-06-18 04:00:00	AMZN	Stock	132.75	132.75	132.75	132.75	5480.0
2020-06-18 07:00:00	AMZN	Stock	132.4	132.4	132.05	132.1015	80740.0
2020-06-18 08:00:00	AMZN	Stock	132.05	132.5845	131.955	132.5845	260020.0
2020-06-18 09:00:00	AMZN	Stock	132.4	132.982	132.1	132.2428	6397440.0

> showing 50 of 56,827 rows — these rows as CSV

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