PREVIEW / stock_1hour / 2011-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-15.parquet
  size:    975 KB
  rows:    46,395
  symbols: 3,529

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
2011-03-15 04:00:00	AAPL	Stock	12.4607	12.4607	12.3161	12.325	77392.0
2011-03-15 05:00:00	AAPL	Stock	12.3218	12.3218	12.1071	12.1261	414120.0
2011-03-15 06:00:00	AAPL	Stock	12.1261	12.2821	12.1261	12.2411	983416.0
2011-03-15 07:00:00	AAPL	Stock	12.2411	12.3571	12.2236	12.2589	2971948.0
2011-03-15 08:00:00	AAPL	Stock	12.2607	12.3561	12.2154	12.2682	8962352.0
2011-03-15 09:00:00	AAPL	Stock	12.2686	12.3243	12.1464	12.1936	180506592.0
2011-03-15 10:00:00	AAPL	Stock	12.1925	12.3496	12.1786	12.3324	149274496.0
2011-03-15 11:00:00	AAPL	Stock	12.3336	12.3554	12.2979	12.3279	72138724.0
2011-03-15 12:00:00	AAPL	Stock	12.33	12.4229	12.3236	12.3721	82145420.0
2011-03-15 13:00:00	AAPL	Stock	12.3739	12.3786	12.3446	12.3534	40356512.0
2011-03-15 14:00:00	AAPL	Stock	12.3532	12.4032	12.3261	12.3686	69596212.0
2011-03-15 15:00:00	AAPL	Stock	12.37	12.4179	12.33	12.3368	89192992.0
2011-03-15 16:00:00	AAPL	Stock	12.3368	12.3611	12.303	12.3179	15384068.0
2011-03-15 17:00:00	AAPL	Stock	12.402	12.402	12.3039	12.315	1136128.0
2011-03-15 18:00:00	AAPL	Stock	12.315	12.3368	12.27	12.2857	1147720.0
2011-03-15 19:00:00	AAPL	Stock	12.2861	12.3894	12.2714	12.3211	664804.0
2011-03-15 04:00:00	MSFT	Stock	25.41	25.41	25.0	25.1	6290.0
2011-03-15 05:00:00	MSFT	Stock	25.04	25.04	24.6	24.65	8140.0
2011-03-15 06:00:00	MSFT	Stock	24.81	24.88	24.65	24.88	13585.0
2011-03-15 07:00:00	MSFT	Stock	24.91	25.1	24.91	25.1	39100.0
2011-03-15 08:00:00	MSFT	Stock	25.1	25.2	24.97	24.97	241336.0
2011-03-15 09:00:00	MSFT	Stock	24.97	25.41	24.96	25.14	14021950.0
2011-03-15 10:00:00	MSFT	Stock	25.139	25.417	25.09	25.405	14808525.0
2011-03-15 11:00:00	MSFT	Stock	25.4	25.405	25.24	25.25	9914658.0
2011-03-15 12:00:00	MSFT	Stock	25.25	25.43	25.23	25.285	6073316.0
2011-03-15 13:00:00	MSFT	Stock	25.29	25.4	25.245	25.375	4572499.0
2011-03-15 14:00:00	MSFT	Stock	25.37	25.46	25.28	25.33	5802992.0
2011-03-15 15:00:00	MSFT	Stock	25.32	25.47	25.27	25.4	15431075.0
2011-03-15 16:00:00	MSFT	Stock	25.39	25.42	25.25	25.35	3661997.0
2011-03-15 17:00:00	MSFT	Stock	25.308	25.36	25.308	25.33	14504.0
2011-03-15 18:00:00	MSFT	Stock	25.34	25.39	25.1	25.16	39667.0
2011-03-15 19:00:00	MSFT	Stock	25.22	25.34	25.22	25.27	17750.0
2011-03-15 05:00:00	NVDA	Stock	0.4438	0.4438	0.4315	0.4315	46800.0
2011-03-15 06:00:00	NVDA	Stock	0.4315	0.4315	0.4312	0.4312	24800.0
2011-03-15 07:00:00	NVDA	Stock	0.4322	0.4422	0.4312	0.44	388000.0
2011-03-15 08:00:00	NVDA	Stock	0.4398	0.4425	0.4312	0.434	4114040.0
2011-03-15 09:00:00	NVDA	Stock	0.4328	0.436	0.4253	0.4298	208834440.0
2011-03-15 10:00:00	NVDA	Stock	0.43	0.4475	0.4298	0.4436	283293440.0
2011-03-15 11:00:00	NVDA	Stock	0.4435	0.449	0.4399	0.4469	157062960.0
2011-03-15 12:00:00	NVDA	Stock	0.447	0.449	0.4422	0.4433	127181280.0
2011-03-15 13:00:00	NVDA	Stock	0.4435	0.445	0.44	0.4412	98702880.0
2011-03-15 14:00:00	NVDA	Stock	0.4415	0.4455	0.4388	0.4442	135433360.0
2011-03-15 15:00:00	NVDA	Stock	0.444	0.4468	0.442	0.4425	173349240.0
2011-03-15 16:00:00	NVDA	Stock	0.4415	0.4458	0.4112	0.433	31658160.0
2011-03-15 17:00:00	NVDA	Stock	0.4332	0.4385	0.432	0.4375	2605000.0
2011-03-15 18:00:00	NVDA	Stock	0.4375	0.4378	0.4332	0.4362	1520880.0
2011-03-15 19:00:00	NVDA	Stock	0.435	0.4378	0.4338	0.4378	473200.0
2011-03-15 04:00:00	AMZN	Stock	8.15	8.15	8.15	8.15	4000.0
2011-03-15 05:00:00	AMZN	Stock	8.1505	8.1505	8.0	8.0	20000.0
2011-03-15 06:00:00	AMZN	Stock	8.0005	8.14	8.0005	8.14	59800.0

> showing 50 of 46,395 rows — these rows as CSV

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