PREVIEW / stock_1hour / 2015-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-18.parquet
  size:    1.1 MB
  rows:    49,727
  symbols: 3,443

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
2015-12-18 04:00:00	AAPL	Stock	27.5	27.5	27.09	27.1625	36296.0
2015-12-18 05:00:00	AAPL	Stock	27.15	27.1775	27.145	27.1775	6544.0
2015-12-18 06:00:00	AAPL	Stock	27.1875	27.22	27.12	27.12	22080.0
2015-12-18 07:00:00	AAPL	Stock	27.1625	27.1625	27.09	27.1475	253260.0
2015-12-18 08:00:00	AAPL	Stock	27.1425	27.17	26.75	27.17	440220.0
2015-12-18 09:00:00	AAPL	Stock	27.17	27.38	27.115	27.3175	53682688.0
2015-12-18 10:00:00	AAPL	Stock	27.3175	27.3225	26.915	27.017	33812456.0
2015-12-18 11:00:00	AAPL	Stock	27.0175	27.07	26.785	26.835	24066384.0
2015-12-18 12:00:00	AAPL	Stock	26.8365	26.885	26.6	26.6022	33242024.0
2015-12-18 13:00:00	AAPL	Stock	26.6	26.86	26.6	26.8075	26318296.0
2015-12-18 14:00:00	AAPL	Stock	26.8075	26.875	26.6375	26.6425	22785428.0
2015-12-18 15:00:00	AAPL	Stock	26.6425	26.6875	26.4525	26.4725	53877244.0
2015-12-18 16:00:00	AAPL	Stock	26.5075	26.6765	26.46	26.58	96970060.0
2015-12-18 17:00:00	AAPL	Stock	26.505	26.6075	26.505	26.585	293276.0
2015-12-18 18:00:00	AAPL	Stock	26.5775	26.6	26.5775	26.5875	83392.0
2015-12-18 19:00:00	AAPL	Stock	26.595	26.605	26.5825	26.5825	63504.0
2015-12-18 04:00:00	MSFT	Stock	55.5	55.75	55.5	55.6	5300.0
2015-12-18 05:00:00	MSFT	Stock	55.57	55.57	55.57	55.57	900.0
2015-12-18 06:00:00	MSFT	Stock	55.57	55.66	55.56	55.63	8800.0
2015-12-18 07:00:00	MSFT	Stock	55.63	55.65	55.5	55.56	7400.0
2015-12-18 08:00:00	MSFT	Stock	55.62	55.87	55.56	55.85	23404.0
2015-12-18 09:00:00	MSFT	Stock	55.85	56.15	55.21	55.27	14338377.0
2015-12-18 10:00:00	MSFT	Stock	55.28	55.32	54.85	55.095	10105003.0
2015-12-18 11:00:00	MSFT	Stock	55.1	55.22	54.99	55.07	4038744.0
2015-12-18 12:00:00	MSFT	Stock	55.07	55.1	54.73	54.81	4444913.0
2015-12-18 13:00:00	MSFT	Stock	54.8	55.055	54.75	54.97	3451771.0
2015-12-18 14:00:00	MSFT	Stock	54.97	55.23	54.92	54.95	4423503.0
2015-12-18 15:00:00	MSFT	Stock	54.96	55.03	54.03	54.18	13297512.0
2015-12-18 16:00:00	MSFT	Stock	54.13	55.05	54.07	54.32	21417062.0
2015-12-18 17:00:00	MSFT	Stock	54.33	54.33	54.26	54.32	9863.0
2015-12-18 18:00:00	MSFT	Stock	54.26	54.26	54.15	54.25	10795.0
2015-12-18 19:00:00	MSFT	Stock	54.25	54.25	54.22	54.25	1782.0
2015-12-18 08:00:00	NVDA	Stock	0.8158	0.8158	0.8158	0.8158	4000.0
2015-12-18 09:00:00	NVDA	Stock	0.8118	0.8193	0.8075	0.8102	46618320.0
2015-12-18 10:00:00	NVDA	Stock	0.8105	0.812	0.8033	0.8088	31338120.0
2015-12-18 11:00:00	NVDA	Stock	0.8088	0.8125	0.806	0.806	25583640.0
2015-12-18 12:00:00	NVDA	Stock	0.806	0.8079	0.8025	0.8045	18344760.0
2015-12-18 13:00:00	NVDA	Stock	0.8046	0.8118	0.8044	0.811	27310560.0
2015-12-18 14:00:00	NVDA	Stock	0.811	0.8129	0.8094	0.8101	36092560.0
2015-12-18 15:00:00	NVDA	Stock	0.8102	0.8113	0.8038	0.804	97023000.0
2015-12-18 16:00:00	NVDA	Stock	0.8035	0.8037	0.803	0.8035	18060360.0
2015-12-18 07:00:00	AMZN	Stock	33.3	33.325	33.2	33.2755	150800.0
2015-12-18 08:00:00	AMZN	Stock	33.3	33.584	33.3	33.559	537800.0
2015-12-18 09:00:00	AMZN	Stock	33.573	33.842	33.4	33.7157	25544180.0
2015-12-18 10:00:00	AMZN	Stock	33.726	33.733	33.2625	33.475	23066900.0
2015-12-18 11:00:00	AMZN	Stock	33.4745	33.6162	33.358	33.3818	7257420.0
2015-12-18 12:00:00	AMZN	Stock	33.3715	33.4195	33.2585	33.268	8613680.0
2015-12-18 13:00:00	AMZN	Stock	33.2837	33.437	33.2685	33.4	6066340.0
2015-12-18 14:00:00	AMZN	Stock	33.4145	33.49	33.347	33.3515	7679300.0
2015-12-18 15:00:00	AMZN	Stock	33.3725	33.445	33.2065	33.2065	18392620.0

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

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