PREVIEW / stock_1hour / 2019-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-03.parquet
  size:    1.1 MB
  rows:    49,316
  symbols: 2,609

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-05-03 04:00:00	AAPL	Stock	52.495	52.595	52.495	52.5475	6108.0
2019-05-03 05:00:00	AAPL	Stock	52.5375	52.575	52.4875	52.4875	26136.0
2019-05-03 06:00:00	AAPL	Stock	52.485	52.6	52.4475	52.56	43932.0
2019-05-03 07:00:00	AAPL	Stock	52.525	52.615	52.5125	52.6125	147992.0
2019-05-03 08:00:00	AAPL	Stock	52.61	52.7475	52.4675	52.695	794620.0
2019-05-03 09:00:00	AAPL	Stock	52.695	52.865	52.5725	52.78	13532804.0
2019-05-03 10:00:00	AAPL	Stock	52.775	52.8325	52.5575	52.7112	12037836.0
2019-05-03 11:00:00	AAPL	Stock	52.7125	52.815	52.655	52.748	8773972.0
2019-05-03 12:00:00	AAPL	Stock	52.7492	52.855	52.7075	52.7425	6215692.0
2019-05-03 13:00:00	AAPL	Stock	52.745	52.925	52.7325	52.8075	5513940.0
2019-05-03 14:00:00	AAPL	Stock	52.8075	52.8625	52.77	52.855	4360104.0
2019-05-03 15:00:00	AAPL	Stock	52.855	52.96	52.745	52.945	10382960.0
2019-05-03 16:00:00	AAPL	Stock	52.9375	52.99	52.8975	52.985	9602248.0
2019-05-03 17:00:00	AAPL	Stock	52.96	52.99	52.9375	52.98	76892.0
2019-05-03 18:00:00	AAPL	Stock	52.9875	52.9875	52.9525	52.9725	88196.0
2019-05-03 19:00:00	AAPL	Stock	52.97	53.0	52.9575	52.9875	67436.0
2019-05-03 04:00:00	MSFT	Stock	127.0	127.0	126.89	126.89	1883.0
2019-05-03 05:00:00	MSFT	Stock	127.08	127.2	126.92	126.97	4500.0
2019-05-03 06:00:00	MSFT	Stock	126.86	126.99	126.75	126.75	2300.0
2019-05-03 07:00:00	MSFT	Stock	126.75	127.0	126.71	126.9	13688.0
2019-05-03 08:00:00	MSFT	Stock	126.8	127.27	126.53	127.27	56907.0
2019-05-03 09:00:00	MSFT	Stock	127.27	127.865	127.05	127.865	2422995.0
2019-05-03 10:00:00	MSFT	Stock	127.86	128.594	127.78	128.49	3257282.0
2019-05-03 11:00:00	MSFT	Stock	128.495	128.773	128.16	128.35	2751118.0
2019-05-03 12:00:00	MSFT	Stock	128.34	128.75	128.276	128.619	2277412.0
2019-05-03 13:00:00	MSFT	Stock	128.62	129.43	128.55	129.29	3118354.0
2019-05-03 14:00:00	MSFT	Stock	129.28	129.31	128.71	128.76	2177006.0
2019-05-03 15:00:00	MSFT	Stock	128.76	129.04	128.58	128.89	3831081.0
2019-05-03 16:00:00	MSFT	Stock	128.9	129.09	128.78	129.08	2128655.0
2019-05-03 17:00:00	MSFT	Stock	129.07	129.07	129.02	129.05	1983.0
2019-05-03 18:00:00	MSFT	Stock	129.07	129.09	128.9	129.09	5637.0
2019-05-03 19:00:00	MSFT	Stock	129.04	129.19	129.03	129.1	5893.0
2019-05-03 04:00:00	NVDA	Stock	4.5875	4.5875	4.5838	4.5838	9240.0
2019-05-03 06:00:00	NVDA	Stock	4.5838	4.5885	4.5838	4.5885	27640.0
2019-05-03 07:00:00	NVDA	Stock	4.5835	4.5845	4.5502	4.5638	192760.0
2019-05-03 08:00:00	NVDA	Stock	4.5578	4.5888	4.55	4.5888	945840.0
2019-05-03 09:00:00	NVDA	Stock	4.58	4.5982	4.5132	4.5474	66470120.0
2019-05-03 10:00:00	NVDA	Stock	4.5468	4.5692	4.5415	4.5605	50734280.0
2019-05-03 11:00:00	NVDA	Stock	4.5609	4.584	4.5548	4.556	37920680.0
2019-05-03 12:00:00	NVDA	Stock	4.5555	4.5718	4.5492	4.5673	23240800.0
2019-05-03 13:00:00	NVDA	Stock	4.5681	4.5866	4.564	4.5825	20816160.0
2019-05-03 14:00:00	NVDA	Stock	4.5815	4.5828	4.564	4.575	22341000.0
2019-05-03 15:00:00	NVDA	Stock	4.575	4.5818	4.5598	4.575	46845480.0
2019-05-03 16:00:00	NVDA	Stock	4.5752	4.5772	4.5703	4.577	6108800.0
2019-05-03 17:00:00	NVDA	Stock	4.5775	4.5775	4.575	4.5775	71800.0
2019-05-03 18:00:00	NVDA	Stock	4.5775	4.5795	4.5752	4.5775	1844440.0
2019-05-03 19:00:00	NVDA	Stock	4.5772	4.5792	4.575	4.5792	185000.0
2019-05-03 04:00:00	AMZN	Stock	97.05	97.1065	96.8475	97.05	53980.0
2019-05-03 05:00:00	AMZN	Stock	97.049	97.1	97.0	97.0945	16260.0
2019-05-03 06:00:00	AMZN	Stock	97.0345	97.378	97.0345	97.3195	119220.0

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

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