PREVIEW / stock_1hour / 2019-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-04.parquet
  size:    1.1 MB
  rows:    50,073
  symbols: 2,562

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-09-04 04:00:00	AAPL	Stock	52.225	52.3	52.1425	52.185	31156.0
2019-09-04 05:00:00	AAPL	Stock	52.1825	52.1825	52.11	52.115	5836.0
2019-09-04 06:00:00	AAPL	Stock	52.0575	52.1175	52.005	52.08	5836.0
2019-09-04 07:00:00	AAPL	Stock	52.1125	52.175	52.0375	52.1225	140504.0
2019-09-04 08:00:00	AAPL	Stock	52.1	52.175	52.045	52.045	271812.0
2019-09-04 09:00:00	AAPL	Stock	52.04	52.1825	51.885	51.93	10608052.0
2019-09-04 10:00:00	AAPL	Stock	51.9325	51.995	51.83	51.965	7822484.0
2019-09-04 11:00:00	AAPL	Stock	51.9675	52.1125	51.9375	52.065	5506048.0
2019-09-04 12:00:00	AAPL	Stock	52.0625	52.2375	51.925	52.2125	6520196.0
2019-09-04 13:00:00	AAPL	Stock	52.215	52.3685	52.1925	52.22	6227464.0
2019-09-04 14:00:00	AAPL	Stock	52.2212	52.315	52.2	52.2625	4706244.0
2019-09-04 15:00:00	AAPL	Stock	52.2612	52.37	52.25	52.3125	9618604.0
2019-09-04 16:00:00	AAPL	Stock	52.2975	52.315	52.1475	52.25	7078292.0
2019-09-04 17:00:00	AAPL	Stock	52.2325	52.2725	52.175	52.22	37456.0
2019-09-04 18:00:00	AAPL	Stock	52.225	52.2525	52.2	52.2525	30452.0
2019-09-04 19:00:00	AAPL	Stock	52.25	52.27	52.2	52.2525	25308.0
2019-09-04 04:00:00	MSFT	Stock	137.85	137.85	137.59	137.7	1934.0
2019-09-04 05:00:00	MSFT	Stock	137.75	137.93	137.57	137.57	1487.0
2019-09-04 06:00:00	MSFT	Stock	137.6	137.8	137.5	137.5	5881.0
2019-09-04 07:00:00	MSFT	Stock	137.55	137.59	137.43	137.5	27690.0
2019-09-04 08:00:00	MSFT	Stock	137.489	137.6	137.3	137.48	49832.0
2019-09-04 09:00:00	MSFT	Stock	137.36	137.48	136.85	137.065	2104430.0
2019-09-04 10:00:00	MSFT	Stock	137.065	137.13	136.48	137.02	2023044.0
2019-09-04 11:00:00	MSFT	Stock	137.03	137.425	136.94	137.32	1892239.0
2019-09-04 12:00:00	MSFT	Stock	137.32	137.48	137.015	137.355	1390463.0
2019-09-04 13:00:00	MSFT	Stock	137.36	137.54	137.23	137.28	1170803.0
2019-09-04 14:00:00	MSFT	Stock	137.27	137.33	137.0	137.172	1417534.0
2019-09-04 15:00:00	MSFT	Stock	137.18	137.69	137.17	137.69	2560935.0
2019-09-04 16:00:00	MSFT	Stock	137.65	137.65	137.45	137.45	2372775.0
2019-09-04 17:00:00	MSFT	Stock	137.47	137.5	137.44	137.5	3100.0
2019-09-04 18:00:00	MSFT	Stock	137.48	137.5	137.4	137.5	1777.0
2019-09-04 19:00:00	MSFT	Stock	137.4	137.55	137.4	137.42	2993.0
2019-09-04 04:00:00	NVDA	Stock	4.1775	4.205	4.1775	4.1992	124840.0
2019-09-04 05:00:00	NVDA	Stock	4.196	4.1962	4.196	4.1962	8000.0
2019-09-04 06:00:00	NVDA	Stock	4.1788	4.1942	4.1778	4.1942	45000.0
2019-09-04 07:00:00	NVDA	Stock	4.1758	4.183	4.1512	4.1693	443160.0
2019-09-04 08:00:00	NVDA	Stock	4.1663	4.175	4.1562	4.1612	1175560.0
2019-09-04 09:00:00	NVDA	Stock	4.1588	4.2265	4.1588	4.215	45544080.0
2019-09-04 10:00:00	NVDA	Stock	4.2142	4.2238	4.1858	4.1935	27994120.0
2019-09-04 11:00:00	NVDA	Stock	4.1925	4.2018	4.1835	4.1908	15649440.0
2019-09-04 12:00:00	NVDA	Stock	4.1903	4.2062	4.1782	4.206	15421440.0
2019-09-04 13:00:00	NVDA	Stock	4.2062	4.2196	4.205	4.2138	17948080.0
2019-09-04 14:00:00	NVDA	Stock	4.2141	4.2172	4.203	4.2108	18404040.0
2019-09-04 15:00:00	NVDA	Stock	4.211	4.222	4.2092	4.219	37135480.0
2019-09-04 16:00:00	NVDA	Stock	4.219	4.2222	4.2175	4.2188	13248200.0
2019-09-04 17:00:00	NVDA	Stock	4.2175	4.2185	4.2145	4.2145	53440.0
2019-09-04 18:00:00	NVDA	Stock	4.2165	4.2225	4.2165	4.2225	51440.0
2019-09-04 19:00:00	NVDA	Stock	4.2225	4.237	4.2218	4.2305	273040.0
2019-09-04 04:00:00	AMZN	Stock	90.555	90.555	90.555	90.555	11560.0
2019-09-04 05:00:00	AMZN	Stock	90.5	90.5	90.5	90.5	5020.0

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

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