PREVIEW / stock_1hour / 2019-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-13.parquet
  size:    1.1 MB
  rows:    49,988
  symbols: 2,512

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-13 04:00:00	AAPL	Stock	65.3675	65.3775	65.0	65.0375	69460.0
2019-11-13 05:00:00	AAPL	Stock	65.085	65.15	65.055	65.095	38448.0
2019-11-13 06:00:00	AAPL	Stock	65.1	65.135	65.0325	65.1025	39840.0
2019-11-13 07:00:00	AAPL	Stock	65.185	65.345	65.17	65.3	254512.0
2019-11-13 08:00:00	AAPL	Stock	65.49	65.49	65.1375	65.3625	201800.0
2019-11-13 09:00:00	AAPL	Stock	65.3625	65.695	65.265	65.625	11285588.0
2019-11-13 10:00:00	AAPL	Stock	65.6225	65.9175	65.5725	65.9018	14018228.0
2019-11-13 11:00:00	AAPL	Stock	65.9075	66.0425	65.8575	66.0225	12102660.0
2019-11-13 12:00:00	AAPL	Stock	66.02	66.0475	65.9225	66.01	6954692.0
2019-11-13 13:00:00	AAPL	Stock	66.0075	66.17	65.8275	65.9975	9823484.0
2019-11-13 14:00:00	AAPL	Stock	66.0	66.04	65.645	66.015	13831956.0
2019-11-13 15:00:00	AAPL	Stock	66.02	66.195	66.01	66.1175	13620312.0
2019-11-13 16:00:00	AAPL	Stock	66.1238	66.1875	66.0725	66.1875	6660632.0
2019-11-13 17:00:00	AAPL	Stock	66.15	66.2	66.15	66.1775	42728.0
2019-11-13 18:00:00	AAPL	Stock	66.1775	66.18	66.14	66.1625	51148.0
2019-11-13 19:00:00	AAPL	Stock	66.1625	66.18	66.1375	66.15	43596.0
2019-11-13 04:00:00	MSFT	Stock	146.62	146.77	146.32	146.32	1327.0
2019-11-13 05:00:00	MSFT	Stock	146.46	146.5	146.45	146.45	1572.0
2019-11-13 06:00:00	MSFT	Stock	146.45	146.45	146.35	146.35	4104.0
2019-11-13 07:00:00	MSFT	Stock	146.45	146.6	146.45	146.55	12246.0
2019-11-13 08:00:00	MSFT	Stock	147.07	147.07	146.365	146.6	20805.0
2019-11-13 09:00:00	MSFT	Stock	146.74	147.15	146.28	147.14	1897898.0
2019-11-13 10:00:00	MSFT	Stock	147.14	147.462	147.01	147.35	2216416.0
2019-11-13 11:00:00	MSFT	Stock	147.35	147.4	146.85	147.09	1422302.0
2019-11-13 12:00:00	MSFT	Stock	147.086	147.22	146.99	147.174	1149763.0
2019-11-13 13:00:00	MSFT	Stock	147.17	147.175	146.48	146.83	1547782.0
2019-11-13 14:00:00	MSFT	Stock	146.81	147.05	146.62	147.048	1347305.0
2019-11-13 15:00:00	MSFT	Stock	147.05	147.41	147.0	147.34	2456230.0
2019-11-13 16:00:00	MSFT	Stock	147.31	147.42	146.94	147.42	2750157.0
2019-11-13 17:00:00	MSFT	Stock	147.42	147.49	147.36	147.42	4164.0
2019-11-13 18:00:00	MSFT	Stock	147.42	147.42	147.35	147.41	1604.0
2019-11-13 19:00:00	MSFT	Stock	147.4	147.4	147.15	147.27	6185.0
2019-11-13 04:00:00	NVDA	Stock	5.2115	5.2115	5.1948	5.2008	68040.0
2019-11-13 05:00:00	NVDA	Stock	5.2075	5.2135	5.189	5.189	27560.0
2019-11-13 06:00:00	NVDA	Stock	5.2015	5.2075	5.2015	5.2075	20000.0
2019-11-13 07:00:00	NVDA	Stock	5.2075	5.2208	5.205	5.2208	328520.0
2019-11-13 08:00:00	NVDA	Stock	5.205	5.2326	5.2048	5.2288	630920.0
2019-11-13 09:00:00	NVDA	Stock	5.23	5.2325	5.1612	5.1736	47440480.0
2019-11-13 10:00:00	NVDA	Stock	5.174	5.1975	5.1578	5.1848	77367880.0
2019-11-13 11:00:00	NVDA	Stock	5.1838	5.229	5.175	5.2246	35830120.0
2019-11-13 12:00:00	NVDA	Stock	5.2246	5.2365	5.2108	5.2193	24046760.0
2019-11-13 13:00:00	NVDA	Stock	5.2195	5.2225	5.1663	5.1771	26952720.0
2019-11-13 14:00:00	NVDA	Stock	5.178	5.1985	5.1475	5.197	32958520.0
2019-11-13 15:00:00	NVDA	Stock	5.1978	5.2188	5.1975	5.214	35755920.0
2019-11-13 16:00:00	NVDA	Stock	5.2142	5.2185	5.2072	5.215	1913840.0
2019-11-13 17:00:00	NVDA	Stock	5.2148	5.222	5.2125	5.222	176480.0
2019-11-13 18:00:00	NVDA	Stock	5.2222	5.2348	5.2208	5.23	514080.0
2019-11-13 19:00:00	NVDA	Stock	5.2305	5.2333	5.2275	5.2325	418440.0
2019-11-13 05:00:00	AMZN	Stock	88.5	88.5	88.5	88.5	4020.0
2019-11-13 06:00:00	AMZN	Stock	88.5255	88.5255	88.5255	88.5255	7000.0

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

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