PREVIEW / stock_1hour / 2017-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-22.parquet
  size:    1.0 MB
  rows:    47,382
  symbols: 2,985

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-08-22 04:00:00	AAPL	Stock	39.45	39.4525	39.45	39.4525	1320.0
2017-08-22 06:00:00	AAPL	Stock	39.4	39.445	39.4	39.4375	10392.0
2017-08-22 07:00:00	AAPL	Stock	39.425	39.45	39.415	39.4425	52616.0
2017-08-22 08:00:00	AAPL	Stock	39.4475	39.5375	39.425	39.485	254580.0
2017-08-22 09:00:00	AAPL	Stock	39.4775	39.81	39.45	39.7285	12928748.0
2017-08-22 10:00:00	AAPL	Stock	39.7288	39.9125	39.7228	39.8708	12197376.0
2017-08-22 11:00:00	AAPL	Stock	39.872	39.9675	39.8525	39.9512	9049824.0
2017-08-22 12:00:00	AAPL	Stock	39.9505	40.0	39.8825	39.93	8325260.0
2017-08-22 13:00:00	AAPL	Stock	39.93	39.9825	39.8725	39.895	5458200.0
2017-08-22 14:00:00	AAPL	Stock	39.8925	40.0	39.8775	39.955	6630312.0
2017-08-22 15:00:00	AAPL	Stock	39.9525	39.99	39.915	39.945	11918000.0
2017-08-22 16:00:00	AAPL	Stock	39.945	39.975	39.945	39.97	9842016.0
2017-08-22 17:00:00	AAPL	Stock	39.9625	39.98	39.95	39.955	114840.0
2017-08-22 18:00:00	AAPL	Stock	39.955	39.975	39.945	39.9675	21232.0
2017-08-22 19:00:00	AAPL	Stock	39.9725	39.98	39.9625	39.965	33832.0
2017-08-22 07:00:00	MSFT	Stock	72.48	72.48	72.46	72.46	300.0
2017-08-22 08:00:00	MSFT	Stock	72.27	72.57	72.27	72.56	6675.0
2017-08-22 09:00:00	MSFT	Stock	72.56	72.94	72.35	72.835	1560760.0
2017-08-22 10:00:00	MSFT	Stock	72.84	73.11	72.83	72.99	1723957.0
2017-08-22 11:00:00	MSFT	Stock	73.0	73.03	72.92	72.995	1487732.0
2017-08-22 12:00:00	MSFT	Stock	72.995	73.11	72.86	72.96	1230997.0
2017-08-22 13:00:00	MSFT	Stock	72.96	73.02	72.91	73.0	810752.0
2017-08-22 14:00:00	MSFT	Stock	73.0	73.2	72.975	73.105	1627469.0
2017-08-22 15:00:00	MSFT	Stock	73.1	73.24	73.08	73.15	2823051.0
2017-08-22 16:00:00	MSFT	Stock	73.15	73.24	73.1	73.16	1923467.0
2017-08-22 17:00:00	MSFT	Stock	73.12	73.15	73.12	73.15	1551.0
2017-08-22 19:00:00	MSFT	Stock	73.12	73.12	73.12	73.12	576.0
2017-08-22 04:00:00	NVDA	Stock	4.0013	4.0013	4.0013	4.0013	4000.0
2017-08-22 05:00:00	NVDA	Stock	3.9998	3.9998	3.9983	3.9983	49360.0
2017-08-22 07:00:00	NVDA	Stock	3.9925	4.005	3.9925	4.0042	336760.0
2017-08-22 08:00:00	NVDA	Stock	4.005	4.0158	3.9925	4.01	1933560.0
2017-08-22 09:00:00	NVDA	Stock	4.0108	4.0422	3.9928	4.0052	90775280.0
2017-08-22 10:00:00	NVDA	Stock	4.005	4.037	4.0042	4.0315	84382600.0
2017-08-22 11:00:00	NVDA	Stock	4.032	4.0608	4.0238	4.0484	67383960.0
2017-08-22 12:00:00	NVDA	Stock	4.049	4.0593	4.04	4.0482	33115080.0
2017-08-22 13:00:00	NVDA	Stock	4.0481	4.0522	4.0385	4.0415	26909960.0
2017-08-22 14:00:00	NVDA	Stock	4.0413	4.069	4.039	4.0572	45574760.0
2017-08-22 15:00:00	NVDA	Stock	4.0568	4.0698	4.0545	4.0625	70031880.0
2017-08-22 16:00:00	NVDA	Stock	4.0638	4.068	4.0568	4.064	1947400.0
2017-08-22 17:00:00	NVDA	Stock	4.0612	4.0638	4.0602	4.0605	246160.0
2017-08-22 18:00:00	NVDA	Stock	4.0602	4.0662	4.06	4.0662	193360.0
2017-08-22 19:00:00	NVDA	Stock	4.066	4.0715	4.066	4.0715	647400.0
2017-08-22 07:00:00	AMZN	Stock	47.8475	47.865	47.819	47.847	22940.0
2017-08-22 08:00:00	AMZN	Stock	47.95	47.95	47.835	47.937	92220.0
2017-08-22 09:00:00	AMZN	Stock	47.9365	48.1695	47.776	48.0995	8607780.0
2017-08-22 10:00:00	AMZN	Stock	48.1025	48.287	48.1	48.2245	7643400.0
2017-08-22 11:00:00	AMZN	Stock	48.2335	48.3285	48.175	48.3185	4921620.0
2017-08-22 12:00:00	AMZN	Stock	48.3225	48.3965	48.2755	48.315	4699260.0
2017-08-22 13:00:00	AMZN	Stock	48.318	48.3445	48.2025	48.2325	4633800.0
2017-08-22 14:00:00	AMZN	Stock	48.229	48.3605	48.2064	48.287	3622780.0

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

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