PREVIEW / stock_1hour / 2017-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-15.parquet
  size:    1.1 MB
  rows:    50,740
  symbols: 2,943

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
2017-12-15 04:00:00	AAPL	Stock	43.125	43.125	43.125	43.125	400.0
2017-12-15 05:00:00	AAPL	Stock	43.05	43.05	43.05	43.05	3600.0
2017-12-15 06:00:00	AAPL	Stock	43.0275	43.125	43.0275	43.125	11764.0
2017-12-15 07:00:00	AAPL	Stock	43.1025	43.15	43.1025	43.15	72644.0
2017-12-15 08:00:00	AAPL	Stock	43.1375	43.1575	43.055	43.1375	207776.0
2017-12-15 09:00:00	AAPL	Stock	43.1375	43.4475	43.055	43.2125	44969512.0
2017-12-15 10:00:00	AAPL	Stock	43.215	43.2675	43.16	43.1775	11192408.0
2017-12-15 11:00:00	AAPL	Stock	43.18	43.255	43.1675	43.2502	7724812.0
2017-12-15 12:00:00	AAPL	Stock	43.25	43.4125	43.245	43.365	9712740.0
2017-12-15 13:00:00	AAPL	Stock	43.365	43.4075	43.315	43.3925	5816912.0
2017-12-15 14:00:00	AAPL	Stock	43.39	43.42	43.33	43.411	7489996.0
2017-12-15 15:00:00	AAPL	Stock	43.4132	43.5425	43.3875	43.47	22891112.0
2017-12-15 16:00:00	AAPL	Stock	43.475	43.5225	43.4225	43.5	32873936.0
2017-12-15 17:00:00	AAPL	Stock	43.505	43.5125	43.5	43.5	249432.0
2017-12-15 18:00:00	AAPL	Stock	43.5075	43.51	43.5	43.51	57948.0
2017-12-15 19:00:00	AAPL	Stock	43.51	43.53	43.5025	43.53	33772.0
2017-12-15 08:00:00	MSFT	Stock	85.0	85.03	84.69	85.03	3685.0
2017-12-15 09:00:00	MSFT	Stock	85.05	85.59	84.69	85.395	14147061.0
2017-12-15 10:00:00	MSFT	Stock	85.39	86.034	85.385	86.015	3512218.0
2017-12-15 11:00:00	MSFT	Stock	86.01	86.67	86.01	86.66	3400588.0
2017-12-15 12:00:00	MSFT	Stock	86.66	87.09	86.62	86.785	3300359.0
2017-12-15 13:00:00	MSFT	Stock	86.78	86.88	86.53	86.72	2155431.0
2017-12-15 14:00:00	MSFT	Stock	86.715	86.755	86.45	86.51	1971681.0
2017-12-15 15:00:00	MSFT	Stock	86.52	86.975	86.49	86.82	6070107.0
2017-12-15 16:00:00	MSFT	Stock	86.85	86.98	86.76	86.9	14142399.0
2017-12-15 17:00:00	MSFT	Stock	86.9	86.97	86.9	86.97	5557.0
2017-12-15 18:00:00	MSFT	Stock	86.97	86.97	86.9	86.97	1890.0
2017-12-15 19:00:00	MSFT	Stock	86.97	87.0	86.95	86.95	4330.0
2017-12-15 04:00:00	NVDA	Stock	4.6782	4.6782	4.6782	4.6782	4000.0
2017-12-15 06:00:00	NVDA	Stock	4.6972	4.6972	4.6972	4.6972	7200.0
2017-12-15 07:00:00	NVDA	Stock	4.6938	4.6938	4.69	4.69	52360.0
2017-12-15 08:00:00	NVDA	Stock	4.69	4.692	4.6618	4.69	559200.0
2017-12-15 09:00:00	NVDA	Stock	4.69	4.7248	4.6405	4.6473	93742680.0
2017-12-15 10:00:00	NVDA	Stock	4.6452	4.6845	4.6415	4.6788	52586720.0
2017-12-15 11:00:00	NVDA	Stock	4.6782	4.768	4.678	4.7603	98109680.0
2017-12-15 12:00:00	NVDA	Stock	4.7595	4.8095	4.7445	4.7718	128107320.0
2017-12-15 13:00:00	NVDA	Stock	4.7735	4.7762	4.745	4.7655	44087120.0
2017-12-15 14:00:00	NVDA	Stock	4.7642	4.7738	4.7515	4.7548	29426200.0
2017-12-15 15:00:00	NVDA	Stock	4.755	4.7935	4.748	4.79	96014800.0
2017-12-15 16:00:00	NVDA	Stock	4.7875	4.799	4.7875	4.789	31067960.0
2017-12-15 17:00:00	NVDA	Stock	4.79	4.795	4.79	4.795	601080.0
2017-12-15 18:00:00	NVDA	Stock	4.798	4.8	4.7947	4.8	163240.0
2017-12-15 19:00:00	NVDA	Stock	4.7995	4.817	4.7965	4.804	768240.0
2017-12-15 07:00:00	AMZN	Stock	58.8035	58.8745	58.8	58.8565	51500.0
2017-12-15 08:00:00	AMZN	Stock	58.8	58.875	58.713	58.875	219560.0
2017-12-15 09:00:00	AMZN	Stock	58.874	59.1985	58.6296	58.772	25090580.0
2017-12-15 10:00:00	AMZN	Stock	58.7585	58.7905	58.4665	58.6742	11610320.0
2017-12-15 11:00:00	AMZN	Stock	58.6614	58.935	58.6345	58.87	6529040.0
2017-12-15 12:00:00	AMZN	Stock	58.8735	58.92	58.77	58.871	4143600.0
2017-12-15 13:00:00	AMZN	Stock	58.864	58.9274	58.8055	58.9053	3201100.0

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

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