PREVIEW / stock_1hour / 2019-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-20.parquet
  size:    1.1 MB
  rows:    49,537
  symbols: 2,642

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-03-20 04:00:00	AAPL	Stock	46.525	46.6875	46.5075	46.6875	11008.0
2019-03-20 05:00:00	AAPL	Stock	46.6825	46.695	46.625	46.67	34196.0
2019-03-20 06:00:00	AAPL	Stock	46.6325	46.7375	46.625	46.625	7804.0
2019-03-20 07:00:00	AAPL	Stock	46.625	46.6275	46.535	46.625	61840.0
2019-03-20 08:00:00	AAPL	Stock	46.575	46.7475	46.5335	46.55	157900.0
2019-03-20 09:00:00	AAPL	Stock	46.56	46.655	46.1825	46.355	13801164.0
2019-03-20 10:00:00	AAPL	Stock	46.3575	46.8442	46.3525	46.7725	12862752.0
2019-03-20 11:00:00	AAPL	Stock	46.7725	46.81	46.5375	46.5825	8883372.0
2019-03-20 12:00:00	AAPL	Stock	46.5825	46.8	46.5825	46.737	8543556.0
2019-03-20 13:00:00	AAPL	Stock	46.735	46.79	46.6925	46.79	4675324.0
2019-03-20 14:00:00	AAPL	Stock	46.79	47.3725	46.77	47.2028	20136756.0
2019-03-20 15:00:00	AAPL	Stock	47.205	47.245	46.9675	47.0425	17494104.0
2019-03-20 16:00:00	AAPL	Stock	47.04	47.04	46.955	46.995	13796612.0
2019-03-20 17:00:00	AAPL	Stock	46.955	47.0	46.955	46.9975	30904.0
2019-03-20 18:00:00	AAPL	Stock	47.0	47.0325	46.965	47.025	26864.0
2019-03-20 19:00:00	AAPL	Stock	47.0325	47.1225	47.0325	47.1225	32680.0
2019-03-20 04:00:00	MSFT	Stock	117.5	117.53	117.5	117.53	505.0
2019-03-20 05:00:00	MSFT	Stock	117.58	117.63	117.58	117.63	200.0
2019-03-20 06:00:00	MSFT	Stock	117.65	117.71	117.6	117.65	1367.0
2019-03-20 07:00:00	MSFT	Stock	117.53	117.53	117.4	117.48	1228.0
2019-03-20 08:00:00	MSFT	Stock	117.3	117.59	117.3	117.3	9403.0
2019-03-20 09:00:00	MSFT	Stock	117.3	117.53	116.71	116.88	2435180.0
2019-03-20 10:00:00	MSFT	Stock	116.88	117.545	116.86	117.33	2599982.0
2019-03-20 11:00:00	MSFT	Stock	117.35	117.59	117.035	117.105	2014718.0
2019-03-20 12:00:00	MSFT	Stock	117.11	117.535	116.965	117.28	2252333.0
2019-03-20 13:00:00	MSFT	Stock	117.27	117.31	117.15	117.3	1018046.0
2019-03-20 14:00:00	MSFT	Stock	117.29	118.75	117.29	118.35	4496000.0
2019-03-20 15:00:00	MSFT	Stock	118.36	118.48	117.43	117.52	5272875.0
2019-03-20 16:00:00	MSFT	Stock	117.52	117.657	117.4	117.45	3624305.0
2019-03-20 17:00:00	MSFT	Stock	117.5	117.5	117.5	117.5	1078.0
2019-03-20 18:00:00	MSFT	Stock	117.42	117.58	117.33	117.58	10865.0
2019-03-20 19:00:00	MSFT	Stock	117.59	117.59	117.45	117.57	5036.0
2019-03-20 04:00:00	NVDA	Stock	4.425	4.43	4.4225	4.43	27400.0
2019-03-20 05:00:00	NVDA	Stock	4.4075	4.4075	4.4075	4.4075	17480.0
2019-03-20 06:00:00	NVDA	Stock	4.4072	4.4175	4.402	4.4075	133160.0
2019-03-20 07:00:00	NVDA	Stock	4.412	4.4122	4.3928	4.4075	867560.0
2019-03-20 08:00:00	NVDA	Stock	4.4	4.4112	4.3763	4.3785	2486360.0
2019-03-20 09:00:00	NVDA	Stock	4.3775	4.4758	4.3775	4.3958	162555160.0
2019-03-20 10:00:00	NVDA	Stock	4.3965	4.4238	4.3538	4.395	124214520.0
2019-03-20 11:00:00	NVDA	Stock	4.3952	4.3998	4.35	4.3608	59670320.0
2019-03-20 12:00:00	NVDA	Stock	4.3618	4.3685	4.3288	4.3467	50843800.0
2019-03-20 13:00:00	NVDA	Stock	4.3468	4.3468	4.325	4.3415	35284760.0
2019-03-20 14:00:00	NVDA	Stock	4.3415	4.4062	4.3398	4.3865	105533440.0
2019-03-20 15:00:00	NVDA	Stock	4.3868	4.3965	4.349	4.36	82930720.0
2019-03-20 16:00:00	NVDA	Stock	4.36	4.365	4.3468	4.3525	35581200.0
2019-03-20 17:00:00	NVDA	Stock	4.36	4.3752	4.3575	4.3742	874560.0
2019-03-20 18:00:00	NVDA	Stock	4.375	4.3772	4.37	4.3763	527720.0
2019-03-20 19:00:00	NVDA	Stock	4.375	4.39	4.375	4.3898	902520.0
2019-03-20 06:00:00	AMZN	Stock	88.15	88.15	88.15	88.15	4000.0
2019-03-20 07:00:00	AMZN	Stock	88.185	88.687	88.14	88.687	321620.0

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

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