PREVIEW / stock_1hour / 2016-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-09.parquet
  size:    1.0 MB
  rows:    50,384
  symbols: 3,310

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-05-09 04:00:00	AAPL	Stock	23.1925	23.2375	23.1925	23.2375	49028.0
2016-05-09 05:00:00	AAPL	Stock	23.2275	23.25	23.2275	23.25	2352.0
2016-05-09 06:00:00	AAPL	Stock	23.2575	23.2675	23.24	23.25	9560.0
2016-05-09 07:00:00	AAPL	Stock	23.2625	23.2625	23.215	23.23	53840.0
2016-05-09 08:00:00	AAPL	Stock	23.25	23.2825	23.215	23.225	544736.0
2016-05-09 09:00:00	AAPL	Stock	23.225	23.3725	23.1475	23.32	20995800.0
2016-05-09 10:00:00	AAPL	Stock	23.3175	23.4425	23.285	23.3825	20186792.0
2016-05-09 11:00:00	AAPL	Stock	23.3825	23.42	23.3225	23.3475	11624972.0
2016-05-09 12:00:00	AAPL	Stock	23.3475	23.3575	23.255	23.2578	9239336.0
2016-05-09 13:00:00	AAPL	Stock	23.26	23.2825	23.1825	23.1875	11738452.0
2016-05-09 14:00:00	AAPL	Stock	23.1855	23.31	23.155	23.2838	15003576.0
2016-05-09 15:00:00	AAPL	Stock	23.2838	23.32	23.175	23.1975	20318948.0
2016-05-09 16:00:00	AAPL	Stock	23.1975	23.2615	23.1675	23.18	10731200.0
2016-05-09 17:00:00	AAPL	Stock	23.2002	23.2025	23.175	23.195	148508.0
2016-05-09 18:00:00	AAPL	Stock	23.205	23.205	23.17	23.17	21972.0
2016-05-09 19:00:00	AAPL	Stock	23.165	23.17	23.1575	23.1625	31648.0
2016-05-09 04:00:00	MSFT	Stock	50.44	50.44	50.44	50.44	200.0
2016-05-09 05:00:00	MSFT	Stock	50.49	50.49	50.49	50.49	200.0
2016-05-09 07:00:00	MSFT	Stock	50.5	50.55	50.5	50.55	12390.0
2016-05-09 08:00:00	MSFT	Stock	50.55	50.65	50.39	50.56	30829.0
2016-05-09 09:00:00	MSFT	Stock	50.58	50.58	50.36	50.55	2207708.0
2016-05-09 10:00:00	MSFT	Stock	50.56	50.585	50.08	50.11	2643095.0
2016-05-09 11:00:00	MSFT	Stock	50.104	50.345	50.0	50.22	2227403.0
2016-05-09 12:00:00	MSFT	Stock	50.22	50.31	50.16	50.195	1448641.0
2016-05-09 13:00:00	MSFT	Stock	50.19	50.25	50.15	50.155	1325871.0
2016-05-09 14:00:00	MSFT	Stock	50.156	50.305	50.068	50.295	1698039.0
2016-05-09 15:00:00	MSFT	Stock	50.29	50.3	50.06	50.07	3008720.0
2016-05-09 16:00:00	MSFT	Stock	50.07	50.12	50.07	50.07	1893655.0
2016-05-09 17:00:00	MSFT	Stock	50.076	50.1	50.07	50.1	38833.0
2016-05-09 18:00:00	MSFT	Stock	50.04	50.05	50.0	50.0	4150.0
2016-05-09 19:00:00	MSFT	Stock	50.0	50.0	49.88	49.88	410.0
2016-05-09 06:00:00	NVDA	Stock	0.8925	0.8938	0.8925	0.8938	9600.0
2016-05-09 07:00:00	NVDA	Stock	0.8932	0.8938	0.89	0.89	28000.0
2016-05-09 08:00:00	NVDA	Stock	0.8973	0.8973	0.8888	0.8912	177640.0
2016-05-09 09:00:00	NVDA	Stock	0.8912	0.8925	0.882	0.8868	43852000.0
2016-05-09 10:00:00	NVDA	Stock	0.887	0.8893	0.876	0.8768	67521040.0
2016-05-09 11:00:00	NVDA	Stock	0.8765	0.8806	0.8748	0.88	47361040.0
2016-05-09 12:00:00	NVDA	Stock	0.88	0.88	0.8762	0.879	34562840.0
2016-05-09 13:00:00	NVDA	Stock	0.879	0.884	0.878	0.8818	23564720.0
2016-05-09 14:00:00	NVDA	Stock	0.8815	0.8868	0.881	0.8866	23471840.0
2016-05-09 15:00:00	NVDA	Stock	0.8866	0.8871	0.8805	0.882	47218600.0
2016-05-09 16:00:00	NVDA	Stock	0.882	0.883	0.882	0.883	19435320.0
2016-05-09 17:00:00	NVDA	Stock	0.8821	0.8821	0.882	0.882	612840.0
2016-05-09 18:00:00	NVDA	Stock	0.8825	0.883	0.882	0.883	107560.0
2016-05-09 19:00:00	NVDA	Stock	0.882	0.882	0.882	0.882	8000.0
2016-05-09 06:00:00	AMZN	Stock	33.972	33.972	33.89	33.9	30200.0
2016-05-09 07:00:00	AMZN	Stock	33.8705	33.9005	33.85	33.85	47860.0
2016-05-09 08:00:00	AMZN	Stock	33.825	33.875	33.63	33.72	326320.0
2016-05-09 09:00:00	AMZN	Stock	33.7205	33.8605	33.5705	33.8315	10326020.0
2016-05-09 10:00:00	AMZN	Stock	33.8165	33.864	33.675	33.8075	9544860.0

> showing 50 of 50,384 rows — these rows as CSV

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