PREVIEW / stock_1hour / 2018-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-08.parquet
  size:    1.1 MB
  rows:    48,779
  symbols: 2,774

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
2018-08-08 04:00:00	AAPL	Stock	51.7	51.7	51.615	51.615	18080.0
2018-08-08 05:00:00	AAPL	Stock	51.69	51.75	51.625	51.625	23496.0
2018-08-08 06:00:00	AAPL	Stock	51.625	51.665	51.55	51.665	36892.0
2018-08-08 07:00:00	AAPL	Stock	51.665	51.7575	51.625	51.625	193836.0
2018-08-08 08:00:00	AAPL	Stock	51.745	51.7625	51.5752	51.6	179180.0
2018-08-08 09:00:00	AAPL	Stock	51.61	51.6275	51.13	51.52	17945376.0
2018-08-08 10:00:00	AAPL	Stock	51.525	51.9525	51.5125	51.894	15631968.0
2018-08-08 11:00:00	AAPL	Stock	51.895	51.905	51.6725	51.6918	8633820.0
2018-08-08 12:00:00	AAPL	Stock	51.695	51.83	51.64	51.8	4932128.0
2018-08-08 13:00:00	AAPL	Stock	51.795	51.8175	51.6975	51.7832	4438920.0
2018-08-08 14:00:00	AAPL	Stock	51.785	51.8725	51.745	51.835	5705416.0
2018-08-08 15:00:00	AAPL	Stock	51.8375	51.88	51.7975	51.8125	9601536.0
2018-08-08 16:00:00	AAPL	Stock	51.8125	51.8125	51.7375	51.7475	8459036.0
2018-08-08 17:00:00	AAPL	Stock	51.74	51.745	51.7125	51.7375	57148.0
2018-08-08 18:00:00	AAPL	Stock	51.715	51.7375	51.715	51.7225	21860.0
2018-08-08 19:00:00	AAPL	Stock	51.735	51.75	51.7	51.75	79920.0
2018-08-08 04:00:00	MSFT	Stock	108.22	108.9	108.22	108.9	696.0
2018-08-08 05:00:00	MSFT	Stock	108.9	108.9	108.8	108.8	1347.0
2018-08-08 06:00:00	MSFT	Stock	108.8	108.8	108.8	108.8	300.0
2018-08-08 07:00:00	MSFT	Stock	108.77	108.87	108.77	108.8	3454.0
2018-08-08 08:00:00	MSFT	Stock	108.8	108.8	108.62	108.65	10916.0
2018-08-08 09:00:00	MSFT	Stock	108.71	109.37	108.63	108.86	2299430.0
2018-08-08 10:00:00	MSFT	Stock	108.865	109.34	108.79	109.29	1884171.0
2018-08-08 11:00:00	MSFT	Stock	109.29	109.41	109.025	109.045	1340752.0
2018-08-08 12:00:00	MSFT	Stock	109.04	109.23	108.96	109.15	1149433.0
2018-08-08 13:00:00	MSFT	Stock	109.15	109.3	109.09	109.29	975665.0
2018-08-08 14:00:00	MSFT	Stock	109.3	109.52	109.2	109.42	1186535.0
2018-08-08 15:00:00	MSFT	Stock	109.43	109.75	109.4	109.48	2910493.0
2018-08-08 16:00:00	MSFT	Stock	109.49	109.5	109.2	109.3	2077082.0
2018-08-08 17:00:00	MSFT	Stock	109.49	109.49	109.02	109.19	20143.0
2018-08-08 18:00:00	MSFT	Stock	109.15	109.3	109.15	109.3	9597.0
2018-08-08 19:00:00	MSFT	Stock	109.25	109.28	109.25	109.25	3982.0
2018-08-08 07:00:00	NVDA	Stock	6.4238	6.4238	6.4238	6.4238	36320.0
2018-08-08 08:00:00	NVDA	Stock	6.4448	6.4448	6.405	6.4062	397240.0
2018-08-08 09:00:00	NVDA	Stock	6.4062	6.475	6.3815	6.4678	43723360.0
2018-08-08 10:00:00	NVDA	Stock	6.4719	6.5013	6.4625	6.4953	51832480.0
2018-08-08 11:00:00	NVDA	Stock	6.4953	6.506	6.48	6.4857	27353000.0
2018-08-08 12:00:00	NVDA	Stock	6.4865	6.491	6.4625	6.4778	16722040.0
2018-08-08 13:00:00	NVDA	Stock	6.4782	6.4908	6.4725	6.4852	12023400.0
2018-08-08 14:00:00	NVDA	Stock	6.4859	6.4859	6.4708	6.4765	11363640.0
2018-08-08 15:00:00	NVDA	Stock	6.4762	6.4808	6.456	6.46	28182200.0
2018-08-08 16:00:00	NVDA	Stock	6.4605	6.471	6.458	6.4658	38345720.0
2018-08-08 17:00:00	NVDA	Stock	6.4588	6.4688	6.4588	6.465	55960.0
2018-08-08 18:00:00	NVDA	Stock	6.465	6.465	6.462	6.463	172280.0
2018-08-08 19:00:00	NVDA	Stock	6.4638	6.4658	6.4578	6.4578	246320.0
2018-08-08 04:00:00	AMZN	Stock	93.3	93.3	93.255	93.255	6000.0
2018-08-08 05:00:00	AMZN	Stock	93.2495	93.32	93.2495	93.32	12400.0
2018-08-08 07:00:00	AMZN	Stock	93.275	93.325	93.2	93.2795	78780.0
2018-08-08 08:00:00	AMZN	Stock	93.325	93.325	92.9	92.947	203480.0
2018-08-08 09:00:00	AMZN	Stock	92.9005	93.5	92.725	93.311	8987520.0

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

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