PREVIEW / stock_1hour / 2018-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-16.parquet
  size:    1.1 MB
  rows:    48,677
  symbols: 2,868

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-04-16 04:00:00	AAPL	Stock	43.7725	43.8	43.7725	43.8	800.0
2018-04-16 05:00:00	AAPL	Stock	43.935	43.9375	43.935	43.9375	2800.0
2018-04-16 06:00:00	AAPL	Stock	43.9375	43.96	43.87	43.9475	9196.0
2018-04-16 07:00:00	AAPL	Stock	43.94	43.9625	43.8625	43.9125	105308.0
2018-04-16 08:00:00	AAPL	Stock	43.925	43.98	43.88	43.97	202884.0
2018-04-16 09:00:00	AAPL	Stock	43.9675	44.0	43.7075	43.9132	13365224.0
2018-04-16 10:00:00	AAPL	Stock	43.915	43.99	43.7575	43.8312	12131080.0
2018-04-16 11:00:00	AAPL	Stock	43.8325	43.915	43.7312	43.8825	9110644.0
2018-04-16 12:00:00	AAPL	Stock	43.8825	43.9975	43.77	43.98	8670776.0
2018-04-16 13:00:00	AAPL	Stock	43.98	44.0475	43.95	44.0	9051204.0
2018-04-16 14:00:00	AAPL	Stock	44.0	44.0225	43.925	43.9875	7038124.0
2018-04-16 15:00:00	AAPL	Stock	43.9852	44.0375	43.8625	43.955	12765780.0
2018-04-16 16:00:00	AAPL	Stock	43.955	44.085	43.925	43.98	5076224.0
2018-04-16 17:00:00	AAPL	Stock	43.9725	43.9975	43.955	43.975	70112.0
2018-04-16 18:00:00	AAPL	Stock	43.975	43.9975	43.9675	43.9975	12340.0
2018-04-16 19:00:00	AAPL	Stock	43.9925	44.035	43.99	44.025	35888.0
2018-04-16 05:00:00	MSFT	Stock	93.36	93.9	93.35	93.9	2332.0
2018-04-16 06:00:00	MSFT	Stock	93.54	93.54	93.54	93.54	447.0
2018-04-16 07:00:00	MSFT	Stock	93.82	93.82	93.21	93.65	14964.0
2018-04-16 08:00:00	MSFT	Stock	93.55	93.9	93.55	93.9	19305.0
2018-04-16 09:00:00	MSFT	Stock	93.79	94.23	93.51	93.68	2299602.0
2018-04-16 10:00:00	MSFT	Stock	93.68	94.27	93.68	93.89	2445413.0
2018-04-16 11:00:00	MSFT	Stock	93.89	94.125	93.42	94.078	1789398.0
2018-04-16 12:00:00	MSFT	Stock	94.08	94.613	93.94	94.56	2439969.0
2018-04-16 13:00:00	MSFT	Stock	94.56	94.66	94.2	94.3	1634934.0
2018-04-16 14:00:00	MSFT	Stock	94.31	94.36	94.06	94.195	1499285.0
2018-04-16 15:00:00	MSFT	Stock	94.19	94.54	94.03	94.17	3505937.0
2018-04-16 16:00:00	MSFT	Stock	94.17	94.8	94.17	94.6	2990465.0
2018-04-16 17:00:00	MSFT	Stock	94.55	94.55	94.17	94.53	148289.0
2018-04-16 18:00:00	MSFT	Stock	94.46	94.55	94.43	94.43	2644.0
2018-04-16 19:00:00	MSFT	Stock	94.44	94.59	94.43	94.59	3578.0
2018-04-16 04:00:00	NVDA	Stock	5.7948	5.8242	5.788	5.8242	100000.0
2018-04-16 05:00:00	NVDA	Stock	5.8242	5.8362	5.8242	5.8362	36000.0
2018-04-16 06:00:00	NVDA	Stock	5.8362	5.8438	5.818	5.818	44600.0
2018-04-16 07:00:00	NVDA	Stock	5.8265	5.8438	5.8155	5.8248	441640.0
2018-04-16 08:00:00	NVDA	Stock	5.825	5.8425	5.8155	5.8343	1176440.0
2018-04-16 09:00:00	NVDA	Stock	5.835	5.835	5.692	5.715	63699440.0
2018-04-16 10:00:00	NVDA	Stock	5.7149	5.782	5.714	5.744	53350200.0
2018-04-16 11:00:00	NVDA	Stock	5.7472	5.7578	5.7063	5.755	33806400.0
2018-04-16 12:00:00	NVDA	Stock	5.7572	5.821	5.7572	5.808	31687280.0
2018-04-16 13:00:00	NVDA	Stock	5.8069	5.8135	5.7888	5.8094	20314080.0
2018-04-16 14:00:00	NVDA	Stock	5.8098	5.8135	5.7833	5.7879	18284920.0
2018-04-16 15:00:00	NVDA	Stock	5.7875	5.7989	5.7602	5.7868	36718240.0
2018-04-16 16:00:00	NVDA	Stock	5.7872	5.81	5.7825	5.81	27259400.0
2018-04-16 17:00:00	NVDA	Stock	5.8095	5.8112	5.804	5.8112	171440.0
2018-04-16 18:00:00	NVDA	Stock	5.8112	5.8112	5.7988	5.8058	325560.0
2018-04-16 19:00:00	NVDA	Stock	5.8062	5.81	5.805	5.81	299880.0
2018-04-16 04:00:00	AMZN	Stock	71.7005	71.936	71.7005	71.936	4880.0
2018-04-16 06:00:00	AMZN	Stock	72.157	72.157	72.157	72.157	3060.0
2018-04-16 07:00:00	AMZN	Stock	72.15	72.1955	72.05	72.19	236340.0

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

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