PREVIEW / stock_1hour / 2016-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-15.parquet
  size:    1.1 MB
  rows:    50,861
  symbols: 3,403

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-01-15 04:00:00	AAPL	Stock	24.59	24.59	24.4	24.4	17524.0
2016-01-15 05:00:00	AAPL	Stock	24.3875	24.4375	24.2525	24.2975	53632.0
2016-01-15 06:00:00	AAPL	Stock	24.28	24.3625	24.2375	24.2875	166860.0
2016-01-15 07:00:00	AAPL	Stock	24.325	24.45	24.325	24.4125	363936.0
2016-01-15 08:00:00	AAPL	Stock	24.42	24.4375	24.0375	24.15	1717988.0
2016-01-15 09:00:00	AAPL	Stock	24.15	24.375	23.8825	24.249	45789968.0
2016-01-15 10:00:00	AAPL	Stock	24.2505	24.3375	24.005	24.021	36083812.0
2016-01-15 11:00:00	AAPL	Stock	24.018	24.1325	23.945	24.0125	33902760.0
2016-01-15 12:00:00	AAPL	Stock	24.01	24.165	23.84	24.1425	35816948.0
2016-01-15 13:00:00	AAPL	Stock	24.14	24.3825	24.105	24.3025	34700476.0
2016-01-15 14:00:00	AAPL	Stock	24.305	24.3998	24.1775	24.38	27581512.0
2016-01-15 15:00:00	AAPL	Stock	24.3775	24.4275	24.185	24.2725	38582824.0
2016-01-15 16:00:00	AAPL	Stock	24.2675	24.315	24.26	24.2875	16343856.0
2016-01-15 17:00:00	AAPL	Stock	24.2925	24.3125	24.275	24.2875	207040.0
2016-01-15 18:00:00	AAPL	Stock	24.29	24.3075	24.2775	24.2875	815928.0
2016-01-15 19:00:00	AAPL	Stock	24.285	24.2875	24.2675	24.2825	782424.0
2016-01-15 04:00:00	MSFT	Stock	52.48	52.48	52.48	52.48	100.0
2016-01-15 06:00:00	MSFT	Stock	51.93	51.93	51.66	51.66	6498.0
2016-01-15 07:00:00	MSFT	Stock	51.77	52.08	51.77	51.95	3558.0
2016-01-15 08:00:00	MSFT	Stock	51.95	52.0	51.35	51.55	125302.0
2016-01-15 09:00:00	MSFT	Stock	51.55	51.97	51.02	51.32	11486079.0
2016-01-15 10:00:00	MSFT	Stock	51.32	51.73	51.11	51.196	8539463.0
2016-01-15 11:00:00	MSFT	Stock	51.2	51.32	50.87	51.05	6641075.0
2016-01-15 12:00:00	MSFT	Stock	51.05	51.11	50.39	50.91	6648558.0
2016-01-15 13:00:00	MSFT	Stock	50.91	51.02	50.34	50.895	7154916.0
2016-01-15 14:00:00	MSFT	Stock	50.9	51.23	50.69	51.17	6723105.0
2016-01-15 15:00:00	MSFT	Stock	51.17	51.8	50.48	50.98	11885273.0
2016-01-15 16:00:00	MSFT	Stock	50.97	51.1	50.97	51.0	5183425.0
2016-01-15 17:00:00	MSFT	Stock	51.0	51.05	50.98	51.05	15846.0
2016-01-15 18:00:00	MSFT	Stock	51.01	51.02	50.91	50.99	732850.0
2016-01-15 19:00:00	MSFT	Stock	50.99	51.1	50.99	51.03	4136.0
2016-01-15 08:00:00	NVDA	Stock	0.7058	0.7058	0.6842	0.6875	1743360.0
2016-01-15 09:00:00	NVDA	Stock	0.6878	0.6962	0.6772	0.683	89987040.0
2016-01-15 10:00:00	NVDA	Stock	0.683	0.6878	0.6735	0.6753	160272200.0
2016-01-15 11:00:00	NVDA	Stock	0.6753	0.6794	0.6722	0.6735	73538240.0
2016-01-15 12:00:00	NVDA	Stock	0.6734	0.676	0.666	0.6737	82293440.0
2016-01-15 13:00:00	NVDA	Stock	0.6735	0.6765	0.6678	0.674	70212080.0
2016-01-15 14:00:00	NVDA	Stock	0.6742	0.6848	0.673	0.6845	106104960.0
2016-01-15 15:00:00	NVDA	Stock	0.6845	0.6848	0.6755	0.6778	179735840.0
2016-01-15 16:00:00	NVDA	Stock	0.6778	0.6812	0.6778	0.68	17479160.0
2016-01-15 18:00:00	NVDA	Stock	0.6782	0.6782	0.678	0.6782	58000.0
2016-01-15 19:00:00	NVDA	Stock	0.678	0.6782	0.678	0.6782	29120.0
2016-01-15 04:00:00	AMZN	Stock	29.6495	29.6495	29.2655	29.2705	52960.0
2016-01-15 05:00:00	AMZN	Stock	29.175	29.175	29.175	29.175	2700.0
2016-01-15 06:00:00	AMZN	Stock	29.15	29.236	29.1	29.236	12000.0
2016-01-15 07:00:00	AMZN	Stock	29.175	29.289	29.175	29.255	35780.0
2016-01-15 08:00:00	AMZN	Stock	29.24	29.294	28.685	28.7	896660.0
2016-01-15 09:00:00	AMZN	Stock	28.7385	29.231	28.557	28.85	24831880.0
2016-01-15 10:00:00	AMZN	Stock	28.811	29.0775	28.5255	28.55	16834100.0
2016-01-15 11:00:00	AMZN	Stock	28.5436	28.6775	28.48	28.595	14571340.0

> showing 50 of 50,861 rows — these rows as CSV

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