PREVIEW / stock_1hour / 2016-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-27.parquet
  size:    1.0 MB
  rows:    47,908
  symbols: 3,205

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-09-27 04:00:00	AAPL	Stock	28.385	28.385	28.2275	28.2275	11020.0
2016-09-27 05:00:00	AAPL	Stock	28.2825	28.2875	28.2825	28.2875	2056.0
2016-09-27 06:00:00	AAPL	Stock	28.22	28.32	28.21	28.32	53720.0
2016-09-27 07:00:00	AAPL	Stock	28.31	28.375	28.265	28.3475	117380.0
2016-09-27 08:00:00	AAPL	Stock	28.3625	28.3625	28.1625	28.295	383588.0
2016-09-27 09:00:00	AAPL	Stock	28.2825	28.2825	28.1125	28.1925	17119000.0
2016-09-27 10:00:00	AAPL	Stock	28.1912	28.285	28.1302	28.1422	16146028.0
2016-09-27 11:00:00	AAPL	Stock	28.1425	28.2172	28.085	28.1925	9743256.0
2016-09-27 12:00:00	AAPL	Stock	28.1925	28.2475	28.145	28.215	8371452.0
2016-09-27 13:00:00	AAPL	Stock	28.215	28.234	28.1725	28.215	6405892.0
2016-09-27 14:00:00	AAPL	Stock	28.2125	28.28	28.2025	28.24	8383340.0
2016-09-27 15:00:00	AAPL	Stock	28.24	28.295	28.2325	28.2775	13525584.0
2016-09-27 16:00:00	AAPL	Stock	28.2725	28.2925	28.1828	28.27	9335280.0
2016-09-27 17:00:00	AAPL	Stock	28.27	28.2725	28.2525	28.27	16764.0
2016-09-27 18:00:00	AAPL	Stock	28.2725	28.275	28.26	28.2725	18952.0
2016-09-27 19:00:00	AAPL	Stock	28.2725	28.2725	28.26	28.2625	18920.0
2016-09-27 07:00:00	MSFT	Stock	57.37	57.37	57.37	57.37	1000.0
2016-09-27 08:00:00	MSFT	Stock	57.01	57.14	56.9	56.98	2557.0
2016-09-27 09:00:00	MSFT	Stock	56.91	57.245	56.681	57.24	2731188.0
2016-09-27 10:00:00	MSFT	Stock	57.24	57.44	57.2	57.23	3421675.0
2016-09-27 11:00:00	MSFT	Stock	57.24	57.6	57.22	57.596	2135124.0
2016-09-27 12:00:00	MSFT	Stock	57.6	57.82	57.47	57.815	3326424.0
2016-09-27 13:00:00	MSFT	Stock	57.815	57.985	57.68	57.98	3171169.0
2016-09-27 14:00:00	MSFT	Stock	57.976	58.06	57.88	57.905	3315467.0
2016-09-27 15:00:00	MSFT	Stock	57.905	58.0	57.79	57.97	4945965.0
2016-09-27 16:00:00	MSFT	Stock	57.95	57.97	57.8	57.85	3225755.0
2016-09-27 17:00:00	MSFT	Stock	57.85	57.85	57.82	57.83	1375.0
2016-09-27 18:00:00	MSFT	Stock	57.93	57.93	57.83	57.83	1842.0
2016-09-27 19:00:00	MSFT	Stock	57.92	57.93	57.83	57.9	1900.0
2016-09-27 08:00:00	NVDA	Stock	1.6163	1.6175	1.6082	1.6082	143400.0
2016-09-27 09:00:00	NVDA	Stock	1.605	1.6375	1.6	1.6361	46818320.0
2016-09-27 10:00:00	NVDA	Stock	1.6366	1.65	1.6353	1.6365	72743800.0
2016-09-27 11:00:00	NVDA	Stock	1.6365	1.6568	1.6358	1.6558	58580360.0
2016-09-27 12:00:00	NVDA	Stock	1.6558	1.6622	1.6555	1.6619	47194000.0
2016-09-27 13:00:00	NVDA	Stock	1.662	1.666	1.6598	1.6632	36988360.0
2016-09-27 14:00:00	NVDA	Stock	1.6632	1.6648	1.6573	1.6605	44629120.0
2016-09-27 15:00:00	NVDA	Stock	1.6602	1.6641	1.6588	1.6635	75078960.0
2016-09-27 16:00:00	NVDA	Stock	1.6635	1.665	1.6371	1.664	2701600.0
2016-09-27 17:00:00	NVDA	Stock	1.6642	1.665	1.6615	1.6615	156400.0
2016-09-27 18:00:00	NVDA	Stock	1.6615	1.6615	1.6615	1.6615	28000.0
2016-09-27 19:00:00	NVDA	Stock	1.6615	1.6615	1.6585	1.6615	78400.0
2016-09-27 04:00:00	AMZN	Stock	40.275	40.275	40.25	40.25	6000.0
2016-09-27 05:00:00	AMZN	Stock	40.1	40.1	40.0955	40.0955	12000.0
2016-09-27 07:00:00	AMZN	Stock	40.15	40.4	40.15	40.2	74000.0
2016-09-27 08:00:00	AMZN	Stock	40.16	40.2345	39.88	40.156	325960.0
2016-09-27 09:00:00	AMZN	Stock	40.1535	40.42	40.0555	40.4098	9092980.0
2016-09-27 10:00:00	AMZN	Stock	40.401	40.5686	40.401	40.482	11653440.0
2016-09-27 11:00:00	AMZN	Stock	40.4825	40.63	40.464	40.577	6343240.0
2016-09-27 12:00:00	AMZN	Stock	40.5785	40.786	40.57	40.72	5515620.0
2016-09-27 13:00:00	AMZN	Stock	40.714	40.825	40.6905	40.7905	4068420.0

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

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