PREVIEW / stock_1hour / 2017-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-24.parquet
  size:    733 KB
  rows:    31,065
  symbols: 2,837

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-11-24 04:00:00	AAPL	Stock	43.75	43.7875	43.75	43.7725	20704.0
2017-11-24 05:00:00	AAPL	Stock	43.7875	43.7875	43.775	43.775	1196.0
2017-11-24 06:00:00	AAPL	Stock	43.7875	43.8375	43.7675	43.7675	11028.0
2017-11-24 07:00:00	AAPL	Stock	43.75	43.8275	43.75	43.805	104444.0
2017-11-24 08:00:00	AAPL	Stock	43.8175	43.91	43.75	43.855	350288.0
2017-11-24 09:00:00	AAPL	Stock	43.865	43.8775	43.6615	43.8	12177648.0
2017-11-24 10:00:00	AAPL	Stock	43.8	43.83	43.72	43.765	7517832.0
2017-11-24 11:00:00	AAPL	Stock	43.765	43.8275	43.75	43.785	7971784.0
2017-11-24 12:00:00	AAPL	Stock	43.785	43.8125	43.7275	43.74	9041544.0
2017-11-24 13:00:00	AAPL	Stock	43.7425	43.75	43.7165	43.7175	4890508.0
2017-11-24 14:00:00	AAPL	Stock	43.7175	43.72	43.675	43.7125	24248.0
2017-11-24 15:00:00	AAPL	Stock	43.7125	43.7425	43.6975	43.7125	44008.0
2017-11-24 16:00:00	AAPL	Stock	43.7025	43.7225	43.7025	43.7225	1600.0
2017-11-24 06:00:00	MSFT	Stock	83.36	83.36	83.34	83.35	700.0
2017-11-24 07:00:00	MSFT	Stock	83.15	83.4	83.15	83.23	1221.0
2017-11-24 08:00:00	MSFT	Stock	83.35	83.4	83.21	83.31	6765.0
2017-11-24 09:00:00	MSFT	Stock	83.27	83.31	82.77	82.88	1583579.0
2017-11-24 10:00:00	MSFT	Stock	82.89	83.26	82.88	83.225	1086239.0
2017-11-24 11:00:00	MSFT	Stock	83.22	83.36	83.22	83.274	914235.0
2017-11-24 12:00:00	MSFT	Stock	83.27	83.43	83.21	83.27	1565456.0
2017-11-24 13:00:00	MSFT	Stock	83.26	83.38	83.156	83.156	1544303.0
2017-11-24 14:00:00	MSFT	Stock	83.203	83.203	83.203	83.203	309.0
2017-11-24 15:00:00	MSFT	Stock	83.26	83.26	83.251	83.251	657.0
2017-11-24 16:00:00	MSFT	Stock	83.2	83.2	83.2	83.2	100.0
2017-11-24 04:00:00	NVDA	Stock	5.3875	5.3912	5.3875	5.3908	19800.0
2017-11-24 06:00:00	NVDA	Stock	5.3908	5.393	5.3875	5.393	14160.0
2017-11-24 07:00:00	NVDA	Stock	5.39	5.405	5.39	5.3983	393400.0
2017-11-24 08:00:00	NVDA	Stock	5.3955	5.3992	5.3845	5.3845	784600.0
2017-11-24 09:00:00	NVDA	Stock	5.385	5.4098	5.365	5.4015	50871000.0
2017-11-24 10:00:00	NVDA	Stock	5.4	5.413	5.3925	5.4072	38471240.0
2017-11-24 11:00:00	NVDA	Stock	5.4072	5.4165	5.4053	5.4083	26149800.0
2017-11-24 12:00:00	NVDA	Stock	5.4087	5.425	5.4042	5.4238	36907280.0
2017-11-24 13:00:00	NVDA	Stock	5.4238	5.4298	5.4174	5.4221	7036040.0
2017-11-24 14:00:00	NVDA	Stock	5.4225	5.4225	5.4193	5.4225	144960.0
2017-11-24 15:00:00	NVDA	Stock	5.424	5.425	5.4213	5.4235	171400.0
2017-11-24 16:00:00	NVDA	Stock	5.4238	5.4238	5.4232	5.4235	26000.0
2017-11-24 04:00:00	AMZN	Stock	58.25	58.25	58.1	58.1	7360.0
2017-11-24 05:00:00	AMZN	Stock	58.13	58.217	58.125	58.217	26100.0
2017-11-24 06:00:00	AMZN	Stock	58.22	58.2705	58.1	58.1	70200.0
2017-11-24 07:00:00	AMZN	Stock	58.0505	58.1445	58.0075	58.075	110880.0
2017-11-24 08:00:00	AMZN	Stock	58.0075	58.23	58.0075	58.195	603700.0
2017-11-24 09:00:00	AMZN	Stock	58.175	58.69	58.035	58.6862	18739640.0
2017-11-24 10:00:00	AMZN	Stock	58.6825	58.928	58.5255	58.901	16794540.0
2017-11-24 11:00:00	AMZN	Stock	58.8982	59.0315	58.858	58.928	10952840.0
2017-11-24 12:00:00	AMZN	Stock	58.93	59.342	58.9242	59.3205	14085580.0
2017-11-24 13:00:00	AMZN	Stock	59.3	59.363	59.285	59.2975	2318800.0
2017-11-24 14:00:00	AMZN	Stock	59.3	59.35	59.25	59.25	71900.0
2017-11-24 15:00:00	AMZN	Stock	59.223	59.35	59.223	59.3225	49800.0
2017-11-24 16:00:00	AMZN	Stock	59.35	59.35	59.35	59.35	3360.0
2017-11-24 08:00:00	GOOGL	Stock	52.7125	52.7495	52.7125	52.7495	36000.0

> showing 50 of 31,065 rows — these rows as CSV

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