PREVIEW / stock_1hour / 2014-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-25.parquet
  size:    1.0 MB
  rows:    47,807
  symbols: 3,525

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
2014-04-25 04:00:00	AAPL	Stock	20.1857	20.1857	20.1429	20.1429	55020.0
2014-04-25 05:00:00	AAPL	Stock	20.1429	20.1618	20.1429	20.1593	24640.0
2014-04-25 06:00:00	AAPL	Stock	20.15	20.1743	20.0754	20.0754	154140.0
2014-04-25 07:00:00	AAPL	Stock	20.1318	20.1607	20.0714	20.1432	538272.0
2014-04-25 08:00:00	AAPL	Stock	20.1429	20.1839	20.1	20.1736	1814876.0
2014-04-25 09:00:00	AAPL	Stock	20.1782	20.2817	20.1379	20.205	49420980.0
2014-04-25 10:00:00	AAPL	Stock	20.2075	20.2639	20.165	20.2139	39763360.0
2014-04-25 11:00:00	AAPL	Stock	20.2123	20.3786	20.1846	20.3446	59821692.0
2014-04-25 12:00:00	AAPL	Stock	20.3493	20.3564	20.2393	20.2618	26682180.0
2014-04-25 13:00:00	AAPL	Stock	20.2654	20.3393	20.2539	20.3207	25027576.0
2014-04-25 14:00:00	AAPL	Stock	20.3218	20.3804	20.2921	20.3742	38602088.0
2014-04-25 15:00:00	AAPL	Stock	20.3739	20.4282	20.3414	20.4279	62884864.0
2014-04-25 16:00:00	AAPL	Stock	20.4264	20.4286	20.2126	20.4224	12252884.0
2014-04-25 17:00:00	AAPL	Stock	20.3804	20.4264	20.3714	20.3929	1510208.0
2014-04-25 18:00:00	AAPL	Stock	20.3882	20.3961	20.3857	20.3925	148540.0
2014-04-25 19:00:00	AAPL	Stock	20.3864	20.3964	20.3864	20.3957	182224.0
2014-04-25 04:00:00	MSFT	Stock	40.68	40.68	40.68	40.68	100.0
2014-04-25 05:00:00	MSFT	Stock	40.56	40.56	40.5	40.5	300.0
2014-04-25 06:00:00	MSFT	Stock	40.36	40.53	40.36	40.4	18062.0
2014-04-25 07:00:00	MSFT	Stock	40.45	40.67	40.24	40.65	93601.0
2014-04-25 08:00:00	MSFT	Stock	40.6	40.95	40.28	40.42	366848.0
2014-04-25 09:00:00	MSFT	Stock	40.43	40.68	40.17	40.3	11127265.0
2014-04-25 10:00:00	MSFT	Stock	40.29	40.37	39.75	39.825	10699489.0
2014-04-25 11:00:00	MSFT	Stock	39.83	40.17	39.77	40.119	7112481.0
2014-04-25 12:00:00	MSFT	Stock	40.105	40.284	40.07	40.17	5552019.0
2014-04-25 13:00:00	MSFT	Stock	40.17	40.19	39.92	40.01	4569086.0
2014-04-25 14:00:00	MSFT	Stock	40.01	40.035	39.83	39.92	2931195.0
2014-04-25 15:00:00	MSFT	Stock	39.92	40.18	39.82	39.91	9719859.0
2014-04-25 16:00:00	MSFT	Stock	39.91	40.28	39.87	40.07	2478384.0
2014-04-25 17:00:00	MSFT	Stock	40.05	40.124	39.91	39.92	294091.0
2014-04-25 18:00:00	MSFT	Stock	39.97	39.97	39.92	39.92	933.0
2014-04-25 19:00:00	MSFT	Stock	39.93	39.97	39.92	39.93	5900.0
2014-04-25 07:00:00	NVDA	Stock	0.457	0.457	0.4568	0.4568	40000.0
2014-04-25 08:00:00	NVDA	Stock	0.4815	0.4815	0.4815	0.4815	1416000.0
2014-04-25 09:00:00	NVDA	Stock	0.4805	0.485	0.4805	0.4808	38597480.0
2014-04-25 10:00:00	NVDA	Stock	0.4808	0.4808	0.4708	0.472	64202840.0
2014-04-25 11:00:00	NVDA	Stock	0.4719	0.4738	0.4673	0.4726	35380440.0
2014-04-25 12:00:00	NVDA	Stock	0.4728	0.4732	0.4688	0.4691	32733880.0
2014-04-25 13:00:00	NVDA	Stock	0.4692	0.4713	0.4675	0.471	23405880.0
2014-04-25 14:00:00	NVDA	Stock	0.4708	0.471	0.4692	0.47	30114080.0
2014-04-25 15:00:00	NVDA	Stock	0.4699	0.4708	0.4675	0.4681	73096880.0
2014-04-25 16:00:00	NVDA	Stock	0.468	0.4683	0.468	0.4682	2083520.0
2014-04-25 17:00:00	NVDA	Stock	0.4682	0.4683	0.4682	0.4683	538400.0
2014-04-25 04:00:00	AMZN	Stock	16.7	16.7	16.65	16.65	29000.0
2014-04-25 05:00:00	AMZN	Stock	16.615	16.65	16.615	16.645	20600.0
2014-04-25 06:00:00	AMZN	Stock	16.645	16.645	16.45	16.49	536740.0
2014-04-25 07:00:00	AMZN	Stock	16.49	16.5295	16.327	16.329	1547380.0
2014-04-25 08:00:00	AMZN	Stock	16.348	16.4675	15.91	15.966	7215180.0
2014-04-25 09:00:00	AMZN	Stock	15.975	15.975	15.355	15.492	70378280.0
2014-04-25 10:00:00	AMZN	Stock	15.4928	15.8015	15.178	15.2438	63363640.0

> showing 50 of 47,807 rows — these rows as CSV

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