PREVIEW / stock_1hour / 2019-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-16.parquet
  size:    1.1 MB
  rows:    49,088
  symbols: 2,598

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
2019-07-16 04:00:00	AAPL	Stock	51.25	51.36	51.25	51.275	6160.0
2019-07-16 05:00:00	AAPL	Stock	51.2625	51.295	51.2625	51.295	5980.0
2019-07-16 06:00:00	AAPL	Stock	51.2475	51.285	51.2475	51.275	10344.0
2019-07-16 07:00:00	AAPL	Stock	51.285	51.38	51.285	51.35	95644.0
2019-07-16 08:00:00	AAPL	Stock	51.38	51.3825	51.2725	51.2725	146644.0
2019-07-16 09:00:00	AAPL	Stock	51.285	51.5275	51.0025	51.4975	9124648.0
2019-07-16 10:00:00	AAPL	Stock	51.4975	51.5075	51.3625	51.4175	6287068.0
2019-07-16 11:00:00	AAPL	Stock	51.4175	51.4325	51.205	51.2175	5666180.0
2019-07-16 12:00:00	AAPL	Stock	51.2165	51.2175	50.875	51.0	8153284.0
2019-07-16 13:00:00	AAPL	Stock	51.0	51.1375	50.925	50.9338	5203536.0
2019-07-16 14:00:00	AAPL	Stock	50.9325	51.0975	50.93	51.075	4860612.0
2019-07-16 15:00:00	AAPL	Stock	51.075	51.2325	51.06	51.1225	9288364.0
2019-07-16 16:00:00	AAPL	Stock	51.125	51.125	51.0375	51.0375	3739744.0
2019-07-16 17:00:00	AAPL	Stock	51.0375	51.0575	51.0375	51.05	6260.0
2019-07-16 18:00:00	AAPL	Stock	51.0125	51.15	51.0125	51.075	39212.0
2019-07-16 19:00:00	AAPL	Stock	51.075	51.075	51.0475	51.0475	24316.0
2019-07-16 05:00:00	MSFT	Stock	139.0	139.0	139.0	139.0	1300.0
2019-07-16 06:00:00	MSFT	Stock	139.22	139.22	139.11	139.11	350.0
2019-07-16 07:00:00	MSFT	Stock	139.05	139.17	138.96	139.17	14531.0
2019-07-16 08:00:00	MSFT	Stock	139.01	139.24	139.0	139.09	21690.0
2019-07-16 09:00:00	MSFT	Stock	139.0	139.09	138.42	138.505	2193078.0
2019-07-16 10:00:00	MSFT	Stock	138.51	138.535	137.305	137.59	3575536.0
2019-07-16 11:00:00	MSFT	Stock	137.6	137.63	137.07	137.094	2495566.0
2019-07-16 12:00:00	MSFT	Stock	137.09	137.274	136.52	137.21	2575758.0
2019-07-16 13:00:00	MSFT	Stock	137.21	137.46	136.79	136.82	1479626.0
2019-07-16 14:00:00	MSFT	Stock	136.815	137.06	136.59	136.935	2018879.0
2019-07-16 15:00:00	MSFT	Stock	136.93	137.18	136.82	137.08	3423994.0
2019-07-16 16:00:00	MSFT	Stock	137.06	137.1	136.95	137.0	1957867.0
2019-07-16 17:00:00	MSFT	Stock	137.04	137.08	136.95	137.04	4440.0
2019-07-16 18:00:00	MSFT	Stock	137.07	137.07	137.06	137.07	645.0
2019-07-16 19:00:00	MSFT	Stock	137.06	137.06	136.95	137.03	4866.0
2019-07-16 05:00:00	NVDA	Stock	4.1845	4.1845	4.1725	4.1725	30480.0
2019-07-16 06:00:00	NVDA	Stock	4.1748	4.175	4.17	4.1705	74400.0
2019-07-16 07:00:00	NVDA	Stock	4.1763	4.1778	4.1675	4.1712	278040.0
2019-07-16 08:00:00	NVDA	Stock	4.1672	4.192	4.1648	4.1685	858520.0
2019-07-16 09:00:00	NVDA	Stock	4.165	4.1818	4.121	4.1425	65540080.0
2019-07-16 10:00:00	NVDA	Stock	4.1428	4.1958	4.1355	4.1955	58975600.0
2019-07-16 11:00:00	NVDA	Stock	4.1954	4.2042	4.173	4.1955	40435480.0
2019-07-16 12:00:00	NVDA	Stock	4.1956	4.1983	4.1438	4.1616	45625920.0
2019-07-16 13:00:00	NVDA	Stock	4.162	4.1875	4.1618	4.1708	39529440.0
2019-07-16 14:00:00	NVDA	Stock	4.1702	4.1968	4.1702	4.1848	25114760.0
2019-07-16 15:00:00	NVDA	Stock	4.1843	4.1972	4.1758	4.1768	33312400.0
2019-07-16 16:00:00	NVDA	Stock	4.177	4.18	4.1612	4.173	8247400.0
2019-07-16 18:00:00	NVDA	Stock	4.1697	4.1697	4.1663	4.1663	8000.0
2019-07-16 19:00:00	NVDA	Stock	4.1652	4.1675	4.1633	4.165	116200.0
2019-07-16 06:00:00	AMZN	Stock	100.95	100.95	100.75	100.75	4000.0
2019-07-16 07:00:00	AMZN	Stock	100.82	100.901	100.8	100.8005	71400.0
2019-07-16 08:00:00	AMZN	Stock	100.8402	100.9052	100.7	100.793	163840.0
2019-07-16 09:00:00	AMZN	Stock	100.788	101.316	100.5	101.0255	6321580.0
2019-07-16 10:00:00	AMZN	Stock	101.0255	101.1218	100.747	101.0061	6255280.0

> showing 50 of 49,088 rows — these rows as CSV

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