PREVIEW / stock_1hour / 2017-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-24.parquet
  size:    1.1 MB
  rows:    48,913
  symbols: 3,056

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
2017-04-24 04:00:00	AAPL	Stock	36.0025	36.05	35.9925	35.9925	11472.0
2017-04-24 05:00:00	AAPL	Stock	35.9925	36.0125	35.9725	35.9725	7048.0
2017-04-24 06:00:00	AAPL	Stock	35.9625	35.9925	35.95	35.9875	18948.0
2017-04-24 07:00:00	AAPL	Stock	35.975	35.975	35.9	35.91	80504.0
2017-04-24 08:00:00	AAPL	Stock	35.905	35.965	35.5675	35.905	300580.0
2017-04-24 09:00:00	AAPL	Stock	35.9025	35.9875	35.795	35.9625	13064044.0
2017-04-24 10:00:00	AAPL	Stock	35.9625	35.9825	35.8775	35.895	9121408.0
2017-04-24 11:00:00	AAPL	Stock	35.8975	35.9225	35.8575	35.9	6196120.0
2017-04-24 12:00:00	AAPL	Stock	35.9025	35.9562	35.9025	35.9438	4512048.0
2017-04-24 13:00:00	AAPL	Stock	35.945	35.96	35.9288	35.9575	4631648.0
2017-04-24 14:00:00	AAPL	Stock	35.9552	35.9725	35.915	35.95	5490676.0
2017-04-24 15:00:00	AAPL	Stock	35.95	35.9675	35.885	35.9075	11376948.0
2017-04-24 16:00:00	AAPL	Stock	35.91	35.925	35.9	35.91	7717152.0
2017-04-24 17:00:00	AAPL	Stock	35.915	35.9375	35.9125	35.9225	22688.0
2017-04-24 18:00:00	AAPL	Stock	35.9225	35.9375	35.9125	35.915	11464.0
2017-04-24 19:00:00	AAPL	Stock	35.9375	35.945	35.93	35.945	18600.0
2017-04-24 04:00:00	MSFT	Stock	67.0	67.41	67.0	67.35	2124.0
2017-04-24 05:00:00	MSFT	Stock	67.34	67.34	67.34	67.34	100.0
2017-04-24 06:00:00	MSFT	Stock	67.39	67.39	67.24	67.24	2046.0
2017-04-24 07:00:00	MSFT	Stock	67.25	67.25	67.16	67.16	8512.0
2017-04-24 08:00:00	MSFT	Stock	67.16	67.32	66.4	67.2	73893.0
2017-04-24 09:00:00	MSFT	Stock	67.2	67.49	67.13	67.34	5117255.0
2017-04-24 10:00:00	MSFT	Stock	67.34	67.44	67.2	67.38	3753107.0
2017-04-24 11:00:00	MSFT	Stock	67.38	67.41	67.16	67.21	3271417.0
2017-04-24 12:00:00	MSFT	Stock	67.2	67.3	67.1	67.21	2531562.0
2017-04-24 13:00:00	MSFT	Stock	67.2	67.37	67.2	67.365	2240820.0
2017-04-24 14:00:00	MSFT	Stock	67.36	67.49	67.3	67.44	2475737.0
2017-04-24 15:00:00	MSFT	Stock	67.44	67.66	67.4	67.53	5650653.0
2017-04-24 16:00:00	MSFT	Stock	67.53	67.63	67.5	67.5	2801631.0
2017-04-24 17:00:00	MSFT	Stock	67.52	67.52	67.5	67.52	4101.0
2017-04-24 18:00:00	MSFT	Stock	67.5	67.52	67.5	67.52	1981.0
2017-04-24 19:00:00	MSFT	Stock	67.52	67.52	67.52	67.52	1100.0
2017-04-24 04:00:00	NVDA	Stock	2.5625	2.575	2.5625	2.575	67480.0
2017-04-24 05:00:00	NVDA	Stock	2.5753	2.5753	2.5753	2.5753	16000.0
2017-04-24 06:00:00	NVDA	Stock	2.5765	2.5792	2.5755	2.5755	86400.0
2017-04-24 07:00:00	NVDA	Stock	2.5758	2.5762	2.5683	2.5688	184120.0
2017-04-24 08:00:00	NVDA	Stock	2.5688	2.5758	2.5675	2.569	1404120.0
2017-04-24 09:00:00	NVDA	Stock	2.5685	2.5862	2.5598	2.5742	65046320.0
2017-04-24 10:00:00	NVDA	Stock	2.5742	2.5788	2.5528	2.5594	59975480.0
2017-04-24 11:00:00	NVDA	Stock	2.5595	2.5645	2.555	2.5618	35193280.0
2017-04-24 12:00:00	NVDA	Stock	2.5622	2.5748	2.5618	2.5718	35608320.0
2017-04-24 13:00:00	NVDA	Stock	2.5715	2.5758	2.5693	2.5745	19739520.0
2017-04-24 14:00:00	NVDA	Stock	2.575	2.5838	2.5744	2.5822	33885480.0
2017-04-24 15:00:00	NVDA	Stock	2.5825	2.587	2.5728	2.5738	63026240.0
2017-04-24 16:00:00	NVDA	Stock	2.5868	2.5868	2.5723	2.5738	22056600.0
2017-04-24 17:00:00	NVDA	Stock	2.575	2.575	2.5712	2.5712	25920.0
2017-04-24 18:00:00	NVDA	Stock	2.574	2.5765	2.574	2.5742	68000.0
2017-04-24 19:00:00	NVDA	Stock	2.574	2.574	2.5718	2.574	26200.0
2017-04-24 04:00:00	AMZN	Stock	45.6	45.695	45.6	45.625	25340.0
2017-04-24 05:00:00	AMZN	Stock	45.6	45.6	45.6	45.6	3540.0

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

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