PREVIEW / stock_1hour / 2015-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-28.parquet
  size:    1.0 MB
  rows:    48,768
  symbols: 3,506

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-04-28 04:00:00	AAPL	Stock	33.6375	33.675	33.5	33.665	178024.0
2015-04-28 05:00:00	AAPL	Stock	33.675	33.7425	33.6625	33.7125	140384.0
2015-04-28 06:00:00	AAPL	Stock	33.725	33.9375	33.685	33.8875	451092.0
2015-04-28 07:00:00	AAPL	Stock	33.8875	34.05	33.84	33.9275	3133700.0
2015-04-28 08:00:00	AAPL	Stock	33.9125	34.045	33.5275	33.6	8738824.0
2015-04-28 09:00:00	AAPL	Stock	33.595	33.68	32.5825	32.79	124778716.0
2015-04-28 10:00:00	AAPL	Stock	32.79	32.85	32.3925	32.7175	88945072.0
2015-04-28 11:00:00	AAPL	Stock	32.72	33.185	32.7088	33.15	59437572.0
2015-04-28 12:00:00	AAPL	Stock	33.15	33.28	33.0925	33.2175	44079792.0
2015-04-28 13:00:00	AAPL	Stock	33.2175	33.2375	32.995	33.0072	27650920.0
2015-04-28 14:00:00	AAPL	Stock	33.0025	33.0075	32.7125	32.715	40206172.0
2015-04-28 15:00:00	AAPL	Stock	32.7162	32.7925	32.57	32.64	48167068.0
2015-04-28 16:00:00	AAPL	Stock	32.64	32.7835	32.55	32.5875	4916552.0
2015-04-28 17:00:00	AAPL	Stock	32.5825	32.585	32.5175	32.5525	347480.0
2015-04-28 18:00:00	AAPL	Stock	32.555	32.585	32.525	32.5622	265108.0
2015-04-28 19:00:00	AAPL	Stock	32.5625	32.575	32.525	32.5675	296320.0
2015-04-28 04:00:00	MSFT	Stock	47.79	47.88	47.79	47.88	460.0
2015-04-28 05:00:00	MSFT	Stock	47.94	47.94	47.84	47.84	340.0
2015-04-28 06:00:00	MSFT	Stock	47.84	47.85	47.81	47.81	3410.0
2015-04-28 07:00:00	MSFT	Stock	47.79	47.79	47.69	47.74	20009.0
2015-04-28 08:00:00	MSFT	Stock	47.75	47.82	47.71	47.78	24098.0
2015-04-28 09:00:00	MSFT	Stock	47.76	48.72	47.68	48.64	7656654.0
2015-04-28 10:00:00	MSFT	Stock	48.635	49.0	48.54	48.955	11747153.0
2015-04-28 11:00:00	MSFT	Stock	48.95	49.135	48.87	49.02	8284487.0
2015-04-28 12:00:00	MSFT	Stock	49.02	49.04	48.81	48.98	4612401.0
2015-04-28 13:00:00	MSFT	Stock	48.98	49.09	48.91	48.98	4502775.0
2015-04-28 14:00:00	MSFT	Stock	48.985	49.14	48.95	49.073	5459452.0
2015-04-28 15:00:00	MSFT	Stock	49.07	49.21	48.9	49.16	11458160.0
2015-04-28 16:00:00	MSFT	Stock	49.155	49.2	48.858	49.15	2963728.0
2015-04-28 17:00:00	MSFT	Stock	49.15	49.18	49.13	49.13	8063.0
2015-04-28 18:00:00	MSFT	Stock	49.13	49.15	49.07	49.1	18608.0
2015-04-28 19:00:00	MSFT	Stock	49.1	49.14	49.08	49.13	8749.0
2015-04-28 08:00:00	NVDA	Stock	0.555	0.555	0.555	0.555	8000.0
2015-04-28 09:00:00	NVDA	Stock	0.559	0.559	0.5492	0.5508	28907000.0
2015-04-28 10:00:00	NVDA	Stock	0.5505	0.5538	0.5488	0.5528	38252080.0
2015-04-28 11:00:00	NVDA	Stock	0.5529	0.5548	0.5516	0.552	19586880.0
2015-04-28 12:00:00	NVDA	Stock	0.5519	0.5568	0.5508	0.5565	34093360.0
2015-04-28 13:00:00	NVDA	Stock	0.5564	0.5596	0.556	0.5581	18648960.0
2015-04-28 14:00:00	NVDA	Stock	0.558	0.5582	0.555	0.5552	24932440.0
2015-04-28 15:00:00	NVDA	Stock	0.5552	0.5578	0.5548	0.5575	50915040.0
2015-04-28 16:00:00	NVDA	Stock	0.5575	0.5595	0.557	0.5595	878600.0
2015-04-28 04:00:00	AMZN	Stock	21.95	21.95	21.95	21.95	2000.0
2015-04-28 06:00:00	AMZN	Stock	21.9525	21.97	21.9425	21.97	41000.0
2015-04-28 07:00:00	AMZN	Stock	21.9085	21.988	21.901	21.988	48800.0
2015-04-28 08:00:00	AMZN	Stock	21.973	22.0	21.9385	21.961	75500.0
2015-04-28 09:00:00	AMZN	Stock	21.95	21.9685	21.7255	21.828	8997900.0
2015-04-28 10:00:00	AMZN	Stock	21.83	21.89	21.685	21.7345	13901280.0
2015-04-28 11:00:00	AMZN	Stock	21.7415	21.8	21.621	21.6805	10203720.0
2015-04-28 12:00:00	AMZN	Stock	21.6885	21.741	21.625	21.6825	7431400.0
2015-04-28 13:00:00	AMZN	Stock	21.686	21.7105	21.5785	21.597	5671920.0

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

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