PREVIEW / stock_1hour / 2016-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-27.parquet
  size:    1.1 MB
  rows:    49,526
  symbols: 3,283

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-06-27 04:00:00	AAPL	Stock	23.255	23.26	23.18	23.2375	32276.0
2016-06-27 05:00:00	AAPL	Stock	23.2775	23.28	23.195	23.195	28968.0
2016-06-27 06:00:00	AAPL	Stock	23.25	23.25	23.165	23.18	108948.0
2016-06-27 07:00:00	AAPL	Stock	23.1825	23.2175	23.1425	23.15	135924.0
2016-06-27 08:00:00	AAPL	Stock	23.1675	23.2875	23.1375	23.2675	464904.0
2016-06-27 09:00:00	AAPL	Stock	23.2675	23.2925	22.9525	23.025	29598036.0
2016-06-27 10:00:00	AAPL	Stock	23.025	23.1	22.925	22.935	29755840.0
2016-06-27 11:00:00	AAPL	Stock	22.9375	23.0225	22.9	22.9962	22622400.0
2016-06-27 12:00:00	AAPL	Stock	22.995	23.05	22.94	22.9775	14497584.0
2016-06-27 13:00:00	AAPL	Stock	22.9775	23.0325	22.9	22.945	14024208.0
2016-06-27 14:00:00	AAPL	Stock	22.9425	22.981	22.8775	22.8962	15526280.0
2016-06-27 15:00:00	AAPL	Stock	22.8975	23.07	22.875	23.01	26519480.0
2016-06-27 16:00:00	AAPL	Stock	23.01	23.035	22.9225	22.99	14915372.0
2016-06-27 17:00:00	AAPL	Stock	22.995	23.025	22.9775	22.9975	4002772.0
2016-06-27 18:00:00	AAPL	Stock	22.9875	23.0275	22.9875	23.0025	56804.0
2016-06-27 19:00:00	AAPL	Stock	23.01	23.025	22.9825	23.005	62104.0
2016-06-27 04:00:00	MSFT	Stock	49.6	49.6	49.56	49.56	200.0
2016-06-27 05:00:00	MSFT	Stock	49.52	49.52	49.52	49.52	200.0
2016-06-27 06:00:00	MSFT	Stock	49.49	49.49	49.35	49.35	734.0
2016-06-27 07:00:00	MSFT	Stock	49.46	49.46	49.19	49.22	12027.0
2016-06-27 08:00:00	MSFT	Stock	49.22	49.35	49.16	49.2	82442.0
2016-06-27 09:00:00	MSFT	Stock	49.23	49.38	48.845	49.02	6288680.0
2016-06-27 10:00:00	MSFT	Stock	49.02	49.147	48.51	48.57	6586033.0
2016-06-27 11:00:00	MSFT	Stock	48.57	48.78	48.43	48.61	5647642.0
2016-06-27 12:00:00	MSFT	Stock	48.61	48.68	48.42	48.58	3604501.0
2016-06-27 13:00:00	MSFT	Stock	48.587	48.65	48.21	48.26	5137386.0
2016-06-27 14:00:00	MSFT	Stock	48.26	48.35	48.09	48.15	6050314.0
2016-06-27 15:00:00	MSFT	Stock	48.15	48.485	48.035	48.43	10969441.0
2016-06-27 16:00:00	MSFT	Stock	48.43	48.45	48.3	48.43	3387341.0
2016-06-27 17:00:00	MSFT	Stock	48.3	48.43	48.3	48.3	239934.0
2016-06-27 18:00:00	MSFT	Stock	48.37	48.4	48.3	48.4	2050.0
2016-06-27 19:00:00	MSFT	Stock	48.43	48.47	48.38	48.46	10143.0
2016-06-27 04:00:00	NVDA	Stock	1.1375	1.1375	1.1375	1.1375	40000.0
2016-06-27 07:00:00	NVDA	Stock	1.1325	1.1325	1.1325	1.1325	12000.0
2016-06-27 08:00:00	NVDA	Stock	1.1312	1.1322	1.1265	1.1315	374120.0
2016-06-27 09:00:00	NVDA	Stock	1.1332	1.1425	1.1295	1.1365	61557880.0
2016-06-27 10:00:00	NVDA	Stock	1.1365	1.14	1.1142	1.1172	88810880.0
2016-06-27 11:00:00	NVDA	Stock	1.117	1.1283	1.1148	1.1242	48246680.0
2016-06-27 12:00:00	NVDA	Stock	1.1242	1.1295	1.121	1.1286	39243600.0
2016-06-27 13:00:00	NVDA	Stock	1.1288	1.1345	1.1265	1.1295	43418200.0
2016-06-27 14:00:00	NVDA	Stock	1.1294	1.1314	1.1239	1.1258	40981240.0
2016-06-27 15:00:00	NVDA	Stock	1.126	1.135	1.1228	1.131	99257960.0
2016-06-27 16:00:00	NVDA	Stock	1.131	1.131	1.125	1.125	13019640.0
2016-06-27 17:00:00	NVDA	Stock	1.1283	1.1283	1.125	1.125	88000.0
2016-06-27 18:00:00	NVDA	Stock	1.1285	1.131	1.1285	1.1285	192000.0
2016-06-27 19:00:00	NVDA	Stock	1.132	1.1338	1.132	1.1338	346000.0
2016-06-27 04:00:00	AMZN	Stock	34.839	34.839	34.834	34.834	12000.0
2016-06-27 06:00:00	AMZN	Stock	34.7995	34.82	34.7995	34.82	4000.0
2016-06-27 07:00:00	AMZN	Stock	34.65	34.725	34.4	34.4	422420.0
2016-06-27 08:00:00	AMZN	Stock	34.4435	34.7	34.4435	34.6	1006360.0

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

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