PREVIEW / stock_1hour / 2016-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-18.parquet
  size:    1.0 MB
  rows:    49,369
  symbols: 3,326

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-18 04:00:00	AAPL	Stock	27.4	27.4	27.2525	27.3025	21424.0
2016-04-18 05:00:00	AAPL	Stock	27.345	27.36	27.3	27.36	15264.0
2016-04-18 06:00:00	AAPL	Stock	27.36	27.3625	27.3125	27.3125	25212.0
2016-04-18 07:00:00	AAPL	Stock	27.325	27.34	27.125	27.2125	325168.0
2016-04-18 08:00:00	AAPL	Stock	27.2125	27.3325	27.205	27.25	671108.0
2016-04-18 09:00:00	AAPL	Stock	27.25	27.285	26.9525	26.98	31765740.0
2016-04-18 10:00:00	AAPL	Stock	26.98	27.16	26.9762	27.0138	29455216.0
2016-04-18 11:00:00	AAPL	Stock	27.0125	27.0765	26.9875	27.0225	15707516.0
2016-04-18 12:00:00	AAPL	Stock	27.0225	27.0775	26.94	26.9525	16762464.0
2016-04-18 13:00:00	AAPL	Stock	26.95	26.955	26.7875	26.82	19867240.0
2016-04-18 14:00:00	AAPL	Stock	26.82	26.8475	26.735	26.78	20455016.0
2016-04-18 15:00:00	AAPL	Stock	26.7785	26.9125	26.7575	26.85	35399928.0
2016-04-18 16:00:00	AAPL	Stock	26.85	27.0135	26.7775	26.8275	13348776.0
2016-04-18 17:00:00	AAPL	Stock	26.825	26.86	26.82	26.8475	32292.0
2016-04-18 18:00:00	AAPL	Stock	26.8425	26.8425	26.825	26.8425	28348.0
2016-04-18 19:00:00	AAPL	Stock	26.8375	26.8625	26.8275	26.8625	43640.0
2016-04-18 05:00:00	MSFT	Stock	55.47	55.52	55.47	55.52	2535.0
2016-04-18 06:00:00	MSFT	Stock	55.51	55.51	55.22	55.22	10999.0
2016-04-18 07:00:00	MSFT	Stock	55.49	55.49	55.34	55.34	645.0
2016-04-18 08:00:00	MSFT	Stock	55.45	55.46	55.34	55.44	13080.0
2016-04-18 09:00:00	MSFT	Stock	55.41	55.745	55.21	55.71	1579028.0
2016-04-18 10:00:00	MSFT	Stock	55.71	56.25	55.7	56.186	3013684.0
2016-04-18 11:00:00	MSFT	Stock	56.18	56.19	55.98	56.05	2064075.0
2016-04-18 12:00:00	MSFT	Stock	56.05	56.59	56.05	56.35	4193783.0
2016-04-18 13:00:00	MSFT	Stock	56.345	56.48	56.23	56.47	2038586.0
2016-04-18 14:00:00	MSFT	Stock	56.47	56.55	56.44	56.5	2210248.0
2016-04-18 15:00:00	MSFT	Stock	56.5	56.555	56.42	56.45	4333134.0
2016-04-18 16:00:00	MSFT	Stock	56.46	56.6	56.36	56.5	2433283.0
2016-04-18 17:00:00	MSFT	Stock	56.39	56.53	56.39	56.5	20489.0
2016-04-18 18:00:00	MSFT	Stock	56.45	56.5	56.44	56.44	8057.0
2016-04-18 19:00:00	MSFT	Stock	56.46	56.52	56.46	56.5	2530.0
2016-04-18 08:00:00	NVDA	Stock	0.9298	0.93	0.9275	0.9275	64000.0
2016-04-18 09:00:00	NVDA	Stock	0.925	0.9265	0.9193	0.9218	22853480.0
2016-04-18 10:00:00	NVDA	Stock	0.9215	0.925	0.9205	0.9214	35416640.0
2016-04-18 11:00:00	NVDA	Stock	0.9215	0.9229	0.9152	0.9179	37160360.0
2016-04-18 12:00:00	NVDA	Stock	0.9179	0.9225	0.9176	0.9205	39958760.0
2016-04-18 13:00:00	NVDA	Stock	0.9206	0.9242	0.9198	0.9226	34912800.0
2016-04-18 14:00:00	NVDA	Stock	0.9225	0.9248	0.9215	0.9232	35003680.0
2016-04-18 15:00:00	NVDA	Stock	0.9232	0.9252	0.922	0.9242	45362640.0
2016-04-18 16:00:00	NVDA	Stock	0.9242	0.9248	0.9242	0.9248	27046720.0
2016-04-18 19:00:00	NVDA	Stock	0.9175	0.9175	0.9175	0.9175	8000.0
2016-04-18 07:00:00	AMZN	Stock	31.25	31.29	31.25	31.25	31600.0
2016-04-18 08:00:00	AMZN	Stock	31.25	31.3	31.21	31.237	76360.0
2016-04-18 09:00:00	AMZN	Stock	31.224	31.8145	31.193	31.6975	13271020.0
2016-04-18 10:00:00	AMZN	Stock	31.6915	31.882	31.6915	31.7897	11458560.0
2016-04-18 11:00:00	AMZN	Stock	31.8025	31.8108	31.312	31.3758	12512280.0
2016-04-18 12:00:00	AMZN	Stock	31.382	31.607	31.3678	31.517	9271160.0
2016-04-18 13:00:00	AMZN	Stock	31.5245	31.5932	31.4565	31.5505	4546360.0
2016-04-18 14:00:00	AMZN	Stock	31.5536	31.6725	31.521	31.5921	5875400.0
2016-04-18 15:00:00	AMZN	Stock	31.592	31.8175	31.5405	31.7695	12620100.0

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

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