PREVIEW / stock_1hour / 2015-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-24.parquet
  size:    1.0 MB
  rows:    48,554
  symbols: 3,422

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-11-24 04:00:00	AAPL	Stock	29.325	29.325	29.185	29.2825	22384.0
2015-11-24 05:00:00	AAPL	Stock	29.3025	29.3225	29.2875	29.2875	1816.0
2015-11-24 06:00:00	AAPL	Stock	29.275	29.3025	29.275	29.28	5920.0
2015-11-24 07:00:00	AAPL	Stock	29.32	29.345	29.2475	29.27	125500.0
2015-11-24 08:00:00	AAPL	Stock	29.2625	29.345	29.24	29.2925	629540.0
2015-11-24 09:00:00	AAPL	Stock	29.28	29.79	29.2525	29.75	26429284.0
2015-11-24 10:00:00	AAPL	Stock	29.7475	29.8075	29.36	29.48	31844884.0
2015-11-24 11:00:00	AAPL	Stock	29.48	29.8375	29.4575	29.7575	22659516.0
2015-11-24 12:00:00	AAPL	Stock	29.76	29.79	29.6425	29.675	10998172.0
2015-11-24 13:00:00	AAPL	Stock	29.675	29.74	29.6575	29.6925	9597436.0
2015-11-24 14:00:00	AAPL	Stock	29.6925	29.7775	29.5902	29.7545	13802772.0
2015-11-24 15:00:00	AAPL	Stock	29.7525	29.7875	29.6425	29.7275	18480696.0
2015-11-24 16:00:00	AAPL	Stock	29.72	29.72	29.679	29.685	25868608.0
2015-11-24 17:00:00	AAPL	Stock	29.6875	29.6975	29.68	29.685	37520.0
2015-11-24 18:00:00	AAPL	Stock	29.685	29.7125	29.675	29.7125	46044.0
2015-11-24 19:00:00	AAPL	Stock	29.7125	29.7125	29.6625	29.6625	67288.0
2015-11-24 05:00:00	MSFT	Stock	54.0	54.0	53.99	53.99	737.0
2015-11-24 06:00:00	MSFT	Stock	53.89	53.89	53.89	53.89	200.0
2015-11-24 07:00:00	MSFT	Stock	53.77	53.82	53.74	53.82	12000.0
2015-11-24 08:00:00	MSFT	Stock	53.72	53.82	53.69	53.82	16966.0
2015-11-24 09:00:00	MSFT	Stock	53.8	54.16	53.8	54.07	2662240.0
2015-11-24 10:00:00	MSFT	Stock	54.07	54.07	53.58	53.82	3704836.0
2015-11-24 11:00:00	MSFT	Stock	53.82	54.25	53.67	54.085	3240638.0
2015-11-24 12:00:00	MSFT	Stock	54.09	54.24	53.99	54.036	1979633.0
2015-11-24 13:00:00	MSFT	Stock	54.04	54.25	54.025	54.18	2430272.0
2015-11-24 14:00:00	MSFT	Stock	54.185	54.44	54.1	54.29	2876993.0
2015-11-24 15:00:00	MSFT	Stock	54.29	54.43	54.15	54.26	4366843.0
2015-11-24 16:00:00	MSFT	Stock	54.25	54.26	54.18	54.26	1841973.0
2015-11-24 17:00:00	MSFT	Stock	54.19	54.25	54.19	54.25	3900.0
2015-11-24 18:00:00	MSFT	Stock	54.34	54.34	54.23	54.25	1000.0
2015-11-24 19:00:00	MSFT	Stock	54.19	54.19	54.19	54.19	600.0
2015-11-24 07:00:00	NVDA	Stock	0.7713	0.7713	0.7713	0.7713	4000.0
2015-11-24 08:00:00	NVDA	Stock	0.7688	0.773	0.7638	0.7638	28000.0
2015-11-24 09:00:00	NVDA	Stock	0.773	0.7768	0.7713	0.7756	18296760.0
2015-11-24 10:00:00	NVDA	Stock	0.7756	0.7793	0.7695	0.774	38110120.0
2015-11-24 11:00:00	NVDA	Stock	0.7739	0.785	0.7732	0.7839	26530680.0
2015-11-24 12:00:00	NVDA	Stock	0.784	0.7856	0.7815	0.7832	15906360.0
2015-11-24 13:00:00	NVDA	Stock	0.7832	0.786	0.7825	0.7848	11937920.0
2015-11-24 14:00:00	NVDA	Stock	0.7845	0.7855	0.7808	0.7815	20337960.0
2015-11-24 15:00:00	NVDA	Stock	0.7816	0.782	0.7769	0.779	43079800.0
2015-11-24 16:00:00	NVDA	Stock	0.7793	0.7793	0.7715	0.7793	9851800.0
2015-11-24 18:00:00	NVDA	Stock	0.7763	0.7763	0.7763	0.7763	5000.0
2015-11-24 07:00:00	AMZN	Stock	33.7685	33.779	33.5	33.5925	76660.0
2015-11-24 08:00:00	AMZN	Stock	33.625	33.7	33.45	33.625	536060.0
2015-11-24 09:00:00	AMZN	Stock	33.649	33.715	33.5255	33.605	13094940.0
2015-11-24 10:00:00	AMZN	Stock	33.6158	33.65	33.0606	33.2624	21323700.0
2015-11-24 11:00:00	AMZN	Stock	33.257	33.6735	33.189	33.63	13969340.0
2015-11-24 12:00:00	AMZN	Stock	33.6255	33.7485	33.425	33.5525	7219940.0
2015-11-24 13:00:00	AMZN	Stock	33.563	33.72	33.55	33.654	7030420.0
2015-11-24 14:00:00	AMZN	Stock	33.6456	33.79	33.5435	33.6465	7490380.0

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

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