PREVIEW / stock_1hour / 2016-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-13.parquet
  size:    1.1 MB
  rows:    48,968
  symbols: 3,152

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
2016-12-13 04:00:00	AAPL	Stock	28.2825	28.3325	28.2825	28.3325	2040.0
2016-12-13 05:00:00	AAPL	Stock	28.355	28.4175	28.355	28.4175	5160.0
2016-12-13 06:00:00	AAPL	Stock	28.3775	28.3875	28.3775	28.3775	5680.0
2016-12-13 07:00:00	AAPL	Stock	28.3625	28.4375	28.3625	28.41	27240.0
2016-12-13 08:00:00	AAPL	Stock	28.435	28.4425	28.325	28.4125	226992.0
2016-12-13 09:00:00	AAPL	Stock	28.42	28.8075	28.42	28.7732	26741648.0
2016-12-13 10:00:00	AAPL	Stock	28.7742	28.8425	28.705	28.74	27702516.0
2016-12-13 11:00:00	AAPL	Stock	28.7412	28.9625	28.7225	28.9475	19224092.0
2016-12-13 12:00:00	AAPL	Stock	28.9475	28.9488	28.8575	28.9012	12837728.0
2016-12-13 13:00:00	AAPL	Stock	28.9025	28.98	28.8675	28.9138	12065276.0
2016-12-13 14:00:00	AAPL	Stock	28.9138	28.95	28.85	28.875	14326400.0
2016-12-13 15:00:00	AAPL	Stock	28.8775	28.955	28.765	28.7975	25748212.0
2016-12-13 16:00:00	AAPL	Stock	28.7975	28.8125	28.7675	28.8125	12529960.0
2016-12-13 17:00:00	AAPL	Stock	28.8125	28.815	28.7975	28.8	43124.0
2016-12-13 18:00:00	AAPL	Stock	28.8	28.825	28.8	28.8225	34708.0
2016-12-13 19:00:00	AAPL	Stock	28.8225	28.8275	28.8	28.82	47744.0
2016-12-13 07:00:00	MSFT	Stock	62.2	62.2	62.2	62.2	2035.0
2016-12-13 08:00:00	MSFT	Stock	62.3	62.41	62.25	62.3	11986.0
2016-12-13 09:00:00	MSFT	Stock	62.32	63.0	62.24	62.88	4274157.0
2016-12-13 10:00:00	MSFT	Stock	62.875	63.29	62.71	63.08	5110775.0
2016-12-13 11:00:00	MSFT	Stock	63.086	63.33	62.86	63.295	3344216.0
2016-12-13 12:00:00	MSFT	Stock	63.3	63.42	63.1	63.1	3733822.0
2016-12-13 13:00:00	MSFT	Stock	63.09	63.4	63.08	63.26	2574127.0
2016-12-13 14:00:00	MSFT	Stock	63.26	63.28	62.97	63.13	3192304.0
2016-12-13 15:00:00	MSFT	Stock	63.13	63.255	62.91	62.98	5872876.0
2016-12-13 16:00:00	MSFT	Stock	62.98	63.263	62.91	63.03	3465372.0
2016-12-13 17:00:00	MSFT	Stock	63.08	63.15	63.08	63.15	11730.0
2016-12-13 18:00:00	MSFT	Stock	63.15	63.15	62.98	62.98	65705.0
2016-12-13 19:00:00	MSFT	Stock	63.14	63.14	63.03	63.03	4141.0
2016-12-13 04:00:00	NVDA	Stock	2.2358	2.2358	2.2358	2.2358	12000.0
2016-12-13 08:00:00	NVDA	Stock	2.2435	2.2562	2.239	2.2555	476280.0
2016-12-13 09:00:00	NVDA	Stock	2.25	2.2898	2.25	2.2798	74136200.0
2016-12-13 10:00:00	NVDA	Stock	2.281	2.2998	2.2685	2.2695	84779120.0
2016-12-13 11:00:00	NVDA	Stock	2.2696	2.2918	2.2618	2.2898	47158120.0
2016-12-13 12:00:00	NVDA	Stock	2.29	2.2958	2.283	2.2922	29427600.0
2016-12-13 13:00:00	NVDA	Stock	2.2915	2.3073	2.2912	2.2995	33126920.0
2016-12-13 14:00:00	NVDA	Stock	2.3	2.3025	2.2875	2.2882	33319160.0
2016-12-13 15:00:00	NVDA	Stock	2.2885	2.2898	2.2755	2.2793	52564560.0
2016-12-13 16:00:00	NVDA	Stock	2.2793	2.2826	2.2788	2.28	6078480.0
2016-12-13 17:00:00	NVDA	Stock	2.2848	2.2848	2.2825	2.2848	155240.0
2016-12-13 18:00:00	NVDA	Stock	2.2835	2.2835	2.2825	2.2825	24280.0
2016-12-13 19:00:00	NVDA	Stock	2.2802	2.2848	2.2802	2.2838	38320.0
2016-12-13 07:00:00	AMZN	Stock	38.156	38.175	38.15	38.174	42100.0
2016-12-13 08:00:00	AMZN	Stock	38.15	38.2	38.1405	38.1985	160200.0
2016-12-13 09:00:00	AMZN	Stock	38.191	38.931	38.1	38.81	22051980.0
2016-12-13 10:00:00	AMZN	Stock	38.805	39.041	38.7385	38.9675	23218580.0
2016-12-13 11:00:00	AMZN	Stock	38.9755	39.108	38.8905	39.0792	11468500.0
2016-12-13 12:00:00	AMZN	Stock	39.0705	39.123	38.938	38.938	6818600.0
2016-12-13 13:00:00	AMZN	Stock	38.935	39.0475	38.9275	39.0345	6345160.0
2016-12-13 14:00:00	AMZN	Stock	39.0345	39.035	38.903	38.9225	7155520.0

> showing 50 of 48,968 rows — these rows as CSV

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