PREVIEW / stock_1hour / 2014-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-27.parquet
  size:    1.1 MB
  rows:    48,893
  symbols: 3,542

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
2014-01-27 04:00:00	AAPL	Stock	19.6061	19.6404	19.5989	19.6336	90244.0
2014-01-27 05:00:00	AAPL	Stock	19.6361	19.6425	19.6143	19.6189	146580.0
2014-01-27 06:00:00	AAPL	Stock	19.625	19.7032	19.6054	19.7032	199696.0
2014-01-27 07:00:00	AAPL	Stock	19.6964	19.7411	19.6696	19.6829	1285620.0
2014-01-27 08:00:00	AAPL	Stock	19.6857	19.7321	19.6325	19.6525	2386944.0
2014-01-27 09:00:00	AAPL	Stock	19.6525	19.8143	19.6314	19.7407	56481824.0
2014-01-27 10:00:00	AAPL	Stock	19.7411	19.7946	19.6661	19.7329	64438416.0
2014-01-27 11:00:00	AAPL	Stock	19.7289	19.7325	19.5861	19.5964	43223152.0
2014-01-27 12:00:00	AAPL	Stock	19.6011	19.6607	19.4911	19.5989	40363512.0
2014-01-27 13:00:00	AAPL	Stock	19.5979	19.7286	19.5796	19.7207	27187720.0
2014-01-27 14:00:00	AAPL	Stock	19.7235	19.8125	19.7054	19.8018	36618792.0
2014-01-27 15:00:00	AAPL	Stock	19.8023	19.8027	19.6618	19.6625	57814456.0
2014-01-27 16:00:00	AAPL	Stock	19.6607	20.0714	18.3929	18.5089	79883104.0
2014-01-27 17:00:00	AAPL	Stock	18.5007	18.5275	17.8757	18.0568	54960920.0
2014-01-27 18:00:00	AAPL	Stock	18.0661	19.6607	18.0361	18.1071	5912452.0
2014-01-27 19:00:00	AAPL	Stock	18.1139	18.1229	18.0361	18.0714	2765028.0
2014-01-27 04:00:00	MSFT	Stock	37.2	37.21	37.2	37.21	900.0
2014-01-27 06:00:00	MSFT	Stock	37.18	37.18	37.07	37.07	208.0
2014-01-27 07:00:00	MSFT	Stock	37.01	37.06	36.91	36.91	2415.0
2014-01-27 08:00:00	MSFT	Stock	37.0	37.05	36.8	37.0	44776.0
2014-01-27 09:00:00	MSFT	Stock	36.99	36.99	36.435	36.46	4292739.0
2014-01-27 10:00:00	MSFT	Stock	36.46	36.5	36.21	36.25	6905648.0
2014-01-27 11:00:00	MSFT	Stock	36.25	36.42	36.16	36.181	3680308.0
2014-01-27 12:00:00	MSFT	Stock	36.18	36.25	35.98	36.17	5527879.0
2014-01-27 13:00:00	MSFT	Stock	36.17	36.39	36.1	36.34	5174475.0
2014-01-27 14:00:00	MSFT	Stock	36.35	36.4	36.23	36.31	4223733.0
2014-01-27 15:00:00	MSFT	Stock	36.3	36.425	36.03	36.03	8217625.0
2014-01-27 16:00:00	MSFT	Stock	36.04	36.861	35.92	35.95	4880989.0
2014-01-27 17:00:00	MSFT	Stock	35.95	36.11	35.9	35.95	60264.0
2014-01-27 18:00:00	MSFT	Stock	35.96	36.1	35.96	36.03	50785.0
2014-01-27 19:00:00	MSFT	Stock	36.05	36.1	36.02	36.02	6950.0
2014-01-27 09:00:00	NVDA	Stock	0.389	0.3945	0.3885	0.3938	14915600.0
2014-01-27 10:00:00	NVDA	Stock	0.394	0.3945	0.3895	0.3895	44193440.0
2014-01-27 11:00:00	NVDA	Stock	0.3895	0.3898	0.3875	0.3875	29429360.0
2014-01-27 12:00:00	NVDA	Stock	0.3875	0.3875	0.3842	0.3858	19355120.0
2014-01-27 13:00:00	NVDA	Stock	0.3858	0.3882	0.3855	0.3874	13885280.0
2014-01-27 14:00:00	NVDA	Stock	0.3871	0.3888	0.3871	0.3882	17262560.0
2014-01-27 15:00:00	NVDA	Stock	0.3882	0.3882	0.3862	0.3865	64257440.0
2014-01-27 16:00:00	NVDA	Stock	0.3865	0.3866	0.3862	0.3864	13435000.0
2014-01-27 04:00:00	AMZN	Stock	19.355	19.4	19.355	19.375	15680.0
2014-01-27 05:00:00	AMZN	Stock	19.365	19.365	19.332	19.355	22000.0
2014-01-27 06:00:00	AMZN	Stock	19.35	19.35	19.35	19.35	2000.0
2014-01-27 07:00:00	AMZN	Stock	19.375	19.4105	19.3435	19.4105	32120.0
2014-01-27 08:00:00	AMZN	Stock	19.4225	19.5345	19.4225	19.484	116320.0
2014-01-27 09:00:00	AMZN	Stock	19.4675	19.6465	19.4365	19.6008	12610520.0
2014-01-27 10:00:00	AMZN	Stock	19.6005	19.705	19.064	19.3417	19491120.0
2014-01-27 11:00:00	AMZN	Stock	19.3215	19.364	19.19	19.2055	5619520.0
2014-01-27 12:00:00	AMZN	Stock	19.208	19.264	19.0245	19.194	7680960.0
2014-01-27 13:00:00	AMZN	Stock	19.1915	19.43	19.1495	19.325	6362760.0
2014-01-27 14:00:00	AMZN	Stock	19.3225	19.488	19.3225	19.458	5633760.0

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

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