PREVIEW / stock_1hour / 2016-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-10.parquet
  size:    1.0 MB
  rows:    46,912
  symbols: 3,177

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-10 04:00:00	AAPL	Stock	28.5625	28.6	28.5625	28.6	8680.0
2016-10-10 05:00:00	AAPL	Stock	28.6	28.6125	28.6	28.6	10680.0
2016-10-10 06:00:00	AAPL	Stock	28.6175	28.725	28.6175	28.6975	81844.0
2016-10-10 07:00:00	AAPL	Stock	28.6975	28.7875	28.6975	28.745	303560.0
2016-10-10 08:00:00	AAPL	Stock	28.75	28.85	28.7	28.8375	1055776.0
2016-10-10 09:00:00	AAPL	Stock	28.84	28.9925	28.68	28.955	28315644.0
2016-10-10 10:00:00	AAPL	Stock	28.9538	29.105	28.9202	29.0725	27735240.0
2016-10-10 11:00:00	AAPL	Stock	29.0712	29.1175	29.016	29.0925	14294008.0
2016-10-10 12:00:00	AAPL	Stock	29.0902	29.095	29.0425	29.078	9806280.0
2016-10-10 13:00:00	AAPL	Stock	29.0788	29.155	29.0725	29.1262	13571372.0
2016-10-10 14:00:00	AAPL	Stock	29.1275	29.1875	29.1088	29.15	10959552.0
2016-10-10 15:00:00	AAPL	Stock	29.1475	29.1525	29.0	29.0125	20980244.0
2016-10-10 16:00:00	AAPL	Stock	29.0125	29.0538	29.0	29.0425	7267860.0
2016-10-10 17:00:00	AAPL	Stock	29.035	29.0375	29.0125	29.0375	693884.0
2016-10-10 18:00:00	AAPL	Stock	29.0375	29.1075	29.03	29.09	202168.0
2016-10-10 19:00:00	AAPL	Stock	29.0825	29.1125	29.08	29.09	161648.0
2016-10-10 07:00:00	MSFT	Stock	57.7	58.0	57.7	58.0	600.0
2016-10-10 08:00:00	MSFT	Stock	57.93	58.04	57.93	58.04	6403.0
2016-10-10 09:00:00	MSFT	Stock	58.06	58.3	57.91	58.29	2703601.0
2016-10-10 10:00:00	MSFT	Stock	58.3	58.39	58.215	58.299	2492591.0
2016-10-10 11:00:00	MSFT	Stock	58.29	58.32	58.06	58.13	2410810.0
2016-10-10 12:00:00	MSFT	Stock	58.125	58.14	57.97	58.03	1523491.0
2016-10-10 13:00:00	MSFT	Stock	58.03	58.06	57.87	58.01	1900437.0
2016-10-10 14:00:00	MSFT	Stock	58.01	58.16	57.98	58.1	1803489.0
2016-10-10 15:00:00	MSFT	Stock	58.11	58.16	58.04	58.05	3185533.0
2016-10-10 16:00:00	MSFT	Stock	58.04	58.1	58.04	58.1	1092630.0
2016-10-10 17:00:00	MSFT	Stock	58.13	58.13	58.04	58.1	77731.0
2016-10-10 18:00:00	MSFT	Stock	58.04	58.04	58.04	58.04	32667.0
2016-10-10 19:00:00	MSFT	Stock	58.07	58.08	58.07	58.08	675.0
2016-10-10 07:00:00	NVDA	Stock	1.691	1.691	1.691	1.691	24000.0
2016-10-10 08:00:00	NVDA	Stock	1.68	1.6812	1.68	1.68	89200.0
2016-10-10 09:00:00	NVDA	Stock	1.68	1.687	1.675	1.682	27541520.0
2016-10-10 10:00:00	NVDA	Stock	1.682	1.6844	1.6725	1.6735	35502920.0
2016-10-10 11:00:00	NVDA	Stock	1.6738	1.674	1.6618	1.6655	42144320.0
2016-10-10 12:00:00	NVDA	Stock	1.6655	1.6708	1.6635	1.6685	22148080.0
2016-10-10 13:00:00	NVDA	Stock	1.6685	1.6728	1.668	1.672	19599160.0
2016-10-10 14:00:00	NVDA	Stock	1.672	1.6733	1.6705	1.6719	18454240.0
2016-10-10 15:00:00	NVDA	Stock	1.6718	1.689	1.671	1.6773	85887440.0
2016-10-10 16:00:00	NVDA	Stock	1.6775	1.6775	1.6765	1.6775	8589680.0
2016-10-10 17:00:00	NVDA	Stock	1.6775	1.6775	1.6775	1.6775	126000.0
2016-10-10 18:00:00	NVDA	Stock	1.6775	1.6823	1.6775	1.6823	316000.0
2016-10-10 19:00:00	NVDA	Stock	1.6775	1.6825	1.6775	1.6823	68400.0
2016-10-10 04:00:00	AMZN	Stock	42.163	42.205	42.163	42.205	5000.0
2016-10-10 05:00:00	AMZN	Stock	42.18	42.18	42.18	42.18	2000.0
2016-10-10 06:00:00	AMZN	Stock	42.2695	42.313	42.225	42.2315	67760.0
2016-10-10 07:00:00	AMZN	Stock	42.2255	42.2255	42.175	42.175	71180.0
2016-10-10 08:00:00	AMZN	Stock	42.225	42.225	42.108	42.175	74260.0
2016-10-10 09:00:00	AMZN	Stock	42.155	42.227	42.0135	42.157	6511900.0
2016-10-10 10:00:00	AMZN	Stock	42.1575	42.26	42.1335	42.23	5995660.0
2016-10-10 11:00:00	AMZN	Stock	42.2345	42.2449	42.1545	42.171	3146480.0

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

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