PREVIEW / stock_1hour / 2014-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-24.parquet
  size:    1.1 MB
  rows:    49,938
  symbols: 3,540

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
2014-01-24 04:00:00	AAPL	Stock	19.8632	19.8632	19.7514	19.8368	98000.0
2014-01-24 05:00:00	AAPL	Stock	19.8025	19.8036	19.7143	19.7271	129668.0
2014-01-24 06:00:00	AAPL	Stock	19.7143	19.7321	19.6964	19.7054	90720.0
2014-01-24 07:00:00	AAPL	Stock	19.7307	19.775	19.7143	19.75	640024.0
2014-01-24 08:00:00	AAPL	Stock	19.7582	19.7954	19.7143	19.7696	1708028.0
2014-01-24 09:00:00	AAPL	Stock	19.7629	19.8436	19.6643	19.6643	53288032.0
2014-01-24 10:00:00	AAPL	Stock	19.6718	19.7818	19.6629	19.7095	54782588.0
2014-01-24 11:00:00	AAPL	Stock	19.7071	19.7136	19.5871	19.6964	53149236.0
2014-01-24 12:00:00	AAPL	Stock	19.6964	19.7436	19.6614	19.6829	45260460.0
2014-01-24 13:00:00	AAPL	Stock	19.6815	19.6964	19.6071	19.6211	24851764.0
2014-01-24 14:00:00	AAPL	Stock	19.6175	19.6307	19.5475	19.5527	37518768.0
2014-01-24 15:00:00	AAPL	Stock	19.55	19.575	19.4554	19.5071	81328380.0
2014-01-24 16:00:00	AAPL	Stock	19.5068	19.6802	19.4893	19.4918	16364992.0
2014-01-24 17:00:00	AAPL	Stock	19.4875	19.5475	19.4729	19.5475	841652.0
2014-01-24 18:00:00	AAPL	Stock	19.5464	19.5464	19.5025	19.5179	429912.0
2014-01-24 19:00:00	AAPL	Stock	19.5179	19.5443	19.5179	19.5439	511504.0
2014-01-24 04:00:00	MSFT	Stock	37.3	37.35	37.29	37.31	1246.0
2014-01-24 05:00:00	MSFT	Stock	37.26	37.28	37.17	37.2	5478.0
2014-01-24 06:00:00	MSFT	Stock	37.17	37.19	36.8	36.91	65898.0
2014-01-24 07:00:00	MSFT	Stock	36.99	37.29	36.98	37.1	252095.0
2014-01-24 08:00:00	MSFT	Stock	37.15	37.38	36.85	37.35	772778.0
2014-01-24 09:00:00	MSFT	Stock	37.36	37.55	37.0	37.12	14345337.0
2014-01-24 10:00:00	MSFT	Stock	37.12	37.29	36.65	36.77	12150418.0
2014-01-24 11:00:00	MSFT	Stock	36.76	36.82	36.53	36.76	8953168.0
2014-01-24 12:00:00	MSFT	Stock	36.76	37.17	36.71	37.099	8559236.0
2014-01-24 13:00:00	MSFT	Stock	37.09	37.28	37.05	37.06	5391048.0
2014-01-24 14:00:00	MSFT	Stock	37.06	37.08	36.75	37.03	5864590.0
2014-01-24 15:00:00	MSFT	Stock	37.025	37.08	36.76	36.81	12295193.0
2014-01-24 16:00:00	MSFT	Stock	36.82	36.996	36.722	36.78	4793285.0
2014-01-24 17:00:00	MSFT	Stock	36.75	37.009	36.7	36.81	9959.0
2014-01-24 18:00:00	MSFT	Stock	36.84	36.84	36.78	36.8	6718.0
2014-01-24 19:00:00	MSFT	Stock	36.8	36.84	36.71	36.71	4039.0
2014-01-24 09:00:00	NVDA	Stock	0.3955	0.3975	0.3938	0.3951	27338000.0
2014-01-24 10:00:00	NVDA	Stock	0.395	0.3973	0.395	0.3968	33744080.0
2014-01-24 11:00:00	NVDA	Stock	0.3965	0.3968	0.3934	0.3953	21663920.0
2014-01-24 12:00:00	NVDA	Stock	0.3951	0.3955	0.3938	0.3948	16471600.0
2014-01-24 13:00:00	NVDA	Stock	0.3946	0.3948	0.3938	0.3939	15189880.0
2014-01-24 14:00:00	NVDA	Stock	0.3939	0.394	0.3918	0.3922	22760440.0
2014-01-24 15:00:00	NVDA	Stock	0.3922	0.3925	0.389	0.3893	55565400.0
2014-01-24 16:00:00	NVDA	Stock	0.389	0.3898	0.3889	0.389	41653160.0
2014-01-24 18:00:00	NVDA	Stock	0.3878	0.3878	0.3878	0.3878	12000.0
2014-01-24 06:00:00	AMZN	Stock	19.855	19.855	19.8	19.8	11520.0
2014-01-24 07:00:00	AMZN	Stock	19.839	19.839	19.8125	19.8125	39000.0
2014-01-24 08:00:00	AMZN	Stock	19.845	19.85	19.8165	19.825	84580.0
2014-01-24 09:00:00	AMZN	Stock	19.8365	20.01	19.772	19.9	14623280.0
2014-01-24 10:00:00	AMZN	Stock	19.892	19.9095	19.731	19.7752	11946480.0
2014-01-24 11:00:00	AMZN	Stock	19.786	19.8075	19.619	19.746	10862100.0
2014-01-24 12:00:00	AMZN	Stock	19.7525	19.7615	19.6355	19.6512	4565320.0
2014-01-24 13:00:00	AMZN	Stock	19.656	19.657	19.5285	19.5315	6711020.0
2014-01-24 14:00:00	AMZN	Stock	19.53	19.567	19.4475	19.524	8723000.0

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

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