PREVIEW / stock_1hour / 2015-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-09.parquet
  size:    1.0 MB
  rows:    49,338
  symbols: 3,474

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-07-09 04:00:00	AAPL	Stock	30.86	30.975	30.86	30.9075	35992.0
2015-07-09 05:00:00	AAPL	Stock	30.9075	30.975	30.895	30.965	53868.0
2015-07-09 06:00:00	AAPL	Stock	30.96	31.0	30.9475	30.9725	119164.0
2015-07-09 07:00:00	AAPL	Stock	30.97	31.0925	30.92	30.9875	436388.0
2015-07-09 08:00:00	AAPL	Stock	30.995	31.05	30.925	30.98	1020452.0
2015-07-09 09:00:00	AAPL	Stock	30.9825	31.015	30.825	30.9825	33323788.0
2015-07-09 10:00:00	AAPL	Stock	30.98	31.0	30.83	30.8775	25315876.0
2015-07-09 11:00:00	AAPL	Stock	30.8775	30.885	30.6525	30.725	25765596.0
2015-07-09 12:00:00	AAPL	Stock	30.7275	30.77	30.655	30.6762	18831864.0
2015-07-09 13:00:00	AAPL	Stock	30.6738	30.6825	30.3275	30.3642	36343320.0
2015-07-09 14:00:00	AAPL	Stock	30.364	30.4	29.805	30.1252	85295528.0
2015-07-09 15:00:00	AAPL	Stock	30.125	30.2702	30.0025	30.0075	61337960.0
2015-07-09 16:00:00	AAPL	Stock	30.0175	30.941	29.9775	30.0542	5402260.0
2015-07-09 17:00:00	AAPL	Stock	30.05	30.1	30.0175	30.0875	451904.0
2015-07-09 18:00:00	AAPL	Stock	30.1075	30.315	30.0875	30.275	503500.0
2015-07-09 19:00:00	AAPL	Stock	30.27	30.275	30.175	30.2625	270640.0
2015-07-09 04:00:00	MSFT	Stock	44.6	44.6	44.6	44.6	100.0
2015-07-09 06:00:00	MSFT	Stock	44.7	44.75	44.7	44.75	3662.0
2015-07-09 07:00:00	MSFT	Stock	44.73	44.75	44.6	44.65	18947.0
2015-07-09 08:00:00	MSFT	Stock	44.6	44.847	44.6	44.79	17043.0
2015-07-09 09:00:00	MSFT	Stock	44.787	44.98	44.65	44.88	6051948.0
2015-07-09 10:00:00	MSFT	Stock	44.88	44.99	44.75	44.941	5615511.0
2015-07-09 11:00:00	MSFT	Stock	44.945	45.22	44.9	44.964	3985919.0
2015-07-09 12:00:00	MSFT	Stock	44.965	45.04	44.79	44.96	3353832.0
2015-07-09 13:00:00	MSFT	Stock	44.96	44.98	44.775	44.835	2290279.0
2015-07-09 14:00:00	MSFT	Stock	44.83	44.88	44.7	44.775	3507931.0
2015-07-09 15:00:00	MSFT	Stock	44.78	44.85	44.5	44.51	4715649.0
2015-07-09 16:00:00	MSFT	Stock	44.52	44.53	44.45	44.45	1236156.0
2015-07-09 17:00:00	MSFT	Stock	44.5	44.5	44.5	44.5	200.0
2015-07-09 18:00:00	MSFT	Stock	44.52	44.78	44.52	44.75	6900.0
2015-07-09 19:00:00	MSFT	Stock	44.77	44.77	44.693	44.693	1812.0
2015-07-09 06:00:00	NVDA	Stock	0.4955	0.4955	0.4955	0.4955	14400.0
2015-07-09 09:00:00	NVDA	Stock	0.4975	0.5013	0.49	0.4905	41186560.0
2015-07-09 10:00:00	NVDA	Stock	0.4904	0.4918	0.486	0.4876	59027240.0
2015-07-09 11:00:00	NVDA	Stock	0.4875	0.4878	0.4822	0.4828	43166280.0
2015-07-09 12:00:00	NVDA	Stock	0.4828	0.487	0.4824	0.4862	43468840.0
2015-07-09 13:00:00	NVDA	Stock	0.4865	0.4885	0.485	0.4885	48378560.0
2015-07-09 14:00:00	NVDA	Stock	0.4885	0.4895	0.4852	0.4886	49222440.0
2015-07-09 15:00:00	NVDA	Stock	0.4885	0.4888	0.485	0.4852	58398600.0
2015-07-09 16:00:00	NVDA	Stock	0.4852	0.4852	0.4825	0.4825	9574560.0
2015-07-09 17:00:00	NVDA	Stock	0.4852	0.4852	0.4852	0.4852	30120.0
2015-07-09 06:00:00	AMZN	Stock	21.729	21.729	21.729	21.729	4000.0
2015-07-09 07:00:00	AMZN	Stock	21.6705	21.727	21.6705	21.724	6000.0
2015-07-09 08:00:00	AMZN	Stock	21.6855	21.727	21.6855	21.727	36000.0
2015-07-09 09:00:00	AMZN	Stock	21.719	21.85	21.715	21.83	5854460.0
2015-07-09 10:00:00	AMZN	Stock	21.8315	21.936	21.7262	21.8198	7979140.0
2015-07-09 11:00:00	AMZN	Stock	21.83	21.895	21.8022	21.8415	4437640.0
2015-07-09 12:00:00	AMZN	Stock	21.8498	21.8725	21.8145	21.8505	3984480.0
2015-07-09 13:00:00	AMZN	Stock	21.846	21.855	21.786	21.824	2572740.0
2015-07-09 14:00:00	AMZN	Stock	21.8218	21.8655	21.7245	21.838	4331900.0

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

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