PREVIEW / stock_1hour / 2013-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-28.parquet
  size:    1.0 MB
  rows:    48,406
  symbols: 3,528

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
2013-10-28 04:00:00	AAPL	Stock	18.8518	18.9286	18.8518	18.9286	100968.0
2013-10-28 05:00:00	AAPL	Stock	18.9314	18.9429	18.9018	18.9286	112700.0
2013-10-28 06:00:00	AAPL	Stock	18.9268	18.9268	18.8571	18.8607	197316.0
2013-10-28 07:00:00	AAPL	Stock	18.8571	18.8893	18.8393	18.8814	539644.0
2013-10-28 08:00:00	AAPL	Stock	18.8807	18.8946	18.8321	18.8896	2053352.0
2013-10-28 09:00:00	AAPL	Stock	18.8889	18.9414	18.6861	18.7239	61610388.0
2013-10-28 10:00:00	AAPL	Stock	18.7189	18.8261	18.7161	18.7939	46960508.0
2013-10-28 11:00:00	AAPL	Stock	18.7944	18.8379	18.7593	18.7839	33860148.0
2013-10-28 12:00:00	AAPL	Stock	18.7857	18.8996	18.7714	18.8861	42432348.0
2013-10-28 13:00:00	AAPL	Stock	18.8861	18.9179	18.8436	18.9106	33645948.0
2013-10-28 14:00:00	AAPL	Stock	18.9107	18.9643	18.9057	18.9596	55021736.0
2013-10-28 15:00:00	AAPL	Stock	18.9596	18.9596	18.8393	18.91	91801052.0
2013-10-28 16:00:00	AAPL	Stock	18.91	19.3571	17.9646	18.4839	89383084.0
2013-10-28 17:00:00	AAPL	Stock	18.4821	19.2029	18.3179	18.9	60842936.0
2013-10-28 18:00:00	AAPL	Stock	18.9107	18.9354	18.8168	18.8536	7173180.0
2013-10-28 19:00:00	AAPL	Stock	18.8521	18.9064	18.6786	18.6939	4060336.0
2013-10-28 06:00:00	MSFT	Stock	35.9	36.02	35.84	35.98	3000.0
2013-10-28 07:00:00	MSFT	Stock	35.98	35.98	35.8	35.8	7149.0
2013-10-28 08:00:00	MSFT	Stock	35.76	35.94	35.73	35.73	33897.0
2013-10-28 09:00:00	MSFT	Stock	35.75	35.75	35.31	35.321	6430515.0
2013-10-28 10:00:00	MSFT	Stock	35.32	35.4	35.27	35.33	6335425.0
2013-10-28 11:00:00	MSFT	Stock	35.329	35.49	35.29	35.453	4256640.0
2013-10-28 12:00:00	MSFT	Stock	35.45	35.54	35.44	35.5	3530076.0
2013-10-28 13:00:00	MSFT	Stock	35.5	35.54	35.46	35.505	3390287.0
2013-10-28 14:00:00	MSFT	Stock	35.5	35.587	35.48	35.52	3877801.0
2013-10-28 15:00:00	MSFT	Stock	35.523	35.59	35.44	35.59	7176454.0
2013-10-28 16:00:00	MSFT	Stock	35.555	35.781	35.44	35.5	2768678.0
2013-10-28 17:00:00	MSFT	Stock	35.6	35.6	35.45	35.45	39395.0
2013-10-28 18:00:00	MSFT	Stock	35.48	35.48	35.46	35.46	1000.0
2013-10-28 19:00:00	MSFT	Stock	35.6	35.6	35.49	35.49	29938.0
2013-10-28 09:00:00	NVDA	Stock	0.3813	0.3822	0.3755	0.3755	42092800.0
2013-10-28 10:00:00	NVDA	Stock	0.3758	0.3775	0.3755	0.376	64013000.0
2013-10-28 11:00:00	NVDA	Stock	0.3763	0.3773	0.376	0.3765	31263880.0
2013-10-28 12:00:00	NVDA	Stock	0.3768	0.377	0.375	0.377	38158960.0
2013-10-28 13:00:00	NVDA	Stock	0.377	0.3773	0.3768	0.377	23502160.0
2013-10-28 14:00:00	NVDA	Stock	0.3768	0.3793	0.3768	0.3786	30254480.0
2013-10-28 15:00:00	NVDA	Stock	0.3786	0.3805	0.378	0.3803	114303720.0
2013-10-28 16:00:00	NVDA	Stock	0.3805	0.3816	0.3786	0.3806	12017600.0
2013-10-28 17:00:00	NVDA	Stock	0.3805	0.3805	0.3805	0.3805	104080.0
2013-10-28 04:00:00	AMZN	Stock	18.2185	18.2185	18.2185	18.2185	3920.0
2013-10-28 07:00:00	AMZN	Stock	18.2	18.2	18.112	18.134	28700.0
2013-10-28 08:00:00	AMZN	Stock	18.1225	18.1635	18.0025	18.0025	259080.0
2013-10-28 09:00:00	AMZN	Stock	18.0155	18.0985	17.9455	18.007	12730780.0
2013-10-28 10:00:00	AMZN	Stock	17.999	18.1195	17.891	17.914	15983080.0
2013-10-28 11:00:00	AMZN	Stock	17.92	17.9895	17.897	17.972	8928400.0
2013-10-28 12:00:00	AMZN	Stock	17.9871	18.1055	17.967	18.0895	5317180.0
2013-10-28 13:00:00	AMZN	Stock	18.0905	18.1375	18.0435	18.0635	4703240.0
2013-10-28 14:00:00	AMZN	Stock	18.0575	18.0605	17.95	18.0115	6603160.0
2013-10-28 15:00:00	AMZN	Stock	18.0107	18.0173	17.86	17.911	11824220.0
2013-10-28 16:00:00	AMZN	Stock	17.908	18.1953	17.875	17.9395	2938060.0

> showing 50 of 48,406 rows — these rows as CSV

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