PREVIEW / stock_1hour / 2017-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-13.parquet
  size:    1.0 MB
  rows:    47,454
  symbols: 2,992

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-07-13 04:00:00	AAPL	Stock	36.44	36.44	36.4375	36.4375	3104.0
2017-07-13 05:00:00	AAPL	Stock	36.4675	36.5	36.4675	36.5	8200.0
2017-07-13 06:00:00	AAPL	Stock	36.48	36.48	36.45	36.45	17644.0
2017-07-13 07:00:00	AAPL	Stock	36.4175	36.45	36.38	36.405	45192.0
2017-07-13 08:00:00	AAPL	Stock	36.4275	36.45	36.375	36.4	85868.0
2017-07-13 09:00:00	AAPL	Stock	36.4175	36.78	36.3575	36.7525	13358512.0
2017-07-13 10:00:00	AAPL	Stock	36.755	36.8475	36.64	36.785	14705480.0
2017-07-13 11:00:00	AAPL	Stock	36.785	36.8925	36.695	36.882	9925988.0
2017-07-13 12:00:00	AAPL	Stock	36.8812	37.1225	36.8475	37.091	13422364.0
2017-07-13 13:00:00	AAPL	Stock	37.0912	37.1125	36.93	36.9925	12070720.0
2017-07-13 14:00:00	AAPL	Stock	36.9942	37.0575	36.9075	36.9562	8592480.0
2017-07-13 15:00:00	AAPL	Stock	36.955	37.02	36.895	36.945	13605172.0
2017-07-13 16:00:00	AAPL	Stock	36.9425	36.96	36.905	36.9575	6316296.0
2017-07-13 17:00:00	AAPL	Stock	36.9575	36.9625	36.8875	36.9	150620.0
2017-07-13 18:00:00	AAPL	Stock	36.8875	36.9	36.78	36.8025	201356.0
2017-07-13 19:00:00	AAPL	Stock	36.8	36.805	36.78	36.785	150944.0
2017-07-13 07:00:00	MSFT	Stock	71.4	71.4	71.3	71.35	20766.0
2017-07-13 08:00:00	MSFT	Stock	71.4	71.45	71.15	71.4	29392.0
2017-07-13 09:00:00	MSFT	Stock	71.44	71.95	71.2	71.91	2933045.0
2017-07-13 10:00:00	MSFT	Stock	71.9	72.04	71.535	71.7	3067704.0
2017-07-13 11:00:00	MSFT	Stock	71.7	71.93	71.49	71.93	1933835.0
2017-07-13 12:00:00	MSFT	Stock	71.93	71.995	71.82	71.97	2001300.0
2017-07-13 13:00:00	MSFT	Stock	71.97	72.02	71.74	71.81	2399852.0
2017-07-13 14:00:00	MSFT	Stock	71.8	71.85	71.63	71.71	1846733.0
2017-07-13 15:00:00	MSFT	Stock	71.7	71.83	71.645	71.77	2456799.0
2017-07-13 16:00:00	MSFT	Stock	71.77	71.85	71.64	71.77	2004076.0
2017-07-13 17:00:00	MSFT	Stock	71.72	71.87	71.72	71.87	1760.0
2017-07-13 18:00:00	MSFT	Stock	71.87	71.87	71.86	71.86	650.0
2017-07-13 19:00:00	MSFT	Stock	71.75	71.75	71.75	71.75	200.0
2017-07-13 04:00:00	NVDA	Stock	4.1125	4.1125	4.0885	4.0963	124840.0
2017-07-13 05:00:00	NVDA	Stock	4.0958	4.0975	4.0848	4.086	154680.0
2017-07-13 06:00:00	NVDA	Stock	4.0948	4.0948	4.0792	4.0792	649640.0
2017-07-13 07:00:00	NVDA	Stock	4.0775	4.085	4.075	4.08	1238840.0
2017-07-13 08:00:00	NVDA	Stock	4.0788	4.0972	4.07	4.0825	5659000.0
2017-07-13 09:00:00	NVDA	Stock	4.0825	4.1575	4.0525	4.148	242927520.0
2017-07-13 10:00:00	NVDA	Stock	4.1478	4.156	4.0623	4.1138	302239200.0
2017-07-13 11:00:00	NVDA	Stock	4.1135	4.131	4.0765	4.1044	154180400.0
2017-07-13 12:00:00	NVDA	Stock	4.1038	4.1198	4.0917	4.1005	64145600.0
2017-07-13 13:00:00	NVDA	Stock	4.1008	4.105	3.9688	4.0178	229041960.0
2017-07-13 14:00:00	NVDA	Stock	4.0162	4.0465	3.9782	4.029	157857360.0
2017-07-13 15:00:00	NVDA	Stock	4.0298	4.0351	4.002	4.0158	144400360.0
2017-07-13 16:00:00	NVDA	Stock	4.016	4.0248	4.0158	4.0245	6047920.0
2017-07-13 17:00:00	NVDA	Stock	4.0225	4.025	4.02	4.025	418680.0
2017-07-13 18:00:00	NVDA	Stock	4.025	4.025	4.0127	4.0162	1048400.0
2017-07-13 19:00:00	NVDA	Stock	4.0158	4.0178	4.0112	4.0135	382640.0
2017-07-13 04:00:00	AMZN	Stock	50.41	50.41	50.41	50.41	2000.0
2017-07-13 05:00:00	AMZN	Stock	50.45	50.5	50.45	50.4715	16260.0
2017-07-13 06:00:00	AMZN	Stock	50.4005	50.4005	50.4005	50.4005	2780.0
2017-07-13 07:00:00	AMZN	Stock	50.35	50.35	50.2	50.2365	86260.0
2017-07-13 08:00:00	AMZN	Stock	50.3785	50.3785	50.175	50.205	233220.0

> showing 50 of 47,454 rows — these rows as CSV

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