PREVIEW / stock_1hour / 2013-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-06.parquet
  size:    977 KB
  rows:    45,470
  symbols: 3,482

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-03-06 04:00:00	AAPL	Stock	15.3979	15.4286	15.3929	15.4286	22400.0
2013-03-06 05:00:00	AAPL	Stock	15.4214	15.4286	15.4007	15.4146	35728.0
2013-03-06 06:00:00	AAPL	Stock	15.4214	15.4232	15.4125	15.4232	30800.0
2013-03-06 07:00:00	AAPL	Stock	15.4196	15.4554	15.32	15.3746	1013600.0
2013-03-06 08:00:00	AAPL	Stock	15.3754	15.4821	15.3518	15.4571	3167696.0
2013-03-06 09:00:00	AAPL	Stock	15.4561	15.5446	15.2268	15.25	101676316.0
2013-03-06 10:00:00	AAPL	Stock	15.25	15.3214	15.2039	15.2779	84531888.0
2013-03-06 11:00:00	AAPL	Stock	15.2789	15.3814	15.2536	15.2879	51979956.0
2013-03-06 12:00:00	AAPL	Stock	15.2835	15.3136	15.21	15.2193	32683896.0
2013-03-06 13:00:00	AAPL	Stock	15.2196	15.24	15.1825	15.2061	41139140.0
2013-03-06 14:00:00	AAPL	Stock	15.2057	15.2946	15.1964	15.2561	38489500.0
2013-03-06 15:00:00	AAPL	Stock	15.2564	15.2564	15.1582	15.2018	67890256.0
2013-03-06 16:00:00	AAPL	Stock	15.2021	15.4384	15.1789	15.1836	27368656.0
2013-03-06 17:00:00	AAPL	Stock	15.1854	15.2021	15.1746	15.1786	446600.0
2013-03-06 18:00:00	AAPL	Stock	15.1821	15.1839	15.175	15.1839	457100.0
2013-03-06 19:00:00	AAPL	Stock	15.1839	15.1875	15.1789	15.1829	179256.0
2013-03-06 04:00:00	MSFT	Stock	28.19	28.19	28.19	28.19	100.0
2013-03-06 06:00:00	MSFT	Stock	28.21	28.33	28.15	28.29	5950.0
2013-03-06 07:00:00	MSFT	Stock	28.24	28.24	28.08	28.18	16940.0
2013-03-06 08:00:00	MSFT	Stock	28.12	28.3	28.11	28.29	39100.0
2013-03-06 09:00:00	MSFT	Stock	28.2	28.23	27.78	27.94	11781068.0
2013-03-06 10:00:00	MSFT	Stock	27.94	28.08	27.9	27.934	8541756.0
2013-03-06 11:00:00	MSFT	Stock	27.94	28.04	27.92	27.995	5516029.0
2013-03-06 12:00:00	MSFT	Stock	27.996	28.045	27.968	28.005	5060229.0
2013-03-06 13:00:00	MSFT	Stock	28.01	28.1	28.0	28.085	3220535.0
2013-03-06 14:00:00	MSFT	Stock	28.08	28.22	28.04	28.155	6365009.0
2013-03-06 15:00:00	MSFT	Stock	28.16	28.21	28.05	28.09	8224702.0
2013-03-06 16:00:00	MSFT	Stock	28.09	28.18	27.92	28.02	2002576.0
2013-03-06 17:00:00	MSFT	Stock	28.35	28.35	28.02	28.03	13154.0
2013-03-06 19:00:00	MSFT	Stock	28.09	28.09	28.09	28.09	461.0
2013-03-06 08:00:00	NVDA	Stock	0.3215	0.3223	0.3203	0.3223	28000.0
2013-03-06 09:00:00	NVDA	Stock	0.3223	0.325	0.3205	0.3243	56191840.0
2013-03-06 10:00:00	NVDA	Stock	0.3244	0.3248	0.321	0.321	64725640.0
2013-03-06 11:00:00	NVDA	Stock	0.321	0.3215	0.3195	0.32	30134640.0
2013-03-06 12:00:00	NVDA	Stock	0.3198	0.3198	0.3185	0.3188	30843360.0
2013-03-06 13:00:00	NVDA	Stock	0.3188	0.3195	0.3183	0.3183	29580360.0
2013-03-06 14:00:00	NVDA	Stock	0.3184	0.3195	0.3183	0.3192	47823920.0
2013-03-06 15:00:00	NVDA	Stock	0.3192	0.32	0.3185	0.3198	70206920.0
2013-03-06 16:00:00	NVDA	Stock	0.3198	0.32	0.3188	0.32	8754280.0
2013-03-06 17:00:00	NVDA	Stock	0.32	0.32	0.3198	0.32	758000.0
2013-03-06 18:00:00	NVDA	Stock	0.3198	0.3198	0.3198	0.3198	36000.0
2013-03-06 04:00:00	AMZN	Stock	13.79	13.79	13.79	13.79	2000.0
2013-03-06 06:00:00	AMZN	Stock	13.795	13.805	13.795	13.8	6000.0
2013-03-06 07:00:00	AMZN	Stock	13.8	13.8	13.7805	13.785	28000.0
2013-03-06 08:00:00	AMZN	Stock	13.8	13.835	13.7695	13.825	167660.0
2013-03-06 09:00:00	AMZN	Stock	13.824	13.8244	13.6785	13.744	8356620.0
2013-03-06 10:00:00	AMZN	Stock	13.752	13.7651	13.615	13.624	8671420.0
2013-03-06 11:00:00	AMZN	Stock	13.6235	13.68	13.604	13.6097	5327360.0
2013-03-06 12:00:00	AMZN	Stock	13.6125	13.6395	13.5916	13.598	3508800.0
2013-03-06 13:00:00	AMZN	Stock	13.5995	13.6565	13.5935	13.65	2852260.0

> showing 50 of 45,470 rows — these rows as CSV

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