PREVIEW / stock_1hour / 2017-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-18.parquet
  size:    1.0 MB
  rows:    48,209
  symbols: 3,030

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
2017-05-18 04:00:00	AAPL	Stock	37.625	37.655	37.5925	37.655	11844.0
2017-05-18 05:00:00	AAPL	Stock	37.655	37.655	37.43	37.45	36984.0
2017-05-18 06:00:00	AAPL	Stock	37.4625	37.4925	37.4025	37.425	102072.0
2017-05-18 07:00:00	AAPL	Stock	37.425	37.685	37.425	37.645	145672.0
2017-05-18 08:00:00	AAPL	Stock	37.6275	37.815	37.4025	37.765	749344.0
2017-05-18 09:00:00	AAPL	Stock	37.775	38.1875	37.735	38.08	25315180.0
2017-05-18 10:00:00	AAPL	Stock	38.0825	38.335	38.0812	38.1525	25190212.0
2017-05-18 11:00:00	AAPL	Stock	38.1525	38.215	37.9275	37.9338	12773708.0
2017-05-18 12:00:00	AAPL	Stock	37.9375	38.1325	37.8925	38.0575	10399812.0
2017-05-18 13:00:00	AAPL	Stock	38.0575	38.1775	37.975	38.105	9504384.0
2017-05-18 14:00:00	AAPL	Stock	38.1075	38.305	38.1042	38.155	14020660.0
2017-05-18 15:00:00	AAPL	Stock	38.1575	38.24	38.1025	38.1275	17498968.0
2017-05-18 16:00:00	AAPL	Stock	38.1325	38.1525	38.1	38.1125	7799964.0
2017-05-18 17:00:00	AAPL	Stock	38.13	38.135	38.1125	38.1125	61128.0
2017-05-18 18:00:00	AAPL	Stock	38.125	38.145	38.1125	38.1425	55072.0
2017-05-18 19:00:00	AAPL	Stock	38.1425	38.1625	38.1425	38.1625	76036.0
2017-05-18 04:00:00	MSFT	Stock	67.5	67.5	67.5	67.5	141.0
2017-05-18 05:00:00	MSFT	Stock	67.4	67.4	67.12	67.12	5959.0
2017-05-18 06:00:00	MSFT	Stock	67.2	67.25	67.2	67.25	6963.0
2017-05-18 07:00:00	MSFT	Stock	67.28	67.35	67.26	67.35	1100.0
2017-05-18 08:00:00	MSFT	Stock	67.4	67.6	67.25	67.4	22589.0
2017-05-18 09:00:00	MSFT	Stock	67.41	67.9	67.14	67.47	3184416.0
2017-05-18 10:00:00	MSFT	Stock	67.48	68.06	67.45	67.842	4358151.0
2017-05-18 11:00:00	MSFT	Stock	67.85	68.13	67.66	67.66	2611850.0
2017-05-18 12:00:00	MSFT	Stock	67.67	67.84	67.59	67.645	2057686.0
2017-05-18 13:00:00	MSFT	Stock	67.64	67.741	67.5	67.655	2282167.0
2017-05-18 14:00:00	MSFT	Stock	67.655	68.02	67.65	67.75	2220334.0
2017-05-18 15:00:00	MSFT	Stock	67.75	67.84	67.575	67.72	4272655.0
2017-05-18 16:00:00	MSFT	Stock	67.71	67.73	67.68	67.71	2257167.0
2017-05-18 17:00:00	MSFT	Stock	67.71	67.73	67.6	67.64	1090.0
2017-05-18 19:00:00	MSFT	Stock	67.74	67.74	67.71	67.71	2962.0
2017-05-18 04:00:00	NVDA	Stock	3.1908	3.2	3.1875	3.1945	91240.0
2017-05-18 05:00:00	NVDA	Stock	3.1925	3.1925	3.1672	3.1895	295920.0
2017-05-18 06:00:00	NVDA	Stock	3.1838	3.185	3.1515	3.1625	236280.0
2017-05-18 07:00:00	NVDA	Stock	3.1575	3.205	3.1575	3.2	750160.0
2017-05-18 08:00:00	NVDA	Stock	3.1975	3.2445	3.16	3.2375	6569000.0
2017-05-18 09:00:00	NVDA	Stock	3.2362	3.2966	3.1762	3.2828	235893000.0
2017-05-18 10:00:00	NVDA	Stock	3.2833	3.3195	3.282	3.2946	202498600.0
2017-05-18 11:00:00	NVDA	Stock	3.294	3.3048	3.237	3.2425	129280920.0
2017-05-18 12:00:00	NVDA	Stock	3.2432	3.27	3.2203	3.268	101950360.0
2017-05-18 13:00:00	NVDA	Stock	3.2693	3.2948	3.2618	3.2872	70617400.0
2017-05-18 14:00:00	NVDA	Stock	3.288	3.31	3.2865	3.295	115998960.0
2017-05-18 15:00:00	NVDA	Stock	3.2955	3.3358	3.294	3.3265	199397800.0
2017-05-18 16:00:00	NVDA	Stock	3.3258	3.3565	3.322	3.3565	9587000.0
2017-05-18 17:00:00	NVDA	Stock	3.3538	3.3568	3.3462	3.355	1205120.0
2017-05-18 18:00:00	NVDA	Stock	3.3538	3.3638	3.35	3.3525	1215760.0
2017-05-18 19:00:00	NVDA	Stock	3.3562	3.3565	3.3528	3.3565	669880.0
2017-05-18 04:00:00	AMZN	Stock	47.175	47.2	47.1	47.2	11880.0
2017-05-18 05:00:00	AMZN	Stock	47.0	47.0	47.0	47.0	16960.0
2017-05-18 06:00:00	AMZN	Stock	47.0795	47.0795	47.0795	47.0795	2900.0

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

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