PREVIEW / stock_1hour / 2011-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-06.parquet
  size:    903 KB
  rows:    43,199
  symbols: 3,473

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
2011-10-06 07:00:00	AAPL	Stock	13.2143	13.4286	13.2143	13.3268	7705320.0
2011-10-06 08:00:00	AAPL	Stock	13.3039	13.4761	13.2639	13.4643	20124944.0
2011-10-06 09:00:00	AAPL	Stock	13.4646	13.5268	13.3064	13.4564	146325648.0
2011-10-06 10:00:00	AAPL	Stock	13.4621	13.7421	13.4196	13.6214	170893660.0
2011-10-06 11:00:00	AAPL	Stock	13.6225	13.7086	13.5854	13.6318	68761532.0
2011-10-06 12:00:00	AAPL	Stock	13.6322	13.6761	13.4521	13.4646	77033656.0
2011-10-06 13:00:00	AAPL	Stock	13.4643	13.5168	13.2787	13.4066	111431376.0
2011-10-06 14:00:00	AAPL	Stock	13.4043	13.5018	13.3571	13.4475	82039244.0
2011-10-06 15:00:00	AAPL	Stock	13.4529	13.4993	13.3596	13.4754	105580048.0
2011-10-06 16:00:00	AAPL	Stock	13.4736	13.5386	13.3895	13.4636	10416392.0
2011-10-06 17:00:00	AAPL	Stock	13.4625	13.5089	13.42	13.4264	842520.0
2011-10-06 18:00:00	AAPL	Stock	13.4286	13.4775	13.41	13.4375	251804.0
2011-10-06 19:00:00	AAPL	Stock	13.4411	13.4536	13.4171	13.4464	125356.0
2011-10-06 07:00:00	MSFT	Stock	26.08	26.08	26.0	26.0	6400.0
2011-10-06 08:00:00	MSFT	Stock	26.0	26.09	25.99	26.0	37212.0
2011-10-06 09:00:00	MSFT	Stock	26.02	26.02	25.7	25.92	6577134.0
2011-10-06 10:00:00	MSFT	Stock	25.92	26.19	25.87	26.07	7983049.0
2011-10-06 11:00:00	MSFT	Stock	26.07	26.29	26.02	26.21	5793728.0
2011-10-06 12:00:00	MSFT	Stock	26.2	26.34	26.17	26.29	5113472.0
2011-10-06 13:00:00	MSFT	Stock	26.29	26.37	26.21	26.312	4506524.0
2011-10-06 14:00:00	MSFT	Stock	26.32	26.4	26.2	26.23	5674828.0
2011-10-06 15:00:00	MSFT	Stock	26.24	26.36	26.13	26.35	13258642.0
2011-10-06 16:00:00	MSFT	Stock	26.34	26.38	26.14	26.27	5532923.0
2011-10-06 17:00:00	MSFT	Stock	26.27	26.34	25.89	26.24	34185.0
2011-10-06 18:00:00	MSFT	Stock	26.34	26.34	26.23	26.23	25208.0
2011-10-06 19:00:00	MSFT	Stock	26.23	26.26	26.23	26.25	1800.0
2011-10-06 04:00:00	NVDA	Stock	0.338	0.338	0.338	0.338	4000.0
2011-10-06 07:00:00	NVDA	Stock	0.3215	0.3215	0.3215	0.3215	20000.0
2011-10-06 08:00:00	NVDA	Stock	0.3375	0.339	0.3362	0.339	461000.0
2011-10-06 09:00:00	NVDA	Stock	0.3378	0.3444	0.3313	0.341	120247360.0
2011-10-06 10:00:00	NVDA	Stock	0.341	0.3462	0.338	0.3422	141049640.0
2011-10-06 11:00:00	NVDA	Stock	0.3422	0.3473	0.341	0.3465	104626320.0
2011-10-06 12:00:00	NVDA	Stock	0.3464	0.3482	0.3438	0.3444	86657640.0
2011-10-06 13:00:00	NVDA	Stock	0.3442	0.3465	0.3405	0.3425	91062280.0
2011-10-06 14:00:00	NVDA	Stock	0.3427	0.346	0.3418	0.3455	57173840.0
2011-10-06 15:00:00	NVDA	Stock	0.3454	0.3475	0.3418	0.3473	139089800.0
2011-10-06 16:00:00	NVDA	Stock	0.3465	0.3473	0.3436	0.346	15347400.0
2011-10-06 17:00:00	NVDA	Stock	0.346	0.3462	0.346	0.346	188000.0
2011-10-06 18:00:00	NVDA	Stock	0.346	0.347	0.346	0.347	64080.0
2011-10-06 19:00:00	NVDA	Stock	0.3465	0.348	0.3465	0.3475	93760.0
2011-10-06 04:00:00	AMZN	Stock	10.948	11.025	10.924	11.025	12000.0
2011-10-06 06:00:00	AMZN	Stock	11.0475	11.0475	11.0475	11.0475	2000.0
2011-10-06 07:00:00	AMZN	Stock	11.0725	11.1	11.025	11.05	181900.0
2011-10-06 08:00:00	AMZN	Stock	11.046	11.0915	10.956	11.03	405000.0
2011-10-06 09:00:00	AMZN	Stock	11.02	11.085	10.8775	11.055	20304100.0
2011-10-06 10:00:00	AMZN	Stock	11.0435	11.181	10.9575	11.0166	25671240.0
2011-10-06 11:00:00	AMZN	Stock	11.0198	11.073	10.9555	10.9985	18485220.0
2011-10-06 12:00:00	AMZN	Stock	11.0	11.1105	10.968	10.9915	15746880.0
2011-10-06 13:00:00	AMZN	Stock	10.986	11.0713	10.8995	11.056	16858340.0
2011-10-06 14:00:00	AMZN	Stock	11.0505	11.1105	10.972	11.0695	12857940.0

> showing 50 of 43,199 rows — these rows as CSV

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