PREVIEW / stock_1hour / 2015-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-17.parquet
  size:    1.0 MB
  rows:    49,363
  symbols: 3,436

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-12-17 04:00:00	AAPL	Stock	27.92	27.95	27.9075	27.95	23532.0
2015-12-17 05:00:00	AAPL	Stock	27.9625	27.9725	27.9425	27.9725	19388.0
2015-12-17 06:00:00	AAPL	Stock	27.9525	28.0375	27.95	28.0125	37524.0
2015-12-17 07:00:00	AAPL	Stock	28.02	28.1125	28.0075	28.075	233516.0
2015-12-17 08:00:00	AAPL	Stock	28.065	28.1125	28.0125	28.07	835976.0
2015-12-17 09:00:00	AAPL	Stock	28.085	28.11	27.695	27.7938	20903928.0
2015-12-17 10:00:00	AAPL	Stock	27.7975	27.83	27.4825	27.53	26610192.0
2015-12-17 11:00:00	AAPL	Stock	27.5275	27.5975	27.3675	27.51	25902208.0
2015-12-17 12:00:00	AAPL	Stock	27.5125	27.5675	27.4475	27.5525	13623796.0
2015-12-17 13:00:00	AAPL	Stock	27.55	27.6375	27.5	27.5175	12782224.0
2015-12-17 14:00:00	AAPL	Stock	27.518	27.5475	27.28	27.365	23054232.0
2015-12-17 15:00:00	AAPL	Stock	27.367	27.4575	27.2475	27.25	33706040.0
2015-12-17 16:00:00	AAPL	Stock	27.2488	27.3425	27.175	27.2125	8727296.0
2015-12-17 17:00:00	AAPL	Stock	27.2125	27.235	27.1875	27.2225	100536.0
2015-12-17 18:00:00	AAPL	Stock	27.2225	27.225	27.1875	27.1875	63044.0
2015-12-17 19:00:00	AAPL	Stock	27.185	27.2	27.15	27.1575	284204.0
2015-12-17 05:00:00	MSFT	Stock	56.29	56.29	56.29	56.29	100.0
2015-12-17 06:00:00	MSFT	Stock	56.48	56.48	56.48	56.48	200.0
2015-12-17 07:00:00	MSFT	Stock	56.44	56.44	56.29	56.29	3767.0
2015-12-17 08:00:00	MSFT	Stock	56.34	56.4	56.29	56.36	25442.0
2015-12-17 09:00:00	MSFT	Stock	56.38	56.79	56.2	56.6	5944284.0
2015-12-17 10:00:00	MSFT	Stock	56.61	56.62	55.74	55.87	7397172.0
2015-12-17 11:00:00	MSFT	Stock	55.86	56.015	55.62	55.74	3854150.0
2015-12-17 12:00:00	MSFT	Stock	55.74	55.99	55.535	55.92	3243868.0
2015-12-17 13:00:00	MSFT	Stock	55.92	56.4	55.9	56.29	3717980.0
2015-12-17 14:00:00	MSFT	Stock	56.29	56.355	56.01	56.078	3860160.0
2015-12-17 15:00:00	MSFT	Stock	56.07	56.195	55.69	55.7	7389737.0
2015-12-17 16:00:00	MSFT	Stock	55.7	55.79	55.53	55.54	3440689.0
2015-12-17 17:00:00	MSFT	Stock	55.6	55.67	55.56	55.56	877.0
2015-12-17 18:00:00	MSFT	Stock	55.67	55.67	55.67	55.67	1110.0
2015-12-17 19:00:00	MSFT	Stock	55.68	55.72	55.55	55.55	18435.0
2015-12-17 08:00:00	NVDA	Stock	0.8448	0.8448	0.8448	0.8448	28000.0
2015-12-17 09:00:00	NVDA	Stock	0.8385	0.839	0.8292	0.8335	18799000.0
2015-12-17 10:00:00	NVDA	Stock	0.8338	0.8338	0.8232	0.8248	29692840.0
2015-12-17 11:00:00	NVDA	Stock	0.8248	0.8265	0.82	0.822	23695360.0
2015-12-17 12:00:00	NVDA	Stock	0.822	0.8244	0.8185	0.8215	15784320.0
2015-12-17 13:00:00	NVDA	Stock	0.8216	0.8256	0.82	0.8238	19066440.0
2015-12-17 14:00:00	NVDA	Stock	0.8236	0.824	0.8194	0.8205	20606600.0
2015-12-17 15:00:00	NVDA	Stock	0.8205	0.8218	0.8162	0.8165	40611200.0
2015-12-17 16:00:00	NVDA	Stock	0.8168	0.817	0.815	0.815	559160.0
2015-12-17 18:00:00	NVDA	Stock	0.8232	0.8232	0.8232	0.8232	16000.0
2015-12-17 04:00:00	AMZN	Stock	31.802	33.9495	31.802	33.914	37300.0
2015-12-17 06:00:00	AMZN	Stock	33.9	33.9	33.8995	33.9	39340.0
2015-12-17 07:00:00	AMZN	Stock	33.9245	33.987	33.9245	33.9255	154600.0
2015-12-17 08:00:00	AMZN	Stock	33.9105	33.9875	33.8775	33.945	381800.0
2015-12-17 09:00:00	AMZN	Stock	33.944	34.125	33.8555	33.9525	13155580.0
2015-12-17 10:00:00	AMZN	Stock	33.9462	34.0135	33.54	33.7838	14800700.0
2015-12-17 11:00:00	AMZN	Stock	33.765	33.9305	33.6525	33.8474	7847660.0
2015-12-17 12:00:00	AMZN	Stock	33.8775	33.906	33.6427	33.7238	3942520.0
2015-12-17 13:00:00	AMZN	Stock	33.724	33.8415	33.633	33.7935	5544120.0

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

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