PREVIEW / stock_1hour / 2016-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-28.parquet
  size:    1.0 MB
  rows:    48,063
  symbols: 3,165

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-12-28 05:00:00	AAPL	Stock	29.345	29.345	29.345	29.345	460.0
2016-12-28 06:00:00	AAPL	Stock	29.325	29.3375	29.3125	29.3375	2032.0
2016-12-28 07:00:00	AAPL	Stock	29.37	29.3925	29.3625	29.3925	8288.0
2016-12-28 08:00:00	AAPL	Stock	29.395	29.4375	29.3625	29.4125	140980.0
2016-12-28 09:00:00	AAPL	Stock	29.4125	29.5042	29.3225	29.335	13799528.0
2016-12-28 10:00:00	AAPL	Stock	29.3375	29.3875	29.1925	29.2375	13524228.0
2016-12-28 11:00:00	AAPL	Stock	29.2332	29.3218	29.2275	29.29	10235252.0
2016-12-28 12:00:00	AAPL	Stock	29.2875	29.2888	29.1875	29.25	8452636.0
2016-12-28 13:00:00	AAPL	Stock	29.25	29.26	29.1725	29.2038	6023556.0
2016-12-28 14:00:00	AAPL	Stock	29.203	29.2375	29.16	29.2125	5772760.0
2016-12-28 15:00:00	AAPL	Stock	29.21	29.2388	29.05	29.1875	11281360.0
2016-12-28 16:00:00	AAPL	Stock	29.185	29.19	29.1475	29.175	3748648.0
2016-12-28 17:00:00	AAPL	Stock	29.15	29.1875	29.15	29.1875	14620.0
2016-12-28 18:00:00	AAPL	Stock	29.16	29.18	29.16	29.1775	12400.0
2016-12-28 19:00:00	AAPL	Stock	29.1775	29.1775	29.1575	29.1625	10432.0
2016-12-28 06:00:00	MSFT	Stock	63.28	63.28	63.28	63.28	158.0
2016-12-28 07:00:00	MSFT	Stock	63.03	63.2	63.03	63.2	300.0
2016-12-28 08:00:00	MSFT	Stock	63.4	63.4	63.3	63.39	2632.0
2016-12-28 09:00:00	MSFT	Stock	63.4	63.4	62.88	62.88	1730608.0
2016-12-28 10:00:00	MSFT	Stock	62.885	63.22	62.83	63.215	1859557.0
2016-12-28 11:00:00	MSFT	Stock	63.217	63.36	63.2	63.229	1287799.0
2016-12-28 12:00:00	MSFT	Stock	63.22	63.23	63.0	63.1	1496548.0
2016-12-28 13:00:00	MSFT	Stock	63.1	63.1	62.97	63.0	962256.0
2016-12-28 14:00:00	MSFT	Stock	63.0	63.055	62.88	63.05	1170404.0
2016-12-28 15:00:00	MSFT	Stock	63.045	63.08	62.9	62.99	2739202.0
2016-12-28 16:00:00	MSFT	Stock	62.99	63.1	62.98	63.07	1531567.0
2016-12-28 17:00:00	MSFT	Stock	62.95	62.99	62.95	62.99	300.0
2016-12-28 18:00:00	MSFT	Stock	63.08	63.08	63.08	63.08	200.0
2016-12-28 19:00:00	MSFT	Stock	63.08	63.08	63.08	63.08	500.0
2016-12-28 04:00:00	NVDA	Stock	3.009	3.009	2.984	2.984	562520.0
2016-12-28 05:00:00	NVDA	Stock	2.984	2.9975	2.984	2.9888	134400.0
2016-12-28 06:00:00	NVDA	Stock	2.9875	2.9875	2.9768	2.9812	300880.0
2016-12-28 07:00:00	NVDA	Stock	2.9812	2.9923	2.9688	2.9688	2040280.0
2016-12-28 08:00:00	NVDA	Stock	2.969	3.0038	2.9688	2.9945	22080640.0
2016-12-28 09:00:00	NVDA	Stock	2.9945	2.9983	2.8328	2.8423	458306080.0
2016-12-28 10:00:00	NVDA	Stock	2.8416	2.8485	2.7318	2.7953	605984440.0
2016-12-28 11:00:00	NVDA	Stock	2.7951	2.8475	2.7905	2.802	306759880.0
2016-12-28 12:00:00	NVDA	Stock	2.8015	2.8068	2.7532	2.7562	182876480.0
2016-12-28 13:00:00	NVDA	Stock	2.755	2.7875	2.7172	2.7457	242341760.0
2016-12-28 14:00:00	NVDA	Stock	2.7456	2.7645	2.7228	2.7459	187911400.0
2016-12-28 15:00:00	NVDA	Stock	2.7468	2.9062	2.7235	2.7312	254473480.0
2016-12-28 16:00:00	NVDA	Stock	2.7328	2.735	2.719	2.7225	8003760.0
2016-12-28 17:00:00	NVDA	Stock	2.7202	2.7275	2.6952	2.6965	5942640.0
2016-12-28 18:00:00	NVDA	Stock	2.6978	2.7025	2.683	2.6995	3120120.0
2016-12-28 19:00:00	NVDA	Stock	2.6988	2.6988	2.6813	2.6813	2524160.0
2016-12-28 06:00:00	AMZN	Stock	38.625	38.625	38.625	38.625	4000.0
2016-12-28 07:00:00	AMZN	Stock	38.695	38.705	38.695	38.705	47340.0
2016-12-28 08:00:00	AMZN	Stock	38.6575	38.8745	38.6575	38.84	665300.0
2016-12-28 09:00:00	AMZN	Stock	38.84	39.0	38.788	38.8047	15467520.0
2016-12-28 10:00:00	AMZN	Stock	38.8097	38.8465	38.6605	38.7743	8748740.0

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

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