PREVIEW / stock_1hour / 2017-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-13.parquet
  size:    1.1 MB
  rows:    48,053
  symbols: 2,947

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-10-13 04:00:00	AAPL	Stock	39.05	39.05	39.05	39.05	400.0
2017-10-13 05:00:00	AAPL	Stock	39.035	39.035	39.0	39.035	4112.0
2017-10-13 06:00:00	AAPL	Stock	39.05	39.05	39.05	39.05	5100.0
2017-10-13 07:00:00	AAPL	Stock	39.0625	39.125	39.0325	39.075	110824.0
2017-10-13 08:00:00	AAPL	Stock	39.1	39.1875	39.0675	39.1575	245056.0
2017-10-13 09:00:00	AAPL	Stock	39.16	39.2392	39.1025	39.175	9522624.0
2017-10-13 10:00:00	AAPL	Stock	39.1775	39.285	39.1775	39.2738	11245324.0
2017-10-13 11:00:00	AAPL	Stock	39.2725	39.2875	39.2275	39.2605	5496600.0
2017-10-13 12:00:00	AAPL	Stock	39.2625	39.2762	39.1375	39.18	8853212.0
2017-10-13 13:00:00	AAPL	Stock	39.18	39.2552	39.17	39.25	4006900.0
2017-10-13 14:00:00	AAPL	Stock	39.2475	39.32	39.2475	39.2938	5582948.0
2017-10-13 15:00:00	AAPL	Stock	39.295	39.295	39.2025	39.2525	8459188.0
2017-10-13 16:00:00	AAPL	Stock	39.2475	39.25	39.23	39.2375	4853712.0
2017-10-13 17:00:00	AAPL	Stock	39.245	39.2475	39.2175	39.245	37044.0
2017-10-13 18:00:00	AAPL	Stock	39.2325	39.25	39.2275	39.25	42156.0
2017-10-13 19:00:00	AAPL	Stock	39.2425	39.2475	39.2375	39.2375	23528.0
2017-10-13 04:00:00	MSFT	Stock	77.22	77.22	77.22	77.22	210.0
2017-10-13 05:00:00	MSFT	Stock	77.35	77.35	77.35	77.35	5051.0
2017-10-13 06:00:00	MSFT	Stock	77.5	77.5	77.35	77.35	1528.0
2017-10-13 07:00:00	MSFT	Stock	77.35	77.35	77.35	77.35	3300.0
2017-10-13 08:00:00	MSFT	Stock	77.3	77.41	77.3	77.4	5023.0
2017-10-13 09:00:00	MSFT	Stock	77.41	77.87	77.35	77.6	2155724.0
2017-10-13 10:00:00	MSFT	Stock	77.605	77.66	77.352	77.38	1629442.0
2017-10-13 11:00:00	MSFT	Stock	77.39	77.53	77.29	77.39	1231429.0
2017-10-13 12:00:00	MSFT	Stock	77.4	77.51	77.33	77.49	912413.0
2017-10-13 13:00:00	MSFT	Stock	77.48	77.57	77.38	77.4	918607.0
2017-10-13 14:00:00	MSFT	Stock	77.4	77.6	77.38	77.595	922901.0
2017-10-13 15:00:00	MSFT	Stock	77.6	77.64	77.42	77.5	2764728.0
2017-10-13 16:00:00	MSFT	Stock	77.49	77.54	77.49	77.54	3158785.0
2017-10-13 17:00:00	MSFT	Stock	77.49	77.49	77.41	77.49	8787.0
2017-10-13 18:00:00	MSFT	Stock	77.49	77.49	77.44	77.44	800.0
2017-10-13 19:00:00	MSFT	Stock	77.49	77.49	77.49	77.49	150.0
2017-10-13 04:00:00	NVDA	Stock	4.7855	4.7855	4.7798	4.7798	12000.0
2017-10-13 05:00:00	NVDA	Stock	4.7872	4.8635	4.7868	4.8625	789880.0
2017-10-13 06:00:00	NVDA	Stock	4.8523	4.855	4.8333	4.8375	669640.0
2017-10-13 07:00:00	NVDA	Stock	4.8378	4.8378	4.808	4.8162	2288560.0
2017-10-13 08:00:00	NVDA	Stock	4.8162	4.8435	4.8162	4.8313	6474800.0
2017-10-13 09:00:00	NVDA	Stock	4.8333	4.8438	4.7913	4.8154	109612240.0
2017-10-13 10:00:00	NVDA	Stock	4.8154	4.8318	4.7995	4.819	70969480.0
2017-10-13 11:00:00	NVDA	Stock	4.82	4.8625	4.8132	4.8585	93792760.0
2017-10-13 12:00:00	NVDA	Stock	4.8592	4.875	4.8485	4.854	92560480.0
2017-10-13 13:00:00	NVDA	Stock	4.8541	4.8725	4.8532	4.8566	59079800.0
2017-10-13 14:00:00	NVDA	Stock	4.8562	4.8658	4.8482	4.851	57314520.0
2017-10-13 15:00:00	NVDA	Stock	4.8508	4.867	4.8495	4.8648	78453960.0
2017-10-13 16:00:00	NVDA	Stock	4.8648	4.8663	4.8526	4.866	12940760.0
2017-10-13 17:00:00	NVDA	Stock	4.865	4.8663	4.8642	4.8642	377080.0
2017-10-13 18:00:00	NVDA	Stock	4.865	4.8663	4.8642	4.8663	418080.0
2017-10-13 19:00:00	NVDA	Stock	4.8658	4.8688	4.8642	4.867	497680.0
2017-10-13 06:00:00	AMZN	Stock	50.2395	50.2995	50.2055	50.25	37680.0
2017-10-13 07:00:00	AMZN	Stock	50.2135	50.25	50.145	50.2	60240.0

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

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