PREVIEW / stock_1hour / 2018-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-19.parquet
  size:    1.1 MB
  rows:    50,175
  symbols: 2,728

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-12-19 04:00:00	AAPL	Stock	41.6075	41.6075	41.575	41.575	6092.0
2018-12-19 05:00:00	AAPL	Stock	41.5925	41.7425	41.5925	41.665	3216.0
2018-12-19 06:00:00	AAPL	Stock	41.675	41.7	41.675	41.675	3116.0
2018-12-19 07:00:00	AAPL	Stock	41.63	41.7175	41.615	41.6725	49680.0
2018-12-19 08:00:00	AAPL	Stock	41.67	41.73	41.5075	41.5825	340144.0
2018-12-19 09:00:00	AAPL	Stock	41.5825	41.7875	41.24	41.6875	13108948.0
2018-12-19 10:00:00	AAPL	Stock	41.6875	41.8625	41.5603	41.65	14303008.0
2018-12-19 11:00:00	AAPL	Stock	41.6545	41.675	41.4425	41.6425	8436624.0
2018-12-19 12:00:00	AAPL	Stock	41.645	41.81	41.63	41.6512	7824212.0
2018-12-19 13:00:00	AAPL	Stock	41.65	41.75	41.465	41.7375	8636836.0
2018-12-19 14:00:00	AAPL	Stock	41.6975	41.8175	40.3	40.435	41424796.0
2018-12-19 15:00:00	AAPL	Stock	40.4375	40.4375	39.7725	40.19	51626812.0
2018-12-19 16:00:00	AAPL	Stock	40.1825	40.275	40.125	40.245	21369228.0
2018-12-19 17:00:00	AAPL	Stock	40.245	40.2475	40.0275	40.1075	4524748.0
2018-12-19 18:00:00	AAPL	Stock	40.1075	40.29	40.0	40.245	758400.0
2018-12-19 19:00:00	AAPL	Stock	40.235	40.3	40.1925	40.3	106748.0
2018-12-19 05:00:00	MSFT	Stock	104.24	104.75	104.24	104.75	5914.0
2018-12-19 06:00:00	MSFT	Stock	104.8	104.8	104.6	104.74	10619.0
2018-12-19 07:00:00	MSFT	Stock	104.55	104.83	104.51	104.56	12851.0
2018-12-19 08:00:00	MSFT	Stock	104.67	104.8	104.1	104.15	44853.0
2018-12-19 09:00:00	MSFT	Stock	104.1	105.099	103.51	104.9	4513927.0
2018-12-19 10:00:00	MSFT	Stock	104.9	105.918	104.9	105.88	5295781.0
2018-12-19 11:00:00	MSFT	Stock	105.89	106.16	105.29	106.16	3610996.0
2018-12-19 12:00:00	MSFT	Stock	106.16	106.66	106.1	106.22	2846000.0
2018-12-19 13:00:00	MSFT	Stock	106.225	106.69	105.825	106.69	3257069.0
2018-12-19 14:00:00	MSFT	Stock	106.69	106.88	103.0	103.38	12591716.0
2018-12-19 15:00:00	MSFT	Stock	103.38	104.3	101.35	103.69	17968132.0
2018-12-19 16:00:00	MSFT	Stock	103.68	104.43	103.3	103.57	12542757.0
2018-12-19 17:00:00	MSFT	Stock	103.65	103.69	103.2	103.23	56302.0
2018-12-19 18:00:00	MSFT	Stock	103.3	104.0	103.2	103.75	24996.0
2018-12-19 19:00:00	MSFT	Stock	103.85	104.04	103.75	104.04	10007.0
2018-12-19 04:00:00	NVDA	Stock	3.64	3.64	3.625	3.625	16000.0
2018-12-19 05:00:00	NVDA	Stock	3.6488	3.65	3.6488	3.65	74280.0
2018-12-19 06:00:00	NVDA	Stock	3.6375	3.65	3.6375	3.65	56440.0
2018-12-19 07:00:00	NVDA	Stock	3.6418	3.67	3.6418	3.65	498480.0
2018-12-19 08:00:00	NVDA	Stock	3.655	3.6725	3.638	3.6438	961120.0
2018-12-19 09:00:00	NVDA	Stock	3.6425	3.6936	3.6138	3.6462	80584360.0
2018-12-19 10:00:00	NVDA	Stock	3.648	3.6752	3.6028	3.6113	79978320.0
2018-12-19 11:00:00	NVDA	Stock	3.612	3.6125	3.5568	3.5876	70004240.0
2018-12-19 12:00:00	NVDA	Stock	3.5898	3.5925	3.5515	3.5886	42489320.0
2018-12-19 13:00:00	NVDA	Stock	3.588	3.6125	3.566	3.607	47369240.0
2018-12-19 14:00:00	NVDA	Stock	3.6095	3.6123	3.469	3.4898	136235640.0
2018-12-19 15:00:00	NVDA	Stock	3.4878	3.4943	3.4108	3.4623	184355560.0
2018-12-19 16:00:00	NVDA	Stock	3.4623	3.4825	3.4505	3.4653	29546640.0
2018-12-19 17:00:00	NVDA	Stock	3.4628	3.4748	3.45	3.452	840400.0
2018-12-19 18:00:00	NVDA	Stock	3.4655	3.4825	3.452	3.4775	300560.0
2018-12-19 19:00:00	NVDA	Stock	3.4815	3.4815	3.46	3.475	451360.0
2018-12-19 05:00:00	AMZN	Stock	77.65	78.204	77.65	78.204	9000.0
2018-12-19 06:00:00	AMZN	Stock	78.0	78.0	78.0	78.0	2000.0
2018-12-19 07:00:00	AMZN	Stock	78.05	78.1495	78.0	78.0	184360.0

> showing 50 of 50,175 rows — these rows as CSV

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