PREVIEW / stock_1hour / 2020-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-04.parquet
  size:    1.2 MB
  rows:    52,603
  symbols: 2,442

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-02-04 04:00:00	AAPL	Stock	78.09	78.61	78.075	78.575	87908.0
2020-02-04 05:00:00	AAPL	Stock	78.5975	78.6	78.45	78.4625	65708.0
2020-02-04 06:00:00	AAPL	Stock	78.3875	78.5625	78.3775	78.5625	48992.0
2020-02-04 07:00:00	AAPL	Stock	78.515	78.9625	78.38	78.9375	581572.0
2020-02-04 08:00:00	AAPL	Stock	78.925	78.97	77.165	78.845	968896.0
2020-02-04 09:00:00	AAPL	Stock	78.8025	79.215	78.4085	78.595	20223408.0
2020-02-04 10:00:00	AAPL	Stock	78.6	79.3775	78.45	79.37	20584876.0
2020-02-04 11:00:00	AAPL	Stock	79.37	79.88	79.2832	79.6	16234008.0
2020-02-04 12:00:00	AAPL	Stock	79.6062	79.6348	79.3325	79.5875	9797708.0
2020-02-04 13:00:00	AAPL	Stock	79.59	79.8475	79.4575	79.8175	7751772.0
2020-02-04 14:00:00	AAPL	Stock	79.82	79.91	79.655	79.7175	7587612.0
2020-02-04 15:00:00	AAPL	Stock	79.7175	79.7825	79.3575	79.715	17045140.0
2020-02-04 16:00:00	AAPL	Stock	79.715	79.9125	79.65	79.8275	10546376.0
2020-02-04 17:00:00	AAPL	Stock	79.825	79.8725	79.8125	79.8375	132600.0
2020-02-04 18:00:00	AAPL	Stock	79.8325	79.845	79.515	79.515	157932.0
2020-02-04 19:00:00	AAPL	Stock	79.545	79.725	79.4375	79.45	160344.0
2020-02-04 04:00:00	MSFT	Stock	176.15	177.24	176.15	177.24	23570.0
2020-02-04 05:00:00	MSFT	Stock	177.2	177.2	176.67	176.67	9174.0
2020-02-04 06:00:00	MSFT	Stock	176.87	176.94	176.8	176.81	5281.0
2020-02-04 07:00:00	MSFT	Stock	176.82	177.05	176.43	176.9	80722.0
2020-02-04 08:00:00	MSFT	Stock	176.64	177.16	174.38	177.08	638964.0
2020-02-04 09:00:00	MSFT	Stock	177.06	177.67	176.31	177.58	4218377.0
2020-02-04 10:00:00	MSFT	Stock	177.62	180.0	177.47	179.06	5507455.0
2020-02-04 11:00:00	MSFT	Stock	179.06	180.64	179.05	180.07	3944993.0
2020-02-04 12:00:00	MSFT	Stock	180.061	180.28	179.78	179.83	2279227.0
2020-02-04 13:00:00	MSFT	Stock	179.835	179.88	179.01	179.31	2557502.0
2020-02-04 14:00:00	MSFT	Stock	179.32	179.65	179.28	179.494	2326164.0
2020-02-04 15:00:00	MSFT	Stock	179.49	180.19	179.34	180.13	4374860.0
2020-02-04 16:00:00	MSFT	Stock	180.12	181.2	179.925	180.81	4088078.0
2020-02-04 17:00:00	MSFT	Stock	180.7	180.79	180.61	180.78	19633.0
2020-02-04 18:00:00	MSFT	Stock	180.61	180.99	180.39	180.39	22136.0
2020-02-04 19:00:00	MSFT	Stock	180.4	180.75	180.15	180.35	21347.0
2020-02-04 04:00:00	NVDA	Stock	6.1	6.125	6.1	6.125	37160.0
2020-02-04 05:00:00	NVDA	Stock	6.133	6.133	6.133	6.133	12000.0
2020-02-04 06:00:00	NVDA	Stock	6.138	6.15	6.1375	6.1485	28640.0
2020-02-04 07:00:00	NVDA	Stock	6.1378	6.1505	6.1062	6.1438	1262480.0
2020-02-04 08:00:00	NVDA	Stock	6.1245	6.1612	6.0082	6.1532	11139880.0
2020-02-04 09:00:00	NVDA	Stock	6.1525	6.1782	6.109	6.1284	38959040.0
2020-02-04 10:00:00	NVDA	Stock	6.1308	6.1432	6.1005	6.139	26395880.0
2020-02-04 11:00:00	NVDA	Stock	6.1405	6.1975	6.1272	6.1948	48415920.0
2020-02-04 12:00:00	NVDA	Stock	6.1948	6.1968	6.159	6.1675	21753760.0
2020-02-04 13:00:00	NVDA	Stock	6.1675	6.1808	6.1562	6.1729	14216040.0
2020-02-04 14:00:00	NVDA	Stock	6.1735	6.1808	6.152	6.1715	17031240.0
2020-02-04 15:00:00	NVDA	Stock	6.1722	6.1923	6.1642	6.1785	28479560.0
2020-02-04 16:00:00	NVDA	Stock	6.1782	6.185	6.1782	6.1782	22864800.0
2020-02-04 17:00:00	NVDA	Stock	6.1835	6.1848	6.1818	6.1848	19120.0
2020-02-04 18:00:00	NVDA	Stock	6.1815	6.185	6.1775	6.1775	336440.0
2020-02-04 19:00:00	NVDA	Stock	6.1725	6.1805	6.17	6.17	189040.0
2020-02-04 04:00:00	AMZN	Stock	101.2	101.25	101.2	101.25	12660.0
2020-02-04 05:00:00	AMZN	Stock	101.499	101.5	101.445	101.45	14300.0

> showing 50 of 52,603 rows — these rows as CSV

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