PREVIEW / stock_1hour / 2014-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-22.parquet
  size:    1.0 MB
  rows:    48,465
  symbols: 3,543

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-05-22 04:00:00	AAPL	Stock	21.6746	21.7011	21.6746	21.7011	14000.0
2014-05-22 06:00:00	AAPL	Stock	21.6786	21.6893	21.6786	21.6893	16800.0
2014-05-22 07:00:00	AAPL	Stock	21.6821	21.6889	21.675	21.6829	58184.0
2014-05-22 08:00:00	AAPL	Stock	21.6732	21.6882	21.6571	21.6718	420980.0
2014-05-22 09:00:00	AAPL	Stock	21.6743	21.7093	21.6146	21.6484	33862668.0
2014-05-22 10:00:00	AAPL	Stock	21.6546	21.6546	21.575	21.6379	25238024.0
2014-05-22 11:00:00	AAPL	Stock	21.6371	21.6764	21.6125	21.6314	16616040.0
2014-05-22 12:00:00	AAPL	Stock	21.6389	21.6511	21.6143	21.6375	7059388.0
2014-05-22 13:00:00	AAPL	Stock	21.6386	21.7086	21.6336	21.7018	17061632.0
2014-05-22 14:00:00	AAPL	Stock	21.7018	21.7804	21.7018	21.7393	25406416.0
2014-05-22 15:00:00	AAPL	Stock	21.7414	21.7579	21.6429	21.6904	28751240.0
2014-05-22 16:00:00	AAPL	Stock	21.6893	21.7179	21.6427	21.6518	7544992.0
2014-05-22 17:00:00	AAPL	Stock	21.6611	21.6893	21.6611	21.6893	82180.0
2014-05-22 18:00:00	AAPL	Stock	21.6689	21.6693	21.6646	21.6686	79408.0
2014-05-22 19:00:00	AAPL	Stock	21.6643	21.6696	21.6589	21.6607	84364.0
2014-05-22 08:00:00	MSFT	Stock	40.27	40.27	40.27	40.27	963.0
2014-05-22 09:00:00	MSFT	Stock	40.33	40.35	40.02	40.03	2853903.0
2014-05-22 10:00:00	MSFT	Stock	40.031	40.06	39.85	39.97	3429631.0
2014-05-22 11:00:00	MSFT	Stock	39.97	40.065	39.95	40.02	2387935.0
2014-05-22 12:00:00	MSFT	Stock	40.01	40.045	39.97	39.985	1925720.0
2014-05-22 13:00:00	MSFT	Stock	39.985	40.16	39.98	40.117	1917574.0
2014-05-22 14:00:00	MSFT	Stock	40.12	40.215	40.11	40.215	1371874.0
2014-05-22 15:00:00	MSFT	Stock	40.21	40.215	40.065	40.105	3870579.0
2014-05-22 16:00:00	MSFT	Stock	40.1	40.12	40.008	40.038	1583295.0
2014-05-22 17:00:00	MSFT	Stock	40.12	40.12	40.12	40.12	300.0
2014-05-22 18:00:00	MSFT	Stock	40.14	40.14	40.14	40.14	600.0
2014-05-22 19:00:00	MSFT	Stock	40.15	40.15	40.13	40.13	600.0
2014-05-22 09:00:00	NVDA	Stock	0.455	0.4582	0.455	0.458	17934520.0
2014-05-22 10:00:00	NVDA	Stock	0.458	0.4588	0.4562	0.458	27387160.0
2014-05-22 11:00:00	NVDA	Stock	0.458	0.4605	0.458	0.4585	15582000.0
2014-05-22 12:00:00	NVDA	Stock	0.4588	0.4595	0.4578	0.4581	14981400.0
2014-05-22 13:00:00	NVDA	Stock	0.4582	0.4585	0.4572	0.4578	6626480.0
2014-05-22 14:00:00	NVDA	Stock	0.4578	0.4588	0.4572	0.4586	13951680.0
2014-05-22 15:00:00	NVDA	Stock	0.4586	0.459	0.4576	0.458	23275720.0
2014-05-22 16:00:00	NVDA	Stock	0.458	0.4581	0.4567	0.458	8189360.0
2014-05-22 19:00:00	NVDA	Stock	0.4605	0.4605	0.4605	0.4605	20000.0
2014-05-22 05:00:00	AMZN	Stock	15.2655	15.2655	15.2655	15.2655	2000.0
2014-05-22 08:00:00	AMZN	Stock	15.2745	15.2975	15.2725	15.28	27440.0
2014-05-22 09:00:00	AMZN	Stock	15.2675	15.29	15.1505	15.25	7480480.0
2014-05-22 10:00:00	AMZN	Stock	15.2571	15.4215	15.1985	15.371	10156100.0
2014-05-22 11:00:00	AMZN	Stock	15.373	15.427	15.3205	15.3375	6507500.0
2014-05-22 12:00:00	AMZN	Stock	15.3375	15.3465	15.2665	15.2775	3802360.0
2014-05-22 13:00:00	AMZN	Stock	15.283	15.3675	15.277	15.3608	3028960.0
2014-05-22 14:00:00	AMZN	Stock	15.36	15.3732	15.2955	15.321	4157260.0
2014-05-22 15:00:00	AMZN	Stock	15.321	15.328	15.2355	15.246	9566960.0
2014-05-22 16:00:00	AMZN	Stock	15.251	15.336	15.2295	15.2455	1378720.0
2014-05-22 17:00:00	AMZN	Stock	15.2425	15.2455	15.2425	15.2455	29280.0
2014-05-22 18:00:00	AMZN	Stock	15.2565	15.2565	15.2565	15.2565	4160.0
2014-05-22 04:00:00	GOOGL	Stock	27.5575	27.6245	27.5575	27.6245	4000.0
2014-05-22 05:00:00	GOOGL	Stock	27.6205	27.705	27.618	27.705	6000.0

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

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