PREVIEW / stock_1hour / 2016-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-25.parquet
  size:    1.0 MB
  rows:    48,513
  symbols: 3,268

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
2016-07-25 04:00:00	AAPL	Stock	24.665	24.665	24.63	24.665	1692.0
2016-07-25 05:00:00	AAPL	Stock	24.655	24.675	24.625	24.625	6256.0
2016-07-25 06:00:00	AAPL	Stock	24.625	24.625	24.595	24.595	4000.0
2016-07-25 07:00:00	AAPL	Stock	24.6	24.625	24.5875	24.6	30168.0
2016-07-25 08:00:00	AAPL	Stock	24.6	24.625	24.5625	24.6125	196236.0
2016-07-25 09:00:00	AAPL	Stock	24.6	24.71	24.54	24.581	23454380.0
2016-07-25 10:00:00	AAPL	Stock	24.581	24.595	24.4625	24.5118	21411084.0
2016-07-25 11:00:00	AAPL	Stock	24.51	24.56	24.4925	24.4998	11720788.0
2016-07-25 12:00:00	AAPL	Stock	24.5	24.51	24.3325	24.345	24090540.0
2016-07-25 13:00:00	AAPL	Stock	24.3425	24.3575	24.2925	24.304	14357792.0
2016-07-25 14:00:00	AAPL	Stock	24.304	24.3525	24.2575	24.26	13493708.0
2016-07-25 15:00:00	AAPL	Stock	24.2618	24.335	24.23	24.33	27129776.0
2016-07-25 16:00:00	AAPL	Stock	24.335	24.4	24.261	24.355	8825228.0
2016-07-25 17:00:00	AAPL	Stock	24.355	24.3725	24.3125	24.325	159904.0
2016-07-25 18:00:00	AAPL	Stock	24.3125	24.325	24.2675	24.27	81652.0
2016-07-25 19:00:00	AAPL	Stock	24.2875	24.2925	24.24	24.285	146432.0
2016-07-25 04:00:00	MSFT	Stock	56.6	56.6	56.6	56.6	200.0
2016-07-25 06:00:00	MSFT	Stock	56.7	56.7	56.68	56.68	200.0
2016-07-25 07:00:00	MSFT	Stock	56.44	56.5	56.4	56.4	6005.0
2016-07-25 08:00:00	MSFT	Stock	56.33	56.56	56.33	56.49	4081.0
2016-07-25 09:00:00	MSFT	Stock	56.53	56.69	56.4	56.435	3523791.0
2016-07-25 10:00:00	MSFT	Stock	56.44	56.5	56.31	56.37	2867691.0
2016-07-25 11:00:00	MSFT	Stock	56.37	56.39	56.255	56.34	1895189.0
2016-07-25 12:00:00	MSFT	Stock	56.34	56.49	56.33	56.44	2324453.0
2016-07-25 13:00:00	MSFT	Stock	56.44	56.5	56.375	56.475	2136488.0
2016-07-25 14:00:00	MSFT	Stock	56.47	56.53	56.4	56.49	1992618.0
2016-07-25 15:00:00	MSFT	Stock	56.49	56.74	56.465	56.73	5444709.0
2016-07-25 16:00:00	MSFT	Stock	56.73	56.75	56.65	56.65	2654892.0
2016-07-25 17:00:00	MSFT	Stock	56.65	56.73	56.65	56.68	1300090.0
2016-07-25 18:00:00	MSFT	Stock	56.67	56.67	56.67	56.67	100.0
2016-07-25 19:00:00	MSFT	Stock	56.71	56.74	56.71	56.72	4405.0
2016-07-25 07:00:00	NVDA	Stock	1.375	1.375	1.375	1.375	18000.0
2016-07-25 08:00:00	NVDA	Stock	1.3675	1.3735	1.3675	1.372	50600.0
2016-07-25 09:00:00	NVDA	Stock	1.3712	1.3812	1.369	1.3755	50634280.0
2016-07-25 10:00:00	NVDA	Stock	1.3752	1.387	1.3745	1.385	53577320.0
2016-07-25 11:00:00	NVDA	Stock	1.385	1.395	1.384	1.3895	57729800.0
2016-07-25 12:00:00	NVDA	Stock	1.3895	1.3918	1.3842	1.3865	25557720.0
2016-07-25 13:00:00	NVDA	Stock	1.3866	1.3925	1.3865	1.3915	20473080.0
2016-07-25 14:00:00	NVDA	Stock	1.3915	1.3953	1.3902	1.3908	25715960.0
2016-07-25 15:00:00	NVDA	Stock	1.3905	1.3922	1.3875	1.392	51041000.0
2016-07-25 16:00:00	NVDA	Stock	1.392	1.395	1.392	1.393	8388240.0
2016-07-25 17:00:00	NVDA	Stock	1.3945	1.395	1.3945	1.395	43760.0
2016-07-25 19:00:00	NVDA	Stock	1.398	1.398	1.398	1.398	22400.0
2016-07-25 06:00:00	AMZN	Stock	37.34	37.34	37.34	37.34	8000.0
2016-07-25 07:00:00	AMZN	Stock	37.3365	37.5	37.3365	37.5	54560.0
2016-07-25 08:00:00	AMZN	Stock	37.4	37.4	37.3175	37.325	77900.0
2016-07-25 09:00:00	AMZN	Stock	37.35	37.425	37.0774	37.1335	8073240.0
2016-07-25 10:00:00	AMZN	Stock	37.127	37.2165	37.077	37.1644	6825120.0
2016-07-25 11:00:00	AMZN	Stock	37.1525	37.1624	36.98	36.9925	5862660.0
2016-07-25 12:00:00	AMZN	Stock	37.004	37.0265	36.9105	36.966	3734320.0

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

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