PREVIEW / stock_1hour / 2016-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-04.parquet
  size:    1.0 MB
  rows:    48,497
  symbols: 3,346

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-04-04 04:00:00	AAPL	Stock	27.6175	27.6175	27.6175	27.6175	6928.0
2016-04-04 05:00:00	AAPL	Stock	27.6	27.6	27.59	27.59	9200.0
2016-04-04 06:00:00	AAPL	Stock	27.5625	27.68	27.5625	27.6725	80176.0
2016-04-04 07:00:00	AAPL	Stock	27.6575	27.7825	27.65	27.7425	322576.0
2016-04-04 08:00:00	AAPL	Stock	27.75	27.775	27.655	27.7	518068.0
2016-04-04 09:00:00	AAPL	Stock	27.7025	27.93	27.4375	27.93	24609136.0
2016-04-04 10:00:00	AAPL	Stock	27.9312	28.0475	27.85	27.8725	30654720.0
2016-04-04 11:00:00	AAPL	Stock	27.8712	27.905	27.7775	27.895	16234316.0
2016-04-04 12:00:00	AAPL	Stock	27.895	27.9925	27.88	27.9912	11719840.0
2016-04-04 13:00:00	AAPL	Stock	27.9925	27.9975	27.8275	27.8575	12752768.0
2016-04-04 14:00:00	AAPL	Stock	27.855	27.8775	27.78	27.8225	12538392.0
2016-04-04 15:00:00	AAPL	Stock	27.8232	27.85	27.7425	27.7825	19548768.0
2016-04-04 16:00:00	AAPL	Stock	27.78	27.7875	27.6855	27.75	7015836.0
2016-04-04 17:00:00	AAPL	Stock	27.74	27.76	27.7175	27.7175	71028.0
2016-04-04 18:00:00	AAPL	Stock	27.725	27.7375	27.7125	27.7375	37072.0
2016-04-04 19:00:00	AAPL	Stock	27.745	27.75	27.725	27.75	57148.0
2016-04-04 05:00:00	MSFT	Stock	55.77	55.77	55.77	55.77	1000.0
2016-04-04 06:00:00	MSFT	Stock	55.73	55.73	55.73	55.73	500.0
2016-04-04 07:00:00	MSFT	Stock	55.6	55.73	55.6	55.73	1291.0
2016-04-04 08:00:00	MSFT	Stock	55.65	55.65	55.5	55.54	3796.0
2016-04-04 09:00:00	MSFT	Stock	55.5	55.66	55.2	55.284	2643459.0
2016-04-04 10:00:00	MSFT	Stock	55.28	55.54	55.0	55.13	2602190.0
2016-04-04 11:00:00	MSFT	Stock	55.12	55.49	55.1	55.445	2197469.0
2016-04-04 12:00:00	MSFT	Stock	55.45	55.505	55.315	55.42	1113231.0
2016-04-04 13:00:00	MSFT	Stock	55.42	55.42	55.26	55.265	921706.0
2016-04-04 14:00:00	MSFT	Stock	55.28	55.3	55.16	55.27	1822122.0
2016-04-04 15:00:00	MSFT	Stock	55.27	55.43	55.2	55.43	3162150.0
2016-04-04 16:00:00	MSFT	Stock	55.43	55.43	55.25	55.3	3208784.0
2016-04-04 17:00:00	MSFT	Stock	55.3	55.3	55.2	55.3	1174.0
2016-04-04 18:00:00	MSFT	Stock	55.25	55.25	55.2	55.2	448.0
2016-04-04 19:00:00	MSFT	Stock	55.35	55.35	55.2	55.2	400.0
2016-04-04 04:00:00	NVDA	Stock	0.9	0.9	0.9	0.9	4000.0
2016-04-04 09:00:00	NVDA	Stock	0.91	0.916	0.9078	0.9102	51644640.0
2016-04-04 10:00:00	NVDA	Stock	0.9102	0.9125	0.8948	0.895	61227520.0
2016-04-04 11:00:00	NVDA	Stock	0.8949	0.8984	0.8938	0.896	52678240.0
2016-04-04 12:00:00	NVDA	Stock	0.896	0.9005	0.8953	0.8982	45417360.0
2016-04-04 13:00:00	NVDA	Stock	0.8984	0.899	0.8948	0.8954	24931520.0
2016-04-04 14:00:00	NVDA	Stock	0.8953	0.8965	0.8915	0.8953	39314240.0
2016-04-04 15:00:00	NVDA	Stock	0.8954	0.8963	0.8925	0.8955	57304080.0
2016-04-04 16:00:00	NVDA	Stock	0.895	0.8998	0.893	0.893	25667520.0
2016-04-04 07:00:00	AMZN	Stock	30.03	30.03	30.03	30.03	2040.0
2016-04-04 08:00:00	AMZN	Stock	30.005	30.024	29.95	29.975	82800.0
2016-04-04 09:00:00	AMZN	Stock	29.975	29.995	29.6285	29.6755	8233140.0
2016-04-04 10:00:00	AMZN	Stock	29.7002	29.82	29.677	29.7005	8663240.0
2016-04-04 11:00:00	AMZN	Stock	29.7065	29.707	29.5275	29.6354	7002060.0
2016-04-04 12:00:00	AMZN	Stock	29.628	29.7945	29.6	29.7645	4650380.0
2016-04-04 13:00:00	AMZN	Stock	29.766	29.7827	29.655	29.663	2658820.0
2016-04-04 14:00:00	AMZN	Stock	29.6675	29.691	29.6205	29.674	3050280.0
2016-04-04 15:00:00	AMZN	Stock	29.672	29.6915	29.588	29.6595	7689260.0
2016-04-04 16:00:00	AMZN	Stock	29.6595	29.6595	29.6055	29.6055	537980.0

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

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