PREVIEW / stock_1hour / 2017-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-12.parquet
  size:    1.1 MB
  rows:    48,652
  symbols: 2,954

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-10-12 05:00:00	AAPL	Stock	39.1	39.1	39.1	39.1	1040.0
2017-10-12 07:00:00	AAPL	Stock	39.0625	39.1	39.05	39.075	24380.0
2017-10-12 08:00:00	AAPL	Stock	39.1	39.225	39.0425	39.05	117820.0
2017-10-12 09:00:00	AAPL	Stock	39.0425	39.3425	39.0425	39.22	11377096.0
2017-10-12 10:00:00	AAPL	Stock	39.2212	39.275	39.1225	39.205	10728896.0
2017-10-12 11:00:00	AAPL	Stock	39.2025	39.2375	39.1875	39.2225	4942196.0
2017-10-12 12:00:00	AAPL	Stock	39.225	39.2862	39.19	39.1925	5169112.0
2017-10-12 13:00:00	AAPL	Stock	39.19	39.245	39.1775	39.195	3291600.0
2017-10-12 14:00:00	AAPL	Stock	39.195	39.1975	39.063	39.0712	5766976.0
2017-10-12 15:00:00	AAPL	Stock	39.0725	39.105	38.9325	39.0025	13277584.0
2017-10-12 16:00:00	AAPL	Stock	39.0	39.1375	38.95	38.965	4938800.0
2017-10-12 17:00:00	AAPL	Stock	38.9625	38.99	38.9525	38.9675	9000.0
2017-10-12 18:00:00	AAPL	Stock	38.965	38.9725	38.95	38.95	19520.0
2017-10-12 19:00:00	AAPL	Stock	38.975	38.9875	38.95	38.95	15636.0
2017-10-12 08:00:00	MSFT	Stock	76.21	76.21	76.21	76.21	100.0
2017-10-12 09:00:00	MSFT	Stock	76.22	76.89	76.22	76.82	1610803.0
2017-10-12 10:00:00	MSFT	Stock	76.82	77.115	76.76	77.1	2392806.0
2017-10-12 11:00:00	MSFT	Stock	77.1	77.29	76.985	77.189	1948901.0
2017-10-12 12:00:00	MSFT	Stock	77.185	77.26	77.04	77.137	1268158.0
2017-10-12 13:00:00	MSFT	Stock	77.14	77.19	77.06	77.12	1186716.0
2017-10-12 14:00:00	MSFT	Stock	77.11	77.14	76.96	77.06	1343708.0
2017-10-12 15:00:00	MSFT	Stock	77.06	77.18	76.95	77.13	3565665.0
2017-10-12 16:00:00	MSFT	Stock	77.12	77.22	76.42	76.42	2691036.0
2017-10-12 17:00:00	MSFT	Stock	77.07	77.19	77.04	77.17	1081.0
2017-10-12 18:00:00	MSFT	Stock	77.04	77.18	77.01	77.18	1894.0
2017-10-12 19:00:00	MSFT	Stock	77.18	77.18	77.18	77.18	142.0
2017-10-12 04:00:00	NVDA	Stock	4.7895	4.8	4.7895	4.8	25400.0
2017-10-12 05:00:00	NVDA	Stock	4.7965	4.7965	4.796	4.796	31280.0
2017-10-12 06:00:00	NVDA	Stock	4.7938	4.7972	4.789	4.789	26520.0
2017-10-12 07:00:00	NVDA	Stock	4.7875	4.7875	4.764	4.78	726120.0
2017-10-12 08:00:00	NVDA	Stock	4.78	4.8048	4.7648	4.775	1847760.0
2017-10-12 09:00:00	NVDA	Stock	4.775	4.7962	4.7483	4.778	97077760.0
2017-10-12 10:00:00	NVDA	Stock	4.778	4.7888	4.7492	4.771	87459120.0
2017-10-12 11:00:00	NVDA	Stock	4.77	4.8	4.7635	4.796	73999400.0
2017-10-12 12:00:00	NVDA	Stock	4.7958	4.8	4.785	4.7888	38252760.0
2017-10-12 13:00:00	NVDA	Stock	4.7897	4.8123	4.787	4.8098	45129560.0
2017-10-12 14:00:00	NVDA	Stock	4.8091	4.8272	4.783	4.7962	91115280.0
2017-10-12 15:00:00	NVDA	Stock	4.7955	4.8053	4.7705	4.7758	71109440.0
2017-10-12 16:00:00	NVDA	Stock	4.775	4.7785	4.76	4.7625	2728880.0
2017-10-12 17:00:00	NVDA	Stock	4.7625	4.7625	4.7525	4.7545	1458560.0
2017-10-12 18:00:00	NVDA	Stock	4.755	4.7602	4.75	4.7602	1175400.0
2017-10-12 19:00:00	NVDA	Stock	4.7625	4.7662	4.7575	4.758	402000.0
2017-10-12 04:00:00	AMZN	Stock	49.865	49.865	49.85	49.85	6000.0
2017-10-12 05:00:00	AMZN	Stock	49.766	49.766	49.765	49.765	8000.0
2017-10-12 06:00:00	AMZN	Stock	49.9	49.965	49.8355	49.8355	37740.0
2017-10-12 07:00:00	AMZN	Stock	49.834	49.834	49.7395	49.7565	28820.0
2017-10-12 08:00:00	AMZN	Stock	49.7495	49.8425	49.735	49.735	37320.0
2017-10-12 09:00:00	AMZN	Stock	49.725	49.9955	49.62	49.8445	12624240.0
2017-10-12 10:00:00	AMZN	Stock	49.842	50.1665	49.75	49.9985	14899580.0
2017-10-12 11:00:00	AMZN	Stock	49.9955	50.3645	49.925	50.3545	11024900.0

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

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