PREVIEW / stock_1hour / 2019-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-25.parquet
  size:    1.1 MB
  rows:    50,955
  symbols: 2,662

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
2019-02-25 04:00:00	AAPL	Stock	43.4175	43.5025	43.4075	43.495	14632.0
2019-02-25 05:00:00	AAPL	Stock	43.495	43.5275	43.4825	43.5225	29860.0
2019-02-25 06:00:00	AAPL	Stock	43.5225	43.67	43.52	43.65	36540.0
2019-02-25 07:00:00	AAPL	Stock	43.625	43.6475	43.5275	43.5725	210076.0
2019-02-25 08:00:00	AAPL	Stock	43.5875	43.665	43.375	43.54	642824.0
2019-02-25 09:00:00	AAPL	Stock	43.5475	43.9025	43.47	43.8425	15561856.0
2019-02-25 10:00:00	AAPL	Stock	43.85	43.9675	43.7605	43.855	14169692.0
2019-02-25 11:00:00	AAPL	Stock	43.855	43.905	43.7525	43.8488	8541976.0
2019-02-25 12:00:00	AAPL	Stock	43.8475	43.8662	43.5575	43.5975	8871924.0
2019-02-25 13:00:00	AAPL	Stock	43.5975	43.65	43.5075	43.6188	6053412.0
2019-02-25 14:00:00	AAPL	Stock	43.6188	43.72	43.6062	43.695	5859280.0
2019-02-25 15:00:00	AAPL	Stock	43.6975	43.7075	43.52	43.565	11449844.0
2019-02-25 16:00:00	AAPL	Stock	43.565	43.57	43.49	43.4975	6512924.0
2019-02-25 17:00:00	AAPL	Stock	43.4975	43.5125	43.43	43.4375	41448.0
2019-02-25 18:00:00	AAPL	Stock	43.4375	43.4375	43.38	43.39	18444.0
2019-02-25 19:00:00	AAPL	Stock	43.4075	43.4475	43.3775	43.41	36180.0
2019-02-25 04:00:00	MSFT	Stock	111.73	111.73	111.47	111.47	2120.0
2019-02-25 05:00:00	MSFT	Stock	111.5	111.82	111.5	111.75	5339.0
2019-02-25 06:00:00	MSFT	Stock	111.67	111.8	111.6	111.8	1773.0
2019-02-25 07:00:00	MSFT	Stock	111.66	111.87	111.6	111.87	51019.0
2019-02-25 08:00:00	MSFT	Stock	111.83	112.1	111.6	111.95	59801.0
2019-02-25 09:00:00	MSFT	Stock	111.98	112.14	111.26	111.57	3563016.0
2019-02-25 10:00:00	MSFT	Stock	111.57	112.18	111.42	112.015	2934782.0
2019-02-25 11:00:00	MSFT	Stock	112.02	112.08	111.77	111.92	2062287.0
2019-02-25 12:00:00	MSFT	Stock	111.91	111.935	111.33	111.545	2074051.0
2019-02-25 13:00:00	MSFT	Stock	111.56	111.69	111.435	111.64	1505851.0
2019-02-25 14:00:00	MSFT	Stock	111.63	111.99	111.595	111.83	1730207.0
2019-02-25 15:00:00	MSFT	Stock	111.83	111.95	111.51	111.59	3807719.0
2019-02-25 16:00:00	MSFT	Stock	111.64	111.69	111.41	111.46	2694012.0
2019-02-25 17:00:00	MSFT	Stock	111.47	111.59	111.41	111.45	4597.0
2019-02-25 18:00:00	MSFT	Stock	111.5	111.5	111.33	111.4	7129.0
2019-02-25 19:00:00	MSFT	Stock	111.41	111.49	111.35	111.35	2336.0
2019-02-25 04:00:00	NVDA	Stock	4.0135	4.025	4.0135	4.025	29000.0
2019-02-25 05:00:00	NVDA	Stock	4.0368	4.0375	4.03	4.03	53120.0
2019-02-25 06:00:00	NVDA	Stock	4.045	4.0468	4.045	4.0468	59400.0
2019-02-25 07:00:00	NVDA	Stock	4.045	4.0632	4.0375	4.0585	1666160.0
2019-02-25 08:00:00	NVDA	Stock	4.0565	4.0665	3.9898	4.0648	2692000.0
2019-02-25 09:00:00	NVDA	Stock	4.0625	4.132	4.0413	4.0946	120064120.0
2019-02-25 10:00:00	NVDA	Stock	4.094	4.1035	4.039	4.0619	91618960.0
2019-02-25 11:00:00	NVDA	Stock	4.0623	4.077	4.0375	4.048	55319440.0
2019-02-25 12:00:00	NVDA	Stock	4.0478	4.0615	4.0092	4.0215	56494520.0
2019-02-25 13:00:00	NVDA	Stock	4.0208	4.029	4.005	4.0105	43022640.0
2019-02-25 14:00:00	NVDA	Stock	4.01	4.0118	3.9818	3.9842	63754360.0
2019-02-25 15:00:00	NVDA	Stock	3.9842	3.988	3.9585	3.9672	107195480.0
2019-02-25 16:00:00	NVDA	Stock	3.9672	3.9722	3.9588	3.9672	33402800.0
2019-02-25 17:00:00	NVDA	Stock	3.9675	3.973	3.9675	3.9725	490480.0
2019-02-25 18:00:00	NVDA	Stock	3.9728	3.9732	3.9638	3.9665	433160.0
2019-02-25 19:00:00	NVDA	Stock	3.9663	3.972	3.9625	3.9638	586800.0
2019-02-25 04:00:00	AMZN	Stock	81.75	81.75	81.75	81.75	2000.0
2019-02-25 05:00:00	AMZN	Stock	82.0	82.05	82.0	82.05	10920.0

> showing 50 of 50,955 rows — these rows as CSV

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