PREVIEW / stock_1hour / 2015-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-14.parquet
  size:    1.0 MB
  rows:    47,465
  symbols: 3,395

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-14 04:00:00	AAPL	Stock	27.9525	27.9525	27.8225	27.8225	800.0
2015-10-14 05:00:00	AAPL	Stock	27.8225	27.8225	27.8225	27.8225	400.0
2015-10-14 06:00:00	AAPL	Stock	27.825	27.8375	27.75	27.8125	210436.0
2015-10-14 07:00:00	AAPL	Stock	27.795	27.8	27.7025	27.765	280452.0
2015-10-14 08:00:00	AAPL	Stock	27.8425	27.8425	27.725	27.775	623788.0
2015-10-14 09:00:00	AAPL	Stock	27.7625	27.88	27.6925	27.695	21383828.0
2015-10-14 10:00:00	AAPL	Stock	27.6975	27.705	27.4375	27.555	40640868.0
2015-10-14 11:00:00	AAPL	Stock	27.555	27.595	27.475	27.5125	18557844.0
2015-10-14 12:00:00	AAPL	Stock	27.5125	27.6475	27.39	27.6225	21720364.0
2015-10-14 13:00:00	AAPL	Stock	27.6212	27.66	27.595	27.6162	11544444.0
2015-10-14 14:00:00	AAPL	Stock	27.6175	27.655	27.4475	27.495	17784240.0
2015-10-14 15:00:00	AAPL	Stock	27.495	27.6275	27.49	27.5525	25659204.0
2015-10-14 16:00:00	AAPL	Stock	27.5525	27.8542	27.4675	27.5375	6262220.0
2015-10-14 17:00:00	AAPL	Stock	27.5575	27.575	27.5375	27.56	73948.0
2015-10-14 18:00:00	AAPL	Stock	27.55	27.59	27.545	27.575	25564.0
2015-10-14 19:00:00	AAPL	Stock	27.575	27.6	27.5575	27.6	28720.0
2015-10-14 08:00:00	MSFT	Stock	46.88	46.9	46.82	46.85	4871.0
2015-10-14 09:00:00	MSFT	Stock	46.73	47.1	46.53	47.06	1931248.0
2015-10-14 10:00:00	MSFT	Stock	47.05	47.055	46.68	46.76	2956720.0
2015-10-14 11:00:00	MSFT	Stock	46.76	46.92	46.72	46.87	2568055.0
2015-10-14 12:00:00	MSFT	Stock	46.864	47.04	46.71	47.02	2128027.0
2015-10-14 13:00:00	MSFT	Stock	47.02	47.05	46.815	46.925	2026197.0
2015-10-14 14:00:00	MSFT	Stock	46.925	47.0	46.74	46.755	2505505.0
2015-10-14 15:00:00	MSFT	Stock	46.76	46.79	46.53	46.68	6923818.0
2015-10-14 16:00:00	MSFT	Stock	46.67	46.906	46.67	46.68	2692559.0
2015-10-14 17:00:00	MSFT	Stock	46.6	46.6	46.58	46.58	204.0
2015-10-14 18:00:00	MSFT	Stock	46.67	46.68	46.63	46.63	3712.0
2015-10-14 19:00:00	MSFT	Stock	46.68	46.68	46.68	46.68	450.0
2015-10-14 08:00:00	NVDA	Stock	0.6605	0.6605	0.6605	0.6605	68400.0
2015-10-14 09:00:00	NVDA	Stock	0.6605	0.6722	0.66	0.6704	40962400.0
2015-10-14 10:00:00	NVDA	Stock	0.6705	0.6734	0.667	0.671	81264960.0
2015-10-14 11:00:00	NVDA	Stock	0.6713	0.6836	0.6708	0.6835	76072200.0
2015-10-14 12:00:00	NVDA	Stock	0.6835	0.6946	0.6795	0.6922	93968160.0
2015-10-14 13:00:00	NVDA	Stock	0.6922	0.694	0.6808	0.681	90751440.0
2015-10-14 14:00:00	NVDA	Stock	0.6808	0.6832	0.678	0.6805	53030240.0
2015-10-14 15:00:00	NVDA	Stock	0.6805	0.6895	0.6798	0.6842	112728960.0
2015-10-14 16:00:00	NVDA	Stock	0.684	0.684	0.6686	0.6686	9559320.0
2015-10-14 17:00:00	NVDA	Stock	0.6825	0.6825	0.6825	0.6825	20000.0
2015-10-14 18:00:00	NVDA	Stock	0.6862	0.6862	0.6862	0.6862	20000.0
2015-10-14 07:00:00	AMZN	Stock	27.4165	27.425	27.4	27.425	20400.0
2015-10-14 08:00:00	AMZN	Stock	27.425	27.546	27.3925	27.4	271320.0
2015-10-14 09:00:00	AMZN	Stock	27.4345	27.6125	27.3838	27.4782	10897020.0
2015-10-14 10:00:00	AMZN	Stock	27.4855	27.4875	26.984	27.156	12373940.0
2015-10-14 11:00:00	AMZN	Stock	27.162	27.3658	27.1	27.319	6495080.0
2015-10-14 12:00:00	AMZN	Stock	27.3032	27.505	27.17	27.4635	5312000.0
2015-10-14 13:00:00	AMZN	Stock	27.475	27.4805	27.344	27.4261	5642720.0
2015-10-14 14:00:00	AMZN	Stock	27.439	27.495	27.228	27.2485	6105720.0
2015-10-14 15:00:00	AMZN	Stock	27.24	27.3475	27.175	27.241	11762400.0
2015-10-14 16:00:00	AMZN	Stock	27.2415	27.5165	26.9	27.0505	2934640.0
2015-10-14 17:00:00	AMZN	Stock	27.0625	27.199	27.028	27.199	136040.0

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

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