PREVIEW / stock_1hour / 2018-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-28.parquet
  size:    1.1 MB
  rows:    49,276
  symbols: 2,873

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-03-28 04:00:00	AAPL	Stock	41.975	41.975	41.6525	41.795	21400.0
2018-03-28 05:00:00	AAPL	Stock	41.85	42.01	41.77	41.9025	63660.0
2018-03-28 06:00:00	AAPL	Stock	41.9075	42.0875	41.8	42.0225	65568.0
2018-03-28 07:00:00	AAPL	Stock	42.0275	42.315	41.97	42.0	522024.0
2018-03-28 08:00:00	AAPL	Stock	42.0612	42.285	41.7525	41.835	1193408.0
2018-03-28 09:00:00	AAPL	Stock	41.7925	41.9475	41.2975	41.7375	21824740.0
2018-03-28 10:00:00	AAPL	Stock	41.7352	41.94	41.335	41.6325	21200260.0
2018-03-28 11:00:00	AAPL	Stock	41.6325	42.2375	41.6325	42.0	20363824.0
2018-03-28 12:00:00	AAPL	Stock	42.01	42.505	41.7625	41.7975	17049996.0
2018-03-28 13:00:00	AAPL	Stock	41.795	42.184	41.6775	41.9338	12957700.0
2018-03-28 14:00:00	AAPL	Stock	41.9375	42.0575	41.69	41.75	12801364.0
2018-03-28 15:00:00	AAPL	Stock	41.7465	41.94	41.4825	41.62	25173960.0
2018-03-28 16:00:00	AAPL	Stock	41.62	41.7125	41.6175	41.7125	7400780.0
2018-03-28 17:00:00	AAPL	Stock	41.62	41.715	41.56	41.6225	178948.0
2018-03-28 18:00:00	AAPL	Stock	41.575	41.7375	41.575	41.7	85192.0
2018-03-28 19:00:00	AAPL	Stock	41.6875	41.7125	41.675	41.7125	44488.0
2018-03-28 04:00:00	MSFT	Stock	89.39	89.39	89.0	89.12	2076.0
2018-03-28 05:00:00	MSFT	Stock	88.92	89.02	88.92	89.0	4801.0
2018-03-28 06:00:00	MSFT	Stock	89.0	89.6	89.0	89.6	3069.0
2018-03-28 07:00:00	MSFT	Stock	89.56	90.65	89.56	90.15	76307.0
2018-03-28 08:00:00	MSFT	Stock	90.5	90.5	89.25	89.25	89772.0
2018-03-28 09:00:00	MSFT	Stock	89.55	90.67	89.049	90.41	7142458.0
2018-03-28 10:00:00	MSFT	Stock	90.41	90.74	88.873	89.49	8149976.0
2018-03-28 11:00:00	MSFT	Stock	89.5	90.29	89.01	89.9	5334285.0
2018-03-28 12:00:00	MSFT	Stock	89.9	91.23	89.76	89.78	6058476.0
2018-03-28 13:00:00	MSFT	Stock	89.79	90.95	89.5	90.43	4413509.0
2018-03-28 14:00:00	MSFT	Stock	90.425	90.655	89.58	89.69	4809140.0
2018-03-28 15:00:00	MSFT	Stock	89.68	90.43	89.06	89.38	8654096.0
2018-03-28 16:00:00	MSFT	Stock	89.39	89.907	89.34	89.7	3426697.0
2018-03-28 17:00:00	MSFT	Stock	89.6	89.64	89.49	89.56	16006.0
2018-03-28 18:00:00	MSFT	Stock	89.56	89.77	89.5	89.63	33850.0
2018-03-28 19:00:00	MSFT	Stock	89.66	90.0	89.66	89.7	14723.0
2018-03-28 04:00:00	NVDA	Stock	5.638	5.7375	5.5988	5.7375	780320.0
2018-03-28 05:00:00	NVDA	Stock	5.6125	5.625	5.5875	5.6245	238800.0
2018-03-28 06:00:00	NVDA	Stock	5.6125	5.6438	5.6125	5.6435	219960.0
2018-03-28 07:00:00	NVDA	Stock	5.6875	5.74	5.685	5.6888	1932400.0
2018-03-28 08:00:00	NVDA	Stock	5.7291	5.737	5.6042	5.6075	5788360.0
2018-03-28 09:00:00	NVDA	Stock	5.609	5.7348	5.4812	5.671	191336440.0
2018-03-28 10:00:00	NVDA	Stock	5.6705	5.707	5.425	5.5198	219301080.0
2018-03-28 11:00:00	NVDA	Stock	5.5195	5.5738	5.45	5.5115	125435960.0
2018-03-28 12:00:00	NVDA	Stock	5.516	5.6125	5.5	5.5	113261080.0
2018-03-28 13:00:00	NVDA	Stock	5.5001	5.5723	5.4563	5.5415	76774960.0
2018-03-28 14:00:00	NVDA	Stock	5.5448	5.5623	5.5005	5.5123	66770760.0
2018-03-28 15:00:00	NVDA	Stock	5.5123	5.5665	5.475	5.5328	124770120.0
2018-03-28 16:00:00	NVDA	Stock	5.5355	5.5548	5.5295	5.5392	992880.0
2018-03-28 17:00:00	NVDA	Stock	5.5392	5.54	5.5125	5.5125	243560.0
2018-03-28 18:00:00	NVDA	Stock	5.525	5.5555	5.5245	5.554	1026720.0
2018-03-28 19:00:00	NVDA	Stock	5.55	5.5625	5.5475	5.5488	516920.0
2018-03-28 04:00:00	AMZN	Stock	74.2	74.4	74.2	74.342	29540.0
2018-03-28 05:00:00	AMZN	Stock	74.2105	74.6055	74.2	74.509	76340.0

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

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