PREVIEW / stock_1hour / 2018-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-02.parquet
  size:    1.1 MB
  rows:    49,329
  symbols: 2,796

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
2018-07-02 04:00:00	AAPL	Stock	45.9675	46.0	45.9675	45.9975	4000.0
2018-07-02 05:00:00	AAPL	Stock	46.0025	46.0125	46.0025	46.0125	2680.0
2018-07-02 06:00:00	AAPL	Stock	45.975	46.0	45.975	46.0	12796.0
2018-07-02 07:00:00	AAPL	Stock	46.065	46.07	45.9275	46.05	56984.0
2018-07-02 08:00:00	AAPL	Stock	45.97	46.2775	45.9625	45.975	132768.0
2018-07-02 09:00:00	AAPL	Stock	45.9675	46.5625	45.855	46.53	10888076.0
2018-07-02 10:00:00	AAPL	Stock	46.53	46.6725	46.4125	46.6425	10293232.0
2018-07-02 11:00:00	AAPL	Stock	46.6425	46.7375	46.4275	46.495	6722380.0
2018-07-02 12:00:00	AAPL	Stock	46.4925	46.5162	46.3902	46.4525	4068488.0
2018-07-02 13:00:00	AAPL	Stock	46.4515	46.6275	46.32	46.6062	4164360.0
2018-07-02 14:00:00	AAPL	Stock	46.6075	46.76	46.5875	46.5988	7154912.0
2018-07-02 15:00:00	AAPL	Stock	46.6025	46.825	46.58	46.7875	10721816.0
2018-07-02 16:00:00	AAPL	Stock	46.795	46.795	46.5595	46.795	7163548.0
2018-07-02 17:00:00	AAPL	Stock	46.77	46.8	46.7625	46.795	32468.0
2018-07-02 18:00:00	AAPL	Stock	46.7775	46.825	46.7775	46.8	54564.0
2018-07-02 19:00:00	AAPL	Stock	46.8	46.8125	46.7775	46.8125	10392.0
2018-07-02 04:00:00	MSFT	Stock	98.06	98.12	97.9	98.12	1694.0
2018-07-02 05:00:00	MSFT	Stock	97.93	98.0	97.93	98.0	1500.0
2018-07-02 06:00:00	MSFT	Stock	98.11	98.23	98.0	98.16	6606.0
2018-07-02 07:00:00	MSFT	Stock	98.25	98.5	98.15	98.32	4248.0
2018-07-02 08:00:00	MSFT	Stock	98.32	98.61	98.08	98.24	32655.0
2018-07-02 09:00:00	MSFT	Stock	98.61	98.65	97.94	98.6	2557683.0
2018-07-02 10:00:00	MSFT	Stock	98.57	99.06	98.46	98.95	2465827.0
2018-07-02 11:00:00	MSFT	Stock	98.95	99.31	98.715	98.84	1682984.0
2018-07-02 12:00:00	MSFT	Stock	98.84	99.065	98.76	99.02	1077856.0
2018-07-02 13:00:00	MSFT	Stock	99.02	99.6	98.74	99.565	1592407.0
2018-07-02 14:00:00	MSFT	Stock	99.57	99.94	99.51	99.595	1961630.0
2018-07-02 15:00:00	MSFT	Stock	99.6	100.06	99.51	100.02	3064132.0
2018-07-02 16:00:00	MSFT	Stock	100.02	100.02	99.95	99.95	2554721.0
2018-07-02 17:00:00	MSFT	Stock	99.99	100.0	99.95	99.95	2750.0
2018-07-02 18:00:00	MSFT	Stock	99.94	100.25	99.94	100.12	22995.0
2018-07-02 19:00:00	MSFT	Stock	100.1	100.2	100.05	100.2	7255.0
2018-07-02 04:00:00	NVDA	Stock	5.875	5.887	5.8728	5.8825	110640.0
2018-07-02 05:00:00	NVDA	Stock	5.881	5.881	5.8775	5.8798	22720.0
2018-07-02 06:00:00	NVDA	Stock	5.8795	5.8795	5.8708	5.8708	60000.0
2018-07-02 07:00:00	NVDA	Stock	5.8995	5.8998	5.8628	5.88	130760.0
2018-07-02 08:00:00	NVDA	Stock	5.875	5.8875	5.8505	5.8575	688520.0
2018-07-02 09:00:00	NVDA	Stock	5.8525	5.9892	5.8316	5.9876	79462640.0
2018-07-02 10:00:00	NVDA	Stock	5.9862	6.008	5.9375	5.9713	72600400.0
2018-07-02 11:00:00	NVDA	Stock	5.9708	5.994	5.941	5.9664	33664440.0
2018-07-02 12:00:00	NVDA	Stock	5.9663	5.9883	5.9563	5.9784	24661360.0
2018-07-02 13:00:00	NVDA	Stock	5.9785	6.0113	5.9646	6.0025	35039840.0
2018-07-02 14:00:00	NVDA	Stock	6.003	6.0414	5.9985	6.022	38386840.0
2018-07-02 15:00:00	NVDA	Stock	6.0205	6.0598	6.012	6.056	45000600.0
2018-07-02 16:00:00	NVDA	Stock	6.0562	6.0595	5.9741	6.0463	7641880.0
2018-07-02 17:00:00	NVDA	Stock	6.0388	6.0475	6.03	6.0405	592000.0
2018-07-02 18:00:00	NVDA	Stock	6.0413	6.0433	6.0263	6.043	85000.0
2018-07-02 19:00:00	NVDA	Stock	6.043	6.056	6.043	6.045	290720.0
2018-07-02 04:00:00	AMZN	Stock	84.4625	84.4625	84.4625	84.4625	2460.0
2018-07-02 06:00:00	AMZN	Stock	84.3875	84.3875	84.3875	84.3875	4000.0

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

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