PREVIEW / stock_1hour / 2017-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-07.parquet
  size:    1.0 MB
  rows:    47,697
  symbols: 3,030

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-04-07 04:00:00	AAPL	Stock	35.8775	35.8775	35.825	35.87	5668.0
2017-04-07 05:00:00	AAPL	Stock	35.87	35.87	35.87	35.87	400.0
2017-04-07 06:00:00	AAPL	Stock	35.8525	35.875	35.8525	35.875	5800.0
2017-04-07 07:00:00	AAPL	Stock	35.875	35.95	35.87	35.9	23940.0
2017-04-07 08:00:00	AAPL	Stock	35.8875	35.935	35.805	35.8525	166456.0
2017-04-07 09:00:00	AAPL	Stock	35.8525	36.045	35.8475	35.8575	11067248.0
2017-04-07 10:00:00	AAPL	Stock	35.8625	36.025	35.8175	35.9622	9311268.0
2017-04-07 11:00:00	AAPL	Stock	35.96	35.9675	35.89	35.9025	6636872.0
2017-04-07 12:00:00	AAPL	Stock	35.905	36.005	35.9022	35.995	4426280.0
2017-04-07 13:00:00	AAPL	Stock	35.9972	36.005	35.93	35.9725	5417980.0
2017-04-07 14:00:00	AAPL	Stock	35.9725	35.9925	35.91	35.9175	6444740.0
2017-04-07 15:00:00	AAPL	Stock	35.9175	35.9362	35.8275	35.835	11415296.0
2017-04-07 16:00:00	AAPL	Stock	35.835	35.9195	35.835	35.84	5155948.0
2017-04-07 17:00:00	AAPL	Stock	35.8525	35.8525	35.8375	35.8375	38976.0
2017-04-07 18:00:00	AAPL	Stock	35.8275	35.8375	35.8275	35.8375	5548.0
2017-04-07 19:00:00	AAPL	Stock	35.8375	35.8575	35.8375	35.8575	12932.0
2017-04-07 08:00:00	MSFT	Stock	65.6	65.6	65.5	65.52	3475.0
2017-04-07 09:00:00	MSFT	Stock	65.55	65.89	65.47	65.5	1630598.0
2017-04-07 10:00:00	MSFT	Stock	65.49	65.85	65.44	65.69	1535629.0
2017-04-07 11:00:00	MSFT	Stock	65.7	65.84	65.64	65.79	1630276.0
2017-04-07 12:00:00	MSFT	Stock	65.8	65.93	65.78	65.8	1242621.0
2017-04-07 13:00:00	MSFT	Stock	65.8	65.96	65.74	65.925	1257163.0
2017-04-07 14:00:00	MSFT	Stock	65.92	65.96	65.825	65.84	1269449.0
2017-04-07 15:00:00	MSFT	Stock	65.845	65.877	65.67	65.69	2434679.0
2017-04-07 16:00:00	MSFT	Stock	65.68	65.77	65.61	65.68	1879257.0
2017-04-07 17:00:00	MSFT	Stock	65.75	65.75	65.71	65.71	613.0
2017-04-07 18:00:00	MSFT	Stock	65.74	65.75	65.74	65.75	7525.0
2017-04-07 19:00:00	MSFT	Stock	65.7	65.7	65.7	65.7	150.0
2017-04-07 04:00:00	NVDA	Stock	2.5025	2.5025	2.5025	2.5025	8000.0
2017-04-07 07:00:00	NVDA	Stock	2.529	2.55	2.5275	2.55	42400.0
2017-04-07 08:00:00	NVDA	Stock	2.5375	2.5375	2.5065	2.525	1303520.0
2017-04-07 09:00:00	NVDA	Stock	2.52	2.5433	2.5003	2.5005	69802800.0
2017-04-07 10:00:00	NVDA	Stock	2.5005	2.5175	2.493	2.5068	101786800.0
2017-04-07 11:00:00	NVDA	Stock	2.5068	2.5125	2.4965	2.504	44597600.0
2017-04-07 12:00:00	NVDA	Stock	2.5038	2.5241	2.5032	2.5225	32013040.0
2017-04-07 13:00:00	NVDA	Stock	2.5221	2.5222	2.5045	2.5053	31671560.0
2017-04-07 14:00:00	NVDA	Stock	2.5053	2.5095	2.5028	2.504	27080160.0
2017-04-07 15:00:00	NVDA	Stock	2.5045	2.5113	2.5018	2.5085	52316400.0
2017-04-07 16:00:00	NVDA	Stock	2.5083	2.51	2.5065	2.507	35541200.0
2017-04-07 17:00:00	NVDA	Stock	2.507	2.5083	2.4938	2.5003	3455280.0
2017-04-07 18:00:00	NVDA	Stock	2.501	2.501	2.494	2.5	332280.0
2017-04-07 19:00:00	NVDA	Stock	2.5025	2.5025	2.4998	2.4998	76000.0
2017-04-07 05:00:00	AMZN	Stock	44.8885	44.8885	44.8885	44.8885	2000.0
2017-04-07 06:00:00	AMZN	Stock	44.95	44.95	44.95	44.95	2000.0
2017-04-07 07:00:00	AMZN	Stock	45.077	45.0825	44.9995	45.0	61460.0
2017-04-07 08:00:00	AMZN	Stock	45.0	45.1	44.809	44.94	289400.0
2017-04-07 09:00:00	AMZN	Stock	44.975	45.053	44.4655	44.509	14568040.0
2017-04-07 10:00:00	AMZN	Stock	44.5118	44.831	44.5	44.6733	13067140.0
2017-04-07 11:00:00	AMZN	Stock	44.6798	44.7185	44.5905	44.642	5531220.0
2017-04-07 12:00:00	AMZN	Stock	44.6465	44.9495	44.6315	44.9385	10606860.0

> showing 50 of 47,697 rows — these rows as CSV

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