PREVIEW / stock_1hour / 2018-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-27.parquet
  size:    1.1 MB
  rows:    48,980
  symbols: 2,889

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
2018-02-27 04:00:00	AAPL	Stock	44.755	44.755	44.615	44.7375	54768.0
2018-02-27 05:00:00	AAPL	Stock	44.745	44.7625	44.6875	44.735	58260.0
2018-02-27 06:00:00	AAPL	Stock	44.7325	44.7325	44.575	44.575	37564.0
2018-02-27 07:00:00	AAPL	Stock	44.575	44.675	44.575	44.6375	234456.0
2018-02-27 08:00:00	AAPL	Stock	44.595	44.77	44.595	44.7275	587004.0
2018-02-27 09:00:00	AAPL	Stock	44.7275	44.975	44.7075	44.8525	21067256.0
2018-02-27 10:00:00	AAPL	Stock	44.8475	45.12	44.695	44.765	31481444.0
2018-02-27 11:00:00	AAPL	Stock	44.765	44.89	44.675	44.7	16330532.0
2018-02-27 12:00:00	AAPL	Stock	44.6925	44.8575	44.54	44.84	14316156.0
2018-02-27 13:00:00	AAPL	Stock	44.8375	44.9775	44.7775	44.8675	13775136.0
2018-02-27 14:00:00	AAPL	Stock	44.8688	44.945	44.745	44.8787	13277988.0
2018-02-27 15:00:00	AAPL	Stock	44.8775	44.9125	44.585	44.585	20995836.0
2018-02-27 16:00:00	AAPL	Stock	44.5975	44.741	44.575	44.6	9264328.0
2018-02-27 17:00:00	AAPL	Stock	44.6	44.6125	44.5925	44.61	47208.0
2018-02-27 18:00:00	AAPL	Stock	44.6075	44.685	44.6075	44.675	67568.0
2018-02-27 19:00:00	AAPL	Stock	44.675	44.7	44.64	44.6875	47120.0
2018-02-27 07:00:00	MSFT	Stock	95.04	95.36	95.04	95.36	1843.0
2018-02-27 08:00:00	MSFT	Stock	95.295	95.58	95.105	95.5	13989.0
2018-02-27 09:00:00	MSFT	Stock	95.5	95.84	95.25	95.38	3457196.0
2018-02-27 10:00:00	MSFT	Stock	95.39	95.83	94.955	95.1	3423979.0
2018-02-27 11:00:00	MSFT	Stock	95.105	95.56	94.85	94.86	2673203.0
2018-02-27 12:00:00	MSFT	Stock	94.85	95.33	94.56	95.3	2053761.0
2018-02-27 13:00:00	MSFT	Stock	95.29	95.345	94.96	95.04	1554236.0
2018-02-27 14:00:00	MSFT	Stock	95.04	95.28	94.75	95.02	2581962.0
2018-02-27 15:00:00	MSFT	Stock	95.0	95.04	94.21	94.21	5162377.0
2018-02-27 16:00:00	MSFT	Stock	94.2	94.65	94.2	94.5	2521983.0
2018-02-27 17:00:00	MSFT	Stock	94.5	94.52	94.2	94.49	20357.0
2018-02-27 18:00:00	MSFT	Stock	94.49	94.55	94.42	94.55	4025.0
2018-02-27 19:00:00	MSFT	Stock	94.64	94.64	94.58	94.64	2300.0
2018-02-27 04:00:00	NVDA	Stock	6.1575	6.1575	6.1415	6.1435	55360.0
2018-02-27 07:00:00	NVDA	Stock	6.1462	6.15	6.1363	6.15	419840.0
2018-02-27 08:00:00	NVDA	Stock	6.14	6.1775	6.1375	6.1588	1754360.0
2018-02-27 09:00:00	NVDA	Stock	6.155	6.2068	6.1272	6.1542	78060160.0
2018-02-27 10:00:00	NVDA	Stock	6.1523	6.2228	6.146	6.1893	82897960.0
2018-02-27 11:00:00	NVDA	Stock	6.1878	6.2068	6.157	6.1594	53318360.0
2018-02-27 12:00:00	NVDA	Stock	6.159	6.1923	6.1283	6.1889	51025520.0
2018-02-27 13:00:00	NVDA	Stock	6.1882	6.2053	6.179	6.189	36324440.0
2018-02-27 14:00:00	NVDA	Stock	6.1892	6.1928	6.158	6.1717	36500240.0
2018-02-27 15:00:00	NVDA	Stock	6.1722	6.1765	6.1373	6.1515	65305080.0
2018-02-27 16:00:00	NVDA	Stock	6.1515	6.1535	6.14	6.1528	7268520.0
2018-02-27 17:00:00	NVDA	Stock	6.1515	6.1568	6.1515	6.1525	162600.0
2018-02-27 18:00:00	NVDA	Stock	6.154	6.1675	6.154	6.1648	473400.0
2018-02-27 19:00:00	NVDA	Stock	6.1625	6.1645	6.158	6.158	346480.0
2018-02-27 04:00:00	AMZN	Stock	76.45	76.45	76.25	76.275	12000.0
2018-02-27 05:00:00	AMZN	Stock	76.25	76.2845	76.225	76.2635	51480.0
2018-02-27 06:00:00	AMZN	Stock	76.3095	76.3095	75.988	75.9895	40320.0
2018-02-27 07:00:00	AMZN	Stock	76.0075	76.3085	75.9755	76.25	352900.0
2018-02-27 08:00:00	AMZN	Stock	76.0	76.2945	75.9795	76.24	396920.0
2018-02-27 09:00:00	AMZN	Stock	76.2565	76.3165	75.7525	75.8755	13245120.0
2018-02-27 10:00:00	AMZN	Stock	75.915	76.339	75.775	75.9625	12210420.0

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

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