PREVIEW / stock_1hour / 2019-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-08.parquet
  size:    1.1 MB
  rows:    49,712
  symbols: 2,501

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-08 04:00:00	AAPL	Stock	64.72	64.75	64.72	64.72	4364.0
2019-11-08 05:00:00	AAPL	Stock	64.675	64.75	64.675	64.7325	11136.0
2019-11-08 06:00:00	AAPL	Stock	64.6825	64.775	64.6825	64.775	18296.0
2019-11-08 07:00:00	AAPL	Stock	64.7825	64.8325	64.675	64.7	104024.0
2019-11-08 08:00:00	AAPL	Stock	64.7625	64.8575	64.69	64.75	229944.0
2019-11-08 09:00:00	AAPL	Stock	64.7575	64.8348	64.355	64.37	9994764.0
2019-11-08 10:00:00	AAPL	Stock	64.37	64.6475	64.2125	64.6475	11164688.0
2019-11-08 11:00:00	AAPL	Stock	64.6462	64.6925	64.4825	64.63	4425644.0
2019-11-08 12:00:00	AAPL	Stock	64.6375	64.7875	64.5875	64.7835	3853448.0
2019-11-08 13:00:00	AAPL	Stock	64.7825	64.905	64.715	64.72	5036244.0
2019-11-08 14:00:00	AAPL	Stock	64.7225	64.8525	64.6975	64.81	3765144.0
2019-11-08 15:00:00	AAPL	Stock	64.8075	65.11	64.8	65.035	13146908.0
2019-11-08 16:00:00	AAPL	Stock	65.035	65.045	64.99	65.005	5878924.0
2019-11-08 17:00:00	AAPL	Stock	65.0025	65.02	65.0	65.0025	42396.0
2019-11-08 18:00:00	AAPL	Stock	65.005	65.0125	65.0025	65.0025	21268.0
2019-11-08 19:00:00	AAPL	Stock	65.005	65.025	65.0	65.0075	70100.0
2019-11-08 04:00:00	MSFT	Stock	144.26	144.5	144.19	144.27	703.0
2019-11-08 05:00:00	MSFT	Stock	144.38	144.51	144.38	144.51	621.0
2019-11-08 06:00:00	MSFT	Stock	144.35	144.48	144.3	144.3	1084.0
2019-11-08 07:00:00	MSFT	Stock	144.35	144.48	144.02	144.05	12876.0
2019-11-08 08:00:00	MSFT	Stock	144.46	144.46	143.9	144.02	35699.0
2019-11-08 09:00:00	MSFT	Stock	144.06	144.5	143.85	144.14	1604230.0
2019-11-08 10:00:00	MSFT	Stock	144.15	144.54	143.76	144.399	1669760.0
2019-11-08 11:00:00	MSFT	Stock	144.4	144.75	144.31	144.71	1251191.0
2019-11-08 12:00:00	MSFT	Stock	144.702	145.4	144.68	145.07	2108452.0
2019-11-08 13:00:00	MSFT	Stock	145.08	145.24	145.02	145.09	959009.0
2019-11-08 14:00:00	MSFT	Stock	145.09	145.25	145.05	145.14	877088.0
2019-11-08 15:00:00	MSFT	Stock	145.14	145.99	145.06	145.96	3775118.0
2019-11-08 16:00:00	MSFT	Stock	145.96	146.09	145.91	145.98	2199243.0
2019-11-08 17:00:00	MSFT	Stock	145.93	145.98	145.93	145.98	6682.0
2019-11-08 18:00:00	MSFT	Stock	145.95	146.06	145.95	146.06	12778.0
2019-11-08 19:00:00	MSFT	Stock	146.05	146.11	146.01	146.11	5641.0
2019-11-08 05:00:00	NVDA	Stock	5.196	5.196	5.194	5.194	8000.0
2019-11-08 06:00:00	NVDA	Stock	5.2188	5.2188	5.2125	5.2125	24000.0
2019-11-08 07:00:00	NVDA	Stock	5.2138	5.2373	5.2003	5.2003	226600.0
2019-11-08 08:00:00	NVDA	Stock	5.2163	5.235	5.1942	5.206	693440.0
2019-11-08 09:00:00	NVDA	Stock	5.2055	5.2182	5.1725	5.1767	21156680.0
2019-11-08 10:00:00	NVDA	Stock	5.1805	5.204	5.1538	5.1973	30452280.0
2019-11-08 11:00:00	NVDA	Stock	5.198	5.225	5.1929	5.223	21431160.0
2019-11-08 12:00:00	NVDA	Stock	5.2228	5.2262	5.2068	5.2072	14404720.0
2019-11-08 13:00:00	NVDA	Stock	5.2069	5.2073	5.1695	5.17	17895960.0
2019-11-08 14:00:00	NVDA	Stock	5.1698	5.185	5.1633	5.1833	17451400.0
2019-11-08 15:00:00	NVDA	Stock	5.1833	5.1953	5.1725	5.1942	32969880.0
2019-11-08 16:00:00	NVDA	Stock	5.1945	5.21	5.1808	5.1888	3810280.0
2019-11-08 17:00:00	NVDA	Stock	5.1882	5.192	5.1875	5.192	177120.0
2019-11-08 18:00:00	NVDA	Stock	5.1918	5.1962	5.1918	5.1925	183560.0
2019-11-08 19:00:00	NVDA	Stock	5.1928	5.197	5.1885	5.1962	108920.0
2019-11-08 05:00:00	AMZN	Stock	89.247	89.247	89.152	89.152	8800.0
2019-11-08 06:00:00	AMZN	Stock	89.1525	89.153	89.1525	89.153	4680.0
2019-11-08 07:00:00	AMZN	Stock	89.3395	89.4095	89.265	89.265	54020.0

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

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