PREVIEW / stock_1hour / 2013-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-30.parquet
  size:    1.0 MB
  rows:    48,134
  symbols: 3,546

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-12-30 04:00:00	AAPL	Stock	19.95	19.97	19.95	19.9643	56560.0
2013-12-30 05:00:00	AAPL	Stock	19.9643	19.9714	19.9643	19.9686	45976.0
2013-12-30 06:00:00	AAPL	Stock	19.9464	19.9464	19.8771	19.8936	63392.0
2013-12-30 07:00:00	AAPL	Stock	19.8925	19.9182	19.8668	19.8925	424032.0
2013-12-30 08:00:00	AAPL	Stock	19.8929	19.9464	19.8679	19.9375	1230684.0
2013-12-30 09:00:00	AAPL	Stock	19.9371	19.9371	19.7971	19.8604	42390208.0
2013-12-30 10:00:00	AAPL	Stock	19.8604	19.866	19.7257	19.7486	48402256.0
2013-12-30 11:00:00	AAPL	Stock	19.7514	19.8329	19.7486	19.8214	30331784.0
2013-12-30 12:00:00	AAPL	Stock	19.8245	19.8304	19.7361	19.7418	21214340.0
2013-12-30 13:00:00	AAPL	Stock	19.7439	19.7796	19.7325	19.7393	11280472.0
2013-12-30 14:00:00	AAPL	Stock	19.7393	19.86	19.7329	19.8303	20176128.0
2013-12-30 15:00:00	AAPL	Stock	19.8296	19.8786	19.7847	19.8036	30338700.0
2013-12-30 16:00:00	AAPL	Stock	19.8043	19.9738	19.7714	19.7975	8151024.0
2013-12-30 17:00:00	AAPL	Stock	19.7896	19.8043	19.775	19.7821	235172.0
2013-12-30 18:00:00	AAPL	Stock	19.7757	19.7857	19.775	19.775	116788.0
2013-12-30 19:00:00	AAPL	Stock	19.7857	19.7857	19.7411	19.7536	210532.0
2013-12-30 06:00:00	MSFT	Stock	37.4	37.4	37.4	37.4	300.0
2013-12-30 07:00:00	MSFT	Stock	37.1	37.32	37.1	37.15	5733.0
2013-12-30 08:00:00	MSFT	Stock	37.22	37.23	37.151	37.16	1478.0
2013-12-30 09:00:00	MSFT	Stock	37.2	37.27	36.935	36.99	2193364.0
2013-12-30 10:00:00	MSFT	Stock	36.98	37.18	36.901	37.145	2997872.0
2013-12-30 11:00:00	MSFT	Stock	37.145	37.15	37.09	37.135	1911347.0
2013-12-30 12:00:00	MSFT	Stock	37.135	37.26	37.12	37.253	1870334.0
2013-12-30 13:00:00	MSFT	Stock	37.25	37.34	37.25	37.27	1462654.0
2013-12-30 14:00:00	MSFT	Stock	37.28	37.38	37.26	37.31	1472175.0
2013-12-30 15:00:00	MSFT	Stock	37.319	37.32	37.18	37.28	2670399.0
2013-12-30 16:00:00	MSFT	Stock	37.28	37.32	37.105	37.29	834371.0
2013-12-30 17:00:00	MSFT	Stock	37.28	37.29	37.28	37.29	2960.0
2013-12-30 18:00:00	MSFT	Stock	37.29	37.29	37.29	37.29	147.0
2013-12-30 19:00:00	MSFT	Stock	37.29	37.29	37.29	37.29	10360.0
2013-12-30 08:00:00	NVDA	Stock	0.395	0.3953	0.3938	0.3953	34960.0
2013-12-30 09:00:00	NVDA	Stock	0.3953	0.3965	0.3938	0.395	18008480.0
2013-12-30 10:00:00	NVDA	Stock	0.3948	0.3968	0.3945	0.3968	26509880.0
2013-12-30 11:00:00	NVDA	Stock	0.3968	0.398	0.3965	0.397	25820640.0
2013-12-30 12:00:00	NVDA	Stock	0.397	0.3988	0.397	0.3982	31744520.0
2013-12-30 13:00:00	NVDA	Stock	0.3984	0.399	0.3982	0.3988	23269760.0
2013-12-30 14:00:00	NVDA	Stock	0.3988	0.3995	0.3988	0.3991	24162400.0
2013-12-30 15:00:00	NVDA	Stock	0.3993	0.3995	0.3982	0.399	70247240.0
2013-12-30 16:00:00	NVDA	Stock	0.3993	0.3993	0.3946	0.3946	20935400.0
2013-12-30 18:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	4000.0
2013-12-30 19:00:00	NVDA	Stock	0.4	0.4	0.3998	0.3998	28000.0
2013-12-30 05:00:00	AMZN	Stock	19.9545	19.9545	19.9545	19.9545	4000.0
2013-12-30 07:00:00	AMZN	Stock	19.9655	19.9705	19.9655	19.9665	25280.0
2013-12-30 08:00:00	AMZN	Stock	19.975	19.985	19.939	19.95	74340.0
2013-12-30 09:00:00	AMZN	Stock	19.947	20.022	19.76	19.8165	6133620.0
2013-12-30 10:00:00	AMZN	Stock	19.8195	19.9055	19.6865	19.6892	8713940.0
2013-12-30 11:00:00	AMZN	Stock	19.6892	19.7613	19.624	19.6595	6615960.0
2013-12-30 12:00:00	AMZN	Stock	19.66	19.7116	19.6225	19.6915	5457160.0
2013-12-30 13:00:00	AMZN	Stock	19.6905	19.7595	19.685	19.7185	4632360.0
2013-12-30 14:00:00	AMZN	Stock	19.7105	19.748	19.6595	19.72	5621540.0

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

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