PREVIEW / stock_1hour / 2017-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-22.parquet
  size:    1.1 MB
  rows:    48,517
  symbols: 2,944

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-11-22 04:00:00	AAPL	Stock	43.3	43.36	43.3	43.3075	5452.0
2017-11-22 05:00:00	AAPL	Stock	43.3325	43.3325	43.3	43.3	15260.0
2017-11-22 06:00:00	AAPL	Stock	43.3025	43.325	43.3025	43.315	2400.0
2017-11-22 07:00:00	AAPL	Stock	43.305	43.4375	43.305	43.4125	157880.0
2017-11-22 08:00:00	AAPL	Stock	43.425	43.4375	43.33	43.345	318272.0
2017-11-22 09:00:00	AAPL	Stock	43.3575	43.565	43.2625	43.3412	16398000.0
2017-11-22 10:00:00	AAPL	Stock	43.335	43.65	43.325	43.6225	14868920.0
2017-11-22 11:00:00	AAPL	Stock	43.6225	43.75	43.465	43.57	13472152.0
2017-11-22 12:00:00	AAPL	Stock	43.5685	43.6325	43.5025	43.5675	6122104.0
2017-11-22 13:00:00	AAPL	Stock	43.5675	43.5875	43.4775	43.5848	5997540.0
2017-11-22 14:00:00	AAPL	Stock	43.5875	43.675	43.55	43.6225	5587300.0
2017-11-22 15:00:00	AAPL	Stock	43.6225	43.75	43.5875	43.735	12612188.0
2017-11-22 16:00:00	AAPL	Stock	43.7375	43.75	43.7125	43.74	14864372.0
2017-11-22 17:00:00	AAPL	Stock	43.7375	43.7375	43.6875	43.7075	24204.0
2017-11-22 18:00:00	AAPL	Stock	43.7175	43.745	43.7075	43.7375	37280.0
2017-11-22 19:00:00	AAPL	Stock	43.7375	43.745	43.7375	43.745	57836.0
2017-11-22 04:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	2700.0
2017-11-22 05:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	300.0
2017-11-22 07:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	100.0
2017-11-22 08:00:00	MSFT	Stock	83.9	83.95	83.87	83.92	10163.0
2017-11-22 09:00:00	MSFT	Stock	83.81	83.96	83.215	83.36	1805701.0
2017-11-22 10:00:00	MSFT	Stock	83.37	83.46	83.24	83.275	2851256.0
2017-11-22 11:00:00	MSFT	Stock	83.28	83.47	83.25	83.41	1889658.0
2017-11-22 12:00:00	MSFT	Stock	83.41	83.45	83.34	83.425	1057717.0
2017-11-22 13:00:00	MSFT	Stock	83.425	83.47	83.3	83.308	992592.0
2017-11-22 14:00:00	MSFT	Stock	83.3	83.33	83.22	83.23	1014371.0
2017-11-22 15:00:00	MSFT	Stock	83.231	83.25	83.04	83.09	2881347.0
2017-11-22 16:00:00	MSFT	Stock	83.11	83.15	83.1	83.11	2964983.0
2017-11-22 17:00:00	MSFT	Stock	83.11	83.14	83.07	83.1	3594.0
2017-11-22 19:00:00	MSFT	Stock	83.14	83.14	83.14	83.14	487.0
2017-11-22 04:00:00	NVDA	Stock	5.4103	5.4122	5.4048	5.4048	12680.0
2017-11-22 05:00:00	NVDA	Stock	5.4072	5.4072	5.3992	5.3992	124000.0
2017-11-22 06:00:00	NVDA	Stock	5.3992	5.3998	5.3908	5.3925	71440.0
2017-11-22 07:00:00	NVDA	Stock	5.399	5.4375	5.399	5.428	1412240.0
2017-11-22 08:00:00	NVDA	Stock	5.43	5.4373	5.3995	5.42	2268360.0
2017-11-22 09:00:00	NVDA	Stock	5.418	5.43	5.3562	5.3712	83640400.0
2017-11-22 10:00:00	NVDA	Stock	5.371	5.3858	5.3543	5.3584	49715920.0
2017-11-22 11:00:00	NVDA	Stock	5.3585	5.3633	5.3403	5.3482	37440720.0
2017-11-22 12:00:00	NVDA	Stock	5.349	5.3675	5.3475	5.3645	25495320.0
2017-11-22 13:00:00	NVDA	Stock	5.3645	5.3712	5.3565	5.3604	20008600.0
2017-11-22 14:00:00	NVDA	Stock	5.359	5.3788	5.3568	5.3758	23894640.0
2017-11-22 15:00:00	NVDA	Stock	5.3756	5.378	5.3588	5.3733	47266320.0
2017-11-22 16:00:00	NVDA	Stock	5.3733	5.374	5.3653	5.3712	31499080.0
2017-11-22 17:00:00	NVDA	Stock	5.373	5.3733	5.3712	5.3733	57960.0
2017-11-22 18:00:00	NVDA	Stock	5.3722	5.3725	5.3705	5.3725	153000.0
2017-11-22 19:00:00	NVDA	Stock	5.3738	5.3738	5.3725	5.3725	10440.0
2017-11-22 06:00:00	AMZN	Stock	57.1085	57.1145	57.104	57.1145	8680.0
2017-11-22 07:00:00	AMZN	Stock	57.109	57.1875	57.109	57.1535	134680.0
2017-11-22 08:00:00	AMZN	Stock	57.0375	57.18	57.0375	57.134	164480.0
2017-11-22 09:00:00	AMZN	Stock	57.1485	57.375	57.05	57.373	12574800.0

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

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