PREVIEW / stock_1hour / 2016-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-14.parquet
  size:    1.0 MB
  rows:    49,061
  symbols: 3,287

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
2016-07-14 04:00:00	AAPL	Stock	24.2425	24.3625	24.2425	24.35	7608.0
2016-07-14 05:00:00	AAPL	Stock	24.35	24.3625	24.34	24.3625	7456.0
2016-07-14 06:00:00	AAPL	Stock	24.3625	24.41	24.3625	24.375	12568.0
2016-07-14 07:00:00	AAPL	Stock	24.3925	24.3925	24.3425	24.3675	117412.0
2016-07-14 08:00:00	AAPL	Stock	24.375	24.375	24.31	24.345	249100.0
2016-07-14 09:00:00	AAPL	Stock	24.33	24.4475	24.3125	24.4225	19994060.0
2016-07-14 10:00:00	AAPL	Stock	24.4225	24.645	24.4175	24.5988	33914372.0
2016-07-14 11:00:00	AAPL	Stock	24.5975	24.6425	24.5875	24.603	15465968.0
2016-07-14 12:00:00	AAPL	Stock	24.605	24.655	24.5825	24.615	12328016.0
2016-07-14 13:00:00	AAPL	Stock	24.615	24.625	24.545	24.605	11180784.0
2016-07-14 14:00:00	AAPL	Stock	24.6075	24.72	24.5862	24.6938	18005884.0
2016-07-14 15:00:00	AAPL	Stock	24.6945	24.7475	24.685	24.6975	25320700.0
2016-07-14 16:00:00	AAPL	Stock	24.6975	24.7225	24.67	24.6975	7880096.0
2016-07-14 17:00:00	AAPL	Stock	24.6975	24.7025	24.675	24.6775	2122456.0
2016-07-14 18:00:00	AAPL	Stock	24.6825	24.6875	24.655	24.655	28400.0
2016-07-14 19:00:00	AAPL	Stock	24.655	24.6575	24.63	24.65	69676.0
2016-07-14 04:00:00	MSFT	Stock	53.76	53.9	53.76	53.9	1062.0
2016-07-14 05:00:00	MSFT	Stock	53.9	54.07	53.9	54.07	3338.0
2016-07-14 06:00:00	MSFT	Stock	54.14	54.14	54.14	54.14	100.0
2016-07-14 07:00:00	MSFT	Stock	53.91	54.04	53.89	54.04	5178.0
2016-07-14 08:00:00	MSFT	Stock	54.0	54.06	53.95	54.02	12822.0
2016-07-14 09:00:00	MSFT	Stock	54.02	54.07	53.58	53.76	3186798.0
2016-07-14 10:00:00	MSFT	Stock	53.77	53.99	53.72	53.895	2967084.0
2016-07-14 11:00:00	MSFT	Stock	53.9	53.96	53.74	53.755	2484143.0
2016-07-14 12:00:00	MSFT	Stock	53.75	53.81	53.7	53.76	2313192.0
2016-07-14 13:00:00	MSFT	Stock	53.76	53.77	53.66	53.705	1886634.0
2016-07-14 14:00:00	MSFT	Stock	53.71	53.765	53.67	53.75	2772584.0
2016-07-14 15:00:00	MSFT	Stock	53.746	53.83	53.695	53.73	4728367.0
2016-07-14 16:00:00	MSFT	Stock	53.74	53.76	53.71	53.76	2657743.0
2016-07-14 17:00:00	MSFT	Stock	53.74	53.74	53.7	53.71	73699.0
2016-07-14 18:00:00	MSFT	Stock	53.6	53.6	53.6	53.6	100.0
2016-07-14 19:00:00	MSFT	Stock	53.7	53.7	53.56	53.7	1800.0
2016-07-14 07:00:00	NVDA	Stock	1.3255	1.3278	1.3255	1.3278	16000.0
2016-07-14 08:00:00	NVDA	Stock	1.3283	1.3358	1.3283	1.3325	391600.0
2016-07-14 09:00:00	NVDA	Stock	1.3325	1.3348	1.3155	1.326	38881240.0
2016-07-14 10:00:00	NVDA	Stock	1.326	1.3368	1.326	1.3365	67009960.0
2016-07-14 11:00:00	NVDA	Stock	1.3363	1.345	1.3345	1.3438	45001960.0
2016-07-14 12:00:00	NVDA	Stock	1.3436	1.3448	1.3375	1.3379	25947000.0
2016-07-14 13:00:00	NVDA	Stock	1.3378	1.3385	1.334	1.3372	28868840.0
2016-07-14 14:00:00	NVDA	Stock	1.3372	1.34	1.3371	1.3378	24376360.0
2016-07-14 15:00:00	NVDA	Stock	1.3378	1.341	1.3328	1.333	46118360.0
2016-07-14 16:00:00	NVDA	Stock	1.333	1.3372	1.3325	1.3368	19166160.0
2016-07-14 17:00:00	NVDA	Stock	1.3368	1.3368	1.3345	1.3365	64000.0
2016-07-14 18:00:00	NVDA	Stock	1.3345	1.3345	1.3325	1.3328	120000.0
2016-07-14 19:00:00	NVDA	Stock	1.332	1.332	1.332	1.332	64400.0
2016-07-14 04:00:00	AMZN	Stock	37.3085	37.3085	37.3085	37.3085	2000.0
2016-07-14 05:00:00	AMZN	Stock	37.393	37.45	37.393	37.45	22000.0
2016-07-14 07:00:00	AMZN	Stock	37.3505	37.4445	37.295	37.4445	97500.0
2016-07-14 08:00:00	AMZN	Stock	37.3805	37.4225	37.205	37.395	119840.0
2016-07-14 09:00:00	AMZN	Stock	37.3975	37.455	37.2675	37.3	7924180.0

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

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