PREVIEW / stock_1hour / 2019-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-01.parquet
  size:    1.1 MB
  rows:    49,663
  symbols: 2,667

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-01 04:00:00	AAPL	Stock	41.6875	41.74	41.6875	41.74	9968.0
2019-02-01 05:00:00	AAPL	Stock	41.6475	41.755	41.6475	41.65	10852.0
2019-02-01 06:00:00	AAPL	Stock	41.59	41.6475	41.59	41.6475	5780.0
2019-02-01 07:00:00	AAPL	Stock	41.645	41.6625	41.5825	41.625	79208.0
2019-02-01 08:00:00	AAPL	Stock	41.63	41.8	41.5275	41.7675	578560.0
2019-02-01 09:00:00	AAPL	Stock	41.7825	42.035	41.6675	41.7775	15280956.0
2019-02-01 10:00:00	AAPL	Stock	41.775	42.245	41.7475	42.01	20675832.0
2019-02-01 11:00:00	AAPL	Stock	42.0075	42.0825	41.8825	41.9725	11180256.0
2019-02-01 12:00:00	AAPL	Stock	41.9715	41.9775	41.75	41.795	9693840.0
2019-02-01 13:00:00	AAPL	Stock	41.7975	41.825	41.595	41.7575	9697960.0
2019-02-01 14:00:00	AAPL	Stock	41.7572	41.7638	41.4825	41.5375	11096148.0
2019-02-01 15:00:00	AAPL	Stock	41.535	41.69	41.49	41.6325	16072312.0
2019-02-01 16:00:00	AAPL	Stock	41.63	41.71	41.63	41.6625	24699104.0
2019-02-01 17:00:00	AAPL	Stock	41.6525	41.6675	41.65	41.665	29308.0
2019-02-01 18:00:00	AAPL	Stock	41.6425	41.6625	41.635	41.65	28876.0
2019-02-01 19:00:00	AAPL	Stock	41.6375	41.65	41.625	41.6375	42536.0
2019-02-01 04:00:00	MSFT	Stock	104.52	104.52	104.44	104.5	7095.0
2019-02-01 05:00:00	MSFT	Stock	104.44	104.44	104.02	104.04	8489.0
2019-02-01 06:00:00	MSFT	Stock	104.06	104.24	104.06	104.21	1776.0
2019-02-01 07:00:00	MSFT	Stock	104.25	104.25	104.1	104.12	9989.0
2019-02-01 08:00:00	MSFT	Stock	104.35	104.69	104.01	104.48	32324.0
2019-02-01 09:00:00	MSFT	Stock	104.42	104.57	103.45	103.534	4190388.0
2019-02-01 10:00:00	MSFT	Stock	103.54	104.1	103.54	103.6	4051105.0
2019-02-01 11:00:00	MSFT	Stock	103.59	103.71	103.38	103.65	2576816.0
2019-02-01 12:00:00	MSFT	Stock	103.65	103.682	103.18	103.21	2586698.0
2019-02-01 13:00:00	MSFT	Stock	103.205	103.205	102.54	102.63	2821304.0
2019-02-01 14:00:00	MSFT	Stock	102.63	102.72	102.35	102.426	2802195.0
2019-02-01 15:00:00	MSFT	Stock	102.42	102.95	102.35	102.82	5532437.0
2019-02-01 16:00:00	MSFT	Stock	102.78	102.78	102.65	102.73	7199379.0
2019-02-01 17:00:00	MSFT	Stock	102.71	102.78	102.61	102.62	26855.0
2019-02-01 18:00:00	MSFT	Stock	102.75	102.75	102.64	102.7	4079.0
2019-02-01 19:00:00	MSFT	Stock	102.7	102.8	102.7	102.8	6737.0
2019-02-01 04:00:00	NVDA	Stock	3.6112	3.6112	3.6058	3.6058	72000.0
2019-02-01 05:00:00	NVDA	Stock	3.6058	3.6058	3.5675	3.5825	56480.0
2019-02-01 06:00:00	NVDA	Stock	3.596	3.5972	3.5888	3.5938	34440.0
2019-02-01 07:00:00	NVDA	Stock	3.5972	3.5972	3.57	3.57	602920.0
2019-02-01 08:00:00	NVDA	Stock	3.5938	3.6058	3.57	3.5992	1967800.0
2019-02-01 09:00:00	NVDA	Stock	3.6095	3.6585	3.565	3.5651	103591040.0
2019-02-01 10:00:00	NVDA	Stock	3.567	3.654	3.5645	3.6149	132571600.0
2019-02-01 11:00:00	NVDA	Stock	3.6145	3.6698	3.6125	3.6655	62158760.0
2019-02-01 12:00:00	NVDA	Stock	3.6665	3.6692	3.6355	3.642	51482560.0
2019-02-01 13:00:00	NVDA	Stock	3.6415	3.6632	3.6253	3.6291	49863840.0
2019-02-01 14:00:00	NVDA	Stock	3.6292	3.6362	3.602	3.6118	50923480.0
2019-02-01 15:00:00	NVDA	Stock	3.6112	3.6233	3.6052	3.6182	72750640.0
2019-02-01 16:00:00	NVDA	Stock	3.6182	3.6228	3.615	3.6228	31715440.0
2019-02-01 17:00:00	NVDA	Stock	3.6193	3.6238	3.6193	3.6208	130920.0
2019-02-01 18:00:00	NVDA	Stock	3.621	3.621	3.6178	3.618	1182800.0
2019-02-01 19:00:00	NVDA	Stock	3.6182	3.6212	3.6182	3.6212	97760.0
2019-02-01 04:00:00	AMZN	Stock	81.9245	82.0	81.25	82.0	191100.0
2019-02-01 05:00:00	AMZN	Stock	82.037	82.32	82.037	82.15	102460.0

> showing 50 of 49,663 rows — these rows as CSV

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