PREVIEW / stock_1hour / 2017-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-12.parquet
  size:    1.0 MB
  rows:    47,749
  symbols: 3,035

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-05-12 04:00:00	AAPL	Stock	38.565	38.625	38.5525	38.6125	37952.0
2017-05-12 05:00:00	AAPL	Stock	38.58	38.58	38.5475	38.575	22848.0
2017-05-12 06:00:00	AAPL	Stock	38.58	38.59	38.545	38.56	34880.0
2017-05-12 07:00:00	AAPL	Stock	38.545	38.6475	38.525	38.6325	234788.0
2017-05-12 08:00:00	AAPL	Stock	38.6325	38.7125	38.565	38.7	624420.0
2017-05-12 09:00:00	AAPL	Stock	38.6975	38.985	38.6675	38.8975	27021072.0
2017-05-12 10:00:00	AAPL	Stock	38.9	39.105	38.8575	38.9427	27598376.0
2017-05-12 11:00:00	AAPL	Stock	38.9435	39.1	38.93	39.03	13638812.0
2017-05-12 12:00:00	AAPL	Stock	39.03	39.0575	38.9625	38.975	8665472.0
2017-05-12 13:00:00	AAPL	Stock	38.9762	39.0125	38.92	38.9938	10129148.0
2017-05-12 14:00:00	AAPL	Stock	38.9975	39.05	38.98	39.0	8057228.0
2017-05-12 15:00:00	AAPL	Stock	39.0	39.0325	38.8847	39.025	18036004.0
2017-05-12 16:00:00	AAPL	Stock	39.025	39.04	39.005	39.0225	5362632.0
2017-05-12 17:00:00	AAPL	Stock	39.0225	39.025	39.0075	39.02	42532.0
2017-05-12 18:00:00	AAPL	Stock	39.02	39.025	39.0075	39.02	45500.0
2017-05-12 19:00:00	AAPL	Stock	39.02	39.025	39.0	39.0175	38348.0
2017-05-12 04:00:00	MSFT	Stock	68.45	68.45	68.45	68.45	100.0
2017-05-12 06:00:00	MSFT	Stock	68.44	68.46	68.37	68.46	340.0
2017-05-12 08:00:00	MSFT	Stock	68.45	68.62	68.32	68.57	14809.0
2017-05-12 09:00:00	MSFT	Stock	68.56	68.64	68.06	68.08	2991816.0
2017-05-12 10:00:00	MSFT	Stock	68.08	68.21	68.04	68.185	2728000.0
2017-05-12 11:00:00	MSFT	Stock	68.19	68.321	68.185	68.28	1252797.0
2017-05-12 12:00:00	MSFT	Stock	68.285	68.44	68.25	68.4	877727.0
2017-05-12 13:00:00	MSFT	Stock	68.4	68.52	68.35	68.5	1084584.0
2017-05-12 14:00:00	MSFT	Stock	68.505	68.52	68.29	68.315	1886238.0
2017-05-12 15:00:00	MSFT	Stock	68.315	68.38	68.23	68.38	3390447.0
2017-05-12 16:00:00	MSFT	Stock	68.37	68.4	68.35	68.38	1733557.0
2017-05-12 17:00:00	MSFT	Stock	68.38	68.42	68.38	68.42	2341.0
2017-05-12 19:00:00	MSFT	Stock	68.42	68.42	68.36	68.36	1034.0
2017-05-12 04:00:00	NVDA	Stock	3.1375	3.1375	3.125	3.1325	120120.0
2017-05-12 05:00:00	NVDA	Stock	3.1345	3.1345	3.1338	3.1345	41040.0
2017-05-12 06:00:00	NVDA	Stock	3.1328	3.1375	3.1328	3.1372	165400.0
2017-05-12 07:00:00	NVDA	Stock	3.1375	3.1475	3.1312	3.1472	817040.0
2017-05-12 08:00:00	NVDA	Stock	3.1475	3.174	3.1312	3.174	9037840.0
2017-05-12 09:00:00	NVDA	Stock	3.1725	3.24	3.1625	3.1775	236380360.0
2017-05-12 10:00:00	NVDA	Stock	3.177	3.2093	3.1445	3.157	217222400.0
2017-05-12 11:00:00	NVDA	Stock	3.1575	3.1973	3.1574	3.1876	152606800.0
2017-05-12 12:00:00	NVDA	Stock	3.1875	3.2093	3.1725	3.202	84922560.0
2017-05-12 13:00:00	NVDA	Stock	3.202	3.2023	3.1823	3.1854	63953320.0
2017-05-12 14:00:00	NVDA	Stock	3.186	3.203	3.1788	3.1868	52117280.0
2017-05-12 15:00:00	NVDA	Stock	3.1868	3.1988	3.1758	3.1973	98671080.0
2017-05-12 16:00:00	NVDA	Stock	3.1975	3.1992	3.193	3.1973	9120480.0
2017-05-12 17:00:00	NVDA	Stock	3.198	3.2	3.1962	3.1965	414000.0
2017-05-12 18:00:00	NVDA	Stock	3.1995	3.1995	3.1965	3.1985	215760.0
2017-05-12 19:00:00	NVDA	Stock	3.1985	3.2	3.1978	3.2	577720.0
2017-05-12 04:00:00	AMZN	Stock	47.3695	47.3695	47.3695	47.3695	4000.0
2017-05-12 07:00:00	AMZN	Stock	47.3795	47.3795	47.3795	47.3795	2000.0
2017-05-12 08:00:00	AMZN	Stock	47.3	47.581	47.3	47.5505	400740.0
2017-05-12 09:00:00	AMZN	Stock	47.575	47.823	47.5505	47.698	12688440.0
2017-05-12 10:00:00	AMZN	Stock	47.6821	47.7675	47.6326	47.7608	7089980.0

> showing 50 of 47,749 rows — these rows as CSV

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