PREVIEW / stock_1hour / 2017-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-12.parquet
  size:    1.0 MB
  rows:    47,839
  symbols: 3,106

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-01-12 04:00:00	AAPL	Stock	29.9	29.9	29.825	29.8375	18668.0
2017-01-12 05:00:00	AAPL	Stock	29.815	29.82	29.7725	29.785	42160.0
2017-01-12 06:00:00	AAPL	Stock	29.77	29.815	29.7125	29.7275	135160.0
2017-01-12 07:00:00	AAPL	Stock	29.7475	29.785	29.6925	29.7	276640.0
2017-01-12 08:00:00	AAPL	Stock	29.7125	29.875	29.6925	29.77	547544.0
2017-01-12 09:00:00	AAPL	Stock	29.765	29.7975	29.66	29.71	21344100.0
2017-01-12 10:00:00	AAPL	Stock	29.7125	29.745	29.5825	29.5925	19550460.0
2017-01-12 11:00:00	AAPL	Stock	29.5925	29.6962	29.5525	29.6625	11901752.0
2017-01-12 12:00:00	AAPL	Stock	29.665	29.75	29.6525	29.735	8536228.0
2017-01-12 13:00:00	AAPL	Stock	29.7348	29.7775	29.7025	29.725	8177048.0
2017-01-12 14:00:00	AAPL	Stock	29.725	29.7575	29.7025	29.75	7539912.0
2017-01-12 15:00:00	AAPL	Stock	29.7518	29.825	29.6898	29.8125	15371160.0
2017-01-12 16:00:00	AAPL	Stock	29.8125	29.8125	29.78	29.805	7188160.0
2017-01-12 17:00:00	AAPL	Stock	29.7975	29.81	29.7825	29.79	98548.0
2017-01-12 18:00:00	AAPL	Stock	29.795	29.8125	29.795	29.795	17376.0
2017-01-12 19:00:00	AAPL	Stock	29.7875	29.8	29.7875	29.7975	11520.0
2017-01-12 07:00:00	MSFT	Stock	62.84	62.84	62.83	62.83	407.0
2017-01-12 08:00:00	MSFT	Stock	63.09	63.09	63.0	63.0	25200.0
2017-01-12 09:00:00	MSFT	Stock	63.0	63.4	62.17	62.3	3667267.0
2017-01-12 10:00:00	MSFT	Stock	62.31	62.33	61.955	62.0	4045478.0
2017-01-12 11:00:00	MSFT	Stock	62.0	62.15	61.95	62.05	2189058.0
2017-01-12 12:00:00	MSFT	Stock	62.055	62.41	62.04	62.35	1875624.0
2017-01-12 13:00:00	MSFT	Stock	62.35	62.49	62.32	62.441	1279730.0
2017-01-12 14:00:00	MSFT	Stock	62.449	62.5	62.364	62.47	1752751.0
2017-01-12 15:00:00	MSFT	Stock	62.465	62.68	62.425	62.61	3199843.0
2017-01-12 16:00:00	MSFT	Stock	62.61	62.65	62.57	62.61	1492984.0
2017-01-12 17:00:00	MSFT	Stock	62.53	62.61	62.53	62.54	66595.0
2017-01-12 18:00:00	MSFT	Stock	62.59	62.59	62.59	62.59	600.0
2017-01-12 19:00:00	MSFT	Stock	62.6	62.6	62.55	62.55	1382.0
2017-01-12 07:00:00	NVDA	Stock	2.6112	2.6112	2.611	2.6112	17160.0
2017-01-12 08:00:00	NVDA	Stock	2.612	2.6275	2.6062	2.615	1333600.0
2017-01-12 09:00:00	NVDA	Stock	2.615	2.6175	2.547	2.5642	121226280.0
2017-01-12 10:00:00	NVDA	Stock	2.5635	2.5742	2.5405	2.5559	134159800.0
2017-01-12 11:00:00	NVDA	Stock	2.557	2.5595	2.5455	2.556	90594800.0
2017-01-12 12:00:00	NVDA	Stock	2.5555	2.572	2.5535	2.5693	47116200.0
2017-01-12 13:00:00	NVDA	Stock	2.5695	2.585	2.5653	2.5759	44808400.0
2017-01-12 14:00:00	NVDA	Stock	2.5758	2.5792	2.56	2.578	61060040.0
2017-01-12 15:00:00	NVDA	Stock	2.5782	2.5888	2.5698	2.5862	81908680.0
2017-01-12 16:00:00	NVDA	Stock	2.586	2.586	2.5818	2.583	2275120.0
2017-01-12 17:00:00	NVDA	Stock	2.5845	2.5875	2.584	2.586	122080.0
2017-01-12 18:00:00	NVDA	Stock	2.5875	2.59	2.5875	2.5875	179240.0
2017-01-12 19:00:00	NVDA	Stock	2.5875	2.5922	2.5875	2.5922	217600.0
2017-01-12 06:00:00	AMZN	Stock	39.8735	39.8735	39.8735	39.8735	2000.0
2017-01-12 07:00:00	AMZN	Stock	39.8765	39.8995	39.875	39.875	38940.0
2017-01-12 08:00:00	AMZN	Stock	39.87	39.876	39.813	39.8625	58620.0
2017-01-12 09:00:00	AMZN	Stock	39.8735	40.4375	39.8575	40.2981	19037080.0
2017-01-12 10:00:00	AMZN	Stock	40.284	40.349	40.0	40.1167	14570100.0
2017-01-12 11:00:00	AMZN	Stock	40.1025	40.2398	40.025	40.204	8385880.0
2017-01-12 12:00:00	AMZN	Stock	40.207	40.341	40.1919	40.3245	6132840.0
2017-01-12 13:00:00	AMZN	Stock	40.325	40.595	40.3245	40.52	10189980.0

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

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