PREVIEW / stock_1hour / 2013-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-12.parquet
  size:    983 KB
  rows:    45,585
  symbols: 3,512

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-07-12 04:00:00	AAPL	Stock	15.2407	15.2407	15.2407	15.2407	2800.0
2013-07-12 05:00:00	AAPL	Stock	15.2368	15.2368	15.2368	15.2368	2800.0
2013-07-12 06:00:00	AAPL	Stock	15.2371	15.2436	15.2371	15.2436	8400.0
2013-07-12 07:00:00	AAPL	Stock	15.2575	15.2707	15.2368	15.25	177968.0
2013-07-12 08:00:00	AAPL	Stock	15.2336	15.2732	15.2325	15.2732	683620.0
2013-07-12 09:00:00	AAPL	Stock	15.2707	15.3357	15.2429	15.2893	51789808.0
2013-07-12 10:00:00	AAPL	Stock	15.2893	15.3496	15.2536	15.2768	44940028.0
2013-07-12 11:00:00	AAPL	Stock	15.27	15.2914	15.1654	15.2075	36747648.0
2013-07-12 12:00:00	AAPL	Stock	15.2079	15.225	15.1218	15.1632	27633396.0
2013-07-12 13:00:00	AAPL	Stock	15.1607	15.1957	15.1432	15.1746	17281040.0
2013-07-12 14:00:00	AAPL	Stock	15.1725	15.1857	15.1371	15.1757	18450712.0
2013-07-12 15:00:00	AAPL	Stock	15.1761	15.2368	15.1646	15.2321	52169572.0
2013-07-12 16:00:00	AAPL	Stock	15.2325	15.2783	15.1799	15.2325	17554712.0
2013-07-12 17:00:00	AAPL	Stock	15.2243	15.225	15.2036	15.2154	183428.0
2013-07-12 18:00:00	AAPL	Stock	15.2164	15.2268	15.2164	15.2214	80276.0
2013-07-12 19:00:00	AAPL	Stock	15.2214	15.2321	15.2214	15.2321	30800.0
2013-07-12 04:00:00	MSFT	Stock	35.59	35.59	35.59	35.59	3100.0
2013-07-12 07:00:00	MSFT	Stock	35.6	35.6	35.55	35.6	3000.0
2013-07-12 08:00:00	MSFT	Stock	35.6	35.8	35.52	35.53	25110.0
2013-07-12 09:00:00	MSFT	Stock	35.51	35.73	35.4	35.503	4488013.0
2013-07-12 10:00:00	MSFT	Stock	35.505	35.52	35.31	35.4	4784529.0
2013-07-12 11:00:00	MSFT	Stock	35.4	35.41	35.28	35.305	2847450.0
2013-07-12 12:00:00	MSFT	Stock	35.305	35.41	35.3	35.33	2365716.0
2013-07-12 13:00:00	MSFT	Stock	35.335	35.44	35.28	35.41	2535211.0
2013-07-12 14:00:00	MSFT	Stock	35.405	35.54	35.38	35.49	2561704.0
2013-07-12 15:00:00	MSFT	Stock	35.49	35.73	35.43	35.71	9705749.0
2013-07-12 16:00:00	MSFT	Stock	35.72	35.73	35.516	35.67	5830390.0
2013-07-12 17:00:00	MSFT	Stock	35.65	35.66	35.63	35.63	1091.0
2013-07-12 18:00:00	MSFT	Stock	35.68	35.68	35.66	35.66	300.0
2013-07-12 19:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	1184.0
2013-07-12 09:00:00	NVDA	Stock	0.365	0.3685	0.3648	0.3668	28997440.0
2013-07-12 10:00:00	NVDA	Stock	0.367	0.3695	0.3642	0.368	70366680.0
2013-07-12 11:00:00	NVDA	Stock	0.368	0.368	0.3648	0.3649	21502960.0
2013-07-12 12:00:00	NVDA	Stock	0.365	0.366	0.3642	0.3656	15097960.0
2013-07-12 13:00:00	NVDA	Stock	0.3655	0.3658	0.3642	0.3652	16193800.0
2013-07-12 14:00:00	NVDA	Stock	0.3652	0.3655	0.3638	0.3648	12928480.0
2013-07-12 15:00:00	NVDA	Stock	0.365	0.3665	0.3648	0.366	38208680.0
2013-07-12 16:00:00	NVDA	Stock	0.366	0.366	0.3652	0.3655	12950800.0
2013-07-12 17:00:00	NVDA	Stock	0.367	0.367	0.367	0.367	4280.0
2013-07-12 06:00:00	AMZN	Stock	14.972	14.972	14.967	14.97	6000.0
2013-07-12 07:00:00	AMZN	Stock	14.975	14.985	14.975	14.985	37740.0
2013-07-12 08:00:00	AMZN	Stock	14.995	15.0	14.891	14.9145	338220.0
2013-07-12 09:00:00	AMZN	Stock	14.917	15.1535	14.901	15.11	17131420.0
2013-07-12 10:00:00	AMZN	Stock	15.12	15.2372	15.1	15.14	15025480.0
2013-07-12 11:00:00	AMZN	Stock	15.1425	15.225	15.1345	15.161	7192880.0
2013-07-12 12:00:00	AMZN	Stock	15.16	15.2329	15.1325	15.21	10192500.0
2013-07-12 13:00:00	AMZN	Stock	15.212	15.28	15.177	15.2645	5258260.0
2013-07-12 14:00:00	AMZN	Stock	15.2704	15.2935	15.2315	15.291	6079360.0
2013-07-12 15:00:00	AMZN	Stock	15.2935	15.3765	15.263	15.3765	17420920.0
2013-07-12 16:00:00	AMZN	Stock	15.3775	15.383	15.1758	15.3775	6888820.0

> showing 50 of 45,585 rows — these rows as CSV

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