PREVIEW / stock_1hour / 2020-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-24.parquet
  size:    1.2 MB
  rows:    56,073
  symbols: 2,425

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-07-24 04:00:00	AAPL	Stock	91.5	91.5775	91.125	91.5	144544.0
2020-07-24 05:00:00	AAPL	Stock	91.46	91.5625	91.305	91.5625	54088.0
2020-07-24 06:00:00	AAPL	Stock	91.5625	91.9925	91.5	91.7075	134956.0
2020-07-24 07:00:00	AAPL	Stock	91.75	92.0	90.775	91.22	688312.0
2020-07-24 08:00:00	AAPL	Stock	91.8125	92.0	90.85	91.435	1016448.0
2020-07-24 09:00:00	AAPL	Stock	91.4325	91.4675	89.145	90.565	36676448.0
2020-07-24 10:00:00	AAPL	Stock	90.566	92.12	90.5375	92.09	28323896.0
2020-07-24 11:00:00	AAPL	Stock	92.1025	92.905	91.735	92.31	21142336.0
2020-07-24 12:00:00	AAPL	Stock	92.31	92.4175	91.805	91.95	10312604.0
2020-07-24 13:00:00	AAPL	Stock	91.9475	92.6225	91.395	92.4275	10977720.0
2020-07-24 14:00:00	AAPL	Stock	92.425	92.8675	92.1475	92.472	10106164.0
2020-07-24 15:00:00	AAPL	Stock	92.4675	92.97	92.2525	92.605	19349056.0
2020-07-24 16:00:00	AAPL	Stock	92.615	92.8125	92.605	92.775	4198028.0
2020-07-24 17:00:00	AAPL	Stock	92.8125	92.85	92.5	92.5	63960.0
2020-07-24 18:00:00	AAPL	Stock	92.5175	92.615	92.375	92.45	327940.0
2020-07-24 19:00:00	AAPL	Stock	92.4025	92.44	92.2525	92.425	70024.0
2020-07-24 04:00:00	MSFT	Stock	199.7	199.99	199.03	199.9	33908.0
2020-07-24 05:00:00	MSFT	Stock	199.74	200.5	199.74	200.5	15734.0
2020-07-24 06:00:00	MSFT	Stock	200.5	200.9	200.0	200.42	21499.0
2020-07-24 07:00:00	MSFT	Stock	200.41	201.5	199.87	200.5	180554.0
2020-07-24 08:00:00	MSFT	Stock	200.8	201.47	199.83	200.69	240554.0
2020-07-24 09:00:00	MSFT	Stock	200.65	201.2	197.51	199.75	7481407.0
2020-07-24 10:00:00	MSFT	Stock	199.73	202.1	199.67	202.06	6004036.0
2020-07-24 11:00:00	MSFT	Stock	202.07	202.86	201.28	202.495	4132400.0
2020-07-24 12:00:00	MSFT	Stock	202.5	202.57	200.77	201.02	2594214.0
2020-07-24 13:00:00	MSFT	Stock	201.009	202.37	200.2	201.96	2815385.0
2020-07-24 14:00:00	MSFT	Stock	201.99	202.85	201.46	201.73	2560223.0
2020-07-24 15:00:00	MSFT	Stock	201.72	202.27	200.85	201.3	4024892.0
2020-07-24 16:00:00	MSFT	Stock	201.14	201.78	201.14	201.58	2052276.0
2020-07-24 17:00:00	MSFT	Stock	201.6	201.6	201.3	201.31	15690.0
2020-07-24 18:00:00	MSFT	Stock	201.3	201.35	200.82	201.1	144906.0
2020-07-24 19:00:00	MSFT	Stock	201.05	201.05	200.67	200.8	7729.0
2020-07-24 04:00:00	NVDA	Stock	9.9175	9.925	9.8588	9.925	204200.0
2020-07-24 05:00:00	NVDA	Stock	9.925	9.93	9.9225	9.93	329480.0
2020-07-24 06:00:00	NVDA	Stock	9.925	9.9375	9.9125	9.9125	123480.0
2020-07-24 07:00:00	NVDA	Stock	9.9188	9.987	9.8625	9.9	2498120.0
2020-07-24 08:00:00	NVDA	Stock	9.9252	9.9748	9.8625	9.9188	2298160.0
2020-07-24 09:00:00	NVDA	Stock	9.9089	9.9973	9.777	9.9802	83556480.0
2020-07-24 10:00:00	NVDA	Stock	9.98	10.2713	9.979	10.267	100446080.0
2020-07-24 11:00:00	NVDA	Stock	10.2713	10.3648	10.2138	10.3409	82573000.0
2020-07-24 12:00:00	NVDA	Stock	10.345	10.3468	10.1615	10.176	60134200.0
2020-07-24 13:00:00	NVDA	Stock	10.1698	10.25	10.1	10.2283	45530520.0
2020-07-24 14:00:00	NVDA	Stock	10.2302	10.2653	10.1888	10.2338	32012000.0
2020-07-24 15:00:00	NVDA	Stock	10.229	10.258	10.1568	10.1975	42948560.0
2020-07-24 16:00:00	NVDA	Stock	10.1945	10.195	10.1788	10.1912	5862120.0
2020-07-24 17:00:00	NVDA	Stock	10.1825	10.1875	10.175	10.1752	52800.0
2020-07-24 18:00:00	NVDA	Stock	10.1748	10.1945	10.15	10.15	576520.0
2020-07-24 19:00:00	NVDA	Stock	10.1592	10.16	10.15	10.1508	196960.0
2020-07-24 04:00:00	AMZN	Stock	147.5	147.5	147.05	147.05	14920.0
2020-07-24 05:00:00	AMZN	Stock	147.222	147.222	147.0	147.1755	14220.0

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

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