PREVIEW / stock_1hour / 2016-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-12.parquet
  size:    1.0 MB
  rows:    46,845
  symbols: 3,174

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
2016-10-12 04:00:00	AAPL	Stock	29.2325	29.25	29.175	29.22	10848.0
2016-10-12 05:00:00	AAPL	Stock	29.24	29.3075	29.225	29.235	60096.0
2016-10-12 06:00:00	AAPL	Stock	29.235	29.28	29.205	29.2375	67728.0
2016-10-12 07:00:00	AAPL	Stock	29.24	29.265	29.1875	29.195	136384.0
2016-10-12 08:00:00	AAPL	Stock	29.1975	29.3125	29.0125	29.3	863464.0
2016-10-12 09:00:00	AAPL	Stock	29.305	29.4375	29.195	29.265	26216048.0
2016-10-12 10:00:00	AAPL	Stock	29.2625	29.3295	29.1925	29.21	19567112.0
2016-10-12 11:00:00	AAPL	Stock	29.2075	29.4175	29.1875	29.415	20030776.0
2016-10-12 12:00:00	AAPL	Stock	29.417	29.4325	29.3225	29.385	16823792.0
2016-10-12 13:00:00	AAPL	Stock	29.3838	29.4575	29.3725	29.45	11319516.0
2016-10-12 14:00:00	AAPL	Stock	29.45	29.495	29.3225	29.3272	18157060.0
2016-10-12 15:00:00	AAPL	Stock	29.325	29.4125	29.2775	29.3375	22866292.0
2016-10-12 16:00:00	AAPL	Stock	29.3375	29.3475	29.265	29.32	6241088.0
2016-10-12 17:00:00	AAPL	Stock	29.315	29.335	29.2925	29.2925	221508.0
2016-10-12 18:00:00	AAPL	Stock	29.295	29.335	29.2925	29.295	64864.0
2016-10-12 19:00:00	AAPL	Stock	29.3	29.32	29.295	29.3075	28964.0
2016-10-12 07:00:00	MSFT	Stock	57.33	57.33	57.3	57.3	1200.0
2016-10-12 08:00:00	MSFT	Stock	57.3	57.3	57.18	57.19	6109.0
2016-10-12 09:00:00	MSFT	Stock	57.2	57.2	56.4	56.57	4122854.0
2016-10-12 10:00:00	MSFT	Stock	56.58	56.79	56.51	56.7	3383923.0
2016-10-12 11:00:00	MSFT	Stock	56.71	57.03	56.7	57.0	2330625.0
2016-10-12 12:00:00	MSFT	Stock	57.01	57.08	56.98	57.02	1473007.0
2016-10-12 13:00:00	MSFT	Stock	57.03	57.15	56.98	57.135	1376676.0
2016-10-12 14:00:00	MSFT	Stock	57.14	57.27	57.01	57.09	2318075.0
2016-10-12 15:00:00	MSFT	Stock	57.09	57.24	57.01	57.11	4736547.0
2016-10-12 16:00:00	MSFT	Stock	57.11	57.12	57.0	57.01	1408152.0
2016-10-12 17:00:00	MSFT	Stock	57.11	57.11	57.11	57.11	130595.0
2016-10-12 18:00:00	MSFT	Stock	57.09	57.09	57.09	57.09	100.0
2016-10-12 04:00:00	NVDA	Stock	1.6532	1.6532	1.6532	1.6532	4000.0
2016-10-12 08:00:00	NVDA	Stock	1.65	1.6532	1.65	1.6532	50000.0
2016-10-12 09:00:00	NVDA	Stock	1.6525	1.6525	1.6328	1.6468	38959440.0
2016-10-12 10:00:00	NVDA	Stock	1.6465	1.6659	1.6462	1.6633	47895360.0
2016-10-12 11:00:00	NVDA	Stock	1.6635	1.6686	1.6622	1.6642	33732600.0
2016-10-12 12:00:00	NVDA	Stock	1.6642	1.6695	1.6618	1.6665	20569200.0
2016-10-12 13:00:00	NVDA	Stock	1.6666	1.669	1.6632	1.6675	22212000.0
2016-10-12 14:00:00	NVDA	Stock	1.6672	1.6688	1.6618	1.6645	41771800.0
2016-10-12 15:00:00	NVDA	Stock	1.6645	1.6652	1.6589	1.6608	59701600.0
2016-10-12 16:00:00	NVDA	Stock	1.6608	1.6612	1.6595	1.6595	10432160.0
2016-10-12 17:00:00	NVDA	Stock	1.6595	1.6608	1.657	1.6608	304000.0
2016-10-12 06:00:00	AMZN	Stock	41.6765	41.6765	41.6765	41.6765	2000.0
2016-10-12 07:00:00	AMZN	Stock	41.65	41.65	41.65	41.65	34900.0
2016-10-12 08:00:00	AMZN	Stock	41.65	41.65	41.566	41.625	96280.0
2016-10-12 09:00:00	AMZN	Stock	41.6085	41.7495	41.505	41.724	7343000.0
2016-10-12 10:00:00	AMZN	Stock	41.7365	41.7905	41.6	41.6615	8636300.0
2016-10-12 11:00:00	AMZN	Stock	41.66	41.8833	41.6495	41.82	5244500.0
2016-10-12 12:00:00	AMZN	Stock	41.8205	41.8655	41.794	41.835	3134420.0
2016-10-12 13:00:00	AMZN	Stock	41.839	41.8557	41.718	41.7867	2942520.0
2016-10-12 14:00:00	AMZN	Stock	41.765	41.8645	41.724	41.727	3836940.0
2016-10-12 15:00:00	AMZN	Stock	41.727	41.759	41.642	41.705	7188360.0
2016-10-12 16:00:00	AMZN	Stock	41.7045	41.8101	41.68	41.68	3463300.0

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

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