PREVIEW / stock_1hour / 2016-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-18.parquet
  size:    1.0 MB
  rows:    47,925
  symbols: 3,338

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-02-18 04:00:00	AAPL	Stock	24.5	24.5875	24.475	24.575	26280.0
2016-02-18 05:00:00	AAPL	Stock	24.585	24.675	24.585	24.65	37628.0
2016-02-18 06:00:00	AAPL	Stock	24.65	24.775	24.625	24.75	48616.0
2016-02-18 07:00:00	AAPL	Stock	24.75	24.75	24.645	24.6625	107808.0
2016-02-18 08:00:00	AAPL	Stock	24.6675	24.775	24.605	24.6625	294332.0
2016-02-18 09:00:00	AAPL	Stock	24.6675	24.7225	24.4	24.4025	18330292.0
2016-02-18 10:00:00	AAPL	Stock	24.405	24.4175	24.2375	24.255	25055240.0
2016-02-18 11:00:00	AAPL	Stock	24.255	24.2875	24.2	24.275	14985572.0
2016-02-18 12:00:00	AAPL	Stock	24.274	24.2875	24.115	24.19	14762436.0
2016-02-18 13:00:00	AAPL	Stock	24.192	24.25	24.1025	24.17	12282956.0
2016-02-18 14:00:00	AAPL	Stock	24.1725	24.25	24.1475	24.205	10505360.0
2016-02-18 15:00:00	AAPL	Stock	24.2075	24.21	24.0227	24.065	26491444.0
2016-02-18 16:00:00	AAPL	Stock	24.065	24.09	24.0275	24.0675	8352152.0
2016-02-18 17:00:00	AAPL	Stock	24.0725	24.105	24.05	24.0925	199252.0
2016-02-18 18:00:00	AAPL	Stock	24.0975	24.0975	24.0625	24.075	91280.0
2016-02-18 19:00:00	AAPL	Stock	24.0825	24.0975	24.055	24.055	92360.0
2016-02-18 06:00:00	MSFT	Stock	52.68	52.68	52.68	52.68	1000.0
2016-02-18 07:00:00	MSFT	Stock	52.6	52.71	52.56	52.6	29825.0
2016-02-18 08:00:00	MSFT	Stock	52.74	52.74	52.58	52.62	2068.0
2016-02-18 09:00:00	MSFT	Stock	52.62	52.83	52.26	52.695	3605314.0
2016-02-18 10:00:00	MSFT	Stock	52.69	52.95	52.47	52.58	3160043.0
2016-02-18 11:00:00	MSFT	Stock	52.58	52.62	52.35	52.61	2538214.0
2016-02-18 12:00:00	MSFT	Stock	52.61	52.659	52.4	52.465	2574777.0
2016-02-18 13:00:00	MSFT	Stock	52.465	52.6	52.16	52.2	2707552.0
2016-02-18 14:00:00	MSFT	Stock	52.2	52.56	52.2	52.445	3218737.0
2016-02-18 15:00:00	MSFT	Stock	52.445	52.475	52.1	52.19	4665274.0
2016-02-18 16:00:00	MSFT	Stock	52.19	52.24	52.15	52.17	1865515.0
2016-02-18 17:00:00	MSFT	Stock	52.19	52.2	52.18	52.2	301117.0
2016-02-18 18:00:00	MSFT	Stock	52.2	52.21	52.2	52.21	1643.0
2016-02-18 19:00:00	MSFT	Stock	52.24	52.24	52.2	52.2	2360.0
2016-02-18 06:00:00	NVDA	Stock	0.745	0.75	0.7435	0.75	93080.0
2016-02-18 07:00:00	NVDA	Stock	0.7495	0.7548	0.7405	0.7435	1598680.0
2016-02-18 08:00:00	NVDA	Stock	0.7433	0.7508	0.7415	0.746	5617960.0
2016-02-18 09:00:00	NVDA	Stock	0.7475	0.7744	0.745	0.7625	309692360.0
2016-02-18 10:00:00	NVDA	Stock	0.7625	0.764	0.7475	0.7575	190459040.0
2016-02-18 11:00:00	NVDA	Stock	0.7578	0.7593	0.752	0.7585	65131800.0
2016-02-18 12:00:00	NVDA	Stock	0.7585	0.76	0.7553	0.7589	42985720.0
2016-02-18 13:00:00	NVDA	Stock	0.7588	0.7592	0.7525	0.7555	54715160.0
2016-02-18 14:00:00	NVDA	Stock	0.7555	0.7585	0.7548	0.7576	78744600.0
2016-02-18 15:00:00	NVDA	Stock	0.7576	0.7578	0.7503	0.751	163282360.0
2016-02-18 16:00:00	NVDA	Stock	0.751	0.7535	0.75	0.7532	6556520.0
2016-02-18 17:00:00	NVDA	Stock	0.7528	0.7528	0.7528	0.7528	4000.0
2016-02-18 18:00:00	NVDA	Stock	0.752	0.752	0.7515	0.7515	26640.0
2016-02-18 04:00:00	AMZN	Stock	26.665	27.073	26.665	27.073	79160.0
2016-02-18 05:00:00	AMZN	Stock	27.1245	27.1245	27.0985	27.1	20920.0
2016-02-18 06:00:00	AMZN	Stock	27.1065	27.125	27.1	27.105	26480.0
2016-02-18 07:00:00	AMZN	Stock	27.072	27.0895	26.9715	26.985	132740.0
2016-02-18 08:00:00	AMZN	Stock	26.9635	27.1	26.9635	27.074	310300.0
2016-02-18 09:00:00	AMZN	Stock	27.061	27.061	26.775	26.8075	14435060.0
2016-02-18 10:00:00	AMZN	Stock	26.808	26.8925	26.625	26.6835	11896220.0

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

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