PREVIEW / stock_1hour / 2013-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-15.parquet
  size:    1011 KB
  rows:    46,461
  symbols: 3,517

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-05-15 04:00:00	AAPL	Stock	15.7857	15.7857	15.7857	15.7857	8400.0
2013-05-15 05:00:00	AAPL	Stock	15.7879	15.7879	15.7857	15.7857	8400.0
2013-05-15 06:00:00	AAPL	Stock	15.7864	15.8161	15.7864	15.7957	20020.0
2013-05-15 07:00:00	AAPL	Stock	15.8129	15.8225	15.75	15.8071	287364.0
2013-05-15 08:00:00	AAPL	Stock	15.8036	15.8379	15.7411	15.7411	1431668.0
2013-05-15 09:00:00	AAPL	Stock	15.7386	15.75	15.5182	15.5307	108226272.0
2013-05-15 10:00:00	AAPL	Stock	15.5282	15.6054	15.4779	15.5118	95023404.0
2013-05-15 11:00:00	AAPL	Stock	15.5125	15.5571	15.4111	15.4257	72197916.0
2013-05-15 12:00:00	AAPL	Stock	15.425	15.4255	15.3254	15.3807	79334360.0
2013-05-15 13:00:00	AAPL	Stock	15.3789	15.3804	15.1979	15.2075	87329872.0
2013-05-15 14:00:00	AAPL	Stock	15.2068	15.2814	15.1429	15.1693	80380804.0
2013-05-15 15:00:00	AAPL	Stock	15.1636	15.3571	15.0843	15.3204	160566504.0
2013-05-15 16:00:00	AAPL	Stock	15.3204	15.5815	15.2743	15.3268	47760356.0
2013-05-15 17:00:00	AAPL	Stock	15.3214	15.3957	15.2679	15.3214	816620.0
2013-05-15 18:00:00	AAPL	Stock	15.3196	15.3196	15.2679	15.2768	273868.0
2013-05-15 19:00:00	AAPL	Stock	15.2679	15.2821	15.2679	15.275	222600.0
2013-05-15 04:00:00	MSFT	Stock	33.45	33.45	33.45	33.45	500.0
2013-05-15 06:00:00	MSFT	Stock	33.43	33.43	33.43	33.43	400.0
2013-05-15 07:00:00	MSFT	Stock	33.4	33.4	33.4	33.4	1300.0
2013-05-15 08:00:00	MSFT	Stock	33.45	33.53	33.42	33.49	18207.0
2013-05-15 09:00:00	MSFT	Stock	33.49	33.76	33.43	33.73	4731519.0
2013-05-15 10:00:00	MSFT	Stock	33.72	33.76	33.615	33.69	6237336.0
2013-05-15 11:00:00	MSFT	Stock	33.69	33.77	33.64	33.665	4793999.0
2013-05-15 12:00:00	MSFT	Stock	33.67	33.74	33.655	33.71	4794399.0
2013-05-15 13:00:00	MSFT	Stock	33.71	33.74	33.64	33.65	4015026.0
2013-05-15 14:00:00	MSFT	Stock	33.65	33.71	33.583	33.675	4965980.0
2013-05-15 15:00:00	MSFT	Stock	33.675	33.9	33.62	33.855	9407520.0
2013-05-15 16:00:00	MSFT	Stock	33.85	33.88	33.52	33.65	3459777.0
2013-05-15 17:00:00	MSFT	Stock	33.84	33.84	33.679	33.76	6075.0
2013-05-15 18:00:00	MSFT	Stock	33.8	33.8	33.75	33.75	4050.0
2013-05-15 19:00:00	MSFT	Stock	33.75	33.81	33.75	33.75	1677.0
2013-05-15 09:00:00	NVDA	Stock	0.359	0.3638	0.359	0.3635	24501200.0
2013-05-15 10:00:00	NVDA	Stock	0.3634	0.3685	0.3632	0.3684	70422280.0
2013-05-15 11:00:00	NVDA	Stock	0.3685	0.3688	0.366	0.3671	51077960.0
2013-05-15 12:00:00	NVDA	Stock	0.3671	0.368	0.3669	0.3672	32703920.0
2013-05-15 13:00:00	NVDA	Stock	0.3675	0.3675	0.365	0.3664	30569600.0
2013-05-15 14:00:00	NVDA	Stock	0.3661	0.3671	0.3658	0.3665	27667800.0
2013-05-15 15:00:00	NVDA	Stock	0.3668	0.368	0.366	0.3675	58994240.0
2013-05-15 16:00:00	NVDA	Stock	0.3675	0.3678	0.3612	0.3612	16336120.0
2013-05-15 17:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	208880.0
2013-05-15 18:00:00	NVDA	Stock	0.3678	0.3678	0.3678	0.3678	44000.0
2013-05-15 19:00:00	NVDA	Stock	0.3685	0.3685	0.3685	0.3685	11640.0
2013-05-15 05:00:00	AMZN	Stock	13.379	13.379	13.379	13.379	2000.0
2013-05-15 08:00:00	AMZN	Stock	13.395	13.3975	13.38	13.3845	58000.0
2013-05-15 09:00:00	AMZN	Stock	13.3845	13.449	13.3305	13.3936	7834900.0
2013-05-15 10:00:00	AMZN	Stock	13.3945	13.4525	13.3275	13.4025	5802380.0
2013-05-15 11:00:00	AMZN	Stock	13.4	13.4488	13.3815	13.3825	5425360.0
2013-05-15 12:00:00	AMZN	Stock	13.3825	13.4424	13.364	13.364	7773540.0
2013-05-15 13:00:00	AMZN	Stock	13.364	13.3695	13.285	13.2889	8328000.0
2013-05-15 14:00:00	AMZN	Stock	13.289	13.313	13.228	13.2653	5777520.0

> showing 50 of 46,461 rows — these rows as CSV

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