PREVIEW / stock_1hour / 2017-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-06.parquet
  size:    1.0 MB
  rows:    47,709
  symbols: 2,993

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-07-06 05:00:00	AAPL	Stock	35.895	35.895	35.7625	35.8	16996.0
2017-07-06 06:00:00	AAPL	Stock	35.7925	35.81	35.7575	35.81	13176.0
2017-07-06 07:00:00	AAPL	Stock	35.81	35.81	35.7	35.7175	110356.0
2017-07-06 08:00:00	AAPL	Stock	35.7475	35.8225	35.7	35.7975	312836.0
2017-07-06 09:00:00	AAPL	Stock	35.7975	35.875	35.6575	35.6925	12632244.0
2017-07-06 10:00:00	AAPL	Stock	35.69	35.795	35.6025	35.66	15498360.0
2017-07-06 11:00:00	AAPL	Stock	35.6625	35.865	35.63	35.745	11547060.0
2017-07-06 12:00:00	AAPL	Stock	35.745	35.83	35.66	35.7925	7471400.0
2017-07-06 13:00:00	AAPL	Stock	35.7925	35.8062	35.6975	35.715	6671080.0
2017-07-06 14:00:00	AAPL	Stock	35.715	35.7375	35.645	35.7075	7513120.0
2017-07-06 15:00:00	AAPL	Stock	35.7088	35.735	35.63	35.68	15411388.0
2017-07-06 16:00:00	AAPL	Stock	35.6825	35.69	35.6125	35.6475	7938648.0
2017-07-06 17:00:00	AAPL	Stock	35.6275	35.6775	35.625	35.6775	29152.0
2017-07-06 18:00:00	AAPL	Stock	35.675	35.68	35.665	35.67	36052.0
2017-07-06 19:00:00	AAPL	Stock	35.665	35.675	35.6525	35.6625	22956.0
2017-07-06 06:00:00	MSFT	Stock	68.45	68.6	68.45	68.6	650.0
2017-07-06 07:00:00	MSFT	Stock	68.6	68.6	68.45	68.45	2643.0
2017-07-06 08:00:00	MSFT	Stock	68.59	68.59	68.26	68.52	24878.0
2017-07-06 09:00:00	MSFT	Stock	68.61	68.63	68.18	68.41	3036816.0
2017-07-06 10:00:00	MSFT	Stock	68.4	68.535	68.12	68.36	4015903.0
2017-07-06 11:00:00	MSFT	Stock	68.35	68.71	68.28	68.57	2247467.0
2017-07-06 12:00:00	MSFT	Stock	68.576	68.74	68.462	68.675	1484290.0
2017-07-06 13:00:00	MSFT	Stock	68.68	68.78	68.605	68.65	1657025.0
2017-07-06 14:00:00	MSFT	Stock	68.66	68.66	68.49	68.554	1761150.0
2017-07-06 15:00:00	MSFT	Stock	68.55	68.645	68.44	68.58	3798970.0
2017-07-06 16:00:00	MSFT	Stock	68.57	68.71	68.51	68.51	1747365.0
2017-07-06 17:00:00	MSFT	Stock	68.65	68.65	68.65	68.65	170.0
2017-07-06 18:00:00	MSFT	Stock	68.65	68.65	68.6	68.6	450.0
2017-07-06 19:00:00	MSFT	Stock	68.65	68.65	68.65	68.65	1089.0
2017-07-06 04:00:00	NVDA	Stock	3.5712	3.5712	3.5712	3.5712	18080.0
2017-07-06 05:00:00	NVDA	Stock	3.5625	3.5625	3.55	3.55	76400.0
2017-07-06 06:00:00	NVDA	Stock	3.5378	3.542	3.525	3.535	310440.0
2017-07-06 07:00:00	NVDA	Stock	3.535	3.55	3.5292	3.54	2027520.0
2017-07-06 08:00:00	NVDA	Stock	3.5405	3.5612	3.519	3.545	4798920.0
2017-07-06 09:00:00	NVDA	Stock	3.547	3.5562	3.494	3.5168	99850560.0
2017-07-06 10:00:00	NVDA	Stock	3.5156	3.5852	3.505	3.5742	155117720.0
2017-07-06 11:00:00	NVDA	Stock	3.575	3.6252	3.5612	3.612	137488680.0
2017-07-06 12:00:00	NVDA	Stock	3.612	3.6222	3.5888	3.6198	79133640.0
2017-07-06 13:00:00	NVDA	Stock	3.6205	3.6345	3.6112	3.6139	71648880.0
2017-07-06 14:00:00	NVDA	Stock	3.6148	3.616	3.5801	3.6012	56707600.0
2017-07-06 15:00:00	NVDA	Stock	3.6015	3.6038	3.5702	3.5873	86842000.0
2017-07-06 16:00:00	NVDA	Stock	3.5862	3.5913	3.5802	3.5895	19394400.0
2017-07-06 17:00:00	NVDA	Stock	3.5895	3.5938	3.587	3.5885	334640.0
2017-07-06 18:00:00	NVDA	Stock	3.5922	3.615	3.5922	3.61	606680.0
2017-07-06 19:00:00	NVDA	Stock	3.61	3.61	3.5878	3.61	547080.0
2017-07-06 06:00:00	AMZN	Stock	48.118	48.3	48.118	48.3	4400.0
2017-07-06 07:00:00	AMZN	Stock	48.3	48.3	48.075	48.075	69020.0
2017-07-06 08:00:00	AMZN	Stock	48.305	48.305	48.055	48.299	416340.0
2017-07-06 09:00:00	AMZN	Stock	48.3	48.334	48.013	48.1785	8037860.0
2017-07-06 10:00:00	AMZN	Stock	48.1785	48.232	47.951	48.123	8991260.0

> showing 50 of 47,709 rows — these rows as CSV

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