PREVIEW / stock_1hour / 2015-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-27.parquet
  size:    1.0 MB
  rows:    49,381
  symbols: 3,485

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-08-27 04:00:00	AAPL	Stock	27.5825	28.12	27.5825	28.08	165384.0
2015-08-27 05:00:00	AAPL	Stock	28.08	28.1125	28.025	28.0725	97924.0
2015-08-27 06:00:00	AAPL	Stock	28.095	28.125	28.005	28.005	803096.0
2015-08-27 07:00:00	AAPL	Stock	28.01	28.075	27.9075	27.9075	693092.0
2015-08-27 08:00:00	AAPL	Stock	27.905	28.1	27.7825	27.98	3079128.0
2015-08-27 09:00:00	AAPL	Stock	27.98	28.075	27.6825	27.7625	49188700.0
2015-08-27 10:00:00	AAPL	Stock	27.7625	28.0	27.6	27.998	44014844.0
2015-08-27 11:00:00	AAPL	Stock	27.995	28.1975	27.875	28.025	37115204.0
2015-08-27 12:00:00	AAPL	Stock	28.0275	28.31	28.0225	28.2575	31733032.0
2015-08-27 13:00:00	AAPL	Stock	28.2625	28.3	28.0975	28.2125	28660484.0
2015-08-27 14:00:00	AAPL	Stock	28.21	28.2442	27.65	27.68	40942324.0
2015-08-27 15:00:00	AAPL	Stock	27.685	28.23	27.505	28.23	62191764.0
2015-08-27 16:00:00	AAPL	Stock	28.23	28.24	27.8085	28.22	15368356.0
2015-08-27 17:00:00	AAPL	Stock	28.22	28.2475	28.2025	28.245	349660.0
2015-08-27 18:00:00	AAPL	Stock	28.245	28.2475	28.2275	28.24	151656.0
2015-08-27 19:00:00	AAPL	Stock	28.24	28.2475	28.2275	28.245	200456.0
2015-08-27 04:00:00	MSFT	Stock	43.17	43.17	43.08	43.17	7415.0
2015-08-27 05:00:00	MSFT	Stock	43.28	43.28	43.27	43.27	400.0
2015-08-27 06:00:00	MSFT	Stock	43.25	43.28	43.22	43.22	1550.0
2015-08-27 07:00:00	MSFT	Stock	43.21	43.21	42.93	42.93	11346.0
2015-08-27 08:00:00	MSFT	Stock	43.0	43.15	42.93	43.15	46554.0
2015-08-27 09:00:00	MSFT	Stock	43.16	43.64	43.11	43.49	6831824.0
2015-08-27 10:00:00	MSFT	Stock	43.49	43.805	43.25	43.74	7386512.0
2015-08-27 11:00:00	MSFT	Stock	43.74	43.83	43.61	43.79	3680908.0
2015-08-27 12:00:00	MSFT	Stock	43.79	43.95	43.56	43.78	3959408.0
2015-08-27 13:00:00	MSFT	Stock	43.77	43.95	43.67	43.79	4057490.0
2015-08-27 14:00:00	MSFT	Stock	43.8	43.889	43.23	43.28	5838101.0
2015-08-27 15:00:00	MSFT	Stock	43.28	43.92	42.925	43.91	10989645.0
2015-08-27 16:00:00	MSFT	Stock	43.9	44.0	43.646	43.88	5390344.0
2015-08-27 17:00:00	MSFT	Stock	43.98	43.98	43.85	43.98	3117.0
2015-08-27 19:00:00	MSFT	Stock	43.9	43.9	43.85	43.85	1300.0
2015-08-27 07:00:00	NVDA	Stock	0.5572	0.5572	0.5572	0.5572	5920.0
2015-08-27 08:00:00	NVDA	Stock	0.5575	0.5575	0.5538	0.5562	385480.0
2015-08-27 09:00:00	NVDA	Stock	0.5558	0.558	0.5495	0.5512	53249040.0
2015-08-27 10:00:00	NVDA	Stock	0.551	0.5565	0.5478	0.5562	70335800.0
2015-08-27 11:00:00	NVDA	Stock	0.5564	0.5585	0.5548	0.5559	46433120.0
2015-08-27 12:00:00	NVDA	Stock	0.5558	0.561	0.5556	0.561	44165080.0
2015-08-27 13:00:00	NVDA	Stock	0.561	0.5638	0.5598	0.5635	45287680.0
2015-08-27 14:00:00	NVDA	Stock	0.5635	0.5646	0.5575	0.5578	78294480.0
2015-08-27 15:00:00	NVDA	Stock	0.5578	0.566	0.5545	0.566	101883240.0
2015-08-27 16:00:00	NVDA	Stock	0.5658	0.5682	0.5658	0.5658	13318640.0
2015-08-27 17:00:00	NVDA	Stock	0.5688	0.5748	0.5688	0.5688	72000.0
2015-08-27 04:00:00	AMZN	Stock	25.5	25.75	25.5	25.725	69060.0
2015-08-27 05:00:00	AMZN	Stock	25.7145	25.7145	25.6725	25.6725	30520.0
2015-08-27 06:00:00	AMZN	Stock	25.709	25.75	25.601	25.601	150560.0
2015-08-27 07:00:00	AMZN	Stock	25.5635	25.6005	25.475	25.597	292060.0
2015-08-27 08:00:00	AMZN	Stock	25.5875	25.724	25.5	25.7	805040.0
2015-08-27 09:00:00	AMZN	Stock	25.676	26.1345	25.657	25.8665	26765080.0
2015-08-27 10:00:00	AMZN	Stock	25.899	25.9485	25.659	25.7115	14281840.0
2015-08-27 11:00:00	AMZN	Stock	25.71	25.8415	25.6	25.645	8429160.0

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

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