PREVIEW / stock_1hour / 2019-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-29.parquet
  size:    1.1 MB
  rows:    49,564
  symbols: 2,639

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-04-29 04:00:00	AAPL	Stock	51.095	51.135	51.095	51.12	10296.0
2019-04-29 05:00:00	AAPL	Stock	51.12	51.2	51.12	51.12	18364.0
2019-04-29 06:00:00	AAPL	Stock	51.13	51.13	50.99	51.0425	36848.0
2019-04-29 07:00:00	AAPL	Stock	51.0	51.07	50.9675	51.0625	52896.0
2019-04-29 08:00:00	AAPL	Stock	51.04	51.105	51.0	51.03	235872.0
2019-04-29 09:00:00	AAPL	Stock	51.06	51.3175	50.965	51.23	11675880.0
2019-04-29 10:00:00	AAPL	Stock	51.2325	51.4925	51.2075	51.2625	14492316.0
2019-04-29 11:00:00	AAPL	Stock	51.2625	51.3675	51.1912	51.2225	6787464.0
2019-04-29 12:00:00	AAPL	Stock	51.2225	51.3	51.2025	51.2625	4311196.0
2019-04-29 13:00:00	AAPL	Stock	51.2625	51.2908	51.195	51.2125	4150132.0
2019-04-29 14:00:00	AAPL	Stock	51.215	51.3	51.1975	51.286	5306564.0
2019-04-29 15:00:00	AAPL	Stock	51.2875	51.31	51.11	51.1525	10585184.0
2019-04-29 16:00:00	AAPL	Stock	51.1525	51.155	50.825	50.8875	8396064.0
2019-04-29 17:00:00	AAPL	Stock	50.8875	50.9875	50.85	50.8575	151856.0
2019-04-29 18:00:00	AAPL	Stock	50.85	50.8575	50.75	50.765	279540.0
2019-04-29 19:00:00	AAPL	Stock	50.8	50.8225	50.7675	50.78	106232.0
2019-04-29 04:00:00	MSFT	Stock	130.5	130.66	130.4	130.42	11554.0
2019-04-29 05:00:00	MSFT	Stock	130.36	130.36	130.09	130.1	5740.0
2019-04-29 06:00:00	MSFT	Stock	130.1	130.19	130.0	130.0	6104.0
2019-04-29 07:00:00	MSFT	Stock	129.95	130.08	129.9	130.08	6755.0
2019-04-29 08:00:00	MSFT	Stock	130.0	130.19	129.9	129.94	35719.0
2019-04-29 09:00:00	MSFT	Stock	129.96	130.18	129.438	129.81	2445982.0
2019-04-29 10:00:00	MSFT	Stock	129.82	129.935	129.35	129.85	2006776.0
2019-04-29 11:00:00	MSFT	Stock	129.85	129.91	129.49	129.525	1557558.0
2019-04-29 12:00:00	MSFT	Stock	129.525	129.9	129.49	129.795	1074285.0
2019-04-29 13:00:00	MSFT	Stock	129.795	129.94	129.71	129.86	1084431.0
2019-04-29 14:00:00	MSFT	Stock	129.87	130.14	129.85	129.973	1512158.0
2019-04-29 15:00:00	MSFT	Stock	129.98	130.11	129.71	129.74	2525835.0
2019-04-29 16:00:00	MSFT	Stock	129.77	129.81	129.59	129.69	2029890.0
2019-04-29 17:00:00	MSFT	Stock	129.73	129.74	129.65	129.73	10697.0
2019-04-29 18:00:00	MSFT	Stock	129.7	129.76	129.66	129.71	8882.0
2019-04-29 19:00:00	MSFT	Stock	129.71	129.95	129.68	129.75	12668.0
2019-04-29 04:00:00	NVDA	Stock	4.4868	4.489	4.4865	4.4888	25160.0
2019-04-29 05:00:00	NVDA	Stock	4.47	4.4738	4.47	4.473	24880.0
2019-04-29 06:00:00	NVDA	Stock	4.468	4.4688	4.468	4.4688	21080.0
2019-04-29 07:00:00	NVDA	Stock	4.4578	4.4578	4.4418	4.4525	403280.0
2019-04-29 08:00:00	NVDA	Stock	4.4625	4.472	4.435	4.4588	1119320.0
2019-04-29 09:00:00	NVDA	Stock	4.4625	4.472	4.3875	4.4281	84430600.0
2019-04-29 10:00:00	NVDA	Stock	4.4292	4.4895	4.4228	4.4767	90869640.0
2019-04-29 11:00:00	NVDA	Stock	4.4773	4.4863	4.4625	4.4731	31453760.0
2019-04-29 12:00:00	NVDA	Stock	4.473	4.509	4.4705	4.4968	38681920.0
2019-04-29 13:00:00	NVDA	Stock	4.496	4.5072	4.4888	4.5063	22236280.0
2019-04-29 14:00:00	NVDA	Stock	4.5058	4.5112	4.4895	4.492	27879520.0
2019-04-29 15:00:00	NVDA	Stock	4.4915	4.4935	4.4755	4.484	39023800.0
2019-04-29 16:00:00	NVDA	Stock	4.4833	4.4833	4.4295	4.441	25173720.0
2019-04-29 17:00:00	NVDA	Stock	4.441	4.45	4.435	4.4425	747200.0
2019-04-29 18:00:00	NVDA	Stock	4.4465	4.4575	4.4465	4.4575	48560.0
2019-04-29 19:00:00	NVDA	Stock	4.4528	4.457	4.4412	4.4412	109800.0
2019-04-29 04:00:00	AMZN	Stock	97.725	97.725	97.65	97.65	4000.0
2019-04-29 05:00:00	AMZN	Stock	97.75	97.75	97.6	97.6	16240.0

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

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