PREVIEW / stock_1hour / 2014-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-17.parquet
  size:    1.0 MB
  rows:    47,571
  symbols: 3,540

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-04-17 04:00:00	AAPL	Stock	18.4575	18.4575	18.4575	18.4575	5600.0
2014-04-17 07:00:00	AAPL	Stock	18.4571	18.5218	18.4571	18.5218	78624.0
2014-04-17 08:00:00	AAPL	Stock	18.4571	18.6429	18.4571	18.6271	1052632.0
2014-04-17 09:00:00	AAPL	Stock	18.6286	18.6418	18.5429	18.5768	40890136.0
2014-04-17 10:00:00	AAPL	Stock	18.5764	18.6475	18.57	18.6475	34135220.0
2014-04-17 11:00:00	AAPL	Stock	18.6471	18.7071	18.6418	18.7029	29771224.0
2014-04-17 12:00:00	AAPL	Stock	18.7	18.7489	18.6946	18.7364	23374932.0
2014-04-17 13:00:00	AAPL	Stock	18.7361	18.8314	18.7229	18.8118	28647108.0
2014-04-17 14:00:00	AAPL	Stock	18.8107	18.8486	18.7875	18.8082	23446472.0
2014-04-17 15:00:00	AAPL	Stock	18.8079	18.8082	18.735	18.7496	43231020.0
2014-04-17 16:00:00	AAPL	Stock	18.7479	18.7632	18.5361	18.7536	11427444.0
2014-04-17 17:00:00	AAPL	Stock	18.75	18.7554	18.7307	18.7346	385644.0
2014-04-17 18:00:00	AAPL	Stock	18.7418	18.7496	18.7379	18.7379	292712.0
2014-04-17 19:00:00	AAPL	Stock	18.7464	18.7525	18.7464	18.75	29092.0
2014-04-17 07:00:00	MSFT	Stock	40.22	40.22	40.22	40.22	1200.0
2014-04-17 08:00:00	MSFT	Stock	40.24	40.24	40.11	40.11	12028.0
2014-04-17 09:00:00	MSFT	Stock	40.19	40.19	39.63	39.7	7728440.0
2014-04-17 10:00:00	MSFT	Stock	39.7	39.86	39.51	39.77	5245165.0
2014-04-17 11:00:00	MSFT	Stock	39.76	39.85	39.729	39.832	2188435.0
2014-04-17 12:00:00	MSFT	Stock	39.835	40.0	39.81	39.999	2800927.0
2014-04-17 13:00:00	MSFT	Stock	40.0	40.12	39.984	40.1	2692567.0
2014-04-17 14:00:00	MSFT	Stock	40.1	40.12	40.02	40.08	1950098.0
2014-04-17 15:00:00	MSFT	Stock	40.08	40.195	40.01	40.01	7881544.0
2014-04-17 16:00:00	MSFT	Stock	40.01	40.4	39.937	40.4	2932107.0
2014-04-17 17:00:00	MSFT	Stock	40.01	40.03	40.01	40.03	79399.0
2014-04-17 18:00:00	MSFT	Stock	40.03	40.03	40.03	40.03	400.0
2014-04-17 19:00:00	MSFT	Stock	40.16	40.16	40.03	40.04	1000.0
2014-04-17 09:00:00	NVDA	Stock	0.4608	0.4666	0.4595	0.4633	29261880.0
2014-04-17 10:00:00	NVDA	Stock	0.4638	0.4683	0.4633	0.467	31898800.0
2014-04-17 11:00:00	NVDA	Stock	0.4668	0.4669	0.4622	0.4644	15404440.0
2014-04-17 12:00:00	NVDA	Stock	0.4643	0.4648	0.4628	0.4638	12798040.0
2014-04-17 13:00:00	NVDA	Stock	0.4638	0.4652	0.4638	0.4641	10540160.0
2014-04-17 14:00:00	NVDA	Stock	0.4643	0.4658	0.4633	0.4633	9679680.0
2014-04-17 15:00:00	NVDA	Stock	0.4633	0.465	0.4633	0.464	33588480.0
2014-04-17 16:00:00	NVDA	Stock	0.464	0.4652	0.464	0.464	1117280.0
2014-04-17 07:00:00	AMZN	Stock	15.9895	16.0755	15.9895	16.075	98960.0
2014-04-17 08:00:00	AMZN	Stock	16.075	16.1605	16.0625	16.1	520880.0
2014-04-17 09:00:00	AMZN	Stock	16.097	16.37	15.958	16.319	23390220.0
2014-04-17 10:00:00	AMZN	Stock	16.3295	16.433	16.1745	16.2955	15702220.0
2014-04-17 11:00:00	AMZN	Stock	16.3065	16.34	16.228	16.2725	6559100.0
2014-04-17 12:00:00	AMZN	Stock	16.2725	16.3445	16.227	16.301	5046420.0
2014-04-17 13:00:00	AMZN	Stock	16.303	16.355	16.297	16.327	5202900.0
2014-04-17 14:00:00	AMZN	Stock	16.3275	16.332	16.213	16.2565	7524940.0
2014-04-17 15:00:00	AMZN	Stock	16.259	16.302	16.238	16.2455	11909780.0
2014-04-17 16:00:00	AMZN	Stock	16.2455	16.2851	16.2145	16.2455	806260.0
2014-04-17 17:00:00	AMZN	Stock	16.242	16.25	16.242	16.2475	83600.0
2014-04-17 19:00:00	AMZN	Stock	16.225	16.225	16.225	16.225	18000.0
2014-04-17 04:00:00	GOOGL	Stock	26.505	27.357	26.505	27.357	25200.0
2014-04-17 05:00:00	GOOGL	Stock	27.375	27.404	27.28	27.28	12700.0
2014-04-17 06:00:00	GOOGL	Stock	27.35	27.35	27.175	27.2425	61500.0

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

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