PREVIEW / stock_1hour / 2019-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-14.parquet
  size:    1.1 MB
  rows:    50,047
  symbols: 2,497

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-14 04:00:00	AAPL	Stock	66.0625	66.1375	65.975	66.075	14824.0
2019-11-14 05:00:00	AAPL	Stock	66.075	66.15	66.075	66.1375	5868.0
2019-11-14 06:00:00	AAPL	Stock	66.08	66.08	66.0025	66.055	27380.0
2019-11-14 07:00:00	AAPL	Stock	66.085	66.0875	65.6875	65.7125	501172.0
2019-11-14 08:00:00	AAPL	Stock	66.0875	66.0875	65.615	65.8	846144.0
2019-11-14 09:00:00	AAPL	Stock	65.7675	66.2075	65.7525	66.0775	15042540.0
2019-11-14 10:00:00	AAPL	Stock	66.075	66.22	65.6925	65.695	13520676.0
2019-11-14 11:00:00	AAPL	Stock	65.6925	65.9375	65.5575	65.7242	11643372.0
2019-11-14 12:00:00	AAPL	Stock	65.7225	65.835	65.5275	65.7775	7659684.0
2019-11-14 13:00:00	AAPL	Stock	65.7775	65.915	65.525	65.7115	6246048.0
2019-11-14 14:00:00	AAPL	Stock	65.7175	65.75	65.6292	65.7325	3872416.0
2019-11-14 15:00:00	AAPL	Stock	65.73	65.794	65.615	65.6725	9440240.0
2019-11-14 16:00:00	AAPL	Stock	65.6875	65.8333	65.55	65.625	5296056.0
2019-11-14 17:00:00	AAPL	Stock	65.615	65.66	65.3175	65.4375	344964.0
2019-11-14 18:00:00	AAPL	Stock	65.475	65.495	65.35	65.45	229168.0
2019-11-14 19:00:00	AAPL	Stock	65.45	65.66	65.4025	65.66	186004.0
2019-11-14 04:00:00	MSFT	Stock	147.1	147.1	147.1	147.1	180.0
2019-11-14 05:00:00	MSFT	Stock	147.25	147.49	147.25	147.49	1450.0
2019-11-14 06:00:00	MSFT	Stock	147.27	147.39	147.1	147.31	4002.0
2019-11-14 07:00:00	MSFT	Stock	147.25	147.26	147.18	147.22	4643.0
2019-11-14 08:00:00	MSFT	Stock	147.141	147.31	146.91	147.05	11495.0
2019-11-14 09:00:00	MSFT	Stock	147.15	148.0	147.0	147.87	1861690.0
2019-11-14 10:00:00	MSFT	Stock	147.865	148.09	147.39	147.438	1722713.0
2019-11-14 11:00:00	MSFT	Stock	147.44	147.95	147.265	147.33	1562919.0
2019-11-14 12:00:00	MSFT	Stock	147.33	147.75	147.225	147.72	1031286.0
2019-11-14 13:00:00	MSFT	Stock	147.715	147.8	147.0	147.5	1181221.0
2019-11-14 14:00:00	MSFT	Stock	147.5	147.95	147.42	147.946	900057.0
2019-11-14 15:00:00	MSFT	Stock	147.942	148.41	147.85	148.06	3007364.0
2019-11-14 16:00:00	MSFT	Stock	148.06	148.15	147.41	147.96	3097548.0
2019-11-14 17:00:00	MSFT	Stock	147.94	148.06	147.72	147.9	22271.0
2019-11-14 18:00:00	MSFT	Stock	147.85	148.13	147.8	148.06	13955.0
2019-11-14 19:00:00	MSFT	Stock	148.1	148.77	148.02	148.77	12083.0
2019-11-14 04:00:00	NVDA	Stock	5.2125	5.2273	5.2125	5.2273	26040.0
2019-11-14 05:00:00	NVDA	Stock	5.2288	5.2288	5.2255	5.2255	15560.0
2019-11-14 06:00:00	NVDA	Stock	5.2273	5.2348	5.2213	5.2348	46520.0
2019-11-14 07:00:00	NVDA	Stock	5.2362	5.25	5.2312	5.2403	1029880.0
2019-11-14 08:00:00	NVDA	Stock	5.2325	5.2484	5.225	5.2337	1834160.0
2019-11-14 09:00:00	NVDA	Stock	5.2282	5.23	5.1693	5.2033	47793880.0
2019-11-14 10:00:00	NVDA	Stock	5.2032	5.2422	5.176	5.1845	62418920.0
2019-11-14 11:00:00	NVDA	Stock	5.1825	5.2164	5.1629	5.175	52173320.0
2019-11-14 12:00:00	NVDA	Stock	5.1748	5.204	5.1745	5.2028	28562840.0
2019-11-14 13:00:00	NVDA	Stock	5.2028	5.2362	5.2024	5.2214	39748880.0
2019-11-14 14:00:00	NVDA	Stock	5.2198	5.2315	5.2095	5.23	33308960.0
2019-11-14 15:00:00	NVDA	Stock	5.2303	5.247	5.2228	5.245	71587720.0
2019-11-14 16:00:00	NVDA	Stock	5.2448	5.4588	5.0708	5.225	74476960.0
2019-11-14 17:00:00	NVDA	Stock	5.2265	5.2448	5.1808	5.1808	10279680.0
2019-11-14 18:00:00	NVDA	Stock	5.175	5.225	5.15	5.175	8337840.0
2019-11-14 19:00:00	NVDA	Stock	5.175	5.2	5.17	5.1973	2408000.0
2019-11-14 07:00:00	AMZN	Stock	87.6	87.6395	87.6	87.635	12200.0
2019-11-14 08:00:00	AMZN	Stock	87.6153	87.8745	87.455	87.55	114780.0

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

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