PREVIEW / stock_1hour / 2013-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-17.parquet
  size:    1.0 MB
  rows:    47,903
  symbols: 3,560

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
2013-12-17 04:00:00	AAPL	Stock	19.9011	19.9011	19.9011	19.9011	2800.0
2013-12-17 05:00:00	AAPL	Stock	19.9089	19.9089	19.9089	19.9089	2800.0
2013-12-17 06:00:00	AAPL	Stock	19.9089	19.9089	19.9089	19.9089	2800.0
2013-12-17 07:00:00	AAPL	Stock	19.9125	19.9493	19.9107	19.9375	123172.0
2013-12-17 08:00:00	AAPL	Stock	19.9393	19.9682	19.8929	19.9107	1209768.0
2013-12-17 09:00:00	AAPL	Stock	19.9021	19.98	19.85	19.8562	34987288.0
2013-12-17 10:00:00	AAPL	Stock	19.8539	19.9118	19.7982	19.8191	33105576.0
2013-12-17 11:00:00	AAPL	Stock	19.8164	19.8879	19.7634	19.8689	31332112.0
2013-12-17 12:00:00	AAPL	Stock	19.8704	19.8907	19.8214	19.8609	20325032.0
2013-12-17 13:00:00	AAPL	Stock	19.8636	19.9107	19.8586	19.8754	12082756.0
2013-12-17 14:00:00	AAPL	Stock	19.8754	19.9461	19.8461	19.8789	17875340.0
2013-12-17 15:00:00	AAPL	Stock	19.8736	19.9011	19.8061	19.8205	26738152.0
2013-12-17 16:00:00	AAPL	Stock	19.8211	19.8654	19.7935	19.8211	11806284.0
2013-12-17 17:00:00	AAPL	Stock	19.8171	19.8175	19.8007	19.8064	116144.0
2013-12-17 18:00:00	AAPL	Stock	19.8171	19.8211	19.8082	19.8161	144004.0
2013-12-17 19:00:00	AAPL	Stock	19.8196	19.8339	19.8093	19.8264	202916.0
2013-12-17 06:00:00	MSFT	Stock	36.93	36.93	36.91	36.91	700.0
2013-12-17 07:00:00	MSFT	Stock	37.0	37.0	37.0	37.0	700.0
2013-12-17 08:00:00	MSFT	Stock	37.0	37.0	36.88	36.88	4521.0
2013-12-17 09:00:00	MSFT	Stock	36.89	37.0	36.61	36.75	5314977.0
2013-12-17 10:00:00	MSFT	Stock	36.75	37.11	36.66	36.91	5750557.0
2013-12-17 11:00:00	MSFT	Stock	36.91	37.01	36.62	36.635	4718831.0
2013-12-17 12:00:00	MSFT	Stock	36.64	36.775	36.61	36.65	3131543.0
2013-12-17 13:00:00	MSFT	Stock	36.65	36.72	36.34	36.354	7429858.0
2013-12-17 14:00:00	MSFT	Stock	36.35	36.62	36.334	36.53	4233408.0
2013-12-17 15:00:00	MSFT	Stock	36.53	36.595	36.49	36.53	7344482.0
2013-12-17 16:00:00	MSFT	Stock	36.54	36.86	36.5	36.54	2776125.0
2013-12-17 17:00:00	MSFT	Stock	36.525	36.885	36.525	36.885	1500.0
2013-12-17 18:00:00	MSFT	Stock	36.54	36.58	36.54	36.58	13150.0
2013-12-17 19:00:00	MSFT	Stock	36.58	36.65	36.54	36.65	5938.0
2013-12-17 09:00:00	NVDA	Stock	0.3755	0.3763	0.3725	0.3735	37274200.0
2013-12-17 10:00:00	NVDA	Stock	0.3733	0.376	0.3733	0.3758	49047360.0
2013-12-17 11:00:00	NVDA	Stock	0.3756	0.3773	0.3753	0.377	28234400.0
2013-12-17 12:00:00	NVDA	Stock	0.377	0.3778	0.3768	0.3778	10946920.0
2013-12-17 13:00:00	NVDA	Stock	0.3778	0.378	0.3775	0.378	12427360.0
2013-12-17 14:00:00	NVDA	Stock	0.3779	0.3788	0.3778	0.3788	29340640.0
2013-12-17 15:00:00	NVDA	Stock	0.3786	0.3788	0.3778	0.3779	57016880.0
2013-12-17 16:00:00	NVDA	Stock	0.3778	0.378	0.3775	0.3778	41216160.0
2013-12-17 17:00:00	NVDA	Stock	0.378	0.378	0.376	0.376	124000.0
2013-12-17 07:00:00	AMZN	Stock	19.453	19.5	19.4505	19.5	28000.0
2013-12-17 08:00:00	AMZN	Stock	19.495	19.65	19.495	19.606	297360.0
2013-12-17 09:00:00	AMZN	Stock	19.5925	19.6125	19.357	19.528	9057020.0
2013-12-17 10:00:00	AMZN	Stock	19.5255	19.5488	19.361	19.3875	8202020.0
2013-12-17 11:00:00	AMZN	Stock	19.3765	19.4075	19.325	19.392	4301220.0
2013-12-17 12:00:00	AMZN	Stock	19.3855	19.4189	19.3445	19.4068	2364120.0
2013-12-17 13:00:00	AMZN	Stock	19.4015	19.427	19.343	19.3775	2875220.0
2013-12-17 14:00:00	AMZN	Stock	19.375	19.5376	19.3695	19.4385	4576420.0
2013-12-17 15:00:00	AMZN	Stock	19.437	19.4685	19.379	19.3885	6044040.0
2013-12-17 16:00:00	AMZN	Stock	19.3825	19.4	19.3786	19.4	566020.0
2013-12-17 17:00:00	AMZN	Stock	19.4	19.4	19.4	19.4	11300.0

> showing 50 of 47,903 rows — these rows as CSV

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