PREVIEW / stock_1hour / 2017-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-10.parquet
  size:    1.1 MB
  rows:    48,457
  symbols: 2,986

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-10 04:00:00	AAPL	Stock	40.065	40.065	39.9975	39.9975	8740.0
2017-08-10 05:00:00	AAPL	Stock	40.0	40.0	39.975	39.975	12488.0
2017-08-10 06:00:00	AAPL	Stock	39.9875	40.015	39.9525	39.955	59116.0
2017-08-10 07:00:00	AAPL	Stock	39.9625	40.025	39.9375	40.025	92144.0
2017-08-10 08:00:00	AAPL	Stock	40.005	40.1	39.9375	40.03	516308.0
2017-08-10 09:00:00	AAPL	Stock	40.05	40.0625	39.7025	39.7442	17270004.0
2017-08-10 10:00:00	AAPL	Stock	39.7475	39.825	39.5125	39.7775	18800280.0
2017-08-10 11:00:00	AAPL	Stock	39.7785	39.7785	39.3225	39.3725	17124556.0
2017-08-10 12:00:00	AAPL	Stock	39.3713	39.4775	39.105	39.2175	19457160.0
2017-08-10 13:00:00	AAPL	Stock	39.2175	39.3675	39.1475	39.2025	13682692.0
2017-08-10 14:00:00	AAPL	Stock	39.205	39.3625	39.1675	39.2375	10714852.0
2017-08-10 15:00:00	AAPL	Stock	39.2375	39.2775	38.6575	38.83	33621128.0
2017-08-10 16:00:00	AAPL	Stock	38.8275	39.08	38.7675	38.7875	6686624.0
2017-08-10 17:00:00	AAPL	Stock	38.7875	38.83	38.625	38.745	2161532.0
2017-08-10 18:00:00	AAPL	Stock	38.7375	38.83	38.6875	38.785	2334852.0
2017-08-10 19:00:00	AAPL	Stock	38.7875	38.805	38.5925	38.6625	155924.0
2017-08-10 08:00:00	MSFT	Stock	72.25	72.25	72.07	72.15	13248.0
2017-08-10 09:00:00	MSFT	Stock	72.1	72.15	71.76	71.815	2347157.0
2017-08-10 10:00:00	MSFT	Stock	71.82	72.1	71.56	72.05	2787511.0
2017-08-10 11:00:00	MSFT	Stock	72.05	72.16	71.73	71.8	1829624.0
2017-08-10 12:00:00	MSFT	Stock	71.795	71.93	71.605	71.855	2165090.0
2017-08-10 13:00:00	MSFT	Stock	71.85	72.005	71.81	71.905	1642065.0
2017-08-10 14:00:00	MSFT	Stock	71.91	72.19	71.82	71.97	2026974.0
2017-08-10 15:00:00	MSFT	Stock	71.97	72.04	71.35	71.42	6073300.0
2017-08-10 16:00:00	MSFT	Stock	71.41	71.48	71.2	71.27	2749601.0
2017-08-10 17:00:00	MSFT	Stock	71.25	71.41	71.01	71.41	599585.0
2017-08-10 18:00:00	MSFT	Stock	71.06	71.19	71.02	71.06	2804.0
2017-08-10 19:00:00	MSFT	Stock	71.15	71.25	71.14	71.2	3900.0
2017-08-10 04:00:00	NVDA	Stock	4.3048	4.3048	4.295	4.295	95400.0
2017-08-10 05:00:00	NVDA	Stock	4.2885	4.2885	4.28	4.28	12000.0
2017-08-10 06:00:00	NVDA	Stock	4.2872	4.3	4.2872	4.2925	115800.0
2017-08-10 07:00:00	NVDA	Stock	4.2938	4.3045	4.2862	4.301	746320.0
2017-08-10 08:00:00	NVDA	Stock	4.301	4.3188	4.2862	4.3052	3900640.0
2017-08-10 09:00:00	NVDA	Stock	4.3082	4.3165	4.2375	4.2465	118078480.0
2017-08-10 10:00:00	NVDA	Stock	4.2465	4.2548	4.1468	4.2002	228514080.0
2017-08-10 11:00:00	NVDA	Stock	4.2	4.2112	4.136	4.1455	139454160.0
2017-08-10 12:00:00	NVDA	Stock	4.1443	4.1731	4.12	4.1592	124065440.0
2017-08-10 13:00:00	NVDA	Stock	4.1598	4.2	4.1542	4.1944	93360360.0
2017-08-10 14:00:00	NVDA	Stock	4.1945	4.1946	4.1562	4.1828	75388280.0
2017-08-10 15:00:00	NVDA	Stock	4.1825	4.1878	4.1083	4.119	219300680.0
2017-08-10 16:00:00	NVDA	Stock	4.125	4.294	3.7865	3.9583	178299600.0
2017-08-10 17:00:00	NVDA	Stock	3.9542	3.9568	3.7888	3.7888	68388160.0
2017-08-10 18:00:00	NVDA	Stock	3.7932	4.1185	3.7875	3.8438	19826960.0
2017-08-10 19:00:00	NVDA	Stock	3.8438	3.8688	3.825	3.842	10006960.0
2017-08-10 05:00:00	AMZN	Stock	48.85	48.85	48.85	48.85	2000.0
2017-08-10 06:00:00	AMZN	Stock	48.824	48.824	48.8	48.8	16000.0
2017-08-10 07:00:00	AMZN	Stock	48.8685	48.8895	48.8125	48.8895	16000.0
2017-08-10 08:00:00	AMZN	Stock	48.889	49.1945	48.8125	48.8875	162780.0
2017-08-10 09:00:00	AMZN	Stock	48.85	48.993	48.4525	48.5365	17050560.0
2017-08-10 10:00:00	AMZN	Stock	48.5495	48.587	48.204	48.3615	15946580.0

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

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