PREVIEW / stock_1hour / 2014-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-28.parquet
  size:    749 KB
  rows:    31,829
  symbols: 3,472

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
2014-11-28 04:00:00	AAPL	Stock	29.7875	29.7875	29.7075	29.75	61296.0
2014-11-28 05:00:00	AAPL	Stock	29.74	29.78	29.74	29.75	8400.0
2014-11-28 06:00:00	AAPL	Stock	29.75	29.775	29.745	29.7575	61048.0
2014-11-28 07:00:00	AAPL	Stock	29.7725	29.855	29.7725	29.85	214112.0
2014-11-28 08:00:00	AAPL	Stock	29.85	29.8675	29.7488	29.82	623284.0
2014-11-28 09:00:00	AAPL	Stock	29.825	29.85	29.5125	29.6375	24064124.0
2014-11-28 10:00:00	AAPL	Stock	29.6375	29.76	29.565	29.7528	23231920.0
2014-11-28 11:00:00	AAPL	Stock	29.7538	29.755	29.6678	29.725	13646540.0
2014-11-28 12:00:00	AAPL	Stock	29.725	29.7475	29.635	29.7325	21585828.0
2014-11-28 13:00:00	AAPL	Stock	29.7325	29.75	29.6882	29.745	10065560.0
2014-11-28 14:00:00	AAPL	Stock	29.7325	29.7475	29.72	29.73	101948.0
2014-11-28 15:00:00	AAPL	Stock	29.7425	29.7425	29.7025	29.7025	21132.0
2014-11-28 16:00:00	AAPL	Stock	29.705	29.7125	29.7025	29.71	4608.0
2014-11-28 04:00:00	MSFT	Stock	47.82	47.82	47.82	47.82	100.0
2014-11-28 05:00:00	MSFT	Stock	47.82	47.82	47.8	47.8	1085.0
2014-11-28 06:00:00	MSFT	Stock	47.8	47.8	47.8	47.8	500.0
2014-11-28 07:00:00	MSFT	Stock	47.81	47.82	47.8	47.81	2612.0
2014-11-28 08:00:00	MSFT	Stock	47.81	47.85	47.75	47.85	3317.0
2014-11-28 09:00:00	MSFT	Stock	47.83	48.07	47.61	47.857	3105452.0
2014-11-28 10:00:00	MSFT	Stock	47.86	48.18	47.825	48.12	4604371.0
2014-11-28 11:00:00	MSFT	Stock	48.12	48.195	48.04	48.12	3221831.0
2014-11-28 12:00:00	MSFT	Stock	48.11	48.15	47.72	47.82	4292218.0
2014-11-28 13:00:00	MSFT	Stock	47.81	48.142	47.78	47.9	5464138.0
2014-11-28 14:00:00	MSFT	Stock	47.9	47.9	47.82	47.82	600.0
2014-11-28 08:00:00	NVDA	Stock	0.521	0.521	0.521	0.521	14000.0
2014-11-28 09:00:00	NVDA	Stock	0.5255	0.5255	0.5205	0.5222	24555400.0
2014-11-28 10:00:00	NVDA	Stock	0.5222	0.525	0.5201	0.5247	32835720.0
2014-11-28 11:00:00	NVDA	Stock	0.5247	0.527	0.5244	0.526	24851480.0
2014-11-28 12:00:00	NVDA	Stock	0.526	0.5272	0.523	0.5242	25848360.0
2014-11-28 13:00:00	NVDA	Stock	0.5242	0.5243	0.524	0.5242	11353000.0
2014-11-28 14:00:00	NVDA	Stock	0.5242	0.5242	0.5242	0.5242	1231200.0
2014-11-28 16:00:00	NVDA	Stock	0.5198	0.5198	0.5198	0.5198	10000.0
2014-11-28 06:00:00	AMZN	Stock	16.7125	16.7125	16.7125	16.7125	2200.0
2014-11-28 07:00:00	AMZN	Stock	16.734	16.85	16.7175	16.8495	87420.0
2014-11-28 08:00:00	AMZN	Stock	16.827	16.827	16.5975	16.825	165700.0
2014-11-28 09:00:00	AMZN	Stock	16.82	17.063	16.8	17.0495	16625940.0
2014-11-28 10:00:00	AMZN	Stock	17.0455	17.056	16.915	16.9245	15240320.0
2014-11-28 11:00:00	AMZN	Stock	16.9245	17.021	16.9156	16.9976	8338900.0
2014-11-28 12:00:00	AMZN	Stock	16.9952	17.012	16.8935	16.932	12454360.0
2014-11-28 13:00:00	AMZN	Stock	16.932	16.967	16.85	16.85	3051360.0
2014-11-28 14:00:00	AMZN	Stock	16.9354	16.9354	16.9	16.9	33300.0
2014-11-28 16:00:00	AMZN	Stock	16.875	16.875	16.875	16.875	3000.0
2014-11-28 06:00:00	GOOGL	Stock	27.2525	27.2525	27.2525	27.2525	4000.0
2014-11-28 08:00:00	GOOGL	Stock	27.25	27.25	27.25	27.25	13500.0
2014-11-28 09:00:00	GOOGL	Stock	27.325	27.35	27.224	27.2991	3355080.0
2014-11-28 10:00:00	GOOGL	Stock	27.284	27.4425	27.2755	27.43	3986340.0
2014-11-28 11:00:00	GOOGL	Stock	27.4275	27.48	27.381	27.386	4212700.0
2014-11-28 12:00:00	GOOGL	Stock	27.3955	27.474	27.3926	27.4575	3347100.0
2014-11-28 13:00:00	GOOGL	Stock	27.454	27.47	27.39	27.395	3681100.0
2014-11-28 04:00:00	META	Stock	77.69	77.74	77.53	77.53	1760.0

> showing 50 of 31,829 rows — these rows as CSV

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