PREVIEW / stock_1hour / 2014-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-01.parquet
  size:    1.0 MB
  rows:    49,008
  symbols: 3,540

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
2014-05-01 06:00:00	AAPL	Stock	21.0757	21.0757	21.0757	21.0757	7392.0
2014-05-01 07:00:00	AAPL	Stock	21.1404	21.1632	21.1071	21.14	208600.0
2014-05-01 08:00:00	AAPL	Stock	21.1371	21.1857	21.1314	21.1571	1102528.0
2014-05-01 09:00:00	AAPL	Stock	21.1589	21.23	21.0807	21.1429	38662988.0
2014-05-01 10:00:00	AAPL	Stock	21.1418	21.2429	21.1075	21.2114	33129152.0
2014-05-01 11:00:00	AAPL	Stock	21.2143	21.2354	21.01	21.04	31418660.0
2014-05-01 12:00:00	AAPL	Stock	21.04	21.0632	20.9414	21.0468	23310336.0
2014-05-01 13:00:00	AAPL	Stock	21.045	21.1696	20.9954	21.104	19824308.0
2014-05-01 14:00:00	AAPL	Stock	21.1054	21.1579	21.0929	21.1286	15958012.0
2014-05-01 15:00:00	AAPL	Stock	21.1293	21.1357	21.0411	21.12	24376968.0
2014-05-01 16:00:00	AAPL	Stock	21.12	21.2429	21.0739	21.0739	7225400.0
2014-05-01 17:00:00	AAPL	Stock	21.1143	21.1329	21.1107	21.125	213584.0
2014-05-01 18:00:00	AAPL	Stock	21.1232	21.1232	21.1232	21.1232	14000.0
2014-05-01 19:00:00	AAPL	Stock	21.1157	21.1214	21.1089	21.1089	98756.0
2014-05-01 08:00:00	MSFT	Stock	40.5	40.5	40.3	40.31	19885.0
2014-05-01 09:00:00	MSFT	Stock	40.4	40.4	40.17	40.19	3167036.0
2014-05-01 10:00:00	MSFT	Stock	40.19	40.23	40.07	40.085	4338925.0
2014-05-01 11:00:00	MSFT	Stock	40.09	40.2	40.07	40.14	2915924.0
2014-05-01 12:00:00	MSFT	Stock	40.14	40.2	40.12	40.13	1754419.0
2014-05-01 13:00:00	MSFT	Stock	40.135	40.15	39.95	39.97	3539933.0
2014-05-01 14:00:00	MSFT	Stock	39.97	40.0	39.96	39.97	3089813.0
2014-05-01 15:00:00	MSFT	Stock	39.98	40.045	39.95	39.99	7780536.0
2014-05-01 16:00:00	MSFT	Stock	39.99	40.163	39.95	40.0	1537111.0
2014-05-01 17:00:00	MSFT	Stock	40.0	40.0	39.99	40.0	378.0
2014-05-01 18:00:00	MSFT	Stock	39.99	39.99	39.97	39.97	717.0
2014-05-01 19:00:00	MSFT	Stock	39.97	40.0	39.96	39.96	3183.0
2014-05-01 09:00:00	NVDA	Stock	0.4643	0.4688	0.463	0.4655	29816880.0
2014-05-01 10:00:00	NVDA	Stock	0.4658	0.4688	0.4641	0.468	25265120.0
2014-05-01 11:00:00	NVDA	Stock	0.4679	0.4698	0.4678	0.4688	29304040.0
2014-05-01 12:00:00	NVDA	Stock	0.4688	0.4694	0.4651	0.466	17479560.0
2014-05-01 13:00:00	NVDA	Stock	0.466	0.4662	0.4616	0.4619	18997400.0
2014-05-01 14:00:00	NVDA	Stock	0.462	0.463	0.4605	0.461	22118600.0
2014-05-01 15:00:00	NVDA	Stock	0.4612	0.4652	0.4608	0.4643	45532040.0
2014-05-01 16:00:00	NVDA	Stock	0.4641	0.4653	0.4641	0.4643	175440.0
2014-05-01 18:00:00	NVDA	Stock	0.4638	0.4638	0.4638	0.4638	4000.0
2014-05-01 05:00:00	AMZN	Stock	15.25	15.25	15.25	15.25	2000.0
2014-05-01 07:00:00	AMZN	Stock	15.3	15.3	15.25	15.25	16800.0
2014-05-01 08:00:00	AMZN	Stock	15.3	15.3	15.25	15.254	70140.0
2014-05-01 09:00:00	AMZN	Stock	15.227	15.408	15.2	15.3705	14421460.0
2014-05-01 10:00:00	AMZN	Stock	15.3715	15.455	15.3252	15.4	16688520.0
2014-05-01 11:00:00	AMZN	Stock	15.397	15.4875	15.3585	15.4105	9235820.0
2014-05-01 12:00:00	AMZN	Stock	15.403	15.483	15.395	15.4635	5755540.0
2014-05-01 13:00:00	AMZN	Stock	15.4635	15.524	15.3845	15.4	8742840.0
2014-05-01 14:00:00	AMZN	Stock	15.405	15.4745	15.3365	15.3935	10805860.0
2014-05-01 15:00:00	AMZN	Stock	15.39	15.447	15.3275	15.3895	14345720.0
2014-05-01 16:00:00	AMZN	Stock	15.3945	15.4276	15.39	15.3945	357340.0
2014-05-01 17:00:00	AMZN	Stock	15.3875	15.4125	15.3875	15.4125	4500.0
2014-05-01 08:00:00	GOOGL	Stock	26.744	26.7655	26.744	26.7655	8000.0
2014-05-01 09:00:00	GOOGL	Stock	26.8	26.8685	26.6445	26.844	5851180.0
2014-05-01 10:00:00	GOOGL	Stock	26.8435	26.9955	26.702	26.742	6636760.0

> showing 50 of 49,008 rows — these rows as CSV

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