PREVIEW / stock_1hour / 2016-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-18.parquet
  size:    1.0 MB
  rows:    48,540
  symbols: 3,177

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-11-18 04:00:00	AAPL	Stock	27.385	27.385	27.2825	27.2825	4084.0
2016-11-18 05:00:00	AAPL	Stock	27.325	27.3475	27.325	27.3475	3748.0
2016-11-18 06:00:00	AAPL	Stock	27.35	27.35	27.3375	27.3375	2000.0
2016-11-18 07:00:00	AAPL	Stock	27.3575	27.4225	27.3575	27.4225	35508.0
2016-11-18 08:00:00	AAPL	Stock	27.3875	27.5	27.3875	27.5	148432.0
2016-11-18 09:00:00	AAPL	Stock	27.4975	27.635	27.4125	27.5425	22340484.0
2016-11-18 10:00:00	AAPL	Stock	27.5425	27.5625	27.415	27.4725	14354872.0
2016-11-18 11:00:00	AAPL	Stock	27.4725	27.545	27.45	27.4725	10909268.0
2016-11-18 12:00:00	AAPL	Stock	27.4725	27.5475	27.465	27.5475	7271496.0
2016-11-18 13:00:00	AAPL	Stock	27.5475	27.555	27.465	27.47	8269000.0
2016-11-18 14:00:00	AAPL	Stock	27.47	27.4875	27.4275	27.435	8019964.0
2016-11-18 15:00:00	AAPL	Stock	27.4375	27.53	27.4355	27.515	16266196.0
2016-11-18 16:00:00	AAPL	Stock	27.515	27.5175	27.468	27.51	8765196.0
2016-11-18 17:00:00	AAPL	Stock	27.5125	27.525	27.5	27.5075	182180.0
2016-11-18 18:00:00	AAPL	Stock	27.5075	27.5075	27.475	27.5	109532.0
2016-11-18 19:00:00	AAPL	Stock	27.5	27.75	27.4975	27.5675	190800.0
2016-11-18 08:00:00	MSFT	Stock	60.78	60.94	60.78	60.9	13927.0
2016-11-18 09:00:00	MSFT	Stock	60.81	61.14	60.7	60.799	5670083.0
2016-11-18 10:00:00	MSFT	Stock	60.795	60.8	60.32	60.42	4750626.0
2016-11-18 11:00:00	MSFT	Stock	60.41	60.555	60.32	60.45	2417720.0
2016-11-18 12:00:00	MSFT	Stock	60.45	60.52	60.39	60.515	1515667.0
2016-11-18 13:00:00	MSFT	Stock	60.51	60.57	60.495	60.505	1397919.0
2016-11-18 14:00:00	MSFT	Stock	60.51	60.6	60.47	60.55	1480975.0
2016-11-18 15:00:00	MSFT	Stock	60.55	60.575	60.3	60.37	4543938.0
2016-11-18 16:00:00	MSFT	Stock	60.35	60.495	60.29	60.4	1946661.0
2016-11-18 17:00:00	MSFT	Stock	60.3	60.35	60.3	60.35	269503.0
2016-11-18 18:00:00	MSFT	Stock	60.37	60.37	60.3	60.32	197841.0
2016-11-18 19:00:00	MSFT	Stock	60.4	60.4	60.4	60.4	400.0
2016-11-18 04:00:00	NVDA	Stock	2.305	2.305	2.305	2.305	11720.0
2016-11-18 06:00:00	NVDA	Stock	2.3148	2.315	2.3148	2.315	20000.0
2016-11-18 07:00:00	NVDA	Stock	2.3102	2.3108	2.31	2.31	29200.0
2016-11-18 08:00:00	NVDA	Stock	2.3125	2.3235	2.31	2.3162	640280.0
2016-11-18 09:00:00	NVDA	Stock	2.3118	2.3582	2.3052	2.3334	103303480.0
2016-11-18 10:00:00	NVDA	Stock	2.3328	2.3364	2.297	2.3042	122468600.0
2016-11-18 11:00:00	NVDA	Stock	2.3045	2.3328	2.295	2.3325	91826680.0
2016-11-18 12:00:00	NVDA	Stock	2.3325	2.3405	2.3265	2.3324	58289920.0
2016-11-18 13:00:00	NVDA	Stock	2.3322	2.3382	2.3282	2.333	28852640.0
2016-11-18 14:00:00	NVDA	Stock	2.333	2.3375	2.3292	2.3362	37372440.0
2016-11-18 15:00:00	NVDA	Stock	2.3365	2.346	2.3273	2.334	94106080.0
2016-11-18 16:00:00	NVDA	Stock	2.3337	2.3368	2.3325	2.3343	14983080.0
2016-11-18 17:00:00	NVDA	Stock	2.335	2.335	2.3325	2.3325	141720.0
2016-11-18 18:00:00	NVDA	Stock	2.334	2.335	2.3325	2.335	274920.0
2016-11-18 19:00:00	NVDA	Stock	2.335	2.3375	2.334	2.3372	210200.0
2016-11-18 04:00:00	AMZN	Stock	37.809	37.8215	37.809	37.8215	9000.0
2016-11-18 06:00:00	AMZN	Stock	37.979	37.979	37.979	37.979	2600.0
2016-11-18 07:00:00	AMZN	Stock	38.05	38.1535	38.05	38.0875	104860.0
2016-11-18 08:00:00	AMZN	Stock	38.11	38.15	38.009	38.06	504900.0
2016-11-18 09:00:00	AMZN	Stock	38.0745	38.387	38.013	38.14	21267340.0
2016-11-18 10:00:00	AMZN	Stock	38.14	38.2262	37.8822	37.964	15980220.0
2016-11-18 11:00:00	AMZN	Stock	37.9478	38.0715	37.9015	38.0562	9045220.0

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

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