PREVIEW / stock_1hour / 2020-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-03.parquet
  size:    1.3 MB
  rows:    57,722
  symbols: 2,532

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-11-03 04:00:00	AAPL	Stock	109.54	109.9	109.41	109.41	42401.0
2020-11-03 05:00:00	AAPL	Stock	109.43	109.92	109.27	109.37	26995.0
2020-11-03 06:00:00	AAPL	Stock	109.36	109.59	108.74	109.28	60642.0
2020-11-03 07:00:00	AAPL	Stock	109.29	109.58	109.19	109.23	176723.0
2020-11-03 08:00:00	AAPL	Stock	109.25	109.57	109.16	109.3	469732.0
2020-11-03 09:00:00	AAPL	Stock	109.3	109.94	108.73	109.88	12866144.0
2020-11-03 10:00:00	AAPL	Stock	109.89	111.21	109.785	111.19	19006404.0
2020-11-03 11:00:00	AAPL	Stock	111.2	111.45	110.68	110.905	12566624.0
2020-11-03 12:00:00	AAPL	Stock	110.91	111.07	110.53	110.719	8593865.0
2020-11-03 13:00:00	AAPL	Stock	110.71	110.915	109.76	109.85	9088105.0
2020-11-03 14:00:00	AAPL	Stock	109.85	110.47	109.8	110.366	9108059.0
2020-11-03 15:00:00	AAPL	Stock	110.369	111.49	109.99	110.375	18337665.0
2020-11-03 16:00:00	AAPL	Stock	110.44	110.451	110.08	110.25	7976425.0
2020-11-03 17:00:00	AAPL	Stock	110.26	110.44	110.18	110.39	110577.0
2020-11-03 18:00:00	AAPL	Stock	110.38	110.9	110.26	110.81	262932.0
2020-11-03 19:00:00	AAPL	Stock	110.8	111.04	110.2	110.25	355649.0
2020-11-03 04:00:00	MSFT	Stock	204.07	204.36	203.26	203.26	4847.0
2020-11-03 05:00:00	MSFT	Stock	203.42	204.16	203.24	203.37	4531.0
2020-11-03 06:00:00	MSFT	Stock	203.33	203.48	202.52	202.97	16161.0
2020-11-03 07:00:00	MSFT	Stock	203.18	203.5	203.0	203.15	26468.0
2020-11-03 08:00:00	MSFT	Stock	203.5	203.95	202.64	203.5	35698.0
2020-11-03 09:00:00	MSFT	Stock	203.481	205.395	203.12	205.35	2306478.0
2020-11-03 10:00:00	MSFT	Stock	205.39	207.95	205.18	207.88	3726821.0
2020-11-03 11:00:00	MSFT	Stock	207.89	208.12	207.073	207.44	2377599.0
2020-11-03 12:00:00	MSFT	Stock	207.46	207.64	206.65	207.045	1560985.0
2020-11-03 13:00:00	MSFT	Stock	207.04	207.46	205.11	205.29	1672683.0
2020-11-03 14:00:00	MSFT	Stock	205.29	206.57	205.17	206.43	1805722.0
2020-11-03 15:00:00	MSFT	Stock	206.43	208.0	205.69	206.12	4875450.0
2020-11-03 16:00:00	MSFT	Stock	206.43	206.451	205.56	206.05	3556692.0
2020-11-03 17:00:00	MSFT	Stock	206.14	206.25	205.95	206.23	14045.0
2020-11-03 18:00:00	MSFT	Stock	206.41	208.0	206.2	207.16	27167.0
2020-11-03 19:00:00	MSFT	Stock	207.1	207.65	206.0	206.0	29505.0
2020-11-03 04:00:00	NVDA	Stock	12.67	12.7	12.67	12.7	37640.0
2020-11-03 05:00:00	NVDA	Stock	12.688	12.688	12.6708	12.6708	16080.0
2020-11-03 06:00:00	NVDA	Stock	12.6075	12.6075	12.6075	12.6075	4000.0
2020-11-03 07:00:00	NVDA	Stock	12.6	12.6622	12.6	12.6445	145520.0
2020-11-03 08:00:00	NVDA	Stock	12.65	12.6975	12.629	12.6788	381440.0
2020-11-03 09:00:00	NVDA	Stock	12.675	12.8245	12.6028	12.8242	27462120.0
2020-11-03 10:00:00	NVDA	Stock	12.8245	12.9805	12.8	12.979	37638880.0
2020-11-03 11:00:00	NVDA	Stock	12.982	12.9978	12.9005	12.9221	21600960.0
2020-11-03 12:00:00	NVDA	Stock	12.9245	12.9975	12.9012	12.9773	16252640.0
2020-11-03 13:00:00	NVDA	Stock	12.9773	12.9982	12.8855	12.896	16868960.0
2020-11-03 14:00:00	NVDA	Stock	12.8968	12.9855	12.8925	12.9702	17388200.0
2020-11-03 15:00:00	NVDA	Stock	12.9698	13.105	12.9288	13.0198	49003440.0
2020-11-03 16:00:00	NVDA	Stock	13.0195	13.0208	12.9758	12.995	2985240.0
2020-11-03 17:00:00	NVDA	Stock	12.9878	13.0	12.9878	13.0	76000.0
2020-11-03 18:00:00	NVDA	Stock	13.0075	13.1108	13.0075	13.0808	219840.0
2020-11-03 19:00:00	NVDA	Stock	13.0788	13.0923	12.9825	12.9825	345120.0
2020-11-03 04:00:00	AMZN	Stock	151.3505	151.447	151.3505	151.447	9760.0
2020-11-03 05:00:00	AMZN	Stock	151.4	151.4	151.4	151.4	4880.0

> showing 50 of 57,722 rows — these rows as CSV

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