PREVIEW / stock_1hour / 2016-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-26.parquet
  size:    1.0 MB
  rows:    49,032
  symbols: 3,361

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
2016-01-26 04:00:00	AAPL	Stock	24.7625	24.7625	24.625	24.7125	10180.0
2016-01-26 05:00:00	AAPL	Stock	24.7425	24.845	24.7425	24.83	22004.0
2016-01-26 06:00:00	AAPL	Stock	24.8125	25.0	24.7925	24.975	139720.0
2016-01-26 07:00:00	AAPL	Stock	24.975	25.0625	24.9625	24.9775	198912.0
2016-01-26 08:00:00	AAPL	Stock	24.9775	25.025	24.8875	24.9925	833864.0
2016-01-26 09:00:00	AAPL	Stock	25.0	25.0575	24.5175	24.6225	30439508.0
2016-01-26 10:00:00	AAPL	Stock	24.618	25.0325	24.58	24.9325	37784448.0
2016-01-26 11:00:00	AAPL	Stock	24.9325	25.1975	24.9275	25.085	28366872.0
2016-01-26 12:00:00	AAPL	Stock	25.0875	25.195	25.0525	25.0975	18250624.0
2016-01-26 13:00:00	AAPL	Stock	25.0962	25.125	24.9775	25.03	18820016.0
2016-01-26 14:00:00	AAPL	Stock	25.03	25.22	24.995	25.09	29748056.0
2016-01-26 15:00:00	AAPL	Stock	25.09	25.1015	24.76	24.995	59039540.0
2016-01-26 16:00:00	AAPL	Stock	24.9988	25.875	24.2225	24.9025	34387684.0
2016-01-26 17:00:00	AAPL	Stock	24.9025	24.9875	24.32	24.4125	12489712.0
2016-01-26 18:00:00	AAPL	Stock	24.4	24.6	24.29	24.345	3902504.0
2016-01-26 19:00:00	AAPL	Stock	24.33	24.375	24.2775	24.355	1747244.0
2016-01-26 04:00:00	MSFT	Stock	51.3	51.3	51.3	51.3	900.0
2016-01-26 06:00:00	MSFT	Stock	51.75	51.77	51.74	51.77	1400.0
2016-01-26 07:00:00	MSFT	Stock	51.9	51.9	51.89	51.9	2200.0
2016-01-26 08:00:00	MSFT	Stock	51.85	52.0	51.75	51.79	37197.0
2016-01-26 09:00:00	MSFT	Stock	51.9	52.28	51.55	51.71	4143901.0
2016-01-26 10:00:00	MSFT	Stock	51.72	52.277	51.61	52.14	4444776.0
2016-01-26 11:00:00	MSFT	Stock	52.13	52.42	52.09	52.14	3061025.0
2016-01-26 12:00:00	MSFT	Stock	52.13	52.44	52.11	52.22	2430819.0
2016-01-26 13:00:00	MSFT	Stock	52.22	52.43	52.11	52.31	2330734.0
2016-01-26 14:00:00	MSFT	Stock	52.315	52.33	52.06	52.13	2645435.0
2016-01-26 15:00:00	MSFT	Stock	52.13	52.31	51.98	52.18	5515391.0
2016-01-26 16:00:00	MSFT	Stock	52.17	52.2	52.05	52.05	2492389.0
2016-01-26 17:00:00	MSFT	Stock	52.01	52.17	51.88	51.93	120338.0
2016-01-26 18:00:00	MSFT	Stock	51.93	52.0	51.85	52.0	1522.0
2016-01-26 19:00:00	MSFT	Stock	51.89	51.92	51.83	51.92	1275.0
2016-01-26 09:00:00	NVDA	Stock	0.7123	0.7153	0.7046	0.7058	24021200.0
2016-01-26 10:00:00	NVDA	Stock	0.706	0.7129	0.706	0.7118	26851960.0
2016-01-26 11:00:00	NVDA	Stock	0.7118	0.7178	0.7115	0.717	19459560.0
2016-01-26 12:00:00	NVDA	Stock	0.7168	0.7205	0.7165	0.719	20338400.0
2016-01-26 13:00:00	NVDA	Stock	0.7193	0.7203	0.7173	0.718	14633920.0
2016-01-26 14:00:00	NVDA	Stock	0.718	0.7186	0.715	0.7155	18093600.0
2016-01-26 15:00:00	NVDA	Stock	0.7155	0.7178	0.7128	0.7175	66053000.0
2016-01-26 16:00:00	NVDA	Stock	0.7175	0.7175	0.7168	0.7175	29343080.0
2016-01-26 04:00:00	AMZN	Stock	29.806	29.806	29.6515	29.6515	44040.0
2016-01-26 05:00:00	AMZN	Stock	29.671	29.75	29.671	29.75	13980.0
2016-01-26 06:00:00	AMZN	Stock	29.7505	30.0	29.7505	29.9995	31700.0
2016-01-26 07:00:00	AMZN	Stock	30.0275	30.1075	29.95	30.0445	158300.0
2016-01-26 08:00:00	AMZN	Stock	29.928	30.1945	29.926	30.138	411680.0
2016-01-26 09:00:00	AMZN	Stock	30.13	30.225	29.535	29.5605	14781040.0
2016-01-26 10:00:00	AMZN	Stock	29.53	29.87	29.5275	29.6587	14472700.0
2016-01-26 11:00:00	AMZN	Stock	29.662	29.7735	29.519	29.709	8065160.0
2016-01-26 12:00:00	AMZN	Stock	29.7214	29.953	29.7214	29.8082	6392140.0
2016-01-26 13:00:00	AMZN	Stock	29.825	30.18	29.808	30.0025	9678220.0
2016-01-26 14:00:00	AMZN	Stock	30.0065	30.0145	29.758	29.891	6219380.0

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

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