PREVIEW / stock_1hour / 2015-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-02.parquet
  size:    1.0 MB
  rows:    48,486
  symbols: 3,489

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-02 04:00:00	AAPL	Stock	27.75	27.775	27.7375	27.775	11624.0
2015-01-02 05:00:00	AAPL	Stock	27.7975	27.8125	27.725	27.8125	12720.0
2015-01-02 06:00:00	AAPL	Stock	27.825	27.825	27.745	27.745	47292.0
2015-01-02 07:00:00	AAPL	Stock	27.7875	27.8	27.7725	27.7775	119816.0
2015-01-02 08:00:00	AAPL	Stock	27.7725	27.8412	27.595	27.835	542156.0
2015-01-02 09:00:00	AAPL	Stock	27.8375	27.875	27.1625	27.375	39869412.0
2015-01-02 10:00:00	AAPL	Stock	27.3725	27.4275	26.8375	27.0712	50515988.0
2015-01-02 11:00:00	AAPL	Stock	27.0725	27.1975	26.9625	27.194	25167104.0
2015-01-02 12:00:00	AAPL	Stock	27.1925	27.3975	27.1888	27.3388	20199696.0
2015-01-02 13:00:00	AAPL	Stock	27.3388	27.3675	27.1875	27.2475	14654424.0
2015-01-02 14:00:00	AAPL	Stock	27.2488	27.345	27.225	27.27	12287520.0
2015-01-02 15:00:00	AAPL	Stock	27.27	27.381	27.1725	27.325	25809720.0
2015-01-02 16:00:00	AAPL	Stock	27.3325	27.7998	27.1555	27.275	11112036.0
2015-01-02 17:00:00	AAPL	Stock	27.265	27.3325	27.26	27.275	140916.0
2015-01-02 18:00:00	AAPL	Stock	27.275	27.2875	27.2525	27.255	58808.0
2015-01-02 19:00:00	AAPL	Stock	27.2625	27.295	27.2525	27.2825	29424.0
2015-01-02 04:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	100.0
2015-01-02 07:00:00	MSFT	Stock	46.72	46.72	46.7	46.7	300.0
2015-01-02 08:00:00	MSFT	Stock	46.45	46.7	46.45	46.62	43521.0
2015-01-02 09:00:00	MSFT	Stock	46.65	47.42	46.63	47.272	4626926.0
2015-01-02 10:00:00	MSFT	Stock	47.28	47.3	46.92	46.955	4476440.0
2015-01-02 11:00:00	MSFT	Stock	46.96	46.97	46.58	46.715	2845723.0
2015-01-02 12:00:00	MSFT	Stock	46.72	46.84	46.62	46.63	1795833.0
2015-01-02 13:00:00	MSFT	Stock	46.62	46.71	46.54	46.65	2320977.0
2015-01-02 14:00:00	MSFT	Stock	46.65	46.8	46.545	46.716	2073532.0
2015-01-02 15:00:00	MSFT	Stock	46.72	46.9	46.585	46.75	5793005.0
2015-01-02 16:00:00	MSFT	Stock	46.76	46.856	46.55	46.71	2900257.0
2015-01-02 17:00:00	MSFT	Stock	46.73	46.9	46.73	46.75	121462.0
2015-01-02 18:00:00	MSFT	Stock	46.75	46.75	46.75	46.75	1330.0
2015-01-02 19:00:00	MSFT	Stock	46.75	46.75	46.74	46.75	5300.0
2015-01-02 09:00:00	NVDA	Stock	0.5032	0.507	0.5028	0.5053	12896200.0
2015-01-02 10:00:00	NVDA	Stock	0.5053	0.5053	0.498	0.4985	18978520.0
2015-01-02 11:00:00	NVDA	Stock	0.4982	0.5	0.4953	0.4998	18819800.0
2015-01-02 12:00:00	NVDA	Stock	0.4998	0.5015	0.4985	0.4985	7959920.0
2015-01-02 13:00:00	NVDA	Stock	0.4986	0.5008	0.4985	0.4998	7794120.0
2015-01-02 14:00:00	NVDA	Stock	0.4998	0.5035	0.4998	0.5025	6614960.0
2015-01-02 15:00:00	NVDA	Stock	0.5025	0.5043	0.5015	0.5031	26591560.0
2015-01-02 16:00:00	NVDA	Stock	0.5032	0.5032	0.5009	0.5009	10617600.0
2015-01-02 04:00:00	AMZN	Stock	15.6	15.6	15.6	15.6	2840.0
2015-01-02 05:00:00	AMZN	Stock	15.6	15.6	15.6	15.6	2000.0
2015-01-02 08:00:00	AMZN	Stock	15.5175	15.625	15.5175	15.625	33780.0
2015-01-02 09:00:00	AMZN	Stock	15.625	15.7375	15.6055	15.676	8748340.0
2015-01-02 10:00:00	AMZN	Stock	15.6625	15.6795	15.4315	15.448	10844280.0
2015-01-02 11:00:00	AMZN	Stock	15.442	15.506	15.348	15.4875	9177200.0
2015-01-02 12:00:00	AMZN	Stock	15.4885	15.4965	15.4025	15.42	4383340.0
2015-01-02 13:00:00	AMZN	Stock	15.4205	15.424	15.3625	15.4175	3471920.0
2015-01-02 14:00:00	AMZN	Stock	15.4105	15.433	15.386	15.401	4046420.0
2015-01-02 15:00:00	AMZN	Stock	15.4015	15.466	15.3748	15.426	8014840.0
2015-01-02 16:00:00	AMZN	Stock	15.426	15.4956	15.4	15.426	3065260.0
2015-01-02 17:00:00	AMZN	Stock	15.426	15.426	15.426	15.426	40680.0

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

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