PREVIEW / stock_1hour / 2018-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-13.parquet
  size:    1.1 MB
  rows:    48,915
  symbols: 2,882

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
2018-02-13 04:00:00	AAPL	Stock	40.6625	40.6625	40.495	40.51	23880.0
2018-02-13 05:00:00	AAPL	Stock	40.5625	40.5625	40.475	40.5375	14180.0
2018-02-13 06:00:00	AAPL	Stock	40.5075	40.5075	40.425	40.5	37416.0
2018-02-13 07:00:00	AAPL	Stock	40.525	40.565	40.4125	40.55	258092.0
2018-02-13 08:00:00	AAPL	Stock	40.45	40.58	40.4125	40.4175	400484.0
2018-02-13 09:00:00	AAPL	Stock	40.4225	40.8175	40.3575	40.63	18924616.0
2018-02-13 10:00:00	AAPL	Stock	40.615	40.945	40.565	40.9025	18147908.0
2018-02-13 11:00:00	AAPL	Stock	40.9025	40.905	40.62	40.7425	12557712.0
2018-02-13 12:00:00	AAPL	Stock	40.745	40.7775	40.615	40.69	8872356.0
2018-02-13 13:00:00	AAPL	Stock	40.6908	41.055	40.6875	40.8675	12911892.0
2018-02-13 14:00:00	AAPL	Stock	40.8675	41.105	40.8475	41.0725	12691364.0
2018-02-13 15:00:00	AAPL	Stock	41.0725	41.1875	40.95	41.0862	20310664.0
2018-02-13 16:00:00	AAPL	Stock	41.085	41.0925	40.7388	41.055	5804296.0
2018-02-13 17:00:00	AAPL	Stock	41.0525	41.0525	40.95	40.9875	92804.0
2018-02-13 18:00:00	AAPL	Stock	40.9875	41.0425	40.975	41.0125	15464.0
2018-02-13 19:00:00	AAPL	Stock	41.025	41.0625	41.0125	41.025	30656.0
2018-02-13 04:00:00	MSFT	Stock	88.67	88.67	88.67	88.67	800.0
2018-02-13 06:00:00	MSFT	Stock	88.84	88.85	88.84	88.85	609.0
2018-02-13 07:00:00	MSFT	Stock	88.98	88.99	88.84	88.85	4999.0
2018-02-13 08:00:00	MSFT	Stock	88.825	88.93	88.5	88.79	32234.0
2018-02-13 09:00:00	MSFT	Stock	88.76	88.93	87.8	88.348	3407046.0
2018-02-13 10:00:00	MSFT	Stock	88.33	89.11	88.33	88.887	3469075.0
2018-02-13 11:00:00	MSFT	Stock	88.885	88.99	88.49	88.9	2378537.0
2018-02-13 12:00:00	MSFT	Stock	88.9	89.15	88.68	88.86	1735452.0
2018-02-13 13:00:00	MSFT	Stock	88.85	89.755	88.85	89.53	2595552.0
2018-02-13 14:00:00	MSFT	Stock	89.53	89.83	89.36	89.68	2293305.0
2018-02-13 15:00:00	MSFT	Stock	89.67	90.0	89.375	89.781	5201191.0
2018-02-13 16:00:00	MSFT	Stock	89.83	89.9	89.65	89.9	2838809.0
2018-02-13 17:00:00	MSFT	Stock	89.9	89.95	89.65	89.79	2214.0
2018-02-13 18:00:00	MSFT	Stock	89.79	89.85	89.79	89.85	516.0
2018-02-13 19:00:00	MSFT	Stock	89.85	89.95	89.85	89.9	6309.0
2018-02-13 04:00:00	NVDA	Stock	5.6942	5.6942	5.6583	5.675	28000.0
2018-02-13 05:00:00	NVDA	Stock	5.6628	5.663	5.6628	5.663	17840.0
2018-02-13 06:00:00	NVDA	Stock	5.6605	5.665	5.6603	5.6608	18000.0
2018-02-13 07:00:00	NVDA	Stock	5.6625	5.6898	5.66	5.685	572240.0
2018-02-13 08:00:00	NVDA	Stock	5.6618	5.6885	5.6618	5.662	1263480.0
2018-02-13 09:00:00	NVDA	Stock	5.6628	5.805	5.6313	5.7959	121217080.0
2018-02-13 10:00:00	NVDA	Stock	5.7959	5.85	5.7833	5.8045	119356120.0
2018-02-13 11:00:00	NVDA	Stock	5.8032	5.8388	5.7875	5.8034	61258520.0
2018-02-13 12:00:00	NVDA	Stock	5.8025	5.8235	5.773	5.7943	41522600.0
2018-02-13 13:00:00	NVDA	Stock	5.7943	5.8438	5.794	5.8365	49818160.0
2018-02-13 14:00:00	NVDA	Stock	5.8366	5.8625	5.8148	5.8421	57497400.0
2018-02-13 15:00:00	NVDA	Stock	5.8415	5.8485	5.808	5.8173	61724080.0
2018-02-13 16:00:00	NVDA	Stock	5.8158	5.8238	5.8125	5.8188	9182040.0
2018-02-13 17:00:00	NVDA	Stock	5.82	5.82	5.8125	5.8162	189640.0
2018-02-13 18:00:00	NVDA	Stock	5.8185	5.8315	5.8162	5.8315	353480.0
2018-02-13 19:00:00	NVDA	Stock	5.8275	5.8313	5.825	5.83	192200.0
2018-02-13 04:00:00	AMZN	Stock	69.2435	69.2435	69.0205	69.0205	7520.0
2018-02-13 05:00:00	AMZN	Stock	69.0	69.0	69.0	69.0	2360.0
2018-02-13 06:00:00	AMZN	Stock	68.813	68.821	68.75	68.75	42940.0

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

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