PREVIEW / stock_1hour / 2015-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-17.parquet
  size:    1.0 MB
  rows:    48,363
  symbols: 3,443

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-09-17 04:00:00	AAPL	Stock	29.05	29.0975	29.05	29.0675	23696.0
2015-09-17 05:00:00	AAPL	Stock	29.0775	29.095	29.0325	29.05	35716.0
2015-09-17 06:00:00	AAPL	Stock	29.06	29.0875	28.9775	28.9775	66628.0
2015-09-17 07:00:00	AAPL	Stock	28.975	29.01	28.89	28.9	209316.0
2015-09-17 08:00:00	AAPL	Stock	28.9	29.0125	28.8875	28.915	894972.0
2015-09-17 09:00:00	AAPL	Stock	28.915	28.9625	28.7925	28.83	21881284.0
2015-09-17 10:00:00	AAPL	Stock	28.83	28.9175	28.769	28.8662	21949860.0
2015-09-17 11:00:00	AAPL	Stock	28.8672	28.9225	28.8275	28.885	15938156.0
2015-09-17 12:00:00	AAPL	Stock	28.8862	28.935	28.825	28.8625	11726848.0
2015-09-17 13:00:00	AAPL	Stock	28.86	28.9025	28.785	28.8225	18083216.0
2015-09-17 14:00:00	AAPL	Stock	28.825	29.105	28.6675	29.055	62181868.0
2015-09-17 15:00:00	AAPL	Stock	29.0525	29.1225	28.4288	28.4825	70199024.0
2015-09-17 16:00:00	AAPL	Stock	28.48	28.53	28.475	28.5	12379320.0
2015-09-17 17:00:00	AAPL	Stock	28.4975	28.52	28.4775	28.495	305260.0
2015-09-17 18:00:00	AAPL	Stock	28.49	28.55	28.48	28.54	231708.0
2015-09-17 19:00:00	AAPL	Stock	28.5375	28.5425	28.5025	28.53	162784.0
2015-09-17 05:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	100.0
2015-09-17 06:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	100.0
2015-09-17 07:00:00	MSFT	Stock	44.31	44.32	44.3	44.3	900.0
2015-09-17 08:00:00	MSFT	Stock	44.29	44.31	44.2	44.31	10587.0
2015-09-17 09:00:00	MSFT	Stock	44.31	44.49	44.185	44.4	1860993.0
2015-09-17 10:00:00	MSFT	Stock	44.39	44.65	44.35	44.435	2413010.0
2015-09-17 11:00:00	MSFT	Stock	44.43	44.635	44.4	44.43	2319629.0
2015-09-17 12:00:00	MSFT	Stock	44.43	44.61	44.41	44.55	1342955.0
2015-09-17 13:00:00	MSFT	Stock	44.54	44.64	44.48	44.54	1899215.0
2015-09-17 14:00:00	MSFT	Stock	44.528	45.0	44.08	44.85	5830324.0
2015-09-17 15:00:00	MSFT	Stock	44.85	44.91	44.18	44.26	8011667.0
2015-09-17 16:00:00	MSFT	Stock	44.25	44.28	44.1	44.26	4784750.0
2015-09-17 17:00:00	MSFT	Stock	44.17	44.25	44.1	44.12	1231675.0
2015-09-17 18:00:00	MSFT	Stock	44.19	44.2	44.13	44.17	900.0
2015-09-17 19:00:00	MSFT	Stock	44.17	44.25	44.17	44.25	500.0
2015-09-17 04:00:00	NVDA	Stock	0.582	0.5848	0.582	0.5848	35400.0
2015-09-17 06:00:00	NVDA	Stock	0.5895	0.59	0.5895	0.59	57960.0
2015-09-17 08:00:00	NVDA	Stock	0.5855	0.588	0.585	0.588	64000.0
2015-09-17 09:00:00	NVDA	Stock	0.5898	0.5912	0.5838	0.5894	40876720.0
2015-09-17 10:00:00	NVDA	Stock	0.5895	0.5895	0.5844	0.5845	25421680.0
2015-09-17 11:00:00	NVDA	Stock	0.5843	0.5872	0.5841	0.5861	21548480.0
2015-09-17 12:00:00	NVDA	Stock	0.5863	0.5875	0.5858	0.5872	25270720.0
2015-09-17 13:00:00	NVDA	Stock	0.5875	0.589	0.5863	0.588	24444280.0
2015-09-17 14:00:00	NVDA	Stock	0.5883	0.5928	0.5843	0.5923	51446880.0
2015-09-17 15:00:00	NVDA	Stock	0.5923	0.5928	0.5815	0.5828	65360240.0
2015-09-17 16:00:00	NVDA	Stock	0.5828	0.5828	0.582	0.5828	170880.0
2015-09-17 17:00:00	NVDA	Stock	0.5812	0.5812	0.5782	0.5782	20000.0
2015-09-17 18:00:00	NVDA	Stock	0.5785	0.5812	0.5785	0.5812	40000.0
2015-09-17 19:00:00	NVDA	Stock	0.5828	0.5828	0.5828	0.5828	56000.0
2015-09-17 06:00:00	AMZN	Stock	26.35	26.35	26.35	26.35	12780.0
2015-09-17 08:00:00	AMZN	Stock	26.3	26.326	26.3	26.309	12000.0
2015-09-17 09:00:00	AMZN	Stock	26.3245	26.6	26.3245	26.525	4906380.0
2015-09-17 10:00:00	AMZN	Stock	26.52	26.699	26.4945	26.5902	6793280.0
2015-09-17 11:00:00	AMZN	Stock	26.5865	26.654	26.566	26.623	4443240.0

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

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