PREVIEW / stock_1hour / 2018-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-31.parquet
  size:    1.1 MB
  rows:    49,116
  symbols: 2,830

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
2018-05-31 04:00:00	AAPL	Stock	46.975	46.975	46.975	46.975	20212.0
2018-05-31 05:00:00	AAPL	Stock	46.975	46.975	46.95	46.95	16172.0
2018-05-31 06:00:00	AAPL	Stock	46.95	46.95	46.925	46.925	25744.0
2018-05-31 07:00:00	AAPL	Stock	46.93	46.975	46.925	46.975	67596.0
2018-05-31 08:00:00	AAPL	Stock	46.95	46.98	46.925	46.9375	79996.0
2018-05-31 09:00:00	AAPL	Stock	46.9375	46.9625	46.75	46.83	8934224.0
2018-05-31 10:00:00	AAPL	Stock	46.8325	46.8625	46.535	46.6475	11069644.0
2018-05-31 11:00:00	AAPL	Stock	46.6475	47.0575	46.6225	46.9625	12099684.0
2018-05-31 12:00:00	AAPL	Stock	46.9625	46.9675	46.8325	46.91	6589472.0
2018-05-31 13:00:00	AAPL	Stock	46.91	46.9175	46.7125	46.725	5958424.0
2018-05-31 14:00:00	AAPL	Stock	46.7232	46.82	46.625	46.8175	7560536.0
2018-05-31 15:00:00	AAPL	Stock	46.815	46.865	46.67	46.72	14414184.0
2018-05-31 16:00:00	AAPL	Stock	46.72	46.756	46.6875	46.71	27233172.0
2018-05-31 17:00:00	AAPL	Stock	46.7175	46.735	46.7025	46.705	30236.0
2018-05-31 18:00:00	AAPL	Stock	46.7325	46.7325	46.7175	46.73	5160.0
2018-05-31 19:00:00	AAPL	Stock	46.73	46.7425	46.7175	46.7425	22524.0
2018-05-31 04:00:00	MSFT	Stock	99.19	99.2	99.19	99.19	699.0
2018-05-31 06:00:00	MSFT	Stock	99.18	99.19	99.18	99.19	1900.0
2018-05-31 07:00:00	MSFT	Stock	99.0	99.0	99.0	99.0	2736.0
2018-05-31 08:00:00	MSFT	Stock	99.0	99.14	98.91	99.07	22023.0
2018-05-31 09:00:00	MSFT	Stock	99.03	99.559	98.78	99.4	2689011.0
2018-05-31 10:00:00	MSFT	Stock	99.41	99.52	98.73	98.905	2832440.0
2018-05-31 11:00:00	MSFT	Stock	98.9	99.99	98.82	99.78	3191567.0
2018-05-31 12:00:00	MSFT	Stock	99.78	99.9	99.59	99.855	1601928.0
2018-05-31 13:00:00	MSFT	Stock	99.86	99.863	99.26	99.3	1477067.0
2018-05-31 14:00:00	MSFT	Stock	99.31	99.32	98.945	99.03	2168364.0
2018-05-31 15:00:00	MSFT	Stock	99.03	99.12	98.61	98.86	5663227.0
2018-05-31 16:00:00	MSFT	Stock	98.84	98.97	98.48	98.65	8998165.0
2018-05-31 17:00:00	MSFT	Stock	98.62	98.62	98.48	98.58	10692.0
2018-05-31 18:00:00	MSFT	Stock	98.58	98.58	98.5	98.5	1183.0
2018-05-31 19:00:00	MSFT	Stock	98.57	98.58	98.5	98.58	7614.0
2018-05-31 06:00:00	NVDA	Stock	6.3242	6.3242	6.3242	6.3242	20000.0
2018-05-31 07:00:00	NVDA	Stock	6.3345	6.3345	6.3013	6.3098	262640.0
2018-05-31 08:00:00	NVDA	Stock	6.3242	6.3388	6.3014	6.3203	666880.0
2018-05-31 09:00:00	NVDA	Stock	6.3175	6.3595	6.2818	6.3573	59003600.0
2018-05-31 10:00:00	NVDA	Stock	6.3595	6.375	6.3195	6.3375	78621200.0
2018-05-31 11:00:00	NVDA	Stock	6.3375	6.3763	6.3303	6.3655	43483160.0
2018-05-31 12:00:00	NVDA	Stock	6.365	6.3792	6.3525	6.3772	36522600.0
2018-05-31 13:00:00	NVDA	Stock	6.3768	6.38	6.3523	6.3548	32431680.0
2018-05-31 14:00:00	NVDA	Stock	6.3554	6.365	6.3338	6.3435	31669920.0
2018-05-31 15:00:00	NVDA	Stock	6.3418	6.3467	6.3025	6.3055	63079040.0
2018-05-31 16:00:00	NVDA	Stock	6.3055	6.3228	6.3048	6.315	70120000.0
2018-05-31 17:00:00	NVDA	Stock	6.3112	6.3188	6.311	6.3125	257440.0
2018-05-31 18:00:00	NVDA	Stock	6.3185	6.3185	6.313	6.313	21320.0
2018-05-31 19:00:00	NVDA	Stock	6.3175	6.3325	6.3162	6.3162	380040.0
2018-05-31 04:00:00	AMZN	Stock	81.45	81.4645	81.45	81.4645	6180.0
2018-05-31 07:00:00	AMZN	Stock	81.35	81.35	81.172	81.223	37640.0
2018-05-31 08:00:00	AMZN	Stock	81.225	81.321	81.2005	81.318	127500.0
2018-05-31 09:00:00	AMZN	Stock	81.25	81.5885	81.0675	81.443	10925220.0
2018-05-31 10:00:00	AMZN	Stock	81.4315	81.4635	81.109	81.328	6534980.0

> showing 50 of 49,116 rows — these rows as CSV

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