PREVIEW / stock_1hour / 2012-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-28.parquet
  size:    936 KB
  rows:    44,492
  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
2012-11-28 04:00:00	AAPL	Stock	20.8218	20.8218	20.8054	20.8054	5600.0
2012-11-28 06:00:00	AAPL	Stock	20.7946	20.7946	20.7571	20.7571	47908.0
2012-11-28 07:00:00	AAPL	Stock	20.7529	20.8054	20.7396	20.7464	407372.0
2012-11-28 08:00:00	AAPL	Stock	20.7425	20.8036	20.6289	20.6429	4228112.0
2012-11-28 09:00:00	AAPL	Stock	20.6429	20.6607	20.5054	20.5771	86323888.0
2012-11-28 10:00:00	AAPL	Stock	20.5704	20.7036	20.4379	20.6189	112697032.0
2012-11-28 11:00:00	AAPL	Stock	20.6179	20.6966	20.6107	20.635	48029772.0
2012-11-28 12:00:00	AAPL	Stock	20.6346	20.8661	20.5907	20.8311	78460592.0
2012-11-28 13:00:00	AAPL	Stock	20.8379	20.9214	20.7871	20.8304	42851900.0
2012-11-28 14:00:00	AAPL	Stock	20.8282	20.8571	20.6982	20.7557	48958700.0
2012-11-28 15:00:00	AAPL	Stock	20.7618	20.864	20.7454	20.8143	65239580.0
2012-11-28 16:00:00	AAPL	Stock	20.8214	20.864	20.5994	20.8193	17480848.0
2012-11-28 17:00:00	AAPL	Stock	20.8089	20.8232	20.8046	20.8179	231700.0
2012-11-28 18:00:00	AAPL	Stock	20.8129	20.8268	20.8	20.8075	347564.0
2012-11-28 19:00:00	AAPL	Stock	20.8157	20.8189	20.8007	20.815	137788.0
2012-11-28 06:00:00	MSFT	Stock	27.23	27.23	27.23	27.23	1000.0
2012-11-28 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	300.0
2012-11-28 08:00:00	MSFT	Stock	27.17	27.19	27.02	27.08	200028.0
2012-11-28 09:00:00	MSFT	Stock	27.05	27.11	26.77	26.87	6389603.0
2012-11-28 10:00:00	MSFT	Stock	26.86	27.23	26.82	27.18	9471153.0
2012-11-28 11:00:00	MSFT	Stock	27.17	27.18	27.05	27.1	7476660.0
2012-11-28 12:00:00	MSFT	Stock	27.1	27.24	27.03	27.22	8480710.0
2012-11-28 13:00:00	MSFT	Stock	27.23	27.3	27.14	27.222	3651590.0
2012-11-28 14:00:00	MSFT	Stock	27.225	27.27	27.17	27.27	3309918.0
2012-11-28 15:00:00	MSFT	Stock	27.27	27.39	27.21	27.34	8797656.0
2012-11-28 16:00:00	MSFT	Stock	27.34	27.39	27.102	27.36	3540256.0
2012-11-28 17:00:00	MSFT	Stock	27.34	27.38	27.08	27.38	9589.0
2012-11-28 18:00:00	MSFT	Stock	27.38	27.38	27.37	27.38	9750.0
2012-11-28 19:00:00	MSFT	Stock	27.36	27.39	27.35	27.35	15527.0
2012-11-28 08:00:00	NVDA	Stock	0.3038	0.3038	0.3038	0.3038	4000.0
2012-11-28 09:00:00	NVDA	Stock	0.3032	0.3032	0.299	0.3015	42082760.0
2012-11-28 10:00:00	NVDA	Stock	0.3012	0.3055	0.3	0.3052	67371720.0
2012-11-28 11:00:00	NVDA	Stock	0.305	0.3073	0.3038	0.3049	55201520.0
2012-11-28 12:00:00	NVDA	Stock	0.3048	0.3065	0.303	0.3052	37611000.0
2012-11-28 13:00:00	NVDA	Stock	0.3054	0.3058	0.3045	0.3052	24368600.0
2012-11-28 14:00:00	NVDA	Stock	0.3052	0.3055	0.304	0.3049	36764120.0
2012-11-28 15:00:00	NVDA	Stock	0.3049	0.308	0.3048	0.3062	91785960.0
2012-11-28 16:00:00	NVDA	Stock	0.3063	0.3068	0.3046	0.3067	29004600.0
2012-11-28 19:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	23520.0
2012-11-28 06:00:00	AMZN	Stock	12.1705	12.1705	12.1705	12.1705	2000.0
2012-11-28 07:00:00	AMZN	Stock	12.2	12.2	12.118	12.175	14000.0
2012-11-28 08:00:00	AMZN	Stock	12.135	12.1625	12.1	12.1	93300.0
2012-11-28 09:00:00	AMZN	Stock	12.1	12.2095	12.0752	12.1675	6816840.0
2012-11-28 10:00:00	AMZN	Stock	12.159	12.2088	12.0945	12.1845	11001180.0
2012-11-28 11:00:00	AMZN	Stock	12.1915	12.257	12.1902	12.219	5898980.0
2012-11-28 12:00:00	AMZN	Stock	12.2205	12.255	12.1755	12.2355	3902060.0
2012-11-28 13:00:00	AMZN	Stock	12.2355	12.27	12.2055	12.2475	4293980.0
2012-11-28 14:00:00	AMZN	Stock	12.2522	12.2845	12.2385	12.2685	3839400.0
2012-11-28 15:00:00	AMZN	Stock	12.2735	12.3615	12.266	12.348	14941300.0
2012-11-28 16:00:00	AMZN	Stock	12.3555	12.3625	12.24	12.3555	3863840.0

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

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