PREVIEW / stock_1hour / 2015-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-20.parquet
  size:    1.1 MB
  rows:    49,958
  symbols: 3,528

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-03-20 04:00:00	AAPL	Stock	31.92	32.045	31.92	31.9975	18680.0
2015-03-20 05:00:00	AAPL	Stock	31.9975	32.05	31.9975	32.045	72200.0
2015-03-20 06:00:00	AAPL	Stock	32.0	32.0	31.955	31.9875	52932.0
2015-03-20 07:00:00	AAPL	Stock	31.985	32.0375	31.975	32.025	141640.0
2015-03-20 08:00:00	AAPL	Stock	32.0025	32.0625	31.875	32.055	596980.0
2015-03-20 09:00:00	AAPL	Stock	32.0575	32.1	31.9125	31.9825	52364848.0
2015-03-20 10:00:00	AAPL	Stock	31.985	32.005	31.9275	31.9375	20088680.0
2015-03-20 11:00:00	AAPL	Stock	31.9375	32.0	31.89	31.9025	13713752.0
2015-03-20 12:00:00	AAPL	Stock	31.9	31.96	31.8962	31.935	11623340.0
2015-03-20 13:00:00	AAPL	Stock	31.9375	32.0325	31.9375	31.985	13233640.0
2015-03-20 14:00:00	AAPL	Stock	31.9862	32.0215	31.95	32.0178	12372392.0
2015-03-20 15:00:00	AAPL	Stock	32.02	32.03	31.29	31.4875	66134536.0
2015-03-20 16:00:00	AAPL	Stock	31.475	31.9748	31.4718	31.63	72595416.0
2015-03-20 17:00:00	AAPL	Stock	31.63	31.6725	31.475	31.6375	728260.0
2015-03-20 18:00:00	AAPL	Stock	31.635	31.6375	31.475	31.6075	265280.0
2015-03-20 19:00:00	AAPL	Stock	31.475	31.6625	31.475	31.625	163844.0
2015-03-20 04:00:00	MSFT	Stock	42.47	42.47	42.4	42.4	200.0
2015-03-20 06:00:00	MSFT	Stock	42.4	42.4	42.4	42.4	100.0
2015-03-20 08:00:00	MSFT	Stock	42.539	42.77	42.539	42.77	10558.0
2015-03-20 09:00:00	MSFT	Stock	42.77	42.79	42.49	42.73	17859554.0
2015-03-20 10:00:00	MSFT	Stock	42.729	42.98	42.695	42.833	5275222.0
2015-03-20 11:00:00	MSFT	Stock	42.84	42.95	42.72	42.888	3403924.0
2015-03-20 12:00:00	MSFT	Stock	42.88	42.885	42.75	42.845	2821907.0
2015-03-20 13:00:00	MSFT	Stock	42.845	42.91	42.81	42.855	2897072.0
2015-03-20 14:00:00	MSFT	Stock	42.85	42.92	42.84	42.914	3362242.0
2015-03-20 15:00:00	MSFT	Stock	42.92	42.95	42.65	42.76	8523272.0
2015-03-20 16:00:00	MSFT	Stock	42.88	42.892	42.285	42.285	25064230.0
2015-03-20 17:00:00	MSFT	Stock	42.838	42.88	42.8	42.88	41987.0
2015-03-20 18:00:00	MSFT	Stock	42.88	42.88	42.88	42.88	112922.0
2015-03-20 19:00:00	MSFT	Stock	42.88	42.88	42.8	42.8	4072.0
2015-03-20 06:00:00	NVDA	Stock	0.584	0.584	0.5798	0.5798	16000.0
2015-03-20 07:00:00	NVDA	Stock	0.5798	0.5798	0.5798	0.5798	12000.0
2015-03-20 08:00:00	NVDA	Stock	0.581	0.5822	0.5768	0.5822	111880.0
2015-03-20 09:00:00	NVDA	Stock	0.5822	0.5872	0.5798	0.5838	54221640.0
2015-03-20 10:00:00	NVDA	Stock	0.5835	0.5863	0.581	0.5863	31468680.0
2015-03-20 11:00:00	NVDA	Stock	0.5863	0.5868	0.584	0.5853	26241680.0
2015-03-20 12:00:00	NVDA	Stock	0.585	0.5855	0.5821	0.584	59881400.0
2015-03-20 13:00:00	NVDA	Stock	0.584	0.5855	0.5839	0.585	45154920.0
2015-03-20 14:00:00	NVDA	Stock	0.5852	0.588	0.5845	0.588	49986800.0
2015-03-20 15:00:00	NVDA	Stock	0.588	0.5901	0.587	0.5872	127589360.0
2015-03-20 16:00:00	NVDA	Stock	0.5868	0.587	0.5804	0.5804	11097520.0
2015-03-20 17:00:00	NVDA	Stock	0.5868	0.5868	0.5868	0.5868	77200.0
2015-03-20 19:00:00	NVDA	Stock	0.5868	0.5868	0.5868	0.5868	8720.0
2015-03-20 08:00:00	AMZN	Stock	18.75	18.8195	18.75	18.8195	39800.0
2015-03-20 09:00:00	AMZN	Stock	18.785	18.9205	18.7555	18.901	18263900.0
2015-03-20 10:00:00	AMZN	Stock	18.8985	18.9335	18.8615	18.894	7547780.0
2015-03-20 11:00:00	AMZN	Stock	18.892	18.9375	18.8826	18.9	5947780.0
2015-03-20 12:00:00	AMZN	Stock	18.898	18.9455	18.8875	18.9455	3383600.0
2015-03-20 13:00:00	AMZN	Stock	18.9405	18.9685	18.8958	18.929	4246880.0
2015-03-20 14:00:00	AMZN	Stock	18.9275	18.947	18.9	18.947	2485940.0

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

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