PREVIEW / stock_1hour / 2018-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-24.parquet
  size:    1.1 MB
  rows:    49,576
  symbols: 2,901

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-01-24 04:00:00	AAPL	Stock	44.3125	44.3875	44.3125	44.3625	25444.0
2018-01-24 05:00:00	AAPL	Stock	44.3575	44.3575	44.3575	44.3575	400.0
2018-01-24 06:00:00	AAPL	Stock	44.3275	44.37	44.3275	44.3275	10748.0
2018-01-24 07:00:00	AAPL	Stock	44.325	44.4	44.2775	44.3	274080.0
2018-01-24 08:00:00	AAPL	Stock	44.315	44.495	44.25	44.4375	435044.0
2018-01-24 09:00:00	AAPL	Stock	44.4275	44.4475	43.695	43.9288	31289488.0
2018-01-24 10:00:00	AAPL	Stock	43.9275	43.97	43.721	43.7312	27085628.0
2018-01-24 11:00:00	AAPL	Stock	43.7278	43.85	43.6275	43.7475	30564932.0
2018-01-24 12:00:00	AAPL	Stock	43.745	43.835	43.5875	43.5925	16165904.0
2018-01-24 13:00:00	AAPL	Stock	43.5942	43.6525	43.3	43.5475	21218180.0
2018-01-24 14:00:00	AAPL	Stock	43.55	43.6912	43.465	43.585	14560760.0
2018-01-24 15:00:00	AAPL	Stock	43.5925	43.62	43.4525	43.555	21072044.0
2018-01-24 16:00:00	AAPL	Stock	43.5425	43.5875	43.535	43.5625	21468908.0
2018-01-24 17:00:00	AAPL	Stock	43.5625	43.5875	43.5325	43.55	175532.0
2018-01-24 18:00:00	AAPL	Stock	43.55	43.55	43.4625	43.4875	127760.0
2018-01-24 19:00:00	AAPL	Stock	43.4875	43.54	43.4875	43.54	23476.0
2018-01-24 05:00:00	MSFT	Stock	92.28	92.29	92.28	92.29	567.0
2018-01-24 06:00:00	MSFT	Stock	92.29	92.29	92.21	92.21	1300.0
2018-01-24 07:00:00	MSFT	Stock	92.21	92.35	92.21	92.3	12209.0
2018-01-24 08:00:00	MSFT	Stock	92.37	92.4	92.28	92.4	37237.0
2018-01-24 09:00:00	MSFT	Stock	92.38	93.17	92.19	93.15	2600308.0
2018-01-24 10:00:00	MSFT	Stock	93.155	93.43	92.9	93.0	3347072.0
2018-01-24 11:00:00	MSFT	Stock	93.005	93.08	92.21	92.605	3777047.0
2018-01-24 12:00:00	MSFT	Stock	92.605	92.76	92.145	92.22	3280136.0
2018-01-24 13:00:00	MSFT	Stock	92.21	92.28	91.58	92.075	3857690.0
2018-01-24 14:00:00	MSFT	Stock	92.08	92.3	91.98	92.11	2609268.0
2018-01-24 15:00:00	MSFT	Stock	92.11	92.12	91.765	91.84	3831200.0
2018-01-24 16:00:00	MSFT	Stock	91.82	92.097	91.8	92.0	5010525.0
2018-01-24 17:00:00	MSFT	Stock	92.0	92.0	91.78	91.8	10004.0
2018-01-24 18:00:00	MSFT	Stock	91.8	91.85	91.69	91.69	5928.0
2018-01-24 19:00:00	MSFT	Stock	91.85	91.85	91.85	91.85	250.0
2018-01-24 05:00:00	NVDA	Stock	5.97	5.97	5.9698	5.9698	12040.0
2018-01-24 06:00:00	NVDA	Stock	5.9578	5.9638	5.9503	5.9503	161680.0
2018-01-24 07:00:00	NVDA	Stock	5.955	5.9685	5.954	5.96	293800.0
2018-01-24 08:00:00	NVDA	Stock	5.9605	5.9722	5.9522	5.9675	1293520.0
2018-01-24 09:00:00	NVDA	Stock	5.9693	5.9968	5.9188	5.9635	91893160.0
2018-01-24 10:00:00	NVDA	Stock	5.962	6.0124	5.9565	5.9866	81475040.0
2018-01-24 11:00:00	NVDA	Stock	5.9875	5.9913	5.8403	5.8978	105218800.0
2018-01-24 12:00:00	NVDA	Stock	5.8968	5.9238	5.8798	5.897	38200920.0
2018-01-24 13:00:00	NVDA	Stock	5.9	5.9248	5.8388	5.9026	68624480.0
2018-01-24 14:00:00	NVDA	Stock	5.9045	5.9322	5.9023	5.9175	41574160.0
2018-01-24 15:00:00	NVDA	Stock	5.9155	5.9175	5.8838	5.896	54263440.0
2018-01-24 16:00:00	NVDA	Stock	5.895	5.9075	5.89	5.9038	32806560.0
2018-01-24 17:00:00	NVDA	Stock	5.9013	5.9048	5.9	5.9038	208880.0
2018-01-24 18:00:00	NVDA	Stock	5.9038	5.91	5.9038	5.905	515160.0
2018-01-24 19:00:00	NVDA	Stock	5.9122	5.9125	5.91	5.9125	381440.0
2018-01-24 05:00:00	AMZN	Stock	68.25	68.3	68.25	68.3	4000.0
2018-01-24 06:00:00	AMZN	Stock	68.25	68.275	68.25	68.2535	28240.0
2018-01-24 07:00:00	AMZN	Stock	68.275	68.4645	68.275	68.43	195500.0
2018-01-24 08:00:00	AMZN	Stock	68.435	69.0325	68.2525	68.9	1687940.0

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

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