PREVIEW / stock_1hour / 2016-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-14.parquet
  size:    1.0 MB
  rows:    48,179
  symbols: 3,320

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
2016-04-14 04:00:00	AAPL	Stock	27.91	27.95	27.91	27.9375	6580.0
2016-04-14 05:00:00	AAPL	Stock	27.95	27.95	27.91	27.9375	1848.0
2016-04-14 07:00:00	AAPL	Stock	27.965	27.98	27.9	27.9	105476.0
2016-04-14 08:00:00	AAPL	Stock	27.8975	27.98	27.7825	27.855	768264.0
2016-04-14 09:00:00	AAPL	Stock	27.855	28.0425	27.84	27.89	17133792.0
2016-04-14 10:00:00	AAPL	Stock	27.89	27.9375	27.8325	27.93	16809004.0
2016-04-14 11:00:00	AAPL	Stock	27.93	28.0475	27.92	28.0452	12643512.0
2016-04-14 12:00:00	AAPL	Stock	28.045	28.0975	28.0025	28.0425	8786048.0
2016-04-14 13:00:00	AAPL	Stock	28.04	28.0675	27.98	27.9912	8274184.0
2016-04-14 14:00:00	AAPL	Stock	27.99	28.0475	27.975	28.0225	10975932.0
2016-04-14 15:00:00	AAPL	Stock	28.025	28.065	27.995	28.025	12285580.0
2016-04-14 16:00:00	AAPL	Stock	28.025	28.0625	28.0075	28.05	6374680.0
2016-04-14 17:00:00	AAPL	Stock	28.03	28.05	28.025	28.025	107504.0
2016-04-14 18:00:00	AAPL	Stock	28.03	28.05	28.03	28.05	19888.0
2016-04-14 19:00:00	AAPL	Stock	28.05	28.0575	28.045	28.05	15308.0
2016-04-14 08:00:00	MSFT	Stock	55.45	55.45	55.3	55.42	9816.0
2016-04-14 09:00:00	MSFT	Stock	55.45	55.46	55.11	55.23	2591508.0
2016-04-14 10:00:00	MSFT	Stock	55.24	55.38	55.07	55.35	2228398.0
2016-04-14 11:00:00	MSFT	Stock	55.34	55.575	55.26	55.51	2413601.0
2016-04-14 12:00:00	MSFT	Stock	55.51	55.514	55.23	55.395	1806702.0
2016-04-14 13:00:00	MSFT	Stock	55.385	55.47	55.28	55.42	1793783.0
2016-04-14 14:00:00	MSFT	Stock	55.42	55.565	55.36	55.48	2056273.0
2016-04-14 15:00:00	MSFT	Stock	55.485	55.55	55.28	55.36	4156208.0
2016-04-14 16:00:00	MSFT	Stock	55.36	55.44	55.3	55.44	2569998.0
2016-04-14 18:00:00	MSFT	Stock	55.42	55.42	55.42	55.42	300.0
2016-04-14 19:00:00	MSFT	Stock	55.42	55.49	55.42	55.49	1258.0
2016-04-14 06:00:00	NVDA	Stock	0.9242	0.9258	0.9188	0.9188	36000.0
2016-04-14 08:00:00	NVDA	Stock	0.9262	0.9262	0.9113	0.914	256440.0
2016-04-14 09:00:00	NVDA	Stock	0.914	0.9232	0.9123	0.9193	53678240.0
2016-04-14 10:00:00	NVDA	Stock	0.9194	0.9225	0.916	0.922	60925800.0
2016-04-14 11:00:00	NVDA	Stock	0.9218	0.9228	0.9185	0.921	37211080.0
2016-04-14 12:00:00	NVDA	Stock	0.921	0.9242	0.9182	0.9228	43454200.0
2016-04-14 13:00:00	NVDA	Stock	0.9225	0.925	0.92	0.9215	38445480.0
2016-04-14 14:00:00	NVDA	Stock	0.9213	0.9222	0.9186	0.92	40381960.0
2016-04-14 15:00:00	NVDA	Stock	0.92	0.922	0.9186	0.921	74531240.0
2016-04-14 16:00:00	NVDA	Stock	0.921	0.921	0.9208	0.921	4450720.0
2016-04-14 17:00:00	NVDA	Stock	0.921	0.921	0.921	0.921	36000.0
2016-04-14 18:00:00	NVDA	Stock	0.921	0.9255	0.921	0.9255	93160.0
2016-04-14 07:00:00	AMZN	Stock	30.722	30.775	30.722	30.775	14000.0
2016-04-14 08:00:00	AMZN	Stock	30.722	30.85	30.722	30.825	164500.0
2016-04-14 09:00:00	AMZN	Stock	30.8115	31.0305	30.7535	30.9185	10372460.0
2016-04-14 10:00:00	AMZN	Stock	30.912	31.1825	30.8555	31.1805	10604920.0
2016-04-14 11:00:00	AMZN	Stock	31.1699	31.175	30.959	31.164	6997840.0
2016-04-14 12:00:00	AMZN	Stock	31.1586	31.219	31.103	31.1802	13507060.0
2016-04-14 13:00:00	AMZN	Stock	31.18	31.205	31.002	31.015	6077100.0
2016-04-14 14:00:00	AMZN	Stock	31.0135	31.1265	30.9885	31.0725	4496160.0
2016-04-14 15:00:00	AMZN	Stock	31.0805	31.1235	31.035	31.0375	6532940.0
2016-04-14 16:00:00	AMZN	Stock	31.0375	31.045	30.9525	31.032	419640.0
2016-04-14 17:00:00	AMZN	Stock	31.031	31.05	31.031	31.05	31680.0
2016-04-14 18:00:00	AMZN	Stock	31.055	31.055	31.0375	31.0375	14360.0

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

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