PREVIEW / stock_1hour / 2017-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-25.parquet
  size:    1.1 MB
  rows:    48,361
  symbols: 2,970

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-09-25 04:00:00	AAPL	Stock	37.7475	37.785	37.7025	37.75	3800.0
2017-09-25 05:00:00	AAPL	Stock	37.8	37.8	37.725	37.75	6536.0
2017-09-25 06:00:00	AAPL	Stock	37.725	37.725	37.4125	37.6525	91280.0
2017-09-25 07:00:00	AAPL	Stock	37.6725	37.78	37.63	37.6425	227544.0
2017-09-25 08:00:00	AAPL	Stock	37.5	38.05	37.4775	37.4925	1269540.0
2017-09-25 09:00:00	AAPL	Stock	37.4925	37.8125	37.29	37.785	41034664.0
2017-09-25 10:00:00	AAPL	Stock	37.785	37.9575	37.475	37.5135	29489556.0
2017-09-25 11:00:00	AAPL	Stock	37.5175	37.645	37.4225	37.62	18692988.0
2017-09-25 12:00:00	AAPL	Stock	37.62	37.7235	37.4805	37.6925	15784512.0
2017-09-25 13:00:00	AAPL	Stock	37.6925	37.71	37.615	37.6625	9676532.0
2017-09-25 14:00:00	AAPL	Stock	37.665	37.705	37.49	37.565	12019044.0
2017-09-25 15:00:00	AAPL	Stock	37.5675	37.6475	37.5	37.64	21476068.0
2017-09-25 16:00:00	AAPL	Stock	37.6325	37.7025	37.6275	37.685	10300656.0
2017-09-25 17:00:00	AAPL	Stock	37.685	37.7	37.6375	37.6875	244112.0
2017-09-25 18:00:00	AAPL	Stock	37.6525	37.675	37.6525	37.675	19372.0
2017-09-25 19:00:00	AAPL	Stock	37.6625	37.675	37.6375	37.6425	39736.0
2017-09-25 07:00:00	MSFT	Stock	74.21	74.21	74.21	74.21	420.0
2017-09-25 08:00:00	MSFT	Stock	74.35	74.35	74.14	74.25	494.0
2017-09-25 09:00:00	MSFT	Stock	74.14	74.25	73.82	73.86	1554807.0
2017-09-25 10:00:00	MSFT	Stock	73.86	74.0	73.1	73.17	2805087.0
2017-09-25 11:00:00	MSFT	Stock	73.17	73.43	73.04	73.11	2610744.0
2017-09-25 12:00:00	MSFT	Stock	73.105	73.13	72.92	73.033	2011255.0
2017-09-25 13:00:00	MSFT	Stock	73.03	73.15	72.93	73.125	1591995.0
2017-09-25 14:00:00	MSFT	Stock	73.125	73.17	72.92	73.025	1902380.0
2017-09-25 15:00:00	MSFT	Stock	73.03	73.32	72.93	73.27	4869607.0
2017-09-25 16:00:00	MSFT	Stock	73.26	73.45	73.23	73.3	4804976.0
2017-09-25 17:00:00	MSFT	Stock	73.34	73.59	73.31	73.31	14343.0
2017-09-25 18:00:00	MSFT	Stock	73.51	73.51	73.33	73.33	1607.0
2017-09-25 19:00:00	MSFT	Stock	73.31	73.31	73.31	73.31	130.0
2017-09-25 04:00:00	NVDA	Stock	4.4635	4.475	4.4635	4.475	12000.0
2017-09-25 05:00:00	NVDA	Stock	4.4773	4.4835	4.4773	4.4835	47200.0
2017-09-25 06:00:00	NVDA	Stock	4.4748	4.4748	4.4665	4.4665	29480.0
2017-09-25 07:00:00	NVDA	Stock	4.481	4.481	4.455	4.4625	395120.0
2017-09-25 08:00:00	NVDA	Stock	4.4565	4.475	4.4438	4.4487	2728400.0
2017-09-25 09:00:00	NVDA	Stock	4.4487	4.4575	4.3402	4.3502	147353280.0
2017-09-25 10:00:00	NVDA	Stock	4.3523	4.3915	4.304	4.3118	162912120.0
2017-09-25 11:00:00	NVDA	Stock	4.3102	4.3413	4.294	4.3112	108917360.0
2017-09-25 12:00:00	NVDA	Stock	4.3118	4.323	4.2765	4.3154	88015840.0
2017-09-25 13:00:00	NVDA	Stock	4.316	4.3225	4.2925	4.294	55873160.0
2017-09-25 14:00:00	NVDA	Stock	4.2951	4.3013	4.254	4.2773	87137920.0
2017-09-25 15:00:00	NVDA	Stock	4.2778	4.2848	4.2595	4.2738	126220200.0
2017-09-25 16:00:00	NVDA	Stock	4.2748	4.282	4.2705	4.2775	37971880.0
2017-09-25 17:00:00	NVDA	Stock	4.2798	4.2925	4.2768	4.29	632120.0
2017-09-25 18:00:00	NVDA	Stock	4.2908	4.295	4.2828	4.2862	736920.0
2017-09-25 19:00:00	NVDA	Stock	4.2875	4.3	4.285	4.2922	572920.0
2017-09-25 04:00:00	AMZN	Stock	47.7	47.7	47.7	47.7	2000.0
2017-09-25 07:00:00	AMZN	Stock	47.75	47.75	47.65	47.675	26860.0
2017-09-25 08:00:00	AMZN	Stock	47.69	47.69	47.19	47.275	1000340.0
2017-09-25 09:00:00	AMZN	Stock	47.2755	47.495	47.0315	47.1918	18613900.0
2017-09-25 10:00:00	AMZN	Stock	47.193	47.425	47.019	47.0395	10899320.0

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

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