PREVIEW / stock_1hour / 2012-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-18.parquet
  size:    946 KB
  rows:    44,637
  symbols: 3,514

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-05-18 04:00:00	AAPL	Stock	18.9404	18.9404	18.85	18.8618	104720.0
2012-05-18 05:00:00	AAPL	Stock	18.8632	18.9429	18.8571	18.9321	239372.0
2012-05-18 06:00:00	AAPL	Stock	18.9321	18.9821	18.9321	18.9821	187208.0
2012-05-18 07:00:00	AAPL	Stock	19.0	19.0821	18.9929	19.0536	1325996.0
2012-05-18 08:00:00	AAPL	Stock	19.0396	19.1036	19.0021	19.0286	3533600.0
2012-05-18 09:00:00	AAPL	Stock	19.0321	19.1389	18.8807	19.0843	106252244.0
2012-05-18 10:00:00	AAPL	Stock	19.0829	19.4075	19.0714	19.3232	169949164.0
2012-05-18 11:00:00	AAPL	Stock	19.3222	19.3611	18.6493	19.0904	112342860.0
2012-05-18 12:00:00	AAPL	Stock	19.0935	19.2993	19.0893	19.2339	71391796.0
2012-05-18 13:00:00	AAPL	Stock	19.2339	19.235	19.0223	19.0486	56896560.0
2012-05-18 14:00:00	AAPL	Stock	19.0486	19.1014	19.0	19.0296	51541168.0
2012-05-18 15:00:00	AAPL	Stock	19.0289	19.0804	18.9279	18.9375	107166360.0
2012-05-18 16:00:00	AAPL	Stock	18.9339	19.1999	18.925	18.9329	14210280.0
2012-05-18 17:00:00	AAPL	Stock	18.9357	18.998	18.925	18.9393	1034180.0
2012-05-18 18:00:00	AAPL	Stock	18.9411	18.9521	18.9036	18.9111	540820.0
2012-05-18 19:00:00	AAPL	Stock	18.9032	18.9093	18.8679	18.8929	483868.0
2012-05-18 06:00:00	MSFT	Stock	29.99	29.99	29.99	29.99	1000.0
2012-05-18 07:00:00	MSFT	Stock	29.76	29.94	29.76	29.93	1228.0
2012-05-18 08:00:00	MSFT	Stock	29.89	29.97	29.8	29.83	29833.0
2012-05-18 09:00:00	MSFT	Stock	29.81	29.85	29.3	29.32	14536125.0
2012-05-18 10:00:00	MSFT	Stock	29.32	29.63	29.27	29.582	6886292.0
2012-05-18 11:00:00	MSFT	Stock	29.585	29.61	29.19	29.35	7243196.0
2012-05-18 12:00:00	MSFT	Stock	29.34	29.61	29.34	29.48	4423984.0
2012-05-18 13:00:00	MSFT	Stock	29.485	29.52	29.34	29.365	4281497.0
2012-05-18 14:00:00	MSFT	Stock	29.37	29.45	29.26	29.35	4818156.0
2012-05-18 15:00:00	MSFT	Stock	29.35	29.42	29.17	29.27	9944053.0
2012-05-18 16:00:00	MSFT	Stock	29.25	29.529	29.17	29.17	3480488.0
2012-05-18 17:00:00	MSFT	Stock	29.465	29.465	29.18	29.22	22768.0
2012-05-18 18:00:00	MSFT	Stock	29.22	29.23	29.22	29.23	1469.0
2012-05-18 19:00:00	MSFT	Stock	29.22	29.29	29.22	29.29	10588.0
2012-05-18 06:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	4000.0
2012-05-18 07:00:00	NVDA	Stock	0.3175	0.3175	0.3163	0.3163	34200.0
2012-05-18 08:00:00	NVDA	Stock	0.3175	0.3188	0.3175	0.3188	94000.0
2012-05-18 09:00:00	NVDA	Stock	0.3188	0.3188	0.3155	0.3158	60290800.0
2012-05-18 10:00:00	NVDA	Stock	0.3155	0.316	0.3125	0.3145	64851920.0
2012-05-18 11:00:00	NVDA	Stock	0.3145	0.3148	0.3045	0.3068	107424000.0
2012-05-18 12:00:00	NVDA	Stock	0.307	0.3099	0.3068	0.308	65515960.0
2012-05-18 13:00:00	NVDA	Stock	0.308	0.3085	0.3052	0.3062	54092800.0
2012-05-18 14:00:00	NVDA	Stock	0.3061	0.3065	0.304	0.3045	42890800.0
2012-05-18 15:00:00	NVDA	Stock	0.3045	0.3052	0.3005	0.3022	152245680.0
2012-05-18 16:00:00	NVDA	Stock	0.3018	0.3083	0.3005	0.302	2230840.0
2012-05-18 17:00:00	NVDA	Stock	0.3121	0.3121	0.3015	0.3015	4510000.0
2012-05-18 18:00:00	NVDA	Stock	0.304	0.304	0.3022	0.3022	68000.0
2012-05-18 19:00:00	NVDA	Stock	0.3035	0.3035	0.3035	0.3035	10000.0
2012-05-18 04:00:00	AMZN	Stock	10.918	10.918	10.918	10.918	12000.0
2012-05-18 05:00:00	AMZN	Stock	10.86	10.865	10.85	10.85	8700.0
2012-05-18 07:00:00	AMZN	Stock	10.938	10.98	10.938	10.9695	6980.0
2012-05-18 08:00:00	AMZN	Stock	10.9815	10.9975	10.918	10.9745	710120.0
2012-05-18 09:00:00	AMZN	Stock	10.9725	10.9815	10.7705	10.803	20002540.0
2012-05-18 10:00:00	AMZN	Stock	10.799	10.971	10.779	10.916	15199480.0

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

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