PREVIEW / stock_1hour / 2016-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-24.parquet
  size:    1.0 MB
  rows:    48,179
  symbols: 3,291

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
2016-05-24 04:00:00	AAPL	Stock	24.2225	24.25	24.2225	24.25	4800.0
2016-05-24 05:00:00	AAPL	Stock	24.245	24.275	24.245	24.275	7700.0
2016-05-24 06:00:00	AAPL	Stock	24.26	24.27	24.2325	24.2325	65684.0
2016-05-24 07:00:00	AAPL	Stock	24.2325	24.2475	24.22	24.22	101580.0
2016-05-24 08:00:00	AAPL	Stock	24.25	24.2775	24.22	24.27	517880.0
2016-05-24 09:00:00	AAPL	Stock	24.2725	24.345	24.21	24.3075	25219120.0
2016-05-24 10:00:00	AAPL	Stock	24.3075	24.3825	24.2925	24.3675	21501632.0
2016-05-24 11:00:00	AAPL	Stock	24.37	24.435	24.3675	24.434	13493508.0
2016-05-24 12:00:00	AAPL	Stock	24.4348	24.4925	24.3975	24.4925	12146876.0
2016-05-24 13:00:00	AAPL	Stock	24.4925	24.5075	24.4128	24.4425	12797604.0
2016-05-24 14:00:00	AAPL	Stock	24.44	24.4875	24.425	24.4587	10187168.0
2016-05-24 15:00:00	AAPL	Stock	24.46	24.5225	24.445	24.475	21083708.0
2016-05-24 16:00:00	AAPL	Stock	24.475	24.5	24.475	24.4975	11500176.0
2016-05-24 17:00:00	AAPL	Stock	24.5	24.5	24.475	24.485	131776.0
2016-05-24 18:00:00	AAPL	Stock	24.4775	24.4875	24.4775	24.4825	61904.0
2016-05-24 19:00:00	AAPL	Stock	24.49	24.55	24.49	24.55	74612.0
2016-05-24 05:00:00	MSFT	Stock	50.5	50.55	50.5	50.55	3600.0
2016-05-24 06:00:00	MSFT	Stock	50.59	50.59	50.4	50.4	12249.0
2016-05-24 07:00:00	MSFT	Stock	50.45	50.59	50.45	50.57	28172.0
2016-05-24 08:00:00	MSFT	Stock	50.53	50.57	50.4	50.56	70423.0
2016-05-24 09:00:00	MSFT	Stock	50.51	50.74	50.4	50.67	6305348.0
2016-05-24 10:00:00	MSFT	Stock	50.68	51.3	50.675	51.235	6444200.0
2016-05-24 11:00:00	MSFT	Stock	51.24	51.48	51.23	51.47	3238381.0
2016-05-24 12:00:00	MSFT	Stock	51.47	51.55	51.37	51.545	2178133.0
2016-05-24 13:00:00	MSFT	Stock	51.542	51.71	51.45	51.526	2789177.0
2016-05-24 14:00:00	MSFT	Stock	51.53	51.61	51.42	51.535	2836679.0
2016-05-24 15:00:00	MSFT	Stock	51.535	51.71	51.47	51.59	5650695.0
2016-05-24 16:00:00	MSFT	Stock	51.58	51.72	51.52	51.59	2499614.0
2016-05-24 17:00:00	MSFT	Stock	51.67	51.68	51.66	51.66	4230.0
2016-05-24 18:00:00	MSFT	Stock	51.66	51.81	51.66	51.81	24485.0
2016-05-24 19:00:00	MSFT	Stock	51.78	51.85	51.75	51.85	3532.0
2016-05-24 08:00:00	NVDA	Stock	1.1098	1.1138	1.1098	1.1138	258400.0
2016-05-24 09:00:00	NVDA	Stock	1.11	1.1248	1.1075	1.1228	71196360.0
2016-05-24 10:00:00	NVDA	Stock	1.123	1.1258	1.1191	1.1235	70892160.0
2016-05-24 11:00:00	NVDA	Stock	1.1235	1.1268	1.1222	1.1245	39953720.0
2016-05-24 12:00:00	NVDA	Stock	1.1248	1.1312	1.1235	1.1305	37197520.0
2016-05-24 13:00:00	NVDA	Stock	1.1305	1.1345	1.128	1.133	40218320.0
2016-05-24 14:00:00	NVDA	Stock	1.1331	1.1375	1.1322	1.1369	37227160.0
2016-05-24 15:00:00	NVDA	Stock	1.1369	1.1375	1.1328	1.1338	76360000.0
2016-05-24 16:00:00	NVDA	Stock	1.134	1.135	1.1325	1.1332	2127760.0
2016-05-24 17:00:00	NVDA	Stock	1.1363	1.1363	1.1363	1.1363	8000.0
2016-05-24 18:00:00	NVDA	Stock	1.1363	1.137	1.135	1.137	58400.0
2016-05-24 19:00:00	NVDA	Stock	1.1355	1.1355	1.1355	1.1355	8000.0
2016-05-24 04:00:00	AMZN	Stock	34.8375	34.8425	34.8375	34.8425	10000.0
2016-05-24 05:00:00	AMZN	Stock	34.918	34.9215	34.918	34.9215	4000.0
2016-05-24 07:00:00	AMZN	Stock	34.95	34.9995	34.95	34.9995	67980.0
2016-05-24 08:00:00	AMZN	Stock	35.0	35.03	34.97	34.9955	181540.0
2016-05-24 09:00:00	AMZN	Stock	34.9935	35.18	34.9	34.986	8801000.0
2016-05-24 10:00:00	AMZN	Stock	34.996	35.2905	34.9555	35.2665	11000500.0
2016-05-24 11:00:00	AMZN	Stock	35.26	35.36	35.2335	35.36	6558460.0

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

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