PREVIEW / stock_1hour / 2019-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-27.parquet
  size:    1.1 MB
  rows:    49,593
  symbols: 2,656

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-02-27 04:00:00	AAPL	Stock	43.415	43.4475	43.415	43.4475	3328.0
2019-02-27 05:00:00	AAPL	Stock	43.4225	43.445	43.3925	43.445	4880.0
2019-02-27 06:00:00	AAPL	Stock	43.445	43.445	43.4	43.405	4404.0
2019-02-27 07:00:00	AAPL	Stock	43.465	43.5275	43.45	43.475	41008.0
2019-02-27 08:00:00	AAPL	Stock	43.4875	43.69	43.4	43.415	596708.0
2019-02-27 09:00:00	AAPL	Stock	43.4225	43.725	43.3025	43.51	9636008.0
2019-02-27 10:00:00	AAPL	Stock	43.5125	43.5612	43.1825	43.2725	13489404.0
2019-02-27 11:00:00	AAPL	Stock	43.2738	43.5175	43.22	43.4732	7480344.0
2019-02-27 12:00:00	AAPL	Stock	43.4738	43.59	43.4525	43.585	4943712.0
2019-02-27 13:00:00	AAPL	Stock	43.585	43.67	43.5475	43.605	4449160.0
2019-02-27 14:00:00	AAPL	Stock	43.606	43.7375	43.5972	43.66	5236948.0
2019-02-27 15:00:00	AAPL	Stock	43.6625	43.75	43.605	43.72	10283752.0
2019-02-27 16:00:00	AAPL	Stock	43.7175	43.75	43.5605	43.735	13775016.0
2019-02-27 17:00:00	AAPL	Stock	43.725	43.745	43.7	43.725	39476.0
2019-02-27 18:00:00	AAPL	Stock	43.725	43.7275	43.7025	43.705	18372.0
2019-02-27 19:00:00	AAPL	Stock	43.6875	43.7	43.6675	43.6875	12712.0
2019-02-27 04:00:00	MSFT	Stock	112.17	112.17	111.81	112.01	2299.0
2019-02-27 06:00:00	MSFT	Stock	112.06	112.06	112.06	112.06	200.0
2019-02-27 07:00:00	MSFT	Stock	112.23	112.25	111.87	111.91	11559.0
2019-02-27 08:00:00	MSFT	Stock	112.0	112.1	111.73	111.89	32486.0
2019-02-27 09:00:00	MSFT	Stock	111.79	112.18	111.47	111.6	2247681.0
2019-02-27 10:00:00	MSFT	Stock	111.61	111.695	110.88	111.39	3159917.0
2019-02-27 11:00:00	MSFT	Stock	111.39	112.2	111.38	112.127	1885985.0
2019-02-27 12:00:00	MSFT	Stock	112.125	112.345	112.09	112.15	1084974.0
2019-02-27 13:00:00	MSFT	Stock	112.15	112.21	111.75	111.98	2560013.0
2019-02-27 14:00:00	MSFT	Stock	111.985	112.36	111.92	112.25	1886485.0
2019-02-27 15:00:00	MSFT	Stock	112.245	112.31	111.82	112.19	3586782.0
2019-02-27 16:00:00	MSFT	Stock	112.17	112.32	112.14	112.26	3038436.0
2019-02-27 17:00:00	MSFT	Stock	112.3	112.39	112.19	112.22	8513.0
2019-02-27 18:00:00	MSFT	Stock	112.36	112.38	112.22	112.38	6554.0
2019-02-27 19:00:00	MSFT	Stock	112.23	112.25	112.15	112.15	5028.0
2019-02-27 04:00:00	NVDA	Stock	3.9128	3.9128	3.9128	3.9128	20240.0
2019-02-27 05:00:00	NVDA	Stock	3.9125	3.9125	3.9125	3.9125	10000.0
2019-02-27 07:00:00	NVDA	Stock	3.9218	3.9303	3.9178	3.9195	539280.0
2019-02-27 08:00:00	NVDA	Stock	3.9166	3.9373	3.9128	3.9162	820400.0
2019-02-27 09:00:00	NVDA	Stock	3.9152	3.9398	3.861	3.87	74136240.0
2019-02-27 10:00:00	NVDA	Stock	3.8712	3.8832	3.8278	3.8586	93675920.0
2019-02-27 11:00:00	NVDA	Stock	3.858	3.9019	3.8403	3.8898	56061240.0
2019-02-27 12:00:00	NVDA	Stock	3.8892	3.907	3.884	3.8932	34676680.0
2019-02-27 13:00:00	NVDA	Stock	3.894	3.9379	3.892	3.9312	55690200.0
2019-02-27 14:00:00	NVDA	Stock	3.9319	3.9319	3.899	3.9038	49852640.0
2019-02-27 15:00:00	NVDA	Stock	3.904	3.9088	3.8838	3.885	76849680.0
2019-02-27 16:00:00	NVDA	Stock	3.8852	3.8974	3.8852	3.89	14056720.0
2019-02-27 17:00:00	NVDA	Stock	3.8912	3.8925	3.8875	3.8925	68720.0
2019-02-27 18:00:00	NVDA	Stock	3.8903	3.8912	3.8875	3.8875	89880.0
2019-02-27 19:00:00	NVDA	Stock	3.8875	3.8962	3.8875	3.895	285320.0
2019-02-27 04:00:00	AMZN	Stock	81.47	81.47	81.47	81.47	2000.0
2019-02-27 07:00:00	AMZN	Stock	81.5225	81.69	81.503	81.65	52920.0
2019-02-27 08:00:00	AMZN	Stock	81.4875	81.685	81.4115	81.55	71920.0
2019-02-27 09:00:00	AMZN	Stock	81.5	81.7895	81.1805	81.25	5542800.0

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

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