PREVIEW / stock_1hour / 2017-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-28.parquet
  size:    1.0 MB
  rows:    47,183
  symbols: 2,969

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-28 04:00:00	AAPL	Stock	37.3725	37.375	37.3025	37.3675	10100.0
2017-07-28 05:00:00	AAPL	Stock	37.325	37.3725	37.325	37.325	9600.0
2017-07-28 06:00:00	AAPL	Stock	37.3725	37.3725	37.325	37.3375	17152.0
2017-07-28 07:00:00	AAPL	Stock	37.375	37.4325	37.375	37.4175	20120.0
2017-07-28 08:00:00	AAPL	Stock	37.445	37.4575	37.3775	37.4575	161788.0
2017-07-28 09:00:00	AAPL	Stock	37.4625	37.5575	37.315	37.38	12606044.0
2017-07-28 10:00:00	AAPL	Stock	37.3802	37.55	37.375	37.41	8537052.0
2017-07-28 11:00:00	AAPL	Stock	37.41	37.4625	37.365	37.433	7093428.0
2017-07-28 12:00:00	AAPL	Stock	37.4325	37.5325	37.4225	37.51	5428928.0
2017-07-28 13:00:00	AAPL	Stock	37.5102	37.5225	37.4375	37.4652	4209124.0
2017-07-28 14:00:00	AAPL	Stock	37.47	37.5075	37.4475	37.46	4640924.0
2017-07-28 15:00:00	AAPL	Stock	37.46	37.4725	37.2975	37.3725	12773244.0
2017-07-28 16:00:00	AAPL	Stock	37.375	37.375	37.3325	37.3625	6121140.0
2017-07-28 17:00:00	AAPL	Stock	37.35	37.3625	37.3425	37.3475	15288.0
2017-07-28 18:00:00	AAPL	Stock	37.3575	37.375	37.345	37.3625	42276.0
2017-07-28 19:00:00	AAPL	Stock	37.3475	37.37	37.3475	37.37	21696.0
2017-07-28 06:00:00	MSFT	Stock	72.56	72.61	72.56	72.61	2932.0
2017-07-28 07:00:00	MSFT	Stock	72.61	72.76	72.55	72.68	4437.0
2017-07-28 08:00:00	MSFT	Stock	72.75	72.79	72.56	72.78	26395.0
2017-07-28 09:00:00	MSFT	Stock	72.74	73.12	72.54	72.91	2421882.0
2017-07-28 10:00:00	MSFT	Stock	72.9	73.03	72.68	72.92	2035206.0
2017-07-28 11:00:00	MSFT	Stock	72.93	73.07	72.82	72.995	2098830.0
2017-07-28 12:00:00	MSFT	Stock	72.99	73.31	72.96	73.245	1536162.0
2017-07-28 13:00:00	MSFT	Stock	73.245	73.29	73.075	73.175	1226186.0
2017-07-28 14:00:00	MSFT	Stock	73.175	73.2	73.04	73.13	1418777.0
2017-07-28 15:00:00	MSFT	Stock	73.14	73.175	72.975	73.03	3161819.0
2017-07-28 16:00:00	MSFT	Stock	73.04	73.26	72.96	73.04	1755379.0
2017-07-28 17:00:00	MSFT	Stock	73.04	73.04	73.0	73.0	1200.0
2017-07-28 18:00:00	MSFT	Stock	73.04	73.04	73.04	73.04	503958.0
2017-07-28 19:00:00	MSFT	Stock	73.12	73.12	73.09	73.12	1800.0
2017-07-28 04:00:00	NVDA	Stock	4.025	4.025	4.0188	4.0188	37160.0
2017-07-28 05:00:00	NVDA	Stock	4.015	4.0162	4.0005	4.0125	84000.0
2017-07-28 06:00:00	NVDA	Stock	4.008	4.008	3.968	3.9875	395640.0
2017-07-28 07:00:00	NVDA	Stock	3.9828	4.0048	3.95	4.0013	1186120.0
2017-07-28 08:00:00	NVDA	Stock	4.0022	4.025	3.9705	3.9895	3380880.0
2017-07-28 09:00:00	NVDA	Stock	3.99	4.0862	3.9812	4.0706	111502760.0
2017-07-28 10:00:00	NVDA	Stock	4.0715	4.0955	4.0632	4.081	92108320.0
2017-07-28 11:00:00	NVDA	Stock	4.0816	4.121	4.0778	4.1125	76776880.0
2017-07-28 12:00:00	NVDA	Stock	4.1128	4.1345	4.1018	4.1288	47935640.0
2017-07-28 13:00:00	NVDA	Stock	4.13	4.1318	4.116	4.1203	35047040.0
2017-07-28 14:00:00	NVDA	Stock	4.1203	4.131	4.1175	4.1222	33132080.0
2017-07-28 15:00:00	NVDA	Stock	4.1224	4.1263	4.0993	4.11	61935120.0
2017-07-28 16:00:00	NVDA	Stock	4.1098	4.1112	4.1075	4.1092	18504720.0
2017-07-28 17:00:00	NVDA	Stock	4.1092	4.1125	4.1	4.1	539640.0
2017-07-28 18:00:00	NVDA	Stock	4.1098	4.113	4.1028	4.1088	46320.0
2017-07-28 19:00:00	NVDA	Stock	4.1125	4.115	4.1098	4.11	90360.0
2017-07-28 04:00:00	AMZN	Stock	51.0105	51.0105	50.86	50.86	31900.0
2017-07-28 05:00:00	AMZN	Stock	50.9895	50.9895	50.95	50.97	10040.0
2017-07-28 06:00:00	AMZN	Stock	50.955	50.955	50.7	50.75	93340.0
2017-07-28 07:00:00	AMZN	Stock	50.75	50.98	50.725	50.8245	198100.0

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

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