PREVIEW / stock_1hour / 2017-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-31.parquet
  size:    1.1 MB
  rows:    49,071
  symbols: 3,006

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
2017-08-31 04:00:00	AAPL	Stock	40.875	40.92	40.8125	40.92	13568.0
2017-08-31 05:00:00	AAPL	Stock	40.9275	40.975	40.925	40.975	12900.0
2017-08-31 06:00:00	AAPL	Stock	40.95	40.95	40.9	40.9	35224.0
2017-08-31 07:00:00	AAPL	Stock	40.9	40.9175	40.8775	40.8775	77936.0
2017-08-31 08:00:00	AAPL	Stock	40.9	40.9175	40.8525	40.89	311924.0
2017-08-31 09:00:00	AAPL	Stock	40.8875	41.02	40.865	40.9875	14147624.0
2017-08-31 10:00:00	AAPL	Stock	40.985	41.025	40.87	40.9365	13822140.0
2017-08-31 11:00:00	AAPL	Stock	40.9375	40.9975	40.8975	40.984	8259928.0
2017-08-31 12:00:00	AAPL	Stock	40.9825	41.13	40.98	41.0138	15045936.0
2017-08-31 13:00:00	AAPL	Stock	41.0138	41.05	40.945	40.9838	7352680.0
2017-08-31 14:00:00	AAPL	Stock	40.9838	41.0465	40.925	41.025	8189612.0
2017-08-31 15:00:00	AAPL	Stock	41.025	41.0775	40.9575	40.9925	16960784.0
2017-08-31 16:00:00	AAPL	Stock	41.0175	41.035	40.985	41.035	12614580.0
2017-08-31 17:00:00	AAPL	Stock	41.0175	41.03	41.0	41.025	203792.0
2017-08-31 18:00:00	AAPL	Stock	41.025	41.035	41.01	41.025	32548.0
2017-08-31 19:00:00	AAPL	Stock	41.025	41.05	41.015	41.05	56912.0
2017-08-31 04:00:00	MSFT	Stock	73.9	73.9	73.9	73.9	3900.0
2017-08-31 05:00:00	MSFT	Stock	74.1	74.11	74.1	74.11	400.0
2017-08-31 06:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	345.0
2017-08-31 07:00:00	MSFT	Stock	74.15	74.15	74.15	74.15	200.0
2017-08-31 08:00:00	MSFT	Stock	74.1	74.18	74.09	74.1	3185.0
2017-08-31 09:00:00	MSFT	Stock	74.16	74.59	73.8	74.565	2828113.0
2017-08-31 10:00:00	MSFT	Stock	74.565	74.75	74.49	74.565	3603915.0
2017-08-31 11:00:00	MSFT	Stock	74.565	74.75	74.46	74.75	1919004.0
2017-08-31 12:00:00	MSFT	Stock	74.75	74.78	74.65	74.725	1398210.0
2017-08-31 13:00:00	MSFT	Stock	74.725	74.92	74.72	74.905	1723735.0
2017-08-31 14:00:00	MSFT	Stock	74.9	74.96	74.695	74.8	1931100.0
2017-08-31 15:00:00	MSFT	Stock	74.805	74.95	74.7	74.78	5495339.0
2017-08-31 16:00:00	MSFT	Stock	74.8	74.8	74.7	74.7	5601853.0
2017-08-31 17:00:00	MSFT	Stock	74.68	74.779	74.68	74.779	37703.0
2017-08-31 18:00:00	MSFT	Stock	74.67	74.67	74.67	74.67	123.0
2017-08-31 19:00:00	MSFT	Stock	74.75	74.75	74.7	74.7	1000.0
2017-08-31 04:00:00	NVDA	Stock	4.1452	4.1672	4.1452	4.1672	28000.0
2017-08-31 06:00:00	NVDA	Stock	4.165	4.167	4.1645	4.167	28040.0
2017-08-31 07:00:00	NVDA	Stock	4.155	4.162	4.1525	4.1525	108280.0
2017-08-31 08:00:00	NVDA	Stock	4.1538	4.1663	4.1518	4.1655	757480.0
2017-08-31 09:00:00	NVDA	Stock	4.1648	4.2035	4.155	4.1972	97882720.0
2017-08-31 10:00:00	NVDA	Stock	4.1972	4.2245	4.1878	4.215	97455320.0
2017-08-31 11:00:00	NVDA	Stock	4.2152	4.219	4.207	4.2158	43975800.0
2017-08-31 12:00:00	NVDA	Stock	4.2152	4.2392	4.2142	4.234	73862720.0
2017-08-31 13:00:00	NVDA	Stock	4.2333	4.24	4.2228	4.2253	43243040.0
2017-08-31 14:00:00	NVDA	Stock	4.2258	4.229	4.211	4.2202	46645640.0
2017-08-31 15:00:00	NVDA	Stock	4.2205	4.2375	4.2098	4.236	112155960.0
2017-08-31 16:00:00	NVDA	Stock	4.236	4.2365	4.2315	4.2338	31032880.0
2017-08-31 17:00:00	NVDA	Stock	4.2362	4.2375	4.236	4.236	544040.0
2017-08-31 18:00:00	NVDA	Stock	4.236	4.2375	4.235	4.235	155800.0
2017-08-31 19:00:00	NVDA	Stock	4.234	4.2388	4.234	4.2373	299960.0
2017-08-31 04:00:00	AMZN	Stock	48.5245	48.5895	48.5245	48.5895	10200.0
2017-08-31 06:00:00	AMZN	Stock	48.6	48.6	48.4635	48.5	25060.0
2017-08-31 07:00:00	AMZN	Stock	48.525	48.575	48.5245	48.5515	83160.0

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

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