PREVIEW / stock_1hour / 2016-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-05.parquet
  size:    1.0 MB
  rows:    48,307
  symbols: 3,297

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-05-05 05:00:00	AAPL	Stock	23.5875	23.5975	23.57	23.5875	9972.0
2016-05-05 06:00:00	AAPL	Stock	23.575	23.575	23.5	23.5375	10116.0
2016-05-05 07:00:00	AAPL	Stock	23.55	23.55	23.495	23.5125	40196.0
2016-05-05 08:00:00	AAPL	Stock	23.52	23.5625	23.5	23.51	254736.0
2016-05-05 09:00:00	AAPL	Stock	23.52	23.53	23.25	23.2798	20436812.0
2016-05-05 10:00:00	AAPL	Stock	23.2775	23.385	23.2075	23.3	23832796.0
2016-05-05 11:00:00	AAPL	Stock	23.3	23.36	23.26	23.2958	13888560.0
2016-05-05 12:00:00	AAPL	Stock	23.295	23.3275	23.2275	23.2425	11704980.0
2016-05-05 13:00:00	AAPL	Stock	23.2415	23.2525	23.17	23.215	15574792.0
2016-05-05 14:00:00	AAPL	Stock	23.215	23.3	23.1788	23.2462	13977696.0
2016-05-05 15:00:00	AAPL	Stock	23.2462	23.31	23.215	23.31	22108248.0
2016-05-05 16:00:00	AAPL	Stock	23.31	23.3375	23.265	23.31	10179124.0
2016-05-05 17:00:00	AAPL	Stock	23.3	23.32	23.295	23.31	43680.0
2016-05-05 18:00:00	AAPL	Stock	23.3025	23.31	23.29	23.3	51724.0
2016-05-05 19:00:00	AAPL	Stock	23.3075	23.3075	23.2875	23.3025	38084.0
2016-05-05 07:00:00	MSFT	Stock	50.15	50.15	50.0	50.0	560.0
2016-05-05 08:00:00	MSFT	Stock	50.05	50.14	50.01	50.06	10376.0
2016-05-05 09:00:00	MSFT	Stock	50.05	50.05	49.73	49.78	2918892.0
2016-05-05 10:00:00	MSFT	Stock	49.78	50.09	49.748	50.08	3505736.0
2016-05-05 11:00:00	MSFT	Stock	50.09	50.3	50.05	50.15	2629936.0
2016-05-05 12:00:00	MSFT	Stock	50.15	50.16	49.985	50.032	1731846.0
2016-05-05 13:00:00	MSFT	Stock	50.03	50.05	49.855	49.94	2259620.0
2016-05-05 14:00:00	MSFT	Stock	49.94	50.04	49.88	49.926	2106429.0
2016-05-05 15:00:00	MSFT	Stock	49.92	49.99	49.815	49.94	5661736.0
2016-05-05 16:00:00	MSFT	Stock	49.93	49.95	49.91	49.91	2834195.0
2016-05-05 17:00:00	MSFT	Stock	49.94	49.94	49.94	49.94	750.0
2016-05-05 18:00:00	MSFT	Stock	49.94	49.94	49.9	49.9	3629.0
2016-05-05 19:00:00	MSFT	Stock	49.93	50.0	49.82	50.0	2700.0
2016-05-05 04:00:00	NVDA	Stock	0.87	0.87	0.87	0.87	4000.0
2016-05-05 09:00:00	NVDA	Stock	0.8772	0.8775	0.8698	0.87	26572640.0
2016-05-05 10:00:00	NVDA	Stock	0.87	0.8785	0.8678	0.8785	34195160.0
2016-05-05 11:00:00	NVDA	Stock	0.8785	0.8845	0.8746	0.8818	27911200.0
2016-05-05 12:00:00	NVDA	Stock	0.8815	0.882	0.8785	0.8805	17152840.0
2016-05-05 13:00:00	NVDA	Stock	0.8802	0.8811	0.876	0.8795	23692520.0
2016-05-05 14:00:00	NVDA	Stock	0.8795	0.8808	0.8765	0.8768	28575200.0
2016-05-05 15:00:00	NVDA	Stock	0.8768	0.8768	0.8725	0.874	58288200.0
2016-05-05 16:00:00	NVDA	Stock	0.8742	0.8772	0.8742	0.8755	15957160.0
2016-05-05 17:00:00	NVDA	Stock	0.875	0.875	0.875	0.875	4000.0
2016-05-05 18:00:00	NVDA	Stock	0.875	0.8785	0.8742	0.8785	208800.0
2016-05-05 06:00:00	AMZN	Stock	33.65	33.729	33.65	33.654	12140.0
2016-05-05 07:00:00	AMZN	Stock	33.675	33.693	33.6515	33.693	8200.0
2016-05-05 08:00:00	AMZN	Stock	33.675	33.775	33.545	33.75	653260.0
2016-05-05 09:00:00	AMZN	Stock	33.75	33.8245	33.459	33.4759	11337700.0
2016-05-05 10:00:00	AMZN	Stock	33.474	33.6	33.3225	33.4665	11929440.0
2016-05-05 11:00:00	AMZN	Stock	33.4565	33.487	33.3225	33.391	6079860.0
2016-05-05 12:00:00	AMZN	Stock	33.3955	33.4088	33.2585	33.2842	6898280.0
2016-05-05 13:00:00	AMZN	Stock	33.2795	33.3125	32.8	32.991	21479840.0
2016-05-05 14:00:00	AMZN	Stock	32.991	33.1231	32.9416	32.9705	9516600.0
2016-05-05 15:00:00	AMZN	Stock	32.951	33.019	32.875	32.9525	13272880.0
2016-05-05 16:00:00	AMZN	Stock	32.9525	32.9995	32.8335	32.9205	3637880.0

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

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