PREVIEW / stock_1hour / 2019-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-04.parquet
  size:    1.1 MB
  rows:    49,313
  symbols: 2,635

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-04 04:00:00	AAPL	Stock	48.91	48.9275	48.8725	48.8725	29792.0
2019-04-04 05:00:00	AAPL	Stock	48.87	48.9	48.87	48.9	6160.0
2019-04-04 06:00:00	AAPL	Stock	48.9	48.9475	48.875	48.885	7192.0
2019-04-04 07:00:00	AAPL	Stock	48.895	48.9225	48.8125	48.8125	82644.0
2019-04-04 08:00:00	AAPL	Stock	48.8775	48.9228	48.705	48.7375	299144.0
2019-04-04 09:00:00	AAPL	Stock	48.725	49.0475	48.6425	48.9862	10103420.0
2019-04-04 10:00:00	AAPL	Stock	48.9875	49.0425	48.7	48.96	11878560.0
2019-04-04 11:00:00	AAPL	Stock	48.96	49.0925	48.8103	48.94	9033184.0
2019-04-04 12:00:00	AAPL	Stock	48.9375	48.9925	48.805	48.8912	6108992.0
2019-04-04 13:00:00	AAPL	Stock	48.8925	48.9325	48.8375	48.875	4377096.0
2019-04-04 14:00:00	AAPL	Stock	48.875	49.0225	48.839	48.9725	6675472.0
2019-04-04 15:00:00	AAPL	Stock	48.9725	48.994	48.285	48.93	10311912.0
2019-04-04 16:00:00	AAPL	Stock	48.9225	48.9375	48.8858	48.925	6695404.0
2019-04-04 17:00:00	AAPL	Stock	48.92	48.9275	48.8125	48.895	65848.0
2019-04-04 18:00:00	AAPL	Stock	48.8975	48.8975	48.87	48.89	21928.0
2019-04-04 19:00:00	AAPL	Stock	48.875	48.895	48.8575	48.8875	27652.0
2019-04-04 04:00:00	MSFT	Stock	120.13	120.2	120.13	120.2	200.0
2019-04-04 06:00:00	MSFT	Stock	120.2	120.36	120.2	120.32	987.0
2019-04-04 07:00:00	MSFT	Stock	120.17	120.2	119.97	120.0	2141.0
2019-04-04 08:00:00	MSFT	Stock	120.15	120.3	119.92	120.0	16412.0
2019-04-04 09:00:00	MSFT	Stock	119.901	120.23	119.72	120.1	1846758.0
2019-04-04 10:00:00	MSFT	Stock	120.1	120.11	118.75	119.06	3212114.0
2019-04-04 11:00:00	MSFT	Stock	119.07	119.21	118.71	118.95	2071626.0
2019-04-04 12:00:00	MSFT	Stock	118.96	119.19	118.38	118.61	2199771.0
2019-04-04 13:00:00	MSFT	Stock	118.605	118.955	118.49	118.78	1236745.0
2019-04-04 14:00:00	MSFT	Stock	118.78	119.545	118.74	119.53	1301113.0
2019-04-04 15:00:00	MSFT	Stock	119.536	119.59	119.01	119.33	3622725.0
2019-04-04 16:00:00	MSFT	Stock	119.36	119.53	119.17	119.36	2220568.0
2019-04-04 17:00:00	MSFT	Stock	119.34	119.4	119.21	119.35	9307.0
2019-04-04 18:00:00	MSFT	Stock	119.37	119.37	119.25	119.36	4616.0
2019-04-04 19:00:00	MSFT	Stock	119.35	119.36	119.26	119.31	7654.0
2019-04-04 04:00:00	NVDA	Stock	4.723	4.725	4.709	4.725	108280.0
2019-04-04 05:00:00	NVDA	Stock	4.724	4.724	4.7125	4.7125	30000.0
2019-04-04 06:00:00	NVDA	Stock	4.7362	4.7375	4.7362	4.7375	17400.0
2019-04-04 07:00:00	NVDA	Stock	4.7303	4.7342	4.688	4.689	665680.0
2019-04-04 08:00:00	NVDA	Stock	4.72	4.7369	4.6878	4.7042	2041040.0
2019-04-04 09:00:00	NVDA	Stock	4.6962	4.7492	4.6583	4.7182	112490680.0
2019-04-04 10:00:00	NVDA	Stock	4.7182	4.7252	4.6612	4.7005	90186000.0
2019-04-04 11:00:00	NVDA	Stock	4.7005	4.7092	4.6728	4.6798	45815720.0
2019-04-04 12:00:00	NVDA	Stock	4.6793	4.6978	4.6432	4.6732	51435240.0
2019-04-04 13:00:00	NVDA	Stock	4.6742	4.696	4.6695	4.6892	27467800.0
2019-04-04 14:00:00	NVDA	Stock	4.6896	4.728	4.6845	4.7248	36528320.0
2019-04-04 15:00:00	NVDA	Stock	4.7245	4.7265	4.6912	4.7071	50476680.0
2019-04-04 16:00:00	NVDA	Stock	4.7065	4.71	4.7038	4.706	5461000.0
2019-04-04 17:00:00	NVDA	Stock	4.7042	4.7088	4.7038	4.7053	176600.0
2019-04-04 18:00:00	NVDA	Stock	4.7075	4.71	4.7062	4.7068	206560.0
2019-04-04 19:00:00	NVDA	Stock	4.709	4.709	4.704	4.7065	91440.0
2019-04-04 04:00:00	AMZN	Stock	90.7495	90.7495	90.6775	90.6775	6900.0
2019-04-04 05:00:00	AMZN	Stock	90.772	90.8	90.683	90.8	18940.0
2019-04-04 06:00:00	AMZN	Stock	90.847	91.0	90.847	91.0	21880.0

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

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