PREVIEW / stock_1hour / 2019-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-06.parquet
  size:    1.1 MB
  rows:    51,456
  symbols: 2,620

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-06 04:00:00	AAPL	Stock	51.425	51.425	50.955	50.9825	184068.0
2019-05-06 05:00:00	AAPL	Stock	50.955	51.325	50.95	51.2775	115092.0
2019-05-06 06:00:00	AAPL	Stock	51.25	51.3675	51.15	51.3625	210356.0
2019-05-06 07:00:00	AAPL	Stock	51.325	51.5425	51.2	51.425	955380.0
2019-05-06 08:00:00	AAPL	Stock	51.375	51.573	51.2025	51.425	1192844.0
2019-05-06 09:00:00	AAPL	Stock	51.435	52.02	50.875	51.9578	31137608.0
2019-05-06 10:00:00	AAPL	Stock	51.9525	52.1775	51.735	51.88	20159456.0
2019-05-06 11:00:00	AAPL	Stock	51.885	52.0875	51.7	51.925	12719600.0
2019-05-06 12:00:00	AAPL	Stock	51.9275	51.9738	51.65	51.695	10090412.0
2019-05-06 13:00:00	AAPL	Stock	51.695	51.945	51.6325	51.9075	6294836.0
2019-05-06 14:00:00	AAPL	Stock	51.905	52.195	51.8425	52.18	9692156.0
2019-05-06 15:00:00	AAPL	Stock	52.18	52.21	52.0425	52.15	12489560.0
2019-05-06 16:00:00	AAPL	Stock	52.12	52.145	51.72	51.72	9330272.0
2019-05-06 17:00:00	AAPL	Stock	51.7475	51.942	51.5875	51.6875	376128.0
2019-05-06 18:00:00	AAPL	Stock	51.675	51.825	51.665	51.775	123556.0
2019-05-06 19:00:00	AAPL	Stock	51.7775	51.92	51.77	51.8375	133428.0
2019-05-06 04:00:00	MSFT	Stock	126.7	126.7	125.63	126.12	29297.0
2019-05-06 05:00:00	MSFT	Stock	126.05	126.32	125.71	126.3	10160.0
2019-05-06 06:00:00	MSFT	Stock	126.36	126.59	126.24	126.5	9436.0
2019-05-06 07:00:00	MSFT	Stock	126.56	126.97	126.48	126.71	36152.0
2019-05-06 08:00:00	MSFT	Stock	126.76	127.1	126.45	126.95	88691.0
2019-05-06 09:00:00	MSFT	Stock	126.91	127.69	126.11	127.43	3248524.0
2019-05-06 10:00:00	MSFT	Stock	127.42	128.07	126.95	127.99	3185950.0
2019-05-06 11:00:00	MSFT	Stock	127.987	128.1	127.67	127.71	2104699.0
2019-05-06 12:00:00	MSFT	Stock	127.71	127.797	127.37	127.45	1626557.0
2019-05-06 13:00:00	MSFT	Stock	127.45	127.82	127.31	127.763	1222012.0
2019-05-06 14:00:00	MSFT	Stock	127.76	128.56	127.66	128.46	2170121.0
2019-05-06 15:00:00	MSFT	Stock	128.46	128.47	127.965	128.16	3660597.0
2019-05-06 16:00:00	MSFT	Stock	128.15	128.339	127.52	127.52	3103168.0
2019-05-06 17:00:00	MSFT	Stock	127.5	127.95	127.0	127.53	31389.0
2019-05-06 18:00:00	MSFT	Stock	127.52	127.6	127.28	127.5	12986.0
2019-05-06 19:00:00	MSFT	Stock	127.38	127.5	127.35	127.45	3234.0
2019-05-06 04:00:00	NVDA	Stock	4.46	4.46	4.3013	4.323	279560.0
2019-05-06 05:00:00	NVDA	Stock	4.348	4.3502	4.325	4.3498	168560.0
2019-05-06 06:00:00	NVDA	Stock	4.3315	4.3735	4.33	4.3735	84520.0
2019-05-06 07:00:00	NVDA	Stock	4.3672	4.4175	4.36	4.4	1794600.0
2019-05-06 08:00:00	NVDA	Stock	4.4139	4.4192	4.375	4.41	4110880.0
2019-05-06 09:00:00	NVDA	Stock	4.4065	4.4405	4.35	4.4325	96360000.0
2019-05-06 10:00:00	NVDA	Stock	4.4318	4.4722	4.4212	4.4622	62714320.0
2019-05-06 11:00:00	NVDA	Stock	4.4622	4.4688	4.4278	4.4392	55697960.0
2019-05-06 12:00:00	NVDA	Stock	4.4403	4.46	4.4312	4.447	30583760.0
2019-05-06 13:00:00	NVDA	Stock	4.446	4.468	4.4368	4.4678	22654080.0
2019-05-06 14:00:00	NVDA	Stock	4.468	4.5045	4.4585	4.5018	39616240.0
2019-05-06 15:00:00	NVDA	Stock	4.5025	4.5085	4.4878	4.497	60241000.0
2019-05-06 16:00:00	NVDA	Stock	4.4962	4.5071	4.4722	4.4722	15021320.0
2019-05-06 17:00:00	NVDA	Stock	4.4722	4.4795	4.46	4.461	595840.0
2019-05-06 18:00:00	NVDA	Stock	4.4618	4.4962	4.461	4.4682	90880.0
2019-05-06 19:00:00	NVDA	Stock	4.4688	4.475	4.4663	4.4672	215040.0
2019-05-06 04:00:00	AMZN	Stock	95.604	95.837	94.9115	94.9115	237960.0
2019-05-06 05:00:00	AMZN	Stock	94.8	95.4445	94.8	95.4445	162220.0

> showing 50 of 51,456 rows — these rows as CSV

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