PREVIEW / stock_1hour / 2015-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-12.parquet
  size:    1.0 MB
  rows:    48,291
  symbols: 3,403

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-12 04:00:00	AAPL	Stock	29.11	29.1175	29.04	29.1175	1248.0
2015-11-12 05:00:00	AAPL	Stock	29.0325	29.0975	29.0	29.0225	6000.0
2015-11-12 06:00:00	AAPL	Stock	29.025	29.025	29.025	29.025	800.0
2015-11-12 07:00:00	AAPL	Stock	28.97	29.0	28.96	29.0	9956.0
2015-11-12 08:00:00	AAPL	Stock	28.9725	29.019	28.9475	28.99	202920.0
2015-11-12 09:00:00	AAPL	Stock	28.9975	29.125	28.875	29.0825	22794740.0
2015-11-12 10:00:00	AAPL	Stock	29.08	29.205	28.97	29.09	23337148.0
2015-11-12 11:00:00	AAPL	Stock	29.09	29.125	28.9795	29.0225	11856220.0
2015-11-12 12:00:00	AAPL	Stock	29.0225	29.0275	28.915	28.9625	11271792.0
2015-11-12 13:00:00	AAPL	Stock	28.9625	29.025	28.9325	28.9825	9587376.0
2015-11-12 14:00:00	AAPL	Stock	28.9825	29.0575	28.9388	28.9525	13107820.0
2015-11-12 15:00:00	AAPL	Stock	28.9525	29.0462	28.9125	28.935	22537992.0
2015-11-12 16:00:00	AAPL	Stock	28.93	29.0398	28.9125	28.9275	4456460.0
2015-11-12 17:00:00	AAPL	Stock	28.9275	28.9325	28.9	28.905	69736.0
2015-11-12 18:00:00	AAPL	Stock	28.9075	28.92	28.895	28.9025	75324.0
2015-11-12 19:00:00	AAPL	Stock	28.915	28.93	28.8925	28.8975	46588.0
2015-11-12 04:00:00	MSFT	Stock	53.77	53.77	53.77	53.77	1000.0
2015-11-12 05:00:00	MSFT	Stock	53.65	53.65	53.65	53.65	167.0
2015-11-12 07:00:00	MSFT	Stock	53.69	53.69	53.67	53.67	700.0
2015-11-12 08:00:00	MSFT	Stock	53.53	53.6	53.4	53.4	10122.0
2015-11-12 09:00:00	MSFT	Stock	53.414	53.5	53.19	53.37	4584351.0
2015-11-12 10:00:00	MSFT	Stock	53.375	53.535	53.3	53.47	6673504.0
2015-11-12 11:00:00	MSFT	Stock	53.47	53.57	53.415	53.555	3487937.0
2015-11-12 12:00:00	MSFT	Stock	53.55	53.88	53.48	53.84	2690255.0
2015-11-12 13:00:00	MSFT	Stock	53.845	53.979	53.74	53.885	3074535.0
2015-11-12 14:00:00	MSFT	Stock	53.88	53.91	53.44	53.575	3506988.0
2015-11-12 15:00:00	MSFT	Stock	53.56	53.635	53.3	53.32	5436963.0
2015-11-12 16:00:00	MSFT	Stock	53.32	53.753	53.2	53.23	3223012.0
2015-11-12 17:00:00	MSFT	Stock	53.21	53.32	52.85	52.95	150896.0
2015-11-12 18:00:00	MSFT	Stock	52.96	53.07	52.9	53.06	7901.0
2015-11-12 19:00:00	MSFT	Stock	53.1	53.2	53.1	53.13	9022.0
2015-11-12 08:00:00	NVDA	Stock	0.7625	0.7625	0.7625	0.7625	48120.0
2015-11-12 09:00:00	NVDA	Stock	0.761	0.768	0.7568	0.763	26681000.0
2015-11-12 10:00:00	NVDA	Stock	0.7628	0.7668	0.7611	0.7658	47156280.0
2015-11-12 11:00:00	NVDA	Stock	0.7658	0.7662	0.7618	0.7645	32423880.0
2015-11-12 12:00:00	NVDA	Stock	0.7643	0.765	0.7603	0.7625	24658880.0
2015-11-12 13:00:00	NVDA	Stock	0.7625	0.7633	0.7595	0.7621	15745400.0
2015-11-12 14:00:00	NVDA	Stock	0.7622	0.7633	0.7588	0.7615	32316160.0
2015-11-12 15:00:00	NVDA	Stock	0.7612	0.763	0.7598	0.76	74505160.0
2015-11-12 16:00:00	NVDA	Stock	0.76	0.763	0.76	0.763	22583840.0
2015-11-12 18:00:00	NVDA	Stock	0.76	0.76	0.76	0.76	6000.0
2015-11-12 19:00:00	NVDA	Stock	0.76	0.76	0.76	0.76	9440.0
2015-11-12 04:00:00	AMZN	Stock	33.79	33.85	33.75	33.85	25740.0
2015-11-12 05:00:00	AMZN	Stock	33.7675	33.8185	33.7675	33.8185	8500.0
2015-11-12 06:00:00	AMZN	Stock	33.7605	33.7625	33.755	33.7625	19960.0
2015-11-12 07:00:00	AMZN	Stock	33.7625	33.7625	33.6755	33.7	98980.0
2015-11-12 08:00:00	AMZN	Stock	33.7165	33.7625	33.5505	33.6345	439360.0
2015-11-12 09:00:00	AMZN	Stock	33.6102	33.6825	33.4125	33.646	15146720.0
2015-11-12 10:00:00	AMZN	Stock	33.629	33.782	33.472	33.6335	15411760.0
2015-11-12 11:00:00	AMZN	Stock	33.6278	33.691	33.475	33.563	8671540.0

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

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