PREVIEW / stock_1hour / 2020-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-28.parquet
  size:    1.2 MB
  rows:    55,866
  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-28 04:00:00	AAPL	Stock	95.1375	95.1525	94.955	95.15	31720.0
2020-07-28 05:00:00	AAPL	Stock	95.22	95.295	94.6225	94.675	29768.0
2020-07-28 06:00:00	AAPL	Stock	94.675	94.76	94.5075	94.76	37092.0
2020-07-28 07:00:00	AAPL	Stock	94.8075	94.9725	94.36	94.5225	220892.0
2020-07-28 08:00:00	AAPL	Stock	94.9347	94.9875	94.3428	94.6975	214432.0
2020-07-28 09:00:00	AAPL	Stock	94.675	94.7	93.4825	93.7475	13339296.0
2020-07-28 10:00:00	AAPL	Stock	93.7612	94.0575	93.4775	94.0075	12382672.0
2020-07-28 11:00:00	AAPL	Stock	94.01	94.183	93.6725	93.7258	8134892.0
2020-07-28 12:00:00	AAPL	Stock	93.7175	93.94	93.5488	93.94	5184540.0
2020-07-28 13:00:00	AAPL	Stock	93.9325	94.38	93.78	94.33	6209444.0
2020-07-28 14:00:00	AAPL	Stock	94.335	94.3375	93.915	94.0395	6559556.0
2020-07-28 15:00:00	AAPL	Stock	94.0425	94.0678	93.2475	93.26	13463004.0
2020-07-28 16:00:00	AAPL	Stock	93.27	93.4925	93.2525	93.3875	7189848.0
2020-07-28 17:00:00	AAPL	Stock	93.385	93.4775	93.3525	93.4775	66288.0
2020-07-28 18:00:00	AAPL	Stock	93.4775	93.625	93.45	93.5375	67020.0
2020-07-28 19:00:00	AAPL	Stock	93.5125	93.6875	93.445	93.6875	83080.0
2020-07-28 04:00:00	MSFT	Stock	204.3	204.41	203.85	204.4	1655.0
2020-07-28 05:00:00	MSFT	Stock	204.48	204.6	203.4	203.4	3689.0
2020-07-28 06:00:00	MSFT	Stock	203.22	203.5	203.0	203.05	5468.0
2020-07-28 07:00:00	MSFT	Stock	203.69	203.73	202.74	203.0	20471.0
2020-07-28 08:00:00	MSFT	Stock	202.9	204.35	202.69	203.26	43200.0
2020-07-28 09:00:00	MSFT	Stock	203.35	204.0	202.34	202.84	2197733.0
2020-07-28 10:00:00	MSFT	Stock	202.88	203.41	202.25	203.34	2906759.0
2020-07-28 11:00:00	MSFT	Stock	203.34	203.82	202.659	203.06	1868645.0
2020-07-28 12:00:00	MSFT	Stock	203.06	203.88	202.61	203.85	1544063.0
2020-07-28 13:00:00	MSFT	Stock	203.84	204.7	203.73	204.3	2120170.0
2020-07-28 14:00:00	MSFT	Stock	204.33	204.358	203.41	203.526	2069766.0
2020-07-28 15:00:00	MSFT	Stock	203.53	203.6	201.74	201.74	4070879.0
2020-07-28 16:00:00	MSFT	Stock	202.02	202.838	202.02	202.36	2041768.0
2020-07-28 17:00:00	MSFT	Stock	202.35	202.5	202.29	202.45	5781.0
2020-07-28 18:00:00	MSFT	Stock	202.49	202.75	202.44	202.6	6177.0
2020-07-28 19:00:00	MSFT	Stock	202.4	202.58	202.25	202.5	10731.0
2020-07-28 04:00:00	NVDA	Stock	10.4625	10.47	10.42	10.42	47640.0
2020-07-28 07:00:00	NVDA	Stock	10.4125	10.42	10.3528	10.3588	462560.0
2020-07-28 08:00:00	NVDA	Stock	10.3845	10.425	10.35	10.375	586840.0
2020-07-28 09:00:00	NVDA	Stock	10.385	10.385	10.2225	10.2614	45056080.0
2020-07-28 10:00:00	NVDA	Stock	10.2629	10.3595	10.238	10.3425	44706920.0
2020-07-28 11:00:00	NVDA	Stock	10.3439	10.382	10.2875	10.3143	26838240.0
2020-07-28 12:00:00	NVDA	Stock	10.3192	10.3472	10.2925	10.3348	16172200.0
2020-07-28 13:00:00	NVDA	Stock	10.3343	10.3625	10.3025	10.347	13348640.0
2020-07-28 14:00:00	NVDA	Stock	10.3485	10.3508	10.2808	10.296	21353320.0
2020-07-28 15:00:00	NVDA	Stock	10.2941	10.3025	10.2093	10.2155	40732240.0
2020-07-28 16:00:00	NVDA	Stock	10.2155	10.3558	10.2155	10.3188	17030920.0
2020-07-28 17:00:00	NVDA	Stock	10.325	10.335	10.32	10.325	518600.0
2020-07-28 18:00:00	NVDA	Stock	10.3248	10.345	10.3248	10.3332	237400.0
2020-07-28 19:00:00	NVDA	Stock	10.3418	10.36	10.3375	10.3438	495400.0
2020-07-28 06:00:00	AMZN	Stock	152.55	152.55	152.55	152.55	8880.0
2020-07-28 07:00:00	AMZN	Stock	152.5	152.75	151.95	152.1	184000.0
2020-07-28 08:00:00	AMZN	Stock	152.7495	152.7495	151.85	152.5	157200.0
2020-07-28 09:00:00	AMZN	Stock	152.2625	153.8546	151.6812	153.1165	10009420.0

> showing 50 of 55,866 rows — these rows as CSV

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