PREVIEW / stock_1hour / 2015-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-23.parquet
  size:    1.0 MB
  rows:    48,914
  symbols: 3,513

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-06-23 04:00:00	AAPL	Stock	31.96	31.965	31.91	31.9475	3600.0
2015-06-23 05:00:00	AAPL	Stock	31.955	31.955	31.955	31.955	400.0
2015-06-23 06:00:00	AAPL	Stock	31.955	31.955	31.91	31.91	7236.0
2015-06-23 07:00:00	AAPL	Stock	31.915	31.925	31.865	31.915	47344.0
2015-06-23 08:00:00	AAPL	Stock	31.9225	31.925	31.87	31.875	371172.0
2015-06-23 09:00:00	AAPL	Stock	31.875	31.8925	31.7198	31.841	20914760.0
2015-06-23 10:00:00	AAPL	Stock	31.8425	31.9025	31.735	31.8225	23317508.0
2015-06-23 11:00:00	AAPL	Stock	31.8225	31.84	31.7725	31.8	14387708.0
2015-06-23 12:00:00	AAPL	Stock	31.8	31.8025	31.7525	31.765	9315676.0
2015-06-23 13:00:00	AAPL	Stock	31.765	31.835	31.755	31.81	7795024.0
2015-06-23 14:00:00	AAPL	Stock	31.8075	31.85	31.8	31.8375	7902056.0
2015-06-23 15:00:00	AAPL	Stock	31.8362	31.8375	31.7525	31.755	15301904.0
2015-06-23 16:00:00	AAPL	Stock	31.7575	31.7905	31.7375	31.7575	12586056.0
2015-06-23 17:00:00	AAPL	Stock	31.7575	31.77	31.7375	31.745	175648.0
2015-06-23 18:00:00	AAPL	Stock	31.745	31.7525	31.7375	31.7425	187456.0
2015-06-23 19:00:00	AAPL	Stock	31.7575	31.7575	31.7325	31.7375	37576.0
2015-06-23 07:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-06-23 08:00:00	MSFT	Stock	46.26	46.35	46.25	46.25	2250.0
2015-06-23 09:00:00	MSFT	Stock	46.25	46.28	45.95	46.028	2477338.0
2015-06-23 10:00:00	MSFT	Stock	46.02	46.06	45.69	45.75	3541854.0
2015-06-23 11:00:00	MSFT	Stock	45.75	46.1	45.68	45.725	4037875.0
2015-06-23 12:00:00	MSFT	Stock	45.72	45.785	45.62	45.73	2477916.0
2015-06-23 13:00:00	MSFT	Stock	45.735	45.87	45.7	45.835	1494001.0
2015-06-23 14:00:00	MSFT	Stock	45.84	45.9	45.77	45.876	2090759.0
2015-06-23 15:00:00	MSFT	Stock	45.875	45.95	45.83	45.9	4080161.0
2015-06-23 16:00:00	MSFT	Stock	45.91	45.98	45.85	45.9	3561671.0
2015-06-23 17:00:00	MSFT	Stock	45.83	45.91	45.82	45.82	2730.0
2015-06-23 18:00:00	MSFT	Stock	45.92	45.92	45.92	45.92	5293.0
2015-06-23 08:00:00	NVDA	Stock	0.543	0.543	0.543	0.543	4000.0
2015-06-23 09:00:00	NVDA	Stock	0.5455	0.5498	0.536	0.536	46788360.0
2015-06-23 10:00:00	NVDA	Stock	0.536	0.5372	0.5301	0.5315	67859160.0
2015-06-23 11:00:00	NVDA	Stock	0.5315	0.5327	0.5278	0.531	54210600.0
2015-06-23 12:00:00	NVDA	Stock	0.531	0.531	0.528	0.5286	31909560.0
2015-06-23 13:00:00	NVDA	Stock	0.5287	0.5287	0.5262	0.5275	45189480.0
2015-06-23 14:00:00	NVDA	Stock	0.5274	0.5305	0.5272	0.5304	35723760.0
2015-06-23 15:00:00	NVDA	Stock	0.5302	0.5329	0.5293	0.5304	102640120.0
2015-06-23 16:00:00	NVDA	Stock	0.5305	0.5306	0.5305	0.5305	1951320.0
2015-06-23 17:00:00	NVDA	Stock	0.5305	0.5305	0.5305	0.5305	28400.0
2015-06-23 18:00:00	NVDA	Stock	0.5305	0.5305	0.5305	0.5305	8000.0
2015-06-23 19:00:00	NVDA	Stock	0.5302	0.5302	0.53	0.53	34800.0
2015-06-23 08:00:00	AMZN	Stock	21.854	21.8575	21.85	21.85	50280.0
2015-06-23 09:00:00	AMZN	Stock	21.8175	21.8865	21.6845	21.7009	5318440.0
2015-06-23 10:00:00	AMZN	Stock	21.703	21.917	21.686	21.8	5103680.0
2015-06-23 11:00:00	AMZN	Stock	21.8005	22.2315	21.7995	22.1986	13488960.0
2015-06-23 12:00:00	AMZN	Stock	22.202	22.214	22.1	22.1895	5263380.0
2015-06-23 13:00:00	AMZN	Stock	22.1891	22.352	22.154	22.2815	7819080.0
2015-06-23 14:00:00	AMZN	Stock	22.281	22.3475	22.2625	22.3245	6575400.0
2015-06-23 15:00:00	AMZN	Stock	22.32	22.334	22.259	22.305	10769140.0
2015-06-23 16:00:00	AMZN	Stock	22.2995	22.334	22.2995	22.3125	3003080.0
2015-06-23 17:00:00	AMZN	Stock	22.3345	22.3375	22.2995	22.325	40300.0

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

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