PREVIEW / stock_1hour / 2019-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-06.parquet
  size:    1.1 MB
  rows:    50,252
  symbols: 2,517

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-11-06 04:00:00	AAPL	Stock	64.2375	64.275	64.1575	64.175	24900.0
2019-11-06 05:00:00	AAPL	Stock	64.1925	64.195	64.1275	64.1625	11236.0
2019-11-06 06:00:00	AAPL	Stock	64.175	64.175	64.0025	64.135	39864.0
2019-11-06 07:00:00	AAPL	Stock	64.15	64.27	64.125	64.265	130728.0
2019-11-06 08:00:00	AAPL	Stock	64.1875	64.3125	64.1225	64.27	240984.0
2019-11-06 09:00:00	AAPL	Stock	64.2375	64.3725	64.0925	64.2775	8796668.0
2019-11-06 10:00:00	AAPL	Stock	64.2725	64.3025	64.0075	64.025	7942896.0
2019-11-06 11:00:00	AAPL	Stock	64.025	64.3375	63.8412	64.0325	11294340.0
2019-11-06 12:00:00	AAPL	Stock	64.0375	64.1038	63.8875	63.9605	5375292.0
2019-11-06 13:00:00	AAPL	Stock	63.965	64.145	63.905	64.095	4411784.0
2019-11-06 14:00:00	AAPL	Stock	64.0975	64.1825	64.085	64.1625	3790432.0
2019-11-06 15:00:00	AAPL	Stock	64.1625	64.3325	64.1075	64.31	9143876.0
2019-11-06 16:00:00	AAPL	Stock	64.31	64.375	64.28	64.3275	11147272.0
2019-11-06 17:00:00	AAPL	Stock	64.33	64.3875	64.31	64.375	130244.0
2019-11-06 18:00:00	AAPL	Stock	64.375	64.3925	64.3325	64.355	34848.0
2019-11-06 19:00:00	AAPL	Stock	64.34	64.425	64.34	64.3975	33460.0
2019-11-06 04:00:00	MSFT	Stock	144.3	144.6	144.27	144.27	2426.0
2019-11-06 05:00:00	MSFT	Stock	144.36	144.58	144.32	144.58	1090.0
2019-11-06 06:00:00	MSFT	Stock	144.51	144.6	144.45	144.57	2067.0
2019-11-06 07:00:00	MSFT	Stock	144.45	144.58	144.45	144.53	2145.0
2019-11-06 08:00:00	MSFT	Stock	144.351	144.58	144.351	144.54	25291.0
2019-11-06 09:00:00	MSFT	Stock	144.58	144.58	143.76	144.04	1843329.0
2019-11-06 10:00:00	MSFT	Stock	144.04	144.136	143.79	143.88	1775366.0
2019-11-06 11:00:00	MSFT	Stock	143.88	144.2	143.2	143.45	2376792.0
2019-11-06 12:00:00	MSFT	Stock	143.47	143.79	143.44	143.76	1069937.0
2019-11-06 13:00:00	MSFT	Stock	143.77	143.98	143.667	143.96	917918.0
2019-11-06 14:00:00	MSFT	Stock	143.96	144.075	143.85	143.95	901164.0
2019-11-06 15:00:00	MSFT	Stock	143.96	144.18	143.9	144.06	1731968.0
2019-11-06 16:00:00	MSFT	Stock	144.06	144.11	143.925	143.99	3653255.0
2019-11-06 17:00:00	MSFT	Stock	144.0	144.11	143.99	144.035	38531.0
2019-11-06 18:00:00	MSFT	Stock	144.03	144.04	144.03	144.03	1337.0
2019-11-06 19:00:00	MSFT	Stock	144.02	144.06	144.02	144.04	1850.0
2019-11-06 04:00:00	NVDA	Stock	5.2405	5.2405	5.2303	5.233	28000.0
2019-11-06 05:00:00	NVDA	Stock	5.22	5.22	5.212	5.212	21840.0
2019-11-06 06:00:00	NVDA	Stock	5.2158	5.2158	5.2125	5.2125	17880.0
2019-11-06 07:00:00	NVDA	Stock	5.2148	5.2345	5.2148	5.2345	137280.0
2019-11-06 08:00:00	NVDA	Stock	5.2128	5.24	5.2078	5.225	600200.0
2019-11-06 09:00:00	NVDA	Stock	5.2248	5.2418	5.1659	5.1708	34179880.0
2019-11-06 10:00:00	NVDA	Stock	5.17	5.1825	5.1028	5.137	63611320.0
2019-11-06 11:00:00	NVDA	Stock	5.136	5.1805	5.1248	5.1513	33097440.0
2019-11-06 12:00:00	NVDA	Stock	5.1525	5.1766	5.1513	5.176	15483000.0
2019-11-06 13:00:00	NVDA	Stock	5.1762	5.1912	5.1675	5.1878	14185240.0
2019-11-06 14:00:00	NVDA	Stock	5.1895	5.194	5.1765	5.1779	13187000.0
2019-11-06 15:00:00	NVDA	Stock	5.1779	5.1912	5.1715	5.19	17751000.0
2019-11-06 16:00:00	NVDA	Stock	5.1908	5.2198	5.1768	5.19	22925280.0
2019-11-06 17:00:00	NVDA	Stock	5.1985	5.1985	5.1912	5.195	163080.0
2019-11-06 18:00:00	NVDA	Stock	5.1908	5.198	5.1908	5.1912	67520.0
2019-11-06 19:00:00	NVDA	Stock	5.1938	5.2	5.1915	5.2	160320.0
2019-11-06 07:00:00	AMZN	Stock	90.07	90.07	90.07	90.07	2860.0
2019-11-06 08:00:00	AMZN	Stock	90.3105	90.3105	90.05	90.0855	65140.0

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

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