PREVIEW / stock_1hour / 2015-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-24.parquet
  size:    1.0 MB
  rows:    48,843
  symbols: 3,516

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
2015-02-24 04:00:00	AAPL	Stock	33.33	33.415	33.275	33.32	125292.0
2015-02-24 05:00:00	AAPL	Stock	33.3225	33.375	33.305	33.305	101492.0
2015-02-24 06:00:00	AAPL	Stock	33.3125	33.3625	33.275	33.2975	228924.0
2015-02-24 07:00:00	AAPL	Stock	33.285	33.29	33.2275	33.25	469560.0
2015-02-24 08:00:00	AAPL	Stock	33.2525	33.3	33.09	33.1702	1845800.0
2015-02-24 09:00:00	AAPL	Stock	33.1725	33.25	32.7925	32.93	53946952.0
2015-02-24 10:00:00	AAPL	Stock	32.9325	33.325	32.8925	33.2975	51412924.0
2015-02-24 11:00:00	AAPL	Stock	33.2978	33.4	33.2125	33.215	36546752.0
2015-02-24 12:00:00	AAPL	Stock	33.2175	33.25	32.915	33.0175	35136628.0
2015-02-24 13:00:00	AAPL	Stock	33.0175	33.195	33.01	33.125	20507976.0
2015-02-24 14:00:00	AAPL	Stock	33.1225	33.2225	33.085	33.1748	18813036.0
2015-02-24 15:00:00	AAPL	Stock	33.1725	33.24	32.9825	33.045	33052236.0
2015-02-24 16:00:00	AAPL	Stock	33.0425	33.277	32.9192	33.0	6762788.0
2015-02-24 17:00:00	AAPL	Stock	33.0	33.005	32.935	32.9725	356788.0
2015-02-24 18:00:00	AAPL	Stock	32.97	33.0425	32.95	32.9625	144112.0
2015-02-24 19:00:00	AAPL	Stock	32.965	32.9675	32.9475	32.95	197892.0
2015-02-24 08:00:00	MSFT	Stock	44.05	44.07	44.05	44.06	2162.0
2015-02-24 09:00:00	MSFT	Stock	44.07	44.17	43.92	44.07	4496709.0
2015-02-24 10:00:00	MSFT	Stock	44.07	44.2	44.0	44.04	4099993.0
2015-02-24 11:00:00	MSFT	Stock	44.04	44.3	44.04	44.13	2768038.0
2015-02-24 12:00:00	MSFT	Stock	44.135	44.25	44.07	44.245	1893811.0
2015-02-24 13:00:00	MSFT	Stock	44.245	44.25	44.145	44.16	1884154.0
2015-02-24 14:00:00	MSFT	Stock	44.16	44.19	44.09	44.16	2321991.0
2015-02-24 15:00:00	MSFT	Stock	44.16	44.17	44.06	44.1	4217691.0
2015-02-24 16:00:00	MSFT	Stock	44.09	44.19	43.78	44.126	2216651.0
2015-02-24 17:00:00	MSFT	Stock	43.94	43.94	43.83	43.83	6500.0
2015-02-24 18:00:00	MSFT	Stock	43.85	43.85	43.83	43.83	1525.0
2015-02-24 19:00:00	MSFT	Stock	43.83	43.92	43.83	43.92	1200.0
2015-02-24 08:00:00	NVDA	Stock	0.5522	0.5595	0.5522	0.5595	12000.0
2015-02-24 09:00:00	NVDA	Stock	0.5519	0.5565	0.5495	0.55	35809360.0
2015-02-24 10:00:00	NVDA	Stock	0.55	0.554	0.549	0.552	16921960.0
2015-02-24 11:00:00	NVDA	Stock	0.5521	0.5546	0.5518	0.5545	9164160.0
2015-02-24 12:00:00	NVDA	Stock	0.5545	0.5558	0.5539	0.5555	11477720.0
2015-02-24 13:00:00	NVDA	Stock	0.5552	0.5575	0.555	0.5574	12199920.0
2015-02-24 14:00:00	NVDA	Stock	0.5575	0.5575	0.555	0.556	11756680.0
2015-02-24 15:00:00	NVDA	Stock	0.556	0.5578	0.556	0.5578	38676480.0
2015-02-24 16:00:00	NVDA	Stock	0.5578	0.5578	0.5551	0.5578	8196200.0
2015-02-24 08:00:00	AMZN	Stock	19.0	19.0	18.9665	18.9665	6180.0
2015-02-24 09:00:00	AMZN	Stock	18.9665	19.024	18.808	18.9135	7275200.0
2015-02-24 10:00:00	AMZN	Stock	18.915	18.99	18.871	18.964	5694200.0
2015-02-24 11:00:00	AMZN	Stock	18.9688	19.018	18.8795	18.9355	5438480.0
2015-02-24 12:00:00	AMZN	Stock	18.9285	18.966	18.87	18.945	3141560.0
2015-02-24 13:00:00	AMZN	Stock	18.942	18.9975	18.8955	18.9732	2344260.0
2015-02-24 14:00:00	AMZN	Stock	18.978	18.978	18.9125	18.9185	2260580.0
2015-02-24 15:00:00	AMZN	Stock	18.924	18.9495	18.8955	18.9255	6118900.0
2015-02-24 16:00:00	AMZN	Stock	18.9295	18.9643	18.909	18.909	2407440.0
2015-02-24 18:00:00	AMZN	Stock	18.9295	18.9295	18.9295	18.9295	20400.0
2015-02-24 19:00:00	AMZN	Stock	18.909	18.92	18.909	18.92	4000.0
2015-02-24 08:00:00	GOOGL	Stock	26.72	26.7225	26.7075	26.7225	12000.0
2015-02-24 09:00:00	GOOGL	Stock	26.7176	26.8624	26.55	26.822	3567160.0

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

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