PREVIEW / stock_1hour / 2016-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-12.parquet
  size:    1.1 MB
  rows:    49,272
  symbols: 3,164

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-12 04:00:00	AAPL	Stock	28.355	28.355	28.2125	28.24	8060.0
2016-12-12 05:00:00	AAPL	Stock	28.24	28.24	28.24	28.24	2640.0
2016-12-12 06:00:00	AAPL	Stock	28.305	28.315	28.2825	28.315	11380.0
2016-12-12 07:00:00	AAPL	Stock	28.3325	28.3375	28.29	28.32	69664.0
2016-12-12 08:00:00	AAPL	Stock	28.2875	28.4175	28.2875	28.375	316844.0
2016-12-12 09:00:00	AAPL	Stock	28.3775	28.42	28.1225	28.2575	21866376.0
2016-12-12 10:00:00	AAPL	Stock	28.2575	28.2825	28.13	28.28	17054144.0
2016-12-12 11:00:00	AAPL	Stock	28.2812	28.285	28.2112	28.2525	9596164.0
2016-12-12 12:00:00	AAPL	Stock	28.2525	28.26	28.171	28.25	8149388.0
2016-12-12 13:00:00	AAPL	Stock	28.25	28.3225	28.18	28.2085	7313308.0
2016-12-12 14:00:00	AAPL	Stock	28.21	28.2775	28.1875	28.2375	8131088.0
2016-12-12 15:00:00	AAPL	Stock	28.2375	28.3275	28.235	28.3225	14657776.0
2016-12-12 16:00:00	AAPL	Stock	28.33	28.33	28.3	28.3125	9363928.0
2016-12-12 17:00:00	AAPL	Stock	28.3075	28.3175	28.29	28.29	32180.0
2016-12-12 18:00:00	AAPL	Stock	28.3	28.3	28.2625	28.2825	10912.0
2016-12-12 19:00:00	AAPL	Stock	28.3	28.3	28.2775	28.2825	12400.0
2016-12-12 04:00:00	MSFT	Stock	61.95	61.95	61.95	61.95	100.0
2016-12-12 07:00:00	MSFT	Stock	61.73	61.75	61.73	61.75	709.0
2016-12-12 08:00:00	MSFT	Stock	61.75	61.95	61.75	61.81	6343.0
2016-12-12 09:00:00	MSFT	Stock	61.79	62.08	61.66	62.05	2968005.0
2016-12-12 10:00:00	MSFT	Stock	62.045	62.15	61.85	62.07	2825292.0
2016-12-12 11:00:00	MSFT	Stock	62.07	62.3	61.9	61.925	2413200.0
2016-12-12 12:00:00	MSFT	Stock	61.92	61.955	61.76	61.92	1619176.0
2016-12-12 13:00:00	MSFT	Stock	61.93	62.0	61.79	61.835	1456796.0
2016-12-12 14:00:00	MSFT	Stock	61.83	61.98	61.82	61.96	1628888.0
2016-12-12 15:00:00	MSFT	Stock	61.955	62.17	61.94	62.17	3343289.0
2016-12-12 16:00:00	MSFT	Stock	62.17	62.19	62.11	62.19	2669983.0
2016-12-12 17:00:00	MSFT	Stock	62.15	62.15	62.12	62.12	1725.0
2016-12-12 18:00:00	MSFT	Stock	62.11	62.16	62.1	62.16	740.0
2016-12-12 19:00:00	MSFT	Stock	62.16	62.16	62.16	62.16	500.0
2016-12-12 06:00:00	NVDA	Stock	2.286	2.287	2.2825	2.287	41880.0
2016-12-12 07:00:00	NVDA	Stock	2.2825	2.2825	2.253	2.2675	184360.0
2016-12-12 08:00:00	NVDA	Stock	2.2575	2.2738	2.2575	2.2588	545320.0
2016-12-12 09:00:00	NVDA	Stock	2.26	2.2625	2.1885	2.2126	135269640.0
2016-12-12 10:00:00	NVDA	Stock	2.2128	2.215	2.1945	2.2026	113527360.0
2016-12-12 11:00:00	NVDA	Stock	2.2025	2.2407	2.202	2.218	75781280.0
2016-12-12 12:00:00	NVDA	Stock	2.2185	2.2185	2.2008	2.2065	48770800.0
2016-12-12 13:00:00	NVDA	Stock	2.207	2.2098	2.2023	2.2025	31878520.0
2016-12-12 14:00:00	NVDA	Stock	2.2025	2.2206	2.2025	2.2175	48837760.0
2016-12-12 15:00:00	NVDA	Stock	2.2174	2.2413	2.2172	2.2398	98216720.0
2016-12-12 16:00:00	NVDA	Stock	2.2398	2.245	2.2148	2.2388	11285480.0
2016-12-12 17:00:00	NVDA	Stock	2.2425	2.2442	2.24	2.2442	150880.0
2016-12-12 18:00:00	NVDA	Stock	2.2442	2.2445	2.2358	2.238	82920.0
2016-12-12 19:00:00	NVDA	Stock	2.2358	2.238	2.2358	2.2358	290720.0
2016-12-12 04:00:00	AMZN	Stock	38.269	38.269	38.238	38.238	16500.0
2016-12-12 07:00:00	AMZN	Stock	38.2585	38.327	38.253	38.263	27280.0
2016-12-12 08:00:00	AMZN	Stock	38.25	38.3575	38.25	38.33	77280.0
2016-12-12 09:00:00	AMZN	Stock	38.3475	38.371	37.86	38.024	12067740.0
2016-12-12 10:00:00	AMZN	Stock	38.013	38.064	37.9415	38.0278	8656980.0
2016-12-12 11:00:00	AMZN	Stock	38.0265	38.119	37.936	37.943	6511000.0

> showing 50 of 49,272 rows — these rows as CSV

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