PREVIEW / stock_1hour / 2016-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-21.parquet
  size:    1.0 MB
  rows:    48,408
  symbols: 3,249

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-21 05:00:00	AAPL	Stock	25.0	25.0	25.0	25.0	1056.0
2016-07-21 06:00:00	AAPL	Stock	25.07	25.07	25.0225	25.0225	8256.0
2016-07-21 07:00:00	AAPL	Stock	25.05	25.05	25.025	25.03	28404.0
2016-07-21 08:00:00	AAPL	Stock	25.0125	25.0575	25.0125	25.0325	186592.0
2016-07-21 09:00:00	AAPL	Stock	25.035	25.25	24.955	25.1688	24358484.0
2016-07-21 10:00:00	AAPL	Stock	25.17	25.21	25.0125	25.02	19829076.0
2016-07-21 11:00:00	AAPL	Stock	25.018	25.06	24.9275	24.9575	12288300.0
2016-07-21 12:00:00	AAPL	Stock	24.955	24.9675	24.85	24.885	12786900.0
2016-07-21 13:00:00	AAPL	Stock	24.885	24.935	24.865	24.8925	8823028.0
2016-07-21 14:00:00	AAPL	Stock	24.8912	24.9025	24.8425	24.8475	9532756.0
2016-07-21 15:00:00	AAPL	Stock	24.8475	24.875	24.7825	24.855	19547624.0
2016-07-21 16:00:00	AAPL	Stock	24.8575	24.9015	24.75	24.79	9461472.0
2016-07-21 17:00:00	AAPL	Stock	24.7925	24.795	24.7175	24.7375	325928.0
2016-07-21 18:00:00	AAPL	Stock	24.7275	24.785	24.7275	24.7625	51008.0
2016-07-21 19:00:00	AAPL	Stock	24.775	24.7875	24.75	24.7725	68736.0
2016-07-21 04:00:00	MSFT	Stock	56.2	56.2	56.06	56.06	1100.0
2016-07-21 07:00:00	MSFT	Stock	56.05	56.15	55.99	56.12	13624.0
2016-07-21 08:00:00	MSFT	Stock	56.09	56.12	55.8	55.96	40957.0
2016-07-21 09:00:00	MSFT	Stock	55.92	56.23	55.77	55.85	4829818.0
2016-07-21 10:00:00	MSFT	Stock	55.82	56.2	55.76	56.064	4528197.0
2016-07-21 11:00:00	MSFT	Stock	56.07	56.09	55.875	56.01	3166155.0
2016-07-21 12:00:00	MSFT	Stock	56.007	56.02	55.875	55.925	2942552.0
2016-07-21 13:00:00	MSFT	Stock	55.925	56.05	55.92	56.045	2901497.0
2016-07-21 14:00:00	MSFT	Stock	56.04	56.05	55.91	55.965	2436871.0
2016-07-21 15:00:00	MSFT	Stock	55.96	55.965	55.77	55.81	8140663.0
2016-07-21 16:00:00	MSFT	Stock	55.8	55.976	55.77	55.78	2202558.0
2016-07-21 17:00:00	MSFT	Stock	55.8	55.8	55.74	55.74	7437.0
2016-07-21 18:00:00	MSFT	Stock	55.8	55.82	55.8	55.82	3045.0
2016-07-21 19:00:00	MSFT	Stock	55.8	55.8	55.74	55.74	2050.0
2016-07-21 07:00:00	NVDA	Stock	1.355	1.3555	1.355	1.3555	10000.0
2016-07-21 08:00:00	NVDA	Stock	1.3555	1.3558	1.355	1.3558	2337600.0
2016-07-21 09:00:00	NVDA	Stock	1.3575	1.3578	1.3448	1.3463	44507920.0
2016-07-21 10:00:00	NVDA	Stock	1.3463	1.3508	1.3445	1.3478	30190640.0
2016-07-21 11:00:00	NVDA	Stock	1.3476	1.3478	1.3298	1.3328	59581800.0
2016-07-21 12:00:00	NVDA	Stock	1.3328	1.3352	1.3274	1.335	46929800.0
2016-07-21 13:00:00	NVDA	Stock	1.3351	1.3403	1.3348	1.337	48511400.0
2016-07-21 14:00:00	NVDA	Stock	1.3368	1.3375	1.3285	1.3295	28151400.0
2016-07-21 15:00:00	NVDA	Stock	1.3292	1.331	1.326	1.3305	75471160.0
2016-07-21 16:00:00	NVDA	Stock	1.3305	1.3337	1.3305	1.332	2103120.0
2016-07-21 17:00:00	NVDA	Stock	1.3325	1.34	1.3298	1.3298	72000.0
2016-07-21 18:00:00	NVDA	Stock	1.3312	1.3312	1.3312	1.3312	24000.0
2016-07-21 19:00:00	NVDA	Stock	1.3312	1.3312	1.3312	1.3312	36000.0
2016-07-21 05:00:00	AMZN	Stock	37.25	37.25	37.25	37.25	16000.0
2016-07-21 06:00:00	AMZN	Stock	37.3	37.3	37.3	37.3	2000.0
2016-07-21 07:00:00	AMZN	Stock	37.275	37.2875	37.275	37.286	10000.0
2016-07-21 08:00:00	AMZN	Stock	37.327	37.4735	37.286	37.4	523860.0
2016-07-21 09:00:00	AMZN	Stock	37.394	37.435	37.236	37.319	7904820.0
2016-07-21 10:00:00	AMZN	Stock	37.3195	37.468	37.275	37.3435	9207400.0
2016-07-21 11:00:00	AMZN	Stock	37.3495	37.3575	37.192	37.2325	4428440.0
2016-07-21 12:00:00	AMZN	Stock	37.2325	37.268	37.17	37.1885	3511260.0

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

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