PREVIEW / stock_1hour / 2016-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-20.parquet
  size:    1.0 MB
  rows:    47,783
  symbols: 3,216

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-09-20 04:00:00	AAPL	Stock	28.395	28.395	28.3575	28.37	2000.0
2016-09-20 05:00:00	AAPL	Stock	28.3325	28.3325	28.2925	28.3275	13596.0
2016-09-20 06:00:00	AAPL	Stock	28.37	28.47	28.345	28.375	40840.0
2016-09-20 07:00:00	AAPL	Stock	28.35	28.4275	28.2575	28.2575	217548.0
2016-09-20 08:00:00	AAPL	Stock	28.275	28.4275	28.2575	28.275	521976.0
2016-09-20 09:00:00	AAPL	Stock	28.2725	28.4875	28.1275	28.4725	34072976.0
2016-09-20 10:00:00	AAPL	Stock	28.4712	28.51	28.33	28.4475	23161452.0
2016-09-20 11:00:00	AAPL	Stock	28.4475	28.53	28.426	28.45	14353616.0
2016-09-20 12:00:00	AAPL	Stock	28.45	28.46	28.345	28.3515	9409784.0
2016-09-20 13:00:00	AAPL	Stock	28.3505	28.385	28.295	28.3725	10798036.0
2016-09-20 14:00:00	AAPL	Stock	28.3725	28.4825	28.36	28.4675	10992228.0
2016-09-20 15:00:00	AAPL	Stock	28.4675	28.485	28.3925	28.3925	17057540.0
2016-09-20 16:00:00	AAPL	Stock	28.3925	28.4	28.35	28.3575	6849264.0
2016-09-20 17:00:00	AAPL	Stock	28.3575	28.3875	28.3575	28.3675	6820.0
2016-09-20 18:00:00	AAPL	Stock	28.3825	28.4125	28.3675	28.395	31716.0
2016-09-20 19:00:00	AAPL	Stock	28.4125	28.4225	28.4125	28.4125	26108.0
2016-09-20 08:00:00	MSFT	Stock	57.12	57.18	57.12	57.17	3135.0
2016-09-20 09:00:00	MSFT	Stock	57.18	57.35	57.1	57.18	2043173.0
2016-09-20 10:00:00	MSFT	Stock	57.185	57.22	56.79	56.94	2968848.0
2016-09-20 11:00:00	MSFT	Stock	56.93	56.99	56.79	56.81	1848926.0
2016-09-20 12:00:00	MSFT	Stock	56.81	56.96	56.75	56.775	1492689.0
2016-09-20 13:00:00	MSFT	Stock	56.775	56.97	56.75	56.94	1272985.0
2016-09-20 14:00:00	MSFT	Stock	56.94	57.0	56.9	56.95	1345015.0
2016-09-20 15:00:00	MSFT	Stock	56.95	57.02	56.81	56.82	3305966.0
2016-09-20 16:00:00	MSFT	Stock	56.81	57.92	56.81	57.31	2014948.0
2016-09-20 17:00:00	MSFT	Stock	57.36	57.49	57.32	57.35	30058.0
2016-09-20 18:00:00	MSFT	Stock	57.36	57.39	57.32	57.37	5898.0
2016-09-20 19:00:00	MSFT	Stock	57.37	57.38	57.32	57.35	6616.0
2016-09-20 08:00:00	NVDA	Stock	1.595	1.5998	1.5945	1.5975	93800.0
2016-09-20 09:00:00	NVDA	Stock	1.5995	1.61	1.5818	1.5925	54847720.0
2016-09-20 10:00:00	NVDA	Stock	1.5922	1.5978	1.5828	1.585	50054840.0
2016-09-20 11:00:00	NVDA	Stock	1.5852	1.5892	1.5783	1.579	31851480.0
2016-09-20 12:00:00	NVDA	Stock	1.5791	1.5803	1.5685	1.5694	30124920.0
2016-09-20 13:00:00	NVDA	Stock	1.5694	1.5825	1.569	1.579	28761720.0
2016-09-20 14:00:00	NVDA	Stock	1.579	1.5805	1.5762	1.5795	26648040.0
2016-09-20 15:00:00	NVDA	Stock	1.5798	1.5832	1.5775	1.5775	42842080.0
2016-09-20 16:00:00	NVDA	Stock	1.5775	1.5783	1.5752	1.5773	3167880.0
2016-09-20 17:00:00	NVDA	Stock	1.5773	1.5773	1.5705	1.5705	404800.0
2016-09-20 18:00:00	NVDA	Stock	1.5762	1.5773	1.5762	1.5773	51680.0
2016-09-20 19:00:00	NVDA	Stock	1.575	1.575	1.575	1.575	4000.0
2016-09-20 06:00:00	AMZN	Stock	38.9245	38.9245	38.9245	38.9245	2000.0
2016-09-20 07:00:00	AMZN	Stock	38.892	38.9	38.892	38.9	12000.0
2016-09-20 08:00:00	AMZN	Stock	38.899	38.899	38.885	38.885	10000.0
2016-09-20 09:00:00	AMZN	Stock	38.8685	39.034	38.8	38.95	7817800.0
2016-09-20 10:00:00	AMZN	Stock	38.9525	39.0075	38.8175	38.875	5832920.0
2016-09-20 11:00:00	AMZN	Stock	38.869	38.9473	38.841	38.8608	3310440.0
2016-09-20 12:00:00	AMZN	Stock	38.868	38.9485	38.85	38.8745	2901400.0
2016-09-20 13:00:00	AMZN	Stock	38.8755	38.9705	38.85	38.962	3477160.0
2016-09-20 14:00:00	AMZN	Stock	38.951	39.0185	38.941	39.006	3776980.0
2016-09-20 15:00:00	AMZN	Stock	39.014	39.0685	38.9665	39.0155	9064340.0

> showing 50 of 47,783 rows — these rows as CSV

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