PREVIEW / stock_1hour / 2013-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-30.parquet
  size:    1004 KB
  rows:    47,234
  symbols: 3,508

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
2013-05-30 04:00:00	AAPL	Stock	15.875	15.875	15.875	15.875	3920.0
2013-05-30 05:00:00	AAPL	Stock	15.8929	15.8929	15.8929	15.8929	2800.0
2013-05-30 06:00:00	AAPL	Stock	15.8839	15.91	15.8839	15.91	6272.0
2013-05-30 07:00:00	AAPL	Stock	15.9196	16.0354	15.9196	15.9304	479836.0
2013-05-30 08:00:00	AAPL	Stock	15.9379	16.0004	15.9107	15.9511	1051932.0
2013-05-30 09:00:00	AAPL	Stock	15.9471	15.9946	15.8754	15.9917	51739492.0
2013-05-30 10:00:00	AAPL	Stock	15.9886	15.9993	15.9036	15.9643	52958780.0
2013-05-30 11:00:00	AAPL	Stock	15.9682	16.0621	15.9529	16.054	43338512.0
2013-05-30 12:00:00	AAPL	Stock	16.0571	16.0875	16.0157	16.0837	32230604.0
2013-05-30 13:00:00	AAPL	Stock	16.0846	16.1646	16.0696	16.153	48001072.0
2013-05-30 14:00:00	AAPL	Stock	16.1554	16.1845	16.1164	16.1806	38538192.0
2013-05-30 15:00:00	AAPL	Stock	16.1764	16.2321	16.125	16.1282	64773072.0
2013-05-30 16:00:00	AAPL	Stock	16.1282	16.1878	16.0576	16.1179	16360344.0
2013-05-30 17:00:00	AAPL	Stock	16.1225	16.1304	15.953	16.1286	194096.0
2013-05-30 18:00:00	AAPL	Stock	16.1279	16.1279	16.1196	16.1214	53200.0
2013-05-30 19:00:00	AAPL	Stock	16.125	16.1357	16.1136	16.125	143304.0
2013-05-30 07:00:00	MSFT	Stock	35.16	35.16	34.99	35.0	7550.0
2013-05-30 08:00:00	MSFT	Stock	34.99	35.1	34.89	34.9	16042.0
2013-05-30 09:00:00	MSFT	Stock	34.89	35.19	34.813	35.085	5229099.0
2013-05-30 10:00:00	MSFT	Stock	35.07	35.11	34.96	35.075	9037130.0
2013-05-30 11:00:00	MSFT	Stock	35.075	35.09	34.98	34.999	4425224.0
2013-05-30 12:00:00	MSFT	Stock	35.0	35.02	34.92	34.932	3555759.0
2013-05-30 13:00:00	MSFT	Stock	34.94	35.11	34.88	35.1	4562912.0
2013-05-30 14:00:00	MSFT	Stock	35.09	35.21	35.08	35.196	4406527.0
2013-05-30 15:00:00	MSFT	Stock	35.194	35.25	35.02	35.03	10098438.0
2013-05-30 16:00:00	MSFT	Stock	35.03	35.2	34.89	35.02	6000722.0
2013-05-30 17:00:00	MSFT	Stock	35.033	35.11	35.02	35.02	23600.0
2013-05-30 18:00:00	MSFT	Stock	35.03	35.03	35.0	35.0	2314.0
2013-05-30 19:00:00	MSFT	Stock	35.02	35.02	35.02	35.02	497.0
2013-05-30 09:00:00	NVDA	Stock	0.3608	0.3625	0.3595	0.3612	29663800.0
2013-05-30 10:00:00	NVDA	Stock	0.3612	0.3659	0.3611	0.3656	57742200.0
2013-05-30 11:00:00	NVDA	Stock	0.3658	0.3675	0.365	0.3674	30998160.0
2013-05-30 12:00:00	NVDA	Stock	0.3674	0.3684	0.366	0.3679	33467600.0
2013-05-30 13:00:00	NVDA	Stock	0.3681	0.3694	0.3666	0.367	37162240.0
2013-05-30 14:00:00	NVDA	Stock	0.3672	0.3688	0.3668	0.3669	25005160.0
2013-05-30 15:00:00	NVDA	Stock	0.3668	0.367	0.3654	0.3655	53977960.0
2013-05-30 16:00:00	NVDA	Stock	0.3658	0.3658	0.3648	0.3655	4200440.0
2013-05-30 18:00:00	NVDA	Stock	0.3652	0.3652	0.3652	0.3652	20000.0
2013-05-30 06:00:00	AMZN	Stock	13.2555	13.2555	13.2555	13.2555	6000.0
2013-05-30 07:00:00	AMZN	Stock	13.312	13.317	13.312	13.317	4000.0
2013-05-30 08:00:00	AMZN	Stock	13.29	13.315	13.29	13.301	74000.0
2013-05-30 09:00:00	AMZN	Stock	13.2795	13.4285	13.2795	13.414	7009720.0
2013-05-30 10:00:00	AMZN	Stock	13.4065	13.415	13.325	13.384	5228360.0
2013-05-30 11:00:00	AMZN	Stock	13.383	13.4035	13.3435	13.4	4196760.0
2013-05-30 12:00:00	AMZN	Stock	13.3985	13.417	13.3535	13.3616	2399220.0
2013-05-30 13:00:00	AMZN	Stock	13.361	13.4045	13.357	13.3825	2189900.0
2013-05-30 14:00:00	AMZN	Stock	13.3865	13.411	13.379	13.4085	2397780.0
2013-05-30 15:00:00	AMZN	Stock	13.406	13.408	13.3375	13.342	7037580.0
2013-05-30 16:00:00	AMZN	Stock	13.3315	13.3718	13.3312	13.3714	610200.0
2013-05-30 17:00:00	AMZN	Stock	13.3735	13.3735	13.3715	13.3715	8000.0

> showing 50 of 47,234 rows — these rows as CSV

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