PREVIEW / stock_1hour / 2015-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-20.parquet
  size:    1.1 MB
  rows:    49,391
  symbols: 3,544

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-01-20 04:00:00	AAPL	Stock	26.755	26.755	26.67	26.67	22964.0
2015-01-20 05:00:00	AAPL	Stock	26.7	26.75	26.6975	26.75	29228.0
2015-01-20 06:00:00	AAPL	Stock	26.75	26.805	26.725	26.795	64800.0
2015-01-20 07:00:00	AAPL	Stock	26.8125	26.875	26.7875	26.8675	280968.0
2015-01-20 08:00:00	AAPL	Stock	26.8675	26.8875	26.7875	26.815	1062400.0
2015-01-20 09:00:00	AAPL	Stock	26.8025	27.0	26.6625	26.8438	34931172.0
2015-01-20 10:00:00	AAPL	Stock	26.8362	26.9	26.655	26.6725	26357716.0
2015-01-20 11:00:00	AAPL	Stock	26.6725	26.845	26.625	26.7662	18566396.0
2015-01-20 12:00:00	AAPL	Stock	26.765	26.8968	26.7325	26.8825	11707576.0
2015-01-20 13:00:00	AAPL	Stock	26.8825	26.935	26.805	26.92	13263976.0
2015-01-20 14:00:00	AAPL	Stock	26.92	27.125	26.9075	27.1225	22780880.0
2015-01-20 15:00:00	AAPL	Stock	27.1225	27.195	27.0725	27.1775	28720840.0
2015-01-20 16:00:00	AAPL	Stock	27.18	27.2775	26.762	27.26	19982648.0
2015-01-20 17:00:00	AAPL	Stock	27.2625	27.3	27.18	27.3	2328408.0
2015-01-20 18:00:00	AAPL	Stock	27.3	27.31	27.2875	27.305	142008.0
2015-01-20 19:00:00	AAPL	Stock	27.3	27.3	27.18	27.295	311508.0
2015-01-20 04:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-01-20 05:00:00	MSFT	Stock	46.3	46.31	46.3	46.31	1100.0
2015-01-20 07:00:00	MSFT	Stock	46.43	46.47	46.39	46.42	3963.0
2015-01-20 08:00:00	MSFT	Stock	46.45	46.47	46.3	46.3	17932.0
2015-01-20 09:00:00	MSFT	Stock	46.3	46.42	45.81	45.95	3609172.0
2015-01-20 10:00:00	MSFT	Stock	45.945	46.065	45.57	45.755	3876734.0
2015-01-20 11:00:00	MSFT	Stock	45.75	45.885	45.64	45.75	3417798.0
2015-01-20 12:00:00	MSFT	Stock	45.75	46.045	45.71	46.01	1913582.0
2015-01-20 13:00:00	MSFT	Stock	46.0	46.249	45.88	46.19	2717367.0
2015-01-20 14:00:00	MSFT	Stock	46.19	46.58	46.14	46.57	3728058.0
2015-01-20 15:00:00	MSFT	Stock	46.573	46.65	46.37	46.39	5172667.0
2015-01-20 16:00:00	MSFT	Stock	46.39	46.499	46.061	46.061	6115337.0
2015-01-20 17:00:00	MSFT	Stock	46.36	46.39	46.36	46.36	13062.0
2015-01-20 19:00:00	MSFT	Stock	46.4	46.4	46.38	46.38	27089.0
2015-01-20 08:00:00	NVDA	Stock	0.5	0.5003	0.5	0.5003	27600.0
2015-01-20 09:00:00	NVDA	Stock	0.5035	0.5053	0.4985	0.5015	19069400.0
2015-01-20 10:00:00	NVDA	Stock	0.5013	0.5022	0.4974	0.498	16769640.0
2015-01-20 11:00:00	NVDA	Stock	0.4978	0.4995	0.4942	0.4955	17179920.0
2015-01-20 12:00:00	NVDA	Stock	0.4955	0.4972	0.4945	0.4968	12784800.0
2015-01-20 13:00:00	NVDA	Stock	0.4965	0.4978	0.4948	0.4963	10239880.0
2015-01-20 14:00:00	NVDA	Stock	0.4963	0.5004	0.4963	0.5	8310800.0
2015-01-20 15:00:00	NVDA	Stock	0.5003	0.5013	0.4995	0.5005	35275640.0
2015-01-20 16:00:00	NVDA	Stock	0.5005	0.5005	0.4983	0.4983	1291920.0
2015-01-20 17:00:00	NVDA	Stock	0.5005	0.5005	0.4978	0.4978	25880.0
2015-01-20 04:00:00	AMZN	Stock	14.563	14.563	14.5625	14.5625	4000.0
2015-01-20 05:00:00	AMZN	Stock	14.5875	14.5875	14.5875	14.5875	2000.0
2015-01-20 07:00:00	AMZN	Stock	14.605	14.691	14.605	14.6615	9000.0
2015-01-20 08:00:00	AMZN	Stock	14.682	14.682	14.6275	14.6325	45600.0
2015-01-20 09:00:00	AMZN	Stock	14.632	14.668	14.456	14.478	10019340.0
2015-01-20 10:00:00	AMZN	Stock	14.4782	14.516	14.407	14.433	9905580.0
2015-01-20 11:00:00	AMZN	Stock	14.4285	14.4319	14.3195	14.3605	9579800.0
2015-01-20 12:00:00	AMZN	Stock	14.3565	14.453	14.351	14.4355	5042100.0
2015-01-20 13:00:00	AMZN	Stock	14.4325	14.474	14.3885	14.44	3320580.0
2015-01-20 14:00:00	AMZN	Stock	14.4425	14.5185	14.4175	14.5185	6036540.0

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

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