PREVIEW / stock_1hour / 2015-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-27.parquet
  size:    1.0 MB
  rows:    48,659
  symbols: 3,428

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
2015-10-27 04:00:00	AAPL	Stock	28.7975	28.81	28.6075	28.6075	19724.0
2015-10-27 05:00:00	AAPL	Stock	28.65	28.725	28.61	28.725	3596.0
2015-10-27 06:00:00	AAPL	Stock	28.735	28.82	28.7125	28.8175	32824.0
2015-10-27 07:00:00	AAPL	Stock	28.8225	28.9875	28.75	28.9875	205384.0
2015-10-27 08:00:00	AAPL	Stock	28.98	28.99	28.72	28.8875	1169220.0
2015-10-27 09:00:00	AAPL	Stock	28.8925	29.07	28.7	29.0232	29391492.0
2015-10-27 10:00:00	AAPL	Stock	29.0225	29.135	28.9025	29.05	30088760.0
2015-10-27 11:00:00	AAPL	Stock	29.05	29.125	28.8375	28.92	24578200.0
2015-10-27 12:00:00	AAPL	Stock	28.9175	28.94	28.685	28.8125	24928544.0
2015-10-27 13:00:00	AAPL	Stock	28.815	28.9325	28.7652	28.7775	21582544.0
2015-10-27 14:00:00	AAPL	Stock	28.775	28.8275	28.725	28.7295	18729092.0
2015-10-27 15:00:00	AAPL	Stock	28.7278	28.7725	28.4975	28.645	56096360.0
2015-10-27 16:00:00	AAPL	Stock	28.6375	29.5825	27.7025	29.1525	36181160.0
2015-10-27 17:00:00	AAPL	Stock	29.145	29.2125	28.455	28.585	12027172.0
2015-10-27 18:00:00	AAPL	Stock	28.5825	28.755	28.5175	28.745	1748620.0
2015-10-27 19:00:00	AAPL	Stock	28.74	28.8375	28.7	28.8125	795056.0
2015-10-27 04:00:00	MSFT	Stock	54.0	54.0	53.95	53.95	2096.0
2015-10-27 05:00:00	MSFT	Stock	53.97	53.97	53.85	53.92	101746.0
2015-10-27 06:00:00	MSFT	Stock	53.94	53.99	53.91	53.98	5490.0
2015-10-27 07:00:00	MSFT	Stock	53.96	54.04	53.92	54.03	10503.0
2015-10-27 08:00:00	MSFT	Stock	53.99	54.08	53.87	53.93	39037.0
2015-10-27 09:00:00	MSFT	Stock	53.93	54.23	53.81	54.01	7194596.0
2015-10-27 10:00:00	MSFT	Stock	54.01	54.08	53.91	54.07	6731814.0
2015-10-27 11:00:00	MSFT	Stock	54.065	54.37	53.975	54.005	6690884.0
2015-10-27 12:00:00	MSFT	Stock	54.0	54.14	53.91	54.011	5089263.0
2015-10-27 13:00:00	MSFT	Stock	54.015	54.07	53.8	53.85	5583165.0
2015-10-27 14:00:00	MSFT	Stock	53.85	53.96	53.58	53.765	4690291.0
2015-10-27 15:00:00	MSFT	Stock	53.76	53.93	53.64	53.7	7552118.0
2015-10-27 16:00:00	MSFT	Stock	53.69	53.88	53.62	53.7	3160808.0
2015-10-27 17:00:00	MSFT	Stock	53.72	53.75	53.6	53.61	11165.0
2015-10-27 18:00:00	MSFT	Stock	53.68	53.68	53.61	53.65	2800.0
2015-10-27 19:00:00	MSFT	Stock	53.67	53.68	53.61	53.62	5670.0
2015-10-27 08:00:00	NVDA	Stock	0.7125	0.7125	0.7125	0.7125	24000.0
2015-10-27 09:00:00	NVDA	Stock	0.7068	0.7135	0.7068	0.7113	20248560.0
2015-10-27 10:00:00	NVDA	Stock	0.7114	0.714	0.7083	0.7106	25830280.0
2015-10-27 11:00:00	NVDA	Stock	0.7106	0.7141	0.7103	0.7121	20142760.0
2015-10-27 12:00:00	NVDA	Stock	0.7123	0.7154	0.7105	0.7135	16375600.0
2015-10-27 13:00:00	NVDA	Stock	0.7135	0.714	0.7108	0.7109	16233560.0
2015-10-27 14:00:00	NVDA	Stock	0.7108	0.7124	0.7091	0.7099	16898320.0
2015-10-27 15:00:00	NVDA	Stock	0.7098	0.7115	0.7091	0.711	36867200.0
2015-10-27 16:00:00	NVDA	Stock	0.711	0.7235	0.711	0.7235	38951640.0
2015-10-27 07:00:00	AMZN	Stock	30.3755	30.496	30.3755	30.467	17440.0
2015-10-27 08:00:00	AMZN	Stock	30.497	30.575	30.3	30.425	280960.0
2015-10-27 09:00:00	AMZN	Stock	30.4305	30.584	30.2765	30.5655	12492640.0
2015-10-27 10:00:00	AMZN	Stock	30.544	30.6	30.3935	30.5655	12010380.0
2015-10-27 11:00:00	AMZN	Stock	30.564	30.7225	30.501	30.5835	9842160.0
2015-10-27 12:00:00	AMZN	Stock	30.5995	30.6635	30.559	30.6515	6819740.0
2015-10-27 13:00:00	AMZN	Stock	30.652	30.7055	30.58	30.61	5898980.0
2015-10-27 14:00:00	AMZN	Stock	30.6175	30.7355	30.601	30.655	6972040.0
2015-10-27 15:00:00	AMZN	Stock	30.662	30.7125	30.52	30.5235	15340540.0

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

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