PREVIEW / stock_1hour / 2014-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-31.parquet
  size:    1.1 MB
  rows:    49,770
  symbols: 3,534

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
2014-01-31 04:00:00	AAPL	Stock	17.7821	17.7857	17.7821	17.7857	50568.0
2014-01-31 05:00:00	AAPL	Stock	17.7786	17.7786	17.6875	17.6875	55860.0
2014-01-31 06:00:00	AAPL	Stock	17.7529	17.7679	17.6875	17.6989	207060.0
2014-01-31 07:00:00	AAPL	Stock	17.7268	17.7714	17.7039	17.7143	469252.0
2014-01-31 08:00:00	AAPL	Stock	17.75	17.75	17.6875	17.7214	2166360.0
2014-01-31 09:00:00	AAPL	Stock	17.7271	17.7982	17.6786	17.6904	55984992.0
2014-01-31 10:00:00	AAPL	Stock	17.6925	17.7579	17.6268	17.6729	58777460.0
2014-01-31 11:00:00	AAPL	Stock	17.6718	17.775	17.6689	17.7734	31201240.0
2014-01-31 12:00:00	AAPL	Stock	17.7732	17.88	17.7732	17.7996	43485904.0
2014-01-31 13:00:00	AAPL	Stock	17.7957	17.9068	17.7914	17.8929	31121888.0
2014-01-31 14:00:00	AAPL	Stock	17.8939	17.9118	17.8454	17.8482	31674272.0
2014-01-31 15:00:00	AAPL	Stock	17.8482	17.8807	17.8246	17.8782	57134252.0
2014-01-31 16:00:00	AAPL	Stock	17.8786	17.8821	17.7017	17.8821	21482776.0
2014-01-31 17:00:00	AAPL	Stock	17.8764	17.8868	17.8725	17.8839	206332.0
2014-01-31 18:00:00	AAPL	Stock	17.8875	17.8889	17.8786	17.8786	147700.0
2014-01-31 19:00:00	AAPL	Stock	17.8871	17.9011	17.875	17.8929	220500.0
2014-01-31 04:00:00	MSFT	Stock	36.9	37.1	36.81	37.1	9300.0
2014-01-31 05:00:00	MSFT	Stock	36.93	37.05	36.93	37.0	7400.0
2014-01-31 06:00:00	MSFT	Stock	37.0	37.29	37.0	37.18	23454.0
2014-01-31 07:00:00	MSFT	Stock	36.86	37.33	36.86	37.2	58051.0
2014-01-31 08:00:00	MSFT	Stock	37.2	37.27	37.0	37.25	291890.0
2014-01-31 09:00:00	MSFT	Stock	37.23	37.54	36.64	37.05	12278761.0
2014-01-31 10:00:00	MSFT	Stock	37.05	37.07	36.56	36.895	10565994.0
2014-01-31 11:00:00	MSFT	Stock	36.89	37.16	36.88	37.16	6649358.0
2014-01-31 12:00:00	MSFT	Stock	37.155	37.81	37.15	37.78	9801332.0
2014-01-31 13:00:00	MSFT	Stock	37.78	37.79	37.49	37.725	9259069.0
2014-01-31 14:00:00	MSFT	Stock	37.73	37.81	37.67	37.75	11602543.0
2014-01-31 15:00:00	MSFT	Stock	37.745	37.89	37.7	37.84	17350938.0
2014-01-31 16:00:00	MSFT	Stock	37.85	37.89	36.819	37.82	11099775.0
2014-01-31 17:00:00	MSFT	Stock	37.839	37.861	37.754	37.8	45715.0
2014-01-31 18:00:00	MSFT	Stock	37.79	37.8	37.76	37.78	10900.0
2014-01-31 19:00:00	MSFT	Stock	37.78	37.8	37.78	37.8	3550.0
2014-01-31 09:00:00	NVDA	Stock	0.3875	0.391	0.3873	0.3891	18843520.0
2014-01-31 10:00:00	NVDA	Stock	0.3888	0.3933	0.3888	0.3928	30106000.0
2014-01-31 11:00:00	NVDA	Stock	0.3925	0.3945	0.3922	0.3942	19158160.0
2014-01-31 12:00:00	NVDA	Stock	0.3942	0.3948	0.3925	0.3925	28189480.0
2014-01-31 13:00:00	NVDA	Stock	0.3925	0.393	0.3918	0.3929	24815480.0
2014-01-31 14:00:00	NVDA	Stock	0.393	0.3933	0.3918	0.3922	28387720.0
2014-01-31 15:00:00	NVDA	Stock	0.3921	0.393	0.3906	0.3924	124135400.0
2014-01-31 16:00:00	NVDA	Stock	0.3925	0.3926	0.3921	0.3924	54357480.0
2014-01-31 17:00:00	NVDA	Stock	0.3922	0.3928	0.3922	0.3928	51440.0
2014-01-31 04:00:00	AMZN	Stock	19.272	19.345	19.1175	19.1175	179560.0
2014-01-31 05:00:00	AMZN	Stock	19.1	19.225	19.1	19.225	90180.0
2014-01-31 06:00:00	AMZN	Stock	19.125	19.225	19.085	19.085	78200.0
2014-01-31 07:00:00	AMZN	Stock	19.056	19.0745	18.6125	18.6875	1917800.0
2014-01-31 08:00:00	AMZN	Stock	18.7215	18.8125	18.3	18.476	4482460.0
2014-01-31 09:00:00	AMZN	Stock	18.476	18.905	18.25	18.599	64555060.0
2014-01-31 10:00:00	AMZN	Stock	18.611	18.763	18.252	18.2665	62693620.0
2014-01-31 11:00:00	AMZN	Stock	18.2628	18.445	18.2065	18.223	38106060.0
2014-01-31 12:00:00	AMZN	Stock	18.227	18.325	18.0605	18.2438	30321180.0

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

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