PREVIEW / stock_1hour / 2017-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-30.parquet
  size:    1.1 MB
  rows:    48,091
  symbols: 2,927

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-10-30 04:00:00	AAPL	Stock	40.875	40.875	40.8	40.855	31336.0
2017-10-30 05:00:00	AAPL	Stock	40.875	40.875	40.8175	40.82	24724.0
2017-10-30 06:00:00	AAPL	Stock	40.825	40.8975	40.785	40.875	60512.0
2017-10-30 07:00:00	AAPL	Stock	40.875	40.9475	40.8625	40.8925	231772.0
2017-10-30 08:00:00	AAPL	Stock	40.9	41.0875	40.845	41.0825	987724.0
2017-10-30 09:00:00	AAPL	Stock	41.0825	41.5875	40.93	41.5575	35455568.0
2017-10-30 10:00:00	AAPL	Stock	41.5575	42.0175	41.523	41.7795	42765764.0
2017-10-30 11:00:00	AAPL	Stock	41.7775	41.7825	41.535	41.7575	20928116.0
2017-10-30 12:00:00	AAPL	Stock	41.75	41.755	41.4575	41.6225	12695472.0
2017-10-30 13:00:00	AAPL	Stock	41.62	41.7235	41.5325	41.5575	9538164.0
2017-10-30 14:00:00	AAPL	Stock	41.5575	41.6875	41.5575	41.6325	8783660.0
2017-10-30 15:00:00	AAPL	Stock	41.6338	41.7425	41.565	41.68	18952112.0
2017-10-30 16:00:00	AAPL	Stock	41.68	41.7125	41.6422	41.6975	5548308.0
2017-10-30 17:00:00	AAPL	Stock	41.6875	41.71	41.6875	41.7	128232.0
2017-10-30 18:00:00	AAPL	Stock	41.7	41.7275	41.685	41.725	50420.0
2017-10-30 19:00:00	AAPL	Stock	41.705	41.745	41.705	41.7425	53588.0
2017-10-30 04:00:00	MSFT	Stock	83.98	84.07	83.85	83.85	1300.0
2017-10-30 05:00:00	MSFT	Stock	83.89	83.89	83.74	83.87	1126.0
2017-10-30 06:00:00	MSFT	Stock	83.71	83.8	83.67	83.75	6684.0
2017-10-30 07:00:00	MSFT	Stock	83.75	83.78	83.67	83.75	8931.0
2017-10-30 08:00:00	MSFT	Stock	83.75	84.13	83.63	83.87	44700.0
2017-10-30 09:00:00	MSFT	Stock	83.97	84.24	83.105	84.189	4133861.0
2017-10-30 10:00:00	MSFT	Stock	84.18	84.325	83.78	83.85	4847719.0
2017-10-30 11:00:00	MSFT	Stock	83.85	84.19	83.63	84.02	3246520.0
2017-10-30 12:00:00	MSFT	Stock	84.02	84.05	83.6	83.79	2795783.0
2017-10-30 13:00:00	MSFT	Stock	83.78	83.83	83.4	83.43	2070579.0
2017-10-30 14:00:00	MSFT	Stock	83.43	83.67	83.34	83.655	2406893.0
2017-10-30 15:00:00	MSFT	Stock	83.65	83.94	83.5	83.84	4148520.0
2017-10-30 16:00:00	MSFT	Stock	83.82	83.92	83.74	83.88	5038417.0
2017-10-30 18:00:00	MSFT	Stock	83.76	83.76	83.75	83.76	2754.0
2017-10-30 19:00:00	MSFT	Stock	83.77	83.82	83.75	83.75	4075.0
2017-10-30 04:00:00	NVDA	Stock	5.0593	5.075	5.0593	5.075	20000.0
2017-10-30 05:00:00	NVDA	Stock	5.066	5.066	5.0625	5.0625	9600.0
2017-10-30 06:00:00	NVDA	Stock	5.0588	5.065	5.05	5.05	118080.0
2017-10-30 07:00:00	NVDA	Stock	5.0575	5.0588	5.0338	5.05	429160.0
2017-10-30 08:00:00	NVDA	Stock	5.0502	5.0578	5.0375	5.045	1932760.0
2017-10-30 09:00:00	NVDA	Stock	5.0425	5.1313	5.0305	5.1295	91108280.0
2017-10-30 10:00:00	NVDA	Stock	5.129	5.1523	5.0938	5.1115	102534160.0
2017-10-30 11:00:00	NVDA	Stock	5.1117	5.1222	5.0803	5.0861	65725920.0
2017-10-30 12:00:00	NVDA	Stock	5.086	5.1163	5.0612	5.1114	60145200.0
2017-10-30 13:00:00	NVDA	Stock	5.1111	5.121	5.0928	5.0958	27255040.0
2017-10-30 14:00:00	NVDA	Stock	5.096	5.122	5.0955	5.1055	28419200.0
2017-10-30 15:00:00	NVDA	Stock	5.104	5.1071	5.0798	5.094	51283520.0
2017-10-30 16:00:00	NVDA	Stock	5.096	5.1	5.0925	5.1	10211920.0
2017-10-30 17:00:00	NVDA	Stock	5.1	5.1025	5.0995	5.1005	119520.0
2017-10-30 18:00:00	NVDA	Stock	5.1008	5.1025	5.0995	5.101	218160.0
2017-10-30 19:00:00	NVDA	Stock	5.1	5.1025	5.1	5.1025	315680.0
2017-10-30 04:00:00	AMZN	Stock	54.84	54.95	54.7925	54.9	48980.0
2017-10-30 05:00:00	AMZN	Stock	54.864	54.884	54.8005	54.8005	18480.0
2017-10-30 06:00:00	AMZN	Stock	54.751	54.751	54.411	54.45	70140.0

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

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