PREVIEW / stock_1hour / 2012-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-29.parquet
  size:    940 KB
  rows:    44,757
  symbols: 3,489

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
2012-11-29 04:00:00	AAPL	Stock	20.9321	20.9464	20.9314	20.9375	42000.0
2012-11-29 05:00:00	AAPL	Stock	20.9464	20.9607	20.9314	20.9607	49000.0
2012-11-29 06:00:00	AAPL	Stock	20.9582	20.9607	20.9307	20.9607	33600.0
2012-11-29 07:00:00	AAPL	Stock	20.96	21.0368	20.9243	21.0286	1461768.0
2012-11-29 08:00:00	AAPL	Stock	21.0268	21.0318	20.9693	21.0239	3358152.0
2012-11-29 09:00:00	AAPL	Stock	21.0229	21.2232	21.0089	21.1129	90218296.0
2012-11-29 10:00:00	AAPL	Stock	21.1132	21.1732	20.9646	21.1371	109463116.0
2012-11-29 11:00:00	AAPL	Stock	21.1375	21.1518	20.9018	21.0218	83867308.0
2012-11-29 12:00:00	AAPL	Stock	21.0237	21.0964	20.95	21.0296	53227636.0
2012-11-29 13:00:00	AAPL	Stock	21.0311	21.0786	20.9704	21.0421	36930544.0
2012-11-29 14:00:00	AAPL	Stock	21.04	21.1311	20.9879	21.0841	43567244.0
2012-11-29 15:00:00	AAPL	Stock	21.0839	21.1039	21.0114	21.0482	69254724.0
2012-11-29 16:00:00	AAPL	Stock	21.0345	21.0818	21.0286	21.0421	6481272.0
2012-11-29 17:00:00	AAPL	Stock	21.0346	21.0346	20.9575	20.9857	522060.0
2012-11-29 18:00:00	AAPL	Stock	20.9821	21.0104	20.9529	20.9529	550844.0
2012-11-29 19:00:00	AAPL	Stock	20.9507	20.9821	20.9393	20.9564	391636.0
2012-11-29 04:00:00	MSFT	Stock	27.54	27.54	27.54	27.54	150.0
2012-11-29 06:00:00	MSFT	Stock	27.6	27.6	27.55	27.55	2300.0
2012-11-29 07:00:00	MSFT	Stock	27.55	27.59	27.54	27.58	12050.0
2012-11-29 08:00:00	MSFT	Stock	27.5	27.58	27.34	27.35	90479.0
2012-11-29 09:00:00	MSFT	Stock	27.35	27.4	27.0	27.26	5817464.0
2012-11-29 10:00:00	MSFT	Stock	27.26	27.32	27.19	27.295	10090061.0
2012-11-29 11:00:00	MSFT	Stock	27.29	27.292	27.04	27.065	15937145.0
2012-11-29 12:00:00	MSFT	Stock	27.07	27.11	26.97	27.05	8546791.0
2012-11-29 13:00:00	MSFT	Stock	27.05	27.07	27.0	27.036	6004917.0
2012-11-29 14:00:00	MSFT	Stock	27.03	27.04	26.93	26.95	7269757.0
2012-11-29 15:00:00	MSFT	Stock	26.945	27.0	26.86	26.938	12177094.0
2012-11-29 16:00:00	MSFT	Stock	26.95	27.215	26.88	26.98	1760340.0
2012-11-29 17:00:00	MSFT	Stock	26.98	26.98	26.87	26.88	37093.0
2012-11-29 18:00:00	MSFT	Stock	26.9	26.94	26.88	26.9	7123.0
2012-11-29 19:00:00	MSFT	Stock	26.89	26.92	26.89	26.91	23225.0
2012-11-29 08:00:00	NVDA	Stock	0.3065	0.3095	0.3065	0.3095	32000.0
2012-11-29 09:00:00	NVDA	Stock	0.3095	0.3095	0.305	0.306	38393800.0
2012-11-29 10:00:00	NVDA	Stock	0.306	0.3066	0.304	0.3045	71403120.0
2012-11-29 11:00:00	NVDA	Stock	0.3048	0.3048	0.3	0.303	90225720.0
2012-11-29 12:00:00	NVDA	Stock	0.3028	0.3045	0.3005	0.3012	57160240.0
2012-11-29 13:00:00	NVDA	Stock	0.3015	0.3022	0.3008	0.3012	37889560.0
2012-11-29 14:00:00	NVDA	Stock	0.3015	0.3032	0.3002	0.3026	34645840.0
2012-11-29 15:00:00	NVDA	Stock	0.3025	0.303	0.3005	0.3012	117143040.0
2012-11-29 16:00:00	NVDA	Stock	0.301	0.3078	0.3008	0.301	5321960.0
2012-11-29 18:00:00	NVDA	Stock	0.301	0.301	0.301	0.301	60000.0
2012-11-29 19:00:00	NVDA	Stock	0.3008	0.3008	0.3008	0.3008	8000.0
2012-11-29 04:00:00	AMZN	Stock	12.37	12.3995	12.37	12.3995	4000.0
2012-11-29 07:00:00	AMZN	Stock	12.398	12.425	12.3925	12.4105	105800.0
2012-11-29 08:00:00	AMZN	Stock	12.4105	12.42	12.335	12.41	164400.0
2012-11-29 09:00:00	AMZN	Stock	12.409	12.5005	12.375	12.494	22716240.0
2012-11-29 10:00:00	AMZN	Stock	12.495	12.5495	12.4165	12.5272	22082820.0
2012-11-29 11:00:00	AMZN	Stock	12.5225	12.5385	12.4345	12.457	14552680.0
2012-11-29 12:00:00	AMZN	Stock	12.4565	12.5275	12.429	12.494	7393500.0
2012-11-29 13:00:00	AMZN	Stock	12.496	12.5655	12.493	12.536	8274640.0

> showing 50 of 44,757 rows — these rows as CSV

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