PREVIEW / stock_1hour / 2018-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-29.parquet
  size:    1.1 MB
  rows:    49,125
  symbols: 2,890

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-29 04:00:00	AAPL	Stock	41.95	41.95	41.87	41.87	5920.0
2018-03-29 05:00:00	AAPL	Stock	41.9225	41.9725	41.9	41.9725	12020.0
2018-03-29 06:00:00	AAPL	Stock	42.0175	42.0175	41.9325	41.9625	2200.0
2018-03-29 07:00:00	AAPL	Stock	41.875	42.0375	41.7775	41.995	228536.0
2018-03-29 08:00:00	AAPL	Stock	42.0125	42.0375	41.89	41.99	517724.0
2018-03-29 09:00:00	AAPL	Stock	41.9625	42.2025	41.7325	41.813	13806844.0
2018-03-29 10:00:00	AAPL	Stock	41.815	42.5975	41.725	42.5875	18290940.0
2018-03-29 11:00:00	AAPL	Stock	42.5875	42.6575	42.275	42.4487	13269408.0
2018-03-29 12:00:00	AAPL	Stock	42.45	42.55	42.27	42.5125	8560548.0
2018-03-29 13:00:00	AAPL	Stock	42.51	42.7475	42.3075	42.673	8380388.0
2018-03-29 14:00:00	AAPL	Stock	42.6718	42.895	42.565	42.8325	10367024.0
2018-03-29 15:00:00	AAPL	Stock	42.8375	42.9375	41.9725	41.9775	30728936.0
2018-03-29 16:00:00	AAPL	Stock	41.9725	42.1225	41.9125	42.045	26257456.0
2018-03-29 17:00:00	AAPL	Stock	42.0475	42.1	42.04	42.0725	391912.0
2018-03-29 18:00:00	AAPL	Stock	42.0725	42.12	42.0725	42.1	213936.0
2018-03-29 19:00:00	AAPL	Stock	42.07	42.0975	42.0425	42.0425	79452.0
2018-03-29 04:00:00	MSFT	Stock	90.1	90.3	90.1	90.3	1138.0
2018-03-29 05:00:00	MSFT	Stock	90.35	90.35	90.02	90.02	424.0
2018-03-29 06:00:00	MSFT	Stock	90.24	90.24	90.1	90.15	1250.0
2018-03-29 07:00:00	MSFT	Stock	90.1	90.39	90.1	90.22	21496.0
2018-03-29 08:00:00	MSFT	Stock	90.3	90.48	89.99	90.32	112461.0
2018-03-29 09:00:00	MSFT	Stock	90.25	90.38	88.4	88.66	4772591.0
2018-03-29 10:00:00	MSFT	Stock	88.665	90.36	88.49	90.355	7435547.0
2018-03-29 11:00:00	MSFT	Stock	90.35	90.58	89.61	90.09	4893986.0
2018-03-29 12:00:00	MSFT	Stock	90.095	90.725	89.63	90.48	3069355.0
2018-03-29 13:00:00	MSFT	Stock	90.49	91.42	90.06	91.27	2814637.0
2018-03-29 14:00:00	MSFT	Stock	91.26	92.05	91.02	91.89	3962645.0
2018-03-29 15:00:00	MSFT	Stock	91.89	92.29	91.02	91.25	7302319.0
2018-03-29 16:00:00	MSFT	Stock	91.27	91.27	90.7	91.19	5839070.0
2018-03-29 17:00:00	MSFT	Stock	91.2	91.27	91.02	91.11	9313.0
2018-03-29 18:00:00	MSFT	Stock	91.17	91.17	91.04	91.15	11562.0
2018-03-29 19:00:00	MSFT	Stock	91.06	91.23	91.05	91.15	4970.0
2018-03-29 04:00:00	NVDA	Stock	5.5778	5.5845	5.5778	5.5845	15600.0
2018-03-29 05:00:00	NVDA	Stock	5.5843	5.599	5.5843	5.599	27680.0
2018-03-29 06:00:00	NVDA	Stock	5.625	5.6335	5.6228	5.625	46040.0
2018-03-29 07:00:00	NVDA	Stock	5.6375	5.6375	5.6032	5.609	703280.0
2018-03-29 08:00:00	NVDA	Stock	5.6112	5.6348	5.5838	5.608	3437680.0
2018-03-29 09:00:00	NVDA	Stock	5.6075	5.6373	5.5175	5.5402	102525720.0
2018-03-29 10:00:00	NVDA	Stock	5.5422	5.7205	5.5308	5.7168	140929520.0
2018-03-29 11:00:00	NVDA	Stock	5.7161	5.7425	5.6562	5.695	114177760.0
2018-03-29 12:00:00	NVDA	Stock	5.6962	5.7155	5.643	5.715	64265600.0
2018-03-29 13:00:00	NVDA	Stock	5.7135	5.8203	5.6975	5.808	109814200.0
2018-03-29 14:00:00	NVDA	Stock	5.8076	5.867	5.7838	5.8498	121801640.0
2018-03-29 15:00:00	NVDA	Stock	5.8512	5.8875	5.8	5.8078	184550320.0
2018-03-29 16:00:00	NVDA	Stock	5.808	5.8368	5.7898	5.7975	13629600.0
2018-03-29 17:00:00	NVDA	Stock	5.8013	5.8238	5.7975	5.8125	1222120.0
2018-03-29 18:00:00	NVDA	Stock	5.81	5.82	5.7975	5.7975	2556560.0
2018-03-29 19:00:00	NVDA	Stock	5.7975	5.8125	5.79	5.803	842120.0
2018-03-29 04:00:00	AMZN	Stock	71.3915	71.3915	71.366	71.366	4000.0
2018-03-29 05:00:00	AMZN	Stock	71.4745	71.4745	71.35	71.35	4560.0

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

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