PREVIEW / stock_1hour / 2017-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-25.parquet
  size:    1.1 MB
  rows:    48,797
  symbols: 3,128

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-01-25 04:00:00	AAPL	Stock	30.025	30.065	30.025	30.065	1488.0
2017-01-25 05:00:00	AAPL	Stock	30.1	30.11	30.0625	30.0925	13420.0
2017-01-25 06:00:00	AAPL	Stock	30.0875	30.095	30.0875	30.09	6400.0
2017-01-25 07:00:00	AAPL	Stock	30.09	30.1	30.0775	30.09	43672.0
2017-01-25 08:00:00	AAPL	Stock	30.095	30.095	30.0425	30.095	203048.0
2017-01-25 09:00:00	AAPL	Stock	30.0875	30.31	30.0625	30.282	24634764.0
2017-01-25 10:00:00	AAPL	Stock	30.2825	30.4225	30.255	30.3662	20922064.0
2017-01-25 11:00:00	AAPL	Stock	30.3675	30.3938	30.285	30.3215	11781144.0
2017-01-25 12:00:00	AAPL	Stock	30.32	30.4125	30.31	30.405	8951356.0
2017-01-25 13:00:00	AAPL	Stock	30.405	30.5	30.395	30.4975	11277628.0
2017-01-25 14:00:00	AAPL	Stock	30.4962	30.5	30.4225	30.485	11712268.0
2017-01-25 15:00:00	AAPL	Stock	30.485	30.525	30.4525	30.475	20586512.0
2017-01-25 16:00:00	AAPL	Stock	30.48	30.4825	30.45	30.475	8351052.0
2017-01-25 17:00:00	AAPL	Stock	30.475	30.475	30.45	30.47	72216.0
2017-01-25 18:00:00	AAPL	Stock	30.4625	30.465	30.4625	30.465	2080.0
2017-01-25 19:00:00	AAPL	Stock	30.45	30.4625	30.45	30.4625	56144.0
2017-01-25 06:00:00	MSFT	Stock	63.77	63.77	63.77	63.77	120.0
2017-01-25 07:00:00	MSFT	Stock	63.9	64.06	63.9	64.04	3725.0
2017-01-25 08:00:00	MSFT	Stock	64.0	64.0	63.52	64.0	46909.0
2017-01-25 09:00:00	MSFT	Stock	63.91	64.1	63.49	63.68	3471455.0
2017-01-25 10:00:00	MSFT	Stock	63.68	63.82	63.565	63.73	2731409.0
2017-01-25 11:00:00	MSFT	Stock	63.73	63.88	63.64	63.82	2562908.0
2017-01-25 12:00:00	MSFT	Stock	63.82	63.82	63.7	63.776	1473210.0
2017-01-25 13:00:00	MSFT	Stock	63.77	63.84	63.76	63.76	1795889.0
2017-01-25 14:00:00	MSFT	Stock	63.76	63.77	63.52	63.525	2157005.0
2017-01-25 15:00:00	MSFT	Stock	63.53	63.72	63.45	63.68	5502041.0
2017-01-25 16:00:00	MSFT	Stock	63.665	63.78	63.65	63.77	2750420.0
2017-01-25 17:00:00	MSFT	Stock	63.78	63.99	63.68	63.99	34860.0
2017-01-25 18:00:00	MSFT	Stock	63.99	64.1	63.98	64.07	85296.0
2017-01-25 19:00:00	MSFT	Stock	64.05	64.09	63.96	64.0	22403.0
2017-01-25 04:00:00	NVDA	Stock	2.7	2.7	2.7	2.7	8000.0
2017-01-25 06:00:00	NVDA	Stock	2.7075	2.7125	2.7075	2.7125	96040.0
2017-01-25 07:00:00	NVDA	Stock	2.7075	2.72	2.7075	2.7125	436960.0
2017-01-25 08:00:00	NVDA	Stock	2.7163	2.7312	2.7038	2.7275	2718720.0
2017-01-25 09:00:00	NVDA	Stock	2.7258	2.7325	2.6875	2.7018	99279160.0
2017-01-25 10:00:00	NVDA	Stock	2.7017	2.7048	2.6584	2.6905	108112520.0
2017-01-25 11:00:00	NVDA	Stock	2.6903	2.691	2.6703	2.6895	62936400.0
2017-01-25 12:00:00	NVDA	Stock	2.6895	2.6955	2.6715	2.6765	57312480.0
2017-01-25 13:00:00	NVDA	Stock	2.6765	2.6992	2.6765	2.6973	54873480.0
2017-01-25 14:00:00	NVDA	Stock	2.6973	2.6992	2.6852	2.6872	46454480.0
2017-01-25 15:00:00	NVDA	Stock	2.6875	2.698	2.6852	2.6948	64230640.0
2017-01-25 16:00:00	NVDA	Stock	2.6948	2.6948	2.689	2.6925	5927720.0
2017-01-25 17:00:00	NVDA	Stock	2.6892	2.694	2.6878	2.6925	82440.0
2017-01-25 18:00:00	NVDA	Stock	2.6938	2.6938	2.69	2.6925	113240.0
2017-01-25 19:00:00	NVDA	Stock	2.6912	2.6925	2.69	2.6915	230000.0
2017-01-25 06:00:00	AMZN	Stock	41.35	41.35	41.35	41.35	12440.0
2017-01-25 07:00:00	AMZN	Stock	41.344	41.35	41.2555	41.3495	133040.0
2017-01-25 08:00:00	AMZN	Stock	41.325	41.365	41.3	41.325	308620.0
2017-01-25 09:00:00	AMZN	Stock	41.35	41.4495	41.2644	41.3758	10074200.0
2017-01-25 10:00:00	AMZN	Stock	41.3743	41.6765	41.37	41.6515	10744560.0

> showing 50 of 48,797 rows — these rows as CSV

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