PREVIEW / stock_1hour / 2012-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-06.parquet
  size:    951 KB
  rows:    44,539
  symbols: 3,480

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-09-06 04:00:00	AAPL	Stock	23.9814	24.0486	23.9814	24.0464	85792.0
2012-09-06 05:00:00	AAPL	Stock	24.0629	24.0757	24.0629	24.0714	23520.0
2012-09-06 06:00:00	AAPL	Stock	24.0714	24.0846	24.0714	24.0846	14000.0
2012-09-06 07:00:00	AAPL	Stock	24.0714	24.0714	23.9821	24.0329	375760.0
2012-09-06 08:00:00	AAPL	Stock	24.0286	24.0336	23.9561	24.0071	2859388.0
2012-09-06 09:00:00	AAPL	Stock	24.0071	24.0786	23.9571	23.9961	58317280.0
2012-09-06 10:00:00	AAPL	Stock	23.9961	24.1136	23.9832	24.0754	65164540.0
2012-09-06 11:00:00	AAPL	Stock	24.075	24.0868	24.0357	24.0782	30854236.0
2012-09-06 12:00:00	AAPL	Stock	24.0782	24.1968	24.0679	24.1571	60238948.0
2012-09-06 13:00:00	AAPL	Stock	24.1571	24.2246	24.1304	24.2168	40970412.0
2012-09-06 14:00:00	AAPL	Stock	24.215	24.2232	24.125	24.1839	44779868.0
2012-09-06 15:00:00	AAPL	Stock	24.1875	24.1964	24.1129	24.155	60346244.0
2012-09-06 16:00:00	AAPL	Stock	24.1543	24.1768	24.0747	24.175	16497600.0
2012-09-06 17:00:00	AAPL	Stock	24.1768	24.1821	24.1714	24.1782	436632.0
2012-09-06 18:00:00	AAPL	Stock	24.175	24.1786	24.1525	24.1696	134904.0
2012-09-06 19:00:00	AAPL	Stock	24.1671	24.175	24.1607	24.175	187880.0
2012-09-06 05:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	100.0
2012-09-06 07:00:00	MSFT	Stock	30.55	30.56	30.5	30.55	3720.0
2012-09-06 08:00:00	MSFT	Stock	30.5	30.5	30.4	30.43	19045.0
2012-09-06 09:00:00	MSFT	Stock	30.45	30.9	30.39	30.89	4863870.0
2012-09-06 10:00:00	MSFT	Stock	30.9	31.15	30.89	31.1	14281683.0
2012-09-06 11:00:00	MSFT	Stock	31.11	31.335	31.1	31.3	7075040.0
2012-09-06 12:00:00	MSFT	Stock	31.3	31.35	31.25	31.28	3465239.0
2012-09-06 13:00:00	MSFT	Stock	31.28	31.3	31.23	31.29	3246792.0
2012-09-06 14:00:00	MSFT	Stock	31.295	31.32	31.25	31.27	3809828.0
2012-09-06 15:00:00	MSFT	Stock	31.277	31.36	31.26	31.36	8864979.0
2012-09-06 16:00:00	MSFT	Stock	31.35	31.376	31.135	31.3	2201772.0
2012-09-06 17:00:00	MSFT	Stock	31.31	31.33	31.31	31.33	6557.0
2012-09-06 18:00:00	MSFT	Stock	31.35	31.35	31.33	31.35	13430.0
2012-09-06 19:00:00	MSFT	Stock	31.34	31.35	31.34	31.35	10818.0
2012-09-06 08:00:00	NVDA	Stock	0.3375	0.3393	0.3334	0.3334	176000.0
2012-09-06 09:00:00	NVDA	Stock	0.3362	0.341	0.3353	0.3408	43014360.0
2012-09-06 10:00:00	NVDA	Stock	0.341	0.349	0.341	0.349	89919640.0
2012-09-06 11:00:00	NVDA	Stock	0.349	0.3522	0.3482	0.3493	116860400.0
2012-09-06 12:00:00	NVDA	Stock	0.3493	0.35	0.3445	0.3446	68898320.0
2012-09-06 13:00:00	NVDA	Stock	0.3448	0.346	0.3435	0.3438	50764320.0
2012-09-06 14:00:00	NVDA	Stock	0.3438	0.3455	0.3395	0.3433	135130320.0
2012-09-06 15:00:00	NVDA	Stock	0.343	0.345	0.341	0.3433	126533600.0
2012-09-06 16:00:00	NVDA	Stock	0.3428	0.3448	0.3425	0.3433	6945840.0
2012-09-06 17:00:00	NVDA	Stock	0.3433	0.3433	0.3413	0.3413	46000.0
2012-09-06 19:00:00	NVDA	Stock	0.3425	0.3425	0.3415	0.3415	68000.0
2012-09-06 05:00:00	AMZN	Stock	12.4	12.4	12.4	12.4	19960.0
2012-09-06 06:00:00	AMZN	Stock	12.4	12.4	12.4	12.4	4040.0
2012-09-06 07:00:00	AMZN	Stock	12.38	12.3985	12.3785	12.3875	18000.0
2012-09-06 08:00:00	AMZN	Stock	12.3915	12.4	12.325	12.3825	444540.0
2012-09-06 09:00:00	AMZN	Stock	12.3875	12.475	12.311	12.42	9547240.0
2012-09-06 10:00:00	AMZN	Stock	12.4215	12.525	12.4205	12.5123	12933480.0
2012-09-06 11:00:00	AMZN	Stock	12.5115	12.5995	12.506	12.5864	12451420.0
2012-09-06 12:00:00	AMZN	Stock	12.5865	12.6135	12.507	12.5457	10774300.0
2012-09-06 13:00:00	AMZN	Stock	12.543	12.578	12.472	12.4745	14294500.0

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

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