PREVIEW / stock_1hour / 2020-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-17.parquet
  size:    1.2 MB
  rows:    51,159
  symbols: 2,468

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-01-17 04:00:00	AAPL	Stock	79.01	79.3	79.01	79.2475	37120.0
2020-01-17 05:00:00	AAPL	Stock	79.2825	79.3375	79.255	79.255	44820.0
2020-01-17 06:00:00	AAPL	Stock	79.2525	79.3	79.2425	79.2875	38644.0
2020-01-17 07:00:00	AAPL	Stock	79.255	79.31	79.0025	79.155	350740.0
2020-01-17 08:00:00	AAPL	Stock	79.275	79.295	78.9925	79.1825	1085604.0
2020-01-17 09:00:00	AAPL	Stock	79.175	79.2625	78.81	79.2338	23522464.0
2020-01-17 10:00:00	AAPL	Stock	79.2225	79.3125	78.9775	79.07	15011340.0
2020-01-17 11:00:00	AAPL	Stock	79.075	79.1	78.75	79.09	10888772.0
2020-01-17 12:00:00	AAPL	Stock	79.0912	79.2325	78.9375	78.955	8967980.0
2020-01-17 13:00:00	AAPL	Stock	78.955	79.2075	78.8475	79.1925	7962192.0
2020-01-17 14:00:00	AAPL	Stock	79.1938	79.2675	79.105	79.2675	8660464.0
2020-01-17 15:00:00	AAPL	Stock	79.2675	79.685	79.155	79.6675	22418076.0
2020-01-17 16:00:00	AAPL	Stock	79.6675	79.695	79.6025	79.6625	14264452.0
2020-01-17 17:00:00	AAPL	Stock	79.64	79.6825	79.6275	79.66	97704.0
2020-01-17 18:00:00	AAPL	Stock	79.6625	79.68	79.6525	79.6675	60240.0
2020-01-17 19:00:00	AAPL	Stock	79.675	79.6825	79.65	79.6625	80604.0
2020-01-17 04:00:00	MSFT	Stock	167.05	167.15	166.97	167.0	8775.0
2020-01-17 05:00:00	MSFT	Stock	167.0	167.4	167.0	167.4	6021.0
2020-01-17 06:00:00	MSFT	Stock	167.3	167.3	167.1	167.2	6716.0
2020-01-17 07:00:00	MSFT	Stock	167.3	167.32	167.03	167.09	45359.0
2020-01-17 08:00:00	MSFT	Stock	167.2	167.49	167.02	167.372	77235.0
2020-01-17 09:00:00	MSFT	Stock	167.376	167.66	165.77	166.57	7441456.0
2020-01-17 10:00:00	MSFT	Stock	166.56	166.58	165.81	166.027	2877504.0
2020-01-17 11:00:00	MSFT	Stock	166.025	166.13	165.43	165.7	2051408.0
2020-01-17 12:00:00	MSFT	Stock	165.704	166.3	165.53	166.03	1646691.0
2020-01-17 13:00:00	MSFT	Stock	166.035	166.43	166.01	166.341	1145314.0
2020-01-17 14:00:00	MSFT	Stock	166.34	166.575	166.169	166.41	1491852.0
2020-01-17 15:00:00	MSFT	Stock	166.4	167.326	166.17	167.05	3611102.0
2020-01-17 16:00:00	MSFT	Stock	167.1	167.14	166.603	167.1	7938196.0
2020-01-17 17:00:00	MSFT	Stock	166.86	166.9	166.82	166.9	4109.0
2020-01-17 18:00:00	MSFT	Stock	166.87	166.98	166.86	166.87	2721.0
2020-01-17 19:00:00	MSFT	Stock	166.94	166.94	166.82	166.87	10224.0
2020-01-17 04:00:00	NVDA	Stock	6.2375	6.24	6.2348	6.24	12400.0
2020-01-17 06:00:00	NVDA	Stock	6.2323	6.24	6.232	6.24	20800.0
2020-01-17 07:00:00	NVDA	Stock	6.2462	6.2498	6.228	6.2312	380320.0
2020-01-17 08:00:00	NVDA	Stock	6.24	6.248	6.2251	6.246	697880.0
2020-01-17 09:00:00	NVDA	Stock	6.244	6.25	6.2042	6.214	48096280.0
2020-01-17 10:00:00	NVDA	Stock	6.214	6.2353	6.205	6.2108	45250800.0
2020-01-17 11:00:00	NVDA	Stock	6.211	6.22	6.1843	6.2	20210520.0
2020-01-17 12:00:00	NVDA	Stock	6.2	6.2148	6.1942	6.2008	13492760.0
2020-01-17 13:00:00	NVDA	Stock	6.2015	6.2172	6.1988	6.2058	9539120.0
2020-01-17 14:00:00	NVDA	Stock	6.2055	6.2205	6.203	6.2123	13447400.0
2020-01-17 15:00:00	NVDA	Stock	6.212	6.2338	6.1937	6.2318	43331640.0
2020-01-17 16:00:00	NVDA	Stock	6.232	6.232	6.2075	6.209	10688200.0
2020-01-17 17:00:00	NVDA	Stock	6.2123	6.2243	6.2123	6.2243	89080.0
2020-01-17 18:00:00	NVDA	Stock	6.2235	6.2235	6.2185	6.2225	51600.0
2020-01-17 05:00:00	AMZN	Stock	94.135	94.135	94.135	94.135	2840.0
2020-01-17 07:00:00	AMZN	Stock	94.0155	94.075	94.0005	94.025	73740.0
2020-01-17 08:00:00	AMZN	Stock	94.05	94.156	94.0075	94.125	202180.0
2020-01-17 09:00:00	AMZN	Stock	94.1005	94.337	93.5502	93.8064	12286640.0

> showing 50 of 51,159 rows — these rows as CSV

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