PREVIEW / stock_1hour / 2017-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-24.parquet
  size:    1.0 MB
  rows:    47,992
  symbols: 3,108

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-24 04:00:00	AAPL	Stock	29.875	29.875	29.77	29.78	50296.0
2017-01-24 05:00:00	AAPL	Stock	29.8	29.8	29.7275	29.75	28620.0
2017-01-24 06:00:00	AAPL	Stock	29.7825	29.815	29.75	29.8	89712.0
2017-01-24 07:00:00	AAPL	Stock	29.8275	29.875	29.8125	29.8425	175328.0
2017-01-24 08:00:00	AAPL	Stock	29.825	29.95	29.825	29.86	306372.0
2017-01-24 09:00:00	AAPL	Stock	29.8625	30.025	29.8375	29.9962	15504652.0
2017-01-24 10:00:00	AAPL	Stock	29.9988	30.0075	29.9675	29.9838	13523320.0
2017-01-24 11:00:00	AAPL	Stock	29.9825	30.025	29.9825	29.995	8302896.0
2017-01-24 12:00:00	AAPL	Stock	29.9938	30.02	29.9675	29.99	7104780.0
2017-01-24 13:00:00	AAPL	Stock	29.99	30.025	29.985	30.0012	8579064.0
2017-01-24 14:00:00	AAPL	Stock	30.001	30.0212	29.9875	30.0025	9446664.0
2017-01-24 15:00:00	AAPL	Stock	30.0048	30.02	29.975	29.9925	15941192.0
2017-01-24 16:00:00	AAPL	Stock	30.0025	30.0075	29.9775	30.0075	6150676.0
2017-01-24 17:00:00	AAPL	Stock	30.0075	30.0075	29.9975	29.9975	25108.0
2017-01-24 18:00:00	AAPL	Stock	29.995	30.0	29.995	29.995	20336.0
2017-01-24 19:00:00	AAPL	Stock	29.985	29.9975	29.985	29.995	10336.0
2017-01-24 06:00:00	MSFT	Stock	63.15	63.15	63.15	63.15	318.0
2017-01-24 07:00:00	MSFT	Stock	63.1	63.12	63.08	63.12	1582.0
2017-01-24 08:00:00	MSFT	Stock	63.1	63.15	63.1	63.12	5846.0
2017-01-24 09:00:00	MSFT	Stock	63.14	63.28	62.94	63.03	3412201.0
2017-01-24 10:00:00	MSFT	Stock	63.02	63.138	63.01	63.079	2368498.0
2017-01-24 11:00:00	MSFT	Stock	63.075	63.22	63.04	63.11	1980566.0
2017-01-24 12:00:00	MSFT	Stock	63.115	63.205	63.09	63.157	1736531.0
2017-01-24 13:00:00	MSFT	Stock	63.155	63.44	63.14	63.41	2739105.0
2017-01-24 14:00:00	MSFT	Stock	63.414	63.59	63.38	63.59	2859388.0
2017-01-24 15:00:00	MSFT	Stock	63.59	63.735	63.48	63.52	5021810.0
2017-01-24 16:00:00	MSFT	Stock	63.515	63.54	63.42	63.53	2192456.0
2017-01-24 17:00:00	MSFT	Stock	63.53	63.6	63.53	63.6	10250.0
2017-01-24 18:00:00	MSFT	Stock	63.65	63.71	63.62	63.65	1264.0
2017-01-24 19:00:00	MSFT	Stock	63.72	63.76	63.71	63.75	2175.0
2017-01-24 07:00:00	NVDA	Stock	2.6425	2.6425	2.6325	2.6325	18360.0
2017-01-24 08:00:00	NVDA	Stock	2.641	2.641	2.6375	2.638	219960.0
2017-01-24 09:00:00	NVDA	Stock	2.6438	2.661	2.6272	2.641	71452600.0
2017-01-24 10:00:00	NVDA	Stock	2.6418	2.6498	2.631	2.6405	43717960.0
2017-01-24 11:00:00	NVDA	Stock	2.64	2.64	2.6225	2.6325	46953680.0
2017-01-24 12:00:00	NVDA	Stock	2.633	2.6344	2.6253	2.6258	25322840.0
2017-01-24 13:00:00	NVDA	Stock	2.6258	2.6663	2.6258	2.6642	58992920.0
2017-01-24 14:00:00	NVDA	Stock	2.665	2.6895	2.6623	2.6873	72864240.0
2017-01-24 15:00:00	NVDA	Stock	2.6878	2.688	2.6762	2.6828	79465440.0
2017-01-24 16:00:00	NVDA	Stock	2.685	2.6863	2.655	2.6832	4622320.0
2017-01-24 17:00:00	NVDA	Stock	2.684	2.6998	2.684	2.6925	761760.0
2017-01-24 18:00:00	NVDA	Stock	2.6912	2.6988	2.6912	2.6925	559680.0
2017-01-24 19:00:00	NVDA	Stock	2.6925	2.6988	2.6925	2.6988	289200.0
2017-01-24 07:00:00	AMZN	Stock	40.991	41.05	40.991	40.999	28000.0
2017-01-24 08:00:00	AMZN	Stock	40.985	41.05	40.975	41.0	116340.0
2017-01-24 09:00:00	AMZN	Stock	41.0055	41.1435	40.7725	40.8278	12289100.0
2017-01-24 10:00:00	AMZN	Stock	40.8165	40.9	40.725	40.8773	8533520.0
2017-01-24 11:00:00	AMZN	Stock	40.8768	40.962	40.8571	40.9005	6026500.0
2017-01-24 12:00:00	AMZN	Stock	40.902	40.923	40.8546	40.904	2531960.0
2017-01-24 13:00:00	AMZN	Stock	40.904	41.0975	40.8994	41.05	5034520.0

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

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