PREVIEW / stock_1hour / 2019-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-02.parquet
  size:    1.1 MB
  rows:    48,991
  symbols: 2,617

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-05-02 04:00:00	AAPL	Stock	52.6625	52.6625	52.515	52.585	99172.0
2019-05-02 05:00:00	AAPL	Stock	52.58	52.7425	52.575	52.7425	69648.0
2019-05-02 06:00:00	AAPL	Stock	52.74	52.75	52.6525	52.725	46160.0
2019-05-02 07:00:00	AAPL	Stock	52.6775	52.735	52.5825	52.655	188148.0
2019-05-02 08:00:00	AAPL	Stock	52.6275	52.735	52.575	52.61	559876.0
2019-05-02 09:00:00	AAPL	Stock	52.6125	53.1375	52.375	53.115	22236780.0
2019-05-02 10:00:00	AAPL	Stock	53.1132	53.1625	52.74	52.7775	18663956.0
2019-05-02 11:00:00	AAPL	Stock	52.78	52.88	52.0325	52.1575	19457224.0
2019-05-02 12:00:00	AAPL	Stock	52.1625	52.4225	52.1125	52.18	10345460.0
2019-05-02 13:00:00	AAPL	Stock	52.1775	52.5725	52.1025	52.4025	9226808.0
2019-05-02 14:00:00	AAPL	Stock	52.41	52.555	52.2425	52.35	7394524.0
2019-05-02 15:00:00	AAPL	Stock	52.345	52.475	52.1675	52.2925	13400164.0
2019-05-02 16:00:00	AAPL	Stock	52.2875	52.33	52.24	52.2875	4262380.0
2019-05-02 17:00:00	AAPL	Stock	52.2975	52.3125	52.2875	52.29	62364.0
2019-05-02 18:00:00	AAPL	Stock	52.3	52.3125	52.29	52.29	19672.0
2019-05-02 19:00:00	AAPL	Stock	52.3	52.325	52.25	52.275	69672.0
2019-05-02 04:00:00	MSFT	Stock	128.14	128.25	128.09	128.22	3498.0
2019-05-02 05:00:00	MSFT	Stock	128.23	128.58	128.23	128.47	7539.0
2019-05-02 06:00:00	MSFT	Stock	128.45	128.45	128.34	128.34	3000.0
2019-05-02 07:00:00	MSFT	Stock	128.35	128.35	128.0	128.1	10780.0
2019-05-02 08:00:00	MSFT	Stock	128.25	128.39	127.88	127.98	19107.0
2019-05-02 09:00:00	MSFT	Stock	128.0	128.1	127.01	127.05	2787592.0
2019-05-02 10:00:00	MSFT	Stock	127.06	127.98	127.044	127.285	2682217.0
2019-05-02 11:00:00	MSFT	Stock	127.29	127.45	125.56	125.77	3980644.0
2019-05-02 12:00:00	MSFT	Stock	125.779	126.46	125.66	125.77	2952577.0
2019-05-02 13:00:00	MSFT	Stock	125.77	126.53	125.52	126.04	2838128.0
2019-05-02 14:00:00	MSFT	Stock	126.05	126.695	126.01	126.3	2599466.0
2019-05-02 15:00:00	MSFT	Stock	126.3	126.63	126.0	126.2	4475337.0
2019-05-02 16:00:00	MSFT	Stock	126.21	126.95	126.08	126.22	1588851.0
2019-05-02 17:00:00	MSFT	Stock	126.2	126.25	126.18	126.204	5248.0
2019-05-02 18:00:00	MSFT	Stock	126.23	126.32	126.21	126.25	5025.0
2019-05-02 19:00:00	MSFT	Stock	126.25	126.47	126.25	126.3	9464.0
2019-05-02 04:00:00	NVDA	Stock	4.525	4.525	4.525	4.525	4000.0
2019-05-02 05:00:00	NVDA	Stock	4.5255	4.5255	4.5255	4.5255	4000.0
2019-05-02 06:00:00	NVDA	Stock	4.5275	4.5275	4.52	4.52	69440.0
2019-05-02 07:00:00	NVDA	Stock	4.5212	4.5273	4.5	4.5273	177360.0
2019-05-02 08:00:00	NVDA	Stock	4.5075	4.545	4.5075	4.5333	1197920.0
2019-05-02 09:00:00	NVDA	Stock	4.5298	4.5758	4.4779	4.566	59303200.0
2019-05-02 10:00:00	NVDA	Stock	4.5687	4.6218	4.5665	4.5825	86431160.0
2019-05-02 11:00:00	NVDA	Stock	4.5825	4.6053	4.5115	4.5232	64800080.0
2019-05-02 12:00:00	NVDA	Stock	4.5248	4.555	4.5165	4.5308	32210880.0
2019-05-02 13:00:00	NVDA	Stock	4.53	4.5708	4.5168	4.5597	40891440.0
2019-05-02 14:00:00	NVDA	Stock	4.5598	4.5795	4.5445	4.563	31781240.0
2019-05-02 15:00:00	NVDA	Stock	4.5625	4.582	4.5593	4.5798	40580040.0
2019-05-02 16:00:00	NVDA	Stock	4.5798	4.5798	4.5375	4.5665	9205000.0
2019-05-02 17:00:00	NVDA	Stock	4.55	4.5611	4.535	4.5472	516880.0
2019-05-02 18:00:00	NVDA	Stock	4.5438	4.5498	4.5383	4.5438	55960.0
2019-05-02 19:00:00	NVDA	Stock	4.5438	4.5558	4.5415	4.5415	88920.0
2019-05-02 04:00:00	AMZN	Stock	95.7145	95.9145	95.67	95.9145	20000.0
2019-05-02 05:00:00	AMZN	Stock	96.125	96.125	96.053	96.053	4000.0

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

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