PREVIEW / stock_1hour / 2017-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-09.parquet
  size:    1.0 MB
  rows:    48,523
  symbols: 3,127

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
2017-01-09 04:00:00	AAPL	Stock	29.5	29.5	29.43	29.43	5676.0
2017-01-09 05:00:00	AAPL	Stock	29.45	29.4725	29.4375	29.4475	12464.0
2017-01-09 06:00:00	AAPL	Stock	29.415	29.4275	29.3775	29.405	18828.0
2017-01-09 07:00:00	AAPL	Stock	29.4375	29.5425	29.4375	29.525	96996.0
2017-01-09 08:00:00	AAPL	Stock	29.52	29.5675	29.5025	29.5275	356420.0
2017-01-09 09:00:00	AAPL	Stock	29.5275	29.825	29.4725	29.7625	32444348.0
2017-01-09 10:00:00	AAPL	Stock	29.7625	29.8225	29.6935	29.7888	19159256.0
2017-01-09 11:00:00	AAPL	Stock	29.7875	29.8575	29.7295	29.745	13790916.0
2017-01-09 12:00:00	AAPL	Stock	29.7425	29.8	29.71	29.795	10154784.0
2017-01-09 13:00:00	AAPL	Stock	29.795	29.805	29.75	29.7635	6704724.0
2017-01-09 14:00:00	AAPL	Stock	29.7625	29.7725	29.68	29.7685	10120924.0
2017-01-09 15:00:00	AAPL	Stock	29.7675	29.845	29.7425	29.75	17303696.0
2017-01-09 16:00:00	AAPL	Stock	29.75	29.7575	29.725	29.75	14384896.0
2017-01-09 17:00:00	AAPL	Stock	29.75	29.7525	29.7	29.7525	47408.0
2017-01-09 18:00:00	AAPL	Stock	29.7425	29.7625	29.7175	29.755	42848.0
2017-01-09 19:00:00	AAPL	Stock	29.755	29.755	29.7275	29.7275	14828.0
2017-01-09 04:00:00	MSFT	Stock	63.13	63.13	63.13	63.13	575.0
2017-01-09 06:00:00	MSFT	Stock	63.02	63.02	63.02	63.02	100.0
2017-01-09 07:00:00	MSFT	Stock	62.97	62.97	62.97	62.97	463.0
2017-01-09 08:00:00	MSFT	Stock	62.99	62.99	62.9	62.94	1663.0
2017-01-09 09:00:00	MSFT	Stock	62.95	63.08	62.57	63.03	3115015.0
2017-01-09 10:00:00	MSFT	Stock	63.025	63.06	62.77	62.85	2299220.0
2017-01-09 11:00:00	MSFT	Stock	62.84	62.93	62.79	62.84	1122637.0
2017-01-09 12:00:00	MSFT	Stock	62.845	62.9	62.75	62.88	1662460.0
2017-01-09 13:00:00	MSFT	Stock	62.88	62.885	62.64	62.69	1554117.0
2017-01-09 14:00:00	MSFT	Stock	62.69	62.7	62.54	62.65	1728745.0
2017-01-09 15:00:00	MSFT	Stock	62.65	62.75	62.61	62.65	2439892.0
2017-01-09 16:00:00	MSFT	Stock	62.64	62.75	62.56	62.64	5473329.0
2017-01-09 17:00:00	MSFT	Stock	62.74	62.74	62.74	62.74	100.0
2017-01-09 19:00:00	MSFT	Stock	62.65	62.66	62.64	62.66	3250.0
2017-01-09 04:00:00	NVDA	Stock	2.605	2.605	2.6043	2.6043	12000.0
2017-01-09 05:00:00	NVDA	Stock	2.595	2.595	2.595	2.595	4000.0
2017-01-09 06:00:00	NVDA	Stock	2.595	2.6013	2.595	2.6013	40760.0
2017-01-09 07:00:00	NVDA	Stock	2.5975	2.6075	2.5975	2.6025	158080.0
2017-01-09 08:00:00	NVDA	Stock	2.602	2.6075	2.5875	2.5875	1298240.0
2017-01-09 09:00:00	NVDA	Stock	2.5853	2.6985	2.5813	2.6827	211671360.0
2017-01-09 10:00:00	NVDA	Stock	2.6828	2.7	2.67	2.6785	163278040.0
2017-01-09 11:00:00	NVDA	Stock	2.678	2.6825	2.6575	2.6602	108331960.0
2017-01-09 12:00:00	NVDA	Stock	2.6614	2.67	2.6495	2.6628	98526400.0
2017-01-09 13:00:00	NVDA	Stock	2.6628	2.6875	2.6618	2.678	98876000.0
2017-01-09 14:00:00	NVDA	Stock	2.6778	2.6778	2.6615	2.6658	58239920.0
2017-01-09 15:00:00	NVDA	Stock	2.6655	2.6928	2.6654	2.6823	122391480.0
2017-01-09 16:00:00	NVDA	Stock	2.6825	2.6848	2.6729	2.6838	5642640.0
2017-01-09 17:00:00	NVDA	Stock	2.6848	2.6958	2.684	2.6852	647200.0
2017-01-09 18:00:00	NVDA	Stock	2.6892	2.6905	2.684	2.6875	314960.0
2017-01-09 19:00:00	NVDA	Stock	2.6875	2.6938	2.6868	2.6938	413560.0
2017-01-09 04:00:00	AMZN	Stock	39.875	39.875	39.875	39.875	2040.0
2017-01-09 05:00:00	AMZN	Stock	39.8775	39.8775	39.8775	39.8775	4000.0
2017-01-09 06:00:00	AMZN	Stock	39.875	39.8885	39.87	39.8885	34000.0
2017-01-09 07:00:00	AMZN	Stock	39.8695	39.875	39.826	39.85	49560.0

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

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