PREVIEW / stock_1hour / 2018-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-31.parquet
  size:    1.1 MB
  rows:    48,578
  symbols: 2,788

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-31 04:00:00	AAPL	Stock	56.36	56.375	56.325	56.33	26848.0
2018-08-31 05:00:00	AAPL	Stock	56.4375	56.4725	56.33	56.33	32232.0
2018-08-31 06:00:00	AAPL	Stock	56.305	56.4	56.305	56.395	16848.0
2018-08-31 07:00:00	AAPL	Stock	56.4	56.4575	56.37	56.4325	287056.0
2018-08-31 08:00:00	AAPL	Stock	56.41	56.62	56.3625	56.4775	1217768.0
2018-08-31 09:00:00	AAPL	Stock	56.48	57.07	56.4625	56.959	23455504.0
2018-08-31 10:00:00	AAPL	Stock	56.9575	57.2175	56.8225	57.0175	25449108.0
2018-08-31 11:00:00	AAPL	Stock	57.0162	57.145	56.655	56.765	16601808.0
2018-08-31 12:00:00	AAPL	Stock	56.765	57.1175	56.7175	57.1125	13906052.0
2018-08-31 13:00:00	AAPL	Stock	57.1105	57.16	56.875	56.9652	9592580.0
2018-08-31 14:00:00	AAPL	Stock	56.9675	56.9825	56.7598	56.8795	9179752.0
2018-08-31 15:00:00	AAPL	Stock	56.878	57.0075	56.7875	56.8775	22710764.0
2018-08-31 16:00:00	AAPL	Stock	56.875	56.97	56.875	56.945	25121064.0
2018-08-31 17:00:00	AAPL	Stock	56.9475	56.975	56.925	56.955	104184.0
2018-08-31 18:00:00	AAPL	Stock	56.975	56.975	56.9325	56.9625	64452.0
2018-08-31 19:00:00	AAPL	Stock	56.95	57.0	56.95	56.9825	52468.0
2018-08-31 04:00:00	MSFT	Stock	111.78	111.78	111.78	111.78	100.0
2018-08-31 07:00:00	MSFT	Stock	111.6	111.79	111.6	111.79	1669.0
2018-08-31 08:00:00	MSFT	Stock	111.92	111.92	111.56	111.7	11327.0
2018-08-31 09:00:00	MSFT	Stock	111.62	112.4	111.51	112.22	2180710.0
2018-08-31 10:00:00	MSFT	Stock	112.21	112.77	112.15	112.71	2223410.0
2018-08-31 11:00:00	MSFT	Stock	112.708	112.777	111.9	111.9	2367372.0
2018-08-31 12:00:00	MSFT	Stock	111.9	112.09	111.78	111.96	1561288.0
2018-08-31 13:00:00	MSFT	Stock	111.955	111.955	111.76	111.88	857547.0
2018-08-31 14:00:00	MSFT	Stock	111.88	111.9	111.515	111.73	1451043.0
2018-08-31 15:00:00	MSFT	Stock	111.73	112.56	111.73	112.33	4940375.0
2018-08-31 16:00:00	MSFT	Stock	112.33	112.38	112.02	112.33	4606375.0
2018-08-31 17:00:00	MSFT	Stock	112.35	112.35	112.33	112.33	758.0
2018-08-31 18:00:00	MSFT	Stock	112.36	112.45	112.33	112.45	1111.0
2018-08-31 19:00:00	MSFT	Stock	112.42	112.43	112.35	112.35	3305.0
2018-08-31 04:00:00	NVDA	Stock	6.9348	6.9493	6.9348	6.9472	84440.0
2018-08-31 07:00:00	NVDA	Stock	6.9422	6.9475	6.935	6.9375	80880.0
2018-08-31 08:00:00	NVDA	Stock	6.95	6.95	6.9288	6.9375	375880.0
2018-08-31 09:00:00	NVDA	Stock	6.934	7.0078	6.915	6.99	42823200.0
2018-08-31 10:00:00	NVDA	Stock	6.988	7.025	6.9788	7.0168	40130280.0
2018-08-31 11:00:00	NVDA	Stock	7.0178	7.028	6.9928	7.0037	29724760.0
2018-08-31 12:00:00	NVDA	Stock	7.0045	7.022	6.9925	7.0159	21534600.0
2018-08-31 13:00:00	NVDA	Stock	7.0153	7.03	7.0112	7.0248	25320160.0
2018-08-31 14:00:00	NVDA	Stock	7.0254	7.0272	7.0142	7.0215	30234520.0
2018-08-31 15:00:00	NVDA	Stock	7.0222	7.0293	6.9993	7.0178	62353960.0
2018-08-31 16:00:00	NVDA	Stock	7.017	7.0278	7.0165	7.017	3906480.0
2018-08-31 17:00:00	NVDA	Stock	7.0178	7.0288	7.017	7.0252	313720.0
2018-08-31 18:00:00	NVDA	Stock	7.03	7.03	7.0275	7.0275	9000.0
2018-08-31 19:00:00	NVDA	Stock	7.03	7.0312	7.0275	7.0275	122120.0
2018-08-31 04:00:00	AMZN	Stock	100.1	100.29	100.005	100.005	20300.0
2018-08-31 06:00:00	AMZN	Stock	100.25	100.25	100.25	100.25	10200.0
2018-08-31 07:00:00	AMZN	Stock	100.25	100.3245	100.2465	100.25	45000.0
2018-08-31 08:00:00	AMZN	Stock	100.3435	100.5555	100.155	100.375	478500.0
2018-08-31 09:00:00	AMZN	Stock	100.3925	101.027	100.237	100.822	14789480.0
2018-08-31 10:00:00	AMZN	Stock	100.8022	101.119	100.7565	100.879	7705760.0

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

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