PREVIEW / stock_1hour / 2014-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-13.parquet
  size:    1.1 MB
  rows:    48,640
  symbols: 3,532

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-01-13 04:00:00	AAPL	Stock	19.0339	19.0357	19.0179	19.0179	25396.0
2014-01-13 05:00:00	AAPL	Stock	19.0732	19.0732	19.0693	19.0693	18200.0
2014-01-13 06:00:00	AAPL	Stock	19.0829	19.0829	19.0789	19.0814	38360.0
2014-01-13 07:00:00	AAPL	Stock	19.1071	19.1571	19.0821	19.1429	447076.0
2014-01-13 08:00:00	AAPL	Stock	19.1286	19.1554	19.0179	19.0364	1912708.0
2014-01-13 09:00:00	AAPL	Stock	19.0357	19.2482	18.9118	19.2393	62971580.0
2014-01-13 10:00:00	AAPL	Stock	19.2418	19.2929	19.2243	19.2718	46852624.0
2014-01-13 11:00:00	AAPL	Stock	19.2744	19.3732	19.2607	19.3568	37460500.0
2014-01-13 12:00:00	AAPL	Stock	19.3557	19.375	19.2811	19.2886	30323272.0
2014-01-13 13:00:00	AAPL	Stock	19.2882	19.2886	19.1946	19.2429	27463520.0
2014-01-13 14:00:00	AAPL	Stock	19.2421	19.2729	19.1032	19.1539	31341576.0
2014-01-13 15:00:00	AAPL	Stock	19.1539	19.1564	18.9654	19.1286	64055684.0
2014-01-13 16:00:00	AAPL	Stock	19.1332	19.1824	18.9394	19.1314	12542796.0
2014-01-13 17:00:00	AAPL	Stock	19.1296	19.1429	19.1232	19.1232	365148.0
2014-01-13 18:00:00	AAPL	Stock	19.1286	19.1607	19.1225	19.1607	527408.0
2014-01-13 19:00:00	AAPL	Stock	19.1607	19.1657	19.1482	19.1571	218596.0
2014-01-13 05:00:00	MSFT	Stock	36.09	36.09	36.09	36.09	800.0
2014-01-13 06:00:00	MSFT	Stock	36.03	36.03	36.03	36.03	100.0
2014-01-13 07:00:00	MSFT	Stock	36.09	36.09	36.01	36.02	1358.0
2014-01-13 08:00:00	MSFT	Stock	36.0	36.03	35.97	36.01	8946.0
2014-01-13 09:00:00	MSFT	Stock	36.03	36.04	35.61	35.63	3450329.0
2014-01-13 10:00:00	MSFT	Stock	35.63	35.74	35.57	35.705	5256522.0
2014-01-13 11:00:00	MSFT	Stock	35.71	35.8	35.65	35.77	2894471.0
2014-01-13 12:00:00	MSFT	Stock	35.77	35.77	35.53	35.54	2924870.0
2014-01-13 13:00:00	MSFT	Stock	35.54	35.54	35.35	35.42	3435440.0
2014-01-13 14:00:00	MSFT	Stock	35.42	35.47	35.17	35.195	4827642.0
2014-01-13 15:00:00	MSFT	Stock	35.19	35.19	34.83	34.98	17748616.0
2014-01-13 16:00:00	MSFT	Stock	34.99	35.665	34.91	34.97	3800449.0
2014-01-13 17:00:00	MSFT	Stock	34.96	35.03	34.96	35.03	4017.0
2014-01-13 18:00:00	MSFT	Stock	35.03	35.713	34.98	34.99	15047.0
2014-01-13 19:00:00	MSFT	Stock	34.99	35.01	34.98	35.01	5737.0
2014-01-13 08:00:00	NVDA	Stock	0.3973	0.3973	0.3962	0.3965	45000.0
2014-01-13 09:00:00	NVDA	Stock	0.3933	0.3946	0.3915	0.3915	20497760.0
2014-01-13 10:00:00	NVDA	Stock	0.3918	0.395	0.3916	0.3945	24162680.0
2014-01-13 11:00:00	NVDA	Stock	0.3945	0.3955	0.3933	0.3952	21966920.0
2014-01-13 12:00:00	NVDA	Stock	0.3953	0.3956	0.3918	0.3918	18841240.0
2014-01-13 13:00:00	NVDA	Stock	0.3918	0.3919	0.3885	0.3893	25274440.0
2014-01-13 14:00:00	NVDA	Stock	0.3891	0.3891	0.3862	0.3866	29895720.0
2014-01-13 15:00:00	NVDA	Stock	0.3865	0.3865	0.3833	0.384	84460200.0
2014-01-13 16:00:00	NVDA	Stock	0.384	0.3939	0.3839	0.3839	1182960.0
2014-01-13 08:00:00	AMZN	Stock	19.9	19.9055	19.883	19.8915	127200.0
2014-01-13 09:00:00	AMZN	Stock	19.883	19.9615	19.825	19.8504	5286180.0
2014-01-13 10:00:00	AMZN	Stock	19.851	19.989	19.8405	19.9098	5507520.0
2014-01-13 11:00:00	AMZN	Stock	19.9125	19.9835	19.8635	19.9655	4104220.0
2014-01-13 12:00:00	AMZN	Stock	19.957	19.9808	19.875	19.887	4831200.0
2014-01-13 13:00:00	AMZN	Stock	19.8868	19.923	19.7555	19.798	4530260.0
2014-01-13 14:00:00	AMZN	Stock	19.785	19.8105	19.5805	19.621	6280300.0
2014-01-13 15:00:00	AMZN	Stock	19.616	19.616	19.4225	19.543	17394000.0
2014-01-13 16:00:00	AMZN	Stock	19.549	19.914	19.5375	19.57	355540.0
2014-01-13 17:00:00	AMZN	Stock	19.5605	19.599	19.5605	19.575	37000.0

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

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