PREVIEW / stock_1hour / 2015-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-23.parquet
  size:    1.1 MB
  rows:    49,279
  symbols: 3,534

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-23 04:00:00	AAPL	Stock	32.47	32.4875	32.405	32.4625	46004.0
2015-02-23 05:00:00	AAPL	Stock	32.4425	32.51	32.425	32.4925	87888.0
2015-02-23 06:00:00	AAPL	Stock	32.5075	32.545	32.4525	32.4875	119028.0
2015-02-23 07:00:00	AAPL	Stock	32.4975	32.4975	32.4175	32.4825	236992.0
2015-02-23 08:00:00	AAPL	Stock	32.4825	32.525	32.41	32.4125	966496.0
2015-02-23 09:00:00	AAPL	Stock	32.4225	32.6225	32.4025	32.62	37146588.0
2015-02-23 10:00:00	AAPL	Stock	32.62	32.841	32.5975	32.8325	45401020.0
2015-02-23 11:00:00	AAPL	Stock	32.83	32.975	32.8275	32.9302	38450204.0
2015-02-23 12:00:00	AAPL	Stock	32.93	33.035	32.8775	33.035	26833984.0
2015-02-23 13:00:00	AAPL	Stock	33.0348	33.05	32.965	33.0185	20142276.0
2015-02-23 14:00:00	AAPL	Stock	33.0175	33.15	33.015	33.0975	26657592.0
2015-02-23 15:00:00	AAPL	Stock	33.0975	33.25	33.0138	33.2438	40054592.0
2015-02-23 16:00:00	AAPL	Stock	33.25	33.2625	32.9018	33.245	13188248.0
2015-02-23 17:00:00	AAPL	Stock	33.2498	33.255	33.24	33.2475	1456556.0
2015-02-23 18:00:00	AAPL	Stock	33.245	33.245	33.2275	33.2375	148440.0
2015-02-23 19:00:00	AAPL	Stock	33.2375	33.2875	33.2325	33.2775	233420.0
2015-02-23 06:00:00	MSFT	Stock	43.6	43.61	43.6	43.6	600.0
2015-02-23 08:00:00	MSFT	Stock	43.6	43.7	43.56	43.68	1224.0
2015-02-23 09:00:00	MSFT	Stock	43.651	43.93	43.65	43.84	5260641.0
2015-02-23 10:00:00	MSFT	Stock	43.84	43.86	43.74	43.81	4518220.0
2015-02-23 11:00:00	MSFT	Stock	43.81	43.97	43.8	43.942	2682027.0
2015-02-23 12:00:00	MSFT	Stock	43.942	43.985	43.87	43.915	2417002.0
2015-02-23 13:00:00	MSFT	Stock	43.915	43.99	43.9	43.966	2982463.0
2015-02-23 14:00:00	MSFT	Stock	43.96	44.19	43.96	44.125	4008950.0
2015-02-23 15:00:00	MSFT	Stock	44.12	44.19	44.0	44.15	6609836.0
2015-02-23 16:00:00	MSFT	Stock	44.15	44.17	43.965	44.08	2937723.0
2015-02-23 17:00:00	MSFT	Stock	44.08	44.15	44.08	44.15	9076.0
2015-02-23 18:00:00	MSFT	Stock	44.129	44.129	44.129	44.129	104.0
2015-02-23 19:00:00	MSFT	Stock	44.08	44.08	44.08	44.08	173.0
2015-02-23 08:00:00	NVDA	Stock	0.5575	0.562	0.5575	0.562	44000.0
2015-02-23 09:00:00	NVDA	Stock	0.5582	0.5582	0.5519	0.5535	9762360.0
2015-02-23 10:00:00	NVDA	Stock	0.5532	0.5559	0.5515	0.5544	20997000.0
2015-02-23 11:00:00	NVDA	Stock	0.5542	0.5548	0.5528	0.5532	11584480.0
2015-02-23 12:00:00	NVDA	Stock	0.5532	0.5535	0.5512	0.553	9296320.0
2015-02-23 13:00:00	NVDA	Stock	0.553	0.554	0.5528	0.5532	7226280.0
2015-02-23 14:00:00	NVDA	Stock	0.5532	0.5538	0.5522	0.5538	13628080.0
2015-02-23 15:00:00	NVDA	Stock	0.5536	0.554	0.5522	0.554	38276480.0
2015-02-23 16:00:00	NVDA	Stock	0.554	0.554	0.553	0.554	10488200.0
2015-02-23 18:00:00	NVDA	Stock	0.555	0.555	0.555	0.555	8000.0
2015-02-23 19:00:00	NVDA	Stock	0.555	0.555	0.555	0.555	16000.0
2015-02-23 05:00:00	AMZN	Stock	19.12	19.12	19.12	19.12	2000.0
2015-02-23 06:00:00	AMZN	Stock	19.12	19.12	19.12	19.12	2000.0
2015-02-23 07:00:00	AMZN	Stock	19.12	19.135	19.1045	19.135	59820.0
2015-02-23 08:00:00	AMZN	Stock	19.135	19.17	19.125	19.125	79820.0
2015-02-23 09:00:00	AMZN	Stock	19.12	19.227	19.1	19.1535	7786480.0
2015-02-23 10:00:00	AMZN	Stock	19.1595	19.16	18.953	18.9705	8132180.0
2015-02-23 11:00:00	AMZN	Stock	18.976	19.0234	18.959	19.007	4123220.0
2015-02-23 12:00:00	AMZN	Stock	19.0085	19.0585	18.975	18.9825	3353580.0
2015-02-23 13:00:00	AMZN	Stock	18.9815	19.0365	18.9555	19.03	2708860.0
2015-02-23 14:00:00	AMZN	Stock	19.0315	19.047	18.9275	18.9385	3063980.0

> showing 50 of 49,279 rows — these rows as CSV

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