PREVIEW / stock_1hour / 2015-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-05.parquet
  size:    1.0 MB
  rows:    48,478
  symbols: 3,406

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
2015-11-05 04:00:00	AAPL	Stock	30.4575	30.46	30.3875	30.3875	9240.0
2015-11-05 05:00:00	AAPL	Stock	30.3875	30.4975	30.3625	30.4975	35784.0
2015-11-05 06:00:00	AAPL	Stock	30.45	30.5225	30.45	30.49	65108.0
2015-11-05 07:00:00	AAPL	Stock	30.4825	30.4825	30.39	30.425	423504.0
2015-11-05 08:00:00	AAPL	Stock	30.425	30.5125	30.4025	30.455	746424.0
2015-11-05 09:00:00	AAPL	Stock	30.46	30.6725	30.4225	30.6138	23288108.0
2015-11-05 10:00:00	AAPL	Stock	30.615	30.66	30.195	30.2775	32751992.0
2015-11-05 11:00:00	AAPL	Stock	30.275	30.3225	30.205	30.2325	16012684.0
2015-11-05 12:00:00	AAPL	Stock	30.2325	30.233	30.045	30.1975	18338384.0
2015-11-05 13:00:00	AAPL	Stock	30.1965	30.2625	30.1475	30.1775	10886184.0
2015-11-05 14:00:00	AAPL	Stock	30.1775	30.22	30.0625	30.11	12534584.0
2015-11-05 15:00:00	AAPL	Stock	30.11	30.25	30.0775	30.2275	20125292.0
2015-11-05 16:00:00	AAPL	Stock	30.23	30.3725	30.205	30.326	10470360.0
2015-11-05 17:00:00	AAPL	Stock	30.326	30.3425	30.325	30.325	116512.0
2015-11-05 18:00:00	AAPL	Stock	30.325	30.3425	30.325	30.3375	113932.0
2015-11-05 19:00:00	AAPL	Stock	30.3375	30.3425	30.3275	30.3275	55720.0
2015-11-05 04:00:00	MSFT	Stock	54.4	54.4	54.4	54.4	100.0
2015-11-05 05:00:00	MSFT	Stock	54.4	54.4	54.35	54.4	3500.0
2015-11-05 06:00:00	MSFT	Stock	54.4	54.4	54.39	54.4	2300.0
2015-11-05 07:00:00	MSFT	Stock	54.44	54.48	54.44	54.48	1888.0
2015-11-05 08:00:00	MSFT	Stock	54.45	54.49	54.4	54.41	10031.0
2015-11-05 09:00:00	MSFT	Stock	54.39	54.7	54.32	54.4	3672608.0
2015-11-05 10:00:00	MSFT	Stock	54.4	54.41	54.04	54.04	5796674.0
2015-11-05 11:00:00	MSFT	Stock	54.05	54.325	54.0	54.3	2737158.0
2015-11-05 12:00:00	MSFT	Stock	54.31	54.46	54.24	54.43	3140230.0
2015-11-05 13:00:00	MSFT	Stock	54.43	54.471	54.33	54.415	2334475.0
2015-11-05 14:00:00	MSFT	Stock	54.42	54.43	54.23	54.345	2164826.0
2015-11-05 15:00:00	MSFT	Stock	54.345	54.46	54.26	54.39	4508121.0
2015-11-05 16:00:00	MSFT	Stock	54.38	54.38	54.31	54.32	4982060.0
2015-11-05 17:00:00	MSFT	Stock	54.32	54.38	54.32	54.38	400.0
2015-11-05 18:00:00	MSFT	Stock	54.32	54.324	54.32	54.324	1000.0
2015-11-05 19:00:00	MSFT	Stock	54.38	54.38	54.38	54.38	600.0
2015-11-05 07:00:00	NVDA	Stock	0.7058	0.7058	0.7058	0.7058	80000.0
2015-11-05 09:00:00	NVDA	Stock	0.7048	0.7061	0.6982	0.703	25372000.0
2015-11-05 10:00:00	NVDA	Stock	0.7028	0.7032	0.696	0.696	61694080.0
2015-11-05 11:00:00	NVDA	Stock	0.6962	0.7015	0.6955	0.7	38641840.0
2015-11-05 12:00:00	NVDA	Stock	0.7002	0.7025	0.6908	0.6969	67067840.0
2015-11-05 13:00:00	NVDA	Stock	0.6968	0.7013	0.696	0.6995	41038360.0
2015-11-05 14:00:00	NVDA	Stock	0.6994	0.7012	0.691	0.6938	56328080.0
2015-11-05 15:00:00	NVDA	Stock	0.694	0.7006	0.6925	0.6925	108869600.0
2015-11-05 16:00:00	NVDA	Stock	0.6928	0.7622	0.6875	0.7615	31516200.0
2015-11-05 17:00:00	NVDA	Stock	0.7612	0.7662	0.7475	0.7475	2745280.0
2015-11-05 18:00:00	NVDA	Stock	0.7523	0.755	0.7523	0.755	366040.0
2015-11-05 19:00:00	NVDA	Stock	0.755	0.7638	0.755	0.761	703920.0
2015-11-05 06:00:00	AMZN	Stock	32.1475	32.1475	32.1475	32.1475	2000.0
2015-11-05 07:00:00	AMZN	Stock	32.19	32.2145	32.1865	32.2	154220.0
2015-11-05 08:00:00	AMZN	Stock	32.193	32.222	31.975	32.199	309860.0
2015-11-05 09:00:00	AMZN	Stock	32.19	32.8325	32.13	32.613	19052660.0
2015-11-05 10:00:00	AMZN	Stock	32.6185	32.7745	32.3525	32.5595	21779960.0
2015-11-05 11:00:00	AMZN	Stock	32.5625	32.727	32.5065	32.7135	8881180.0

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

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