PREVIEW / stock_1hour / 2017-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-03.parquet
  size:    1.0 MB
  rows:    47,625
  symbols: 3,065

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
2017-03-03 05:00:00	AAPL	Stock	34.72	34.72	34.72	34.72	604.0
2017-03-03 06:00:00	AAPL	Stock	34.7175	34.745	34.7125	34.7125	6184.0
2017-03-03 07:00:00	AAPL	Stock	34.7125	34.725	34.6375	34.6575	54632.0
2017-03-03 08:00:00	AAPL	Stock	34.725	34.7375	34.645	34.6575	163724.0
2017-03-03 09:00:00	AAPL	Stock	34.6575	34.835	34.6475	34.783	11403908.0
2017-03-03 10:00:00	AAPL	Stock	34.785	34.8375	34.715	34.7525	9680352.0
2017-03-03 11:00:00	AAPL	Stock	34.7525	34.8075	34.7225	34.7925	6528248.0
2017-03-03 12:00:00	AAPL	Stock	34.7925	34.8825	34.7738	34.8675	6937448.0
2017-03-03 13:00:00	AAPL	Stock	34.865	34.9575	34.825	34.92	8467172.0
2017-03-03 14:00:00	AAPL	Stock	34.9175	34.9575	34.865	34.9038	6393880.0
2017-03-03 15:00:00	AAPL	Stock	34.905	34.945	34.89	34.9425	13660632.0
2017-03-03 16:00:00	AAPL	Stock	34.9475	34.9475	34.8175	34.8775	11079728.0
2017-03-03 17:00:00	AAPL	Stock	34.8775	34.92	34.8775	34.91	15280.0
2017-03-03 18:00:00	AAPL	Stock	34.895	34.9225	34.8925	34.9225	19196.0
2017-03-03 19:00:00	AAPL	Stock	34.91	34.9225	34.91	34.92	36328.0
2017-03-03 07:00:00	MSFT	Stock	64.0	64.0	63.9	63.9	200.0
2017-03-03 08:00:00	MSFT	Stock	63.88	64.0	63.88	63.9	503.0
2017-03-03 09:00:00	MSFT	Stock	63.9	64.15	63.87	63.955	2048617.0
2017-03-03 10:00:00	MSFT	Stock	63.96	63.99	63.62	63.835	2812832.0
2017-03-03 11:00:00	MSFT	Stock	63.83	63.93	63.75	63.92	1651623.0
2017-03-03 12:00:00	MSFT	Stock	63.915	64.08	63.9	64.04	1321001.0
2017-03-03 13:00:00	MSFT	Stock	64.03	64.12	63.93	64.09	1321959.0
2017-03-03 14:00:00	MSFT	Stock	64.085	64.25	64.08	64.227	1567277.0
2017-03-03 15:00:00	MSFT	Stock	64.23	64.28	64.11	64.23	4132211.0
2017-03-03 16:00:00	MSFT	Stock	64.22	64.26	64.16	64.26	2279428.0
2017-03-03 17:00:00	MSFT	Stock	64.16	64.16	64.16	64.16	193.0
2017-03-03 18:00:00	MSFT	Stock	64.17	64.17	64.17	64.17	115.0
2017-03-03 19:00:00	MSFT	Stock	64.17	64.17	64.17	64.17	1000.0
2017-03-03 04:00:00	NVDA	Stock	2.4663	2.4663	2.4663	2.4663	4000.0
2017-03-03 05:00:00	NVDA	Stock	2.4528	2.4528	2.4528	2.4528	6960.0
2017-03-03 06:00:00	NVDA	Stock	2.455	2.4625	2.455	2.462	52000.0
2017-03-03 07:00:00	NVDA	Stock	2.462	2.475	2.4443	2.4625	676320.0
2017-03-03 08:00:00	NVDA	Stock	2.4563	2.485	2.4538	2.47	2037960.0
2017-03-03 09:00:00	NVDA	Stock	2.467	2.467	2.4055	2.4095	195272880.0
2017-03-03 10:00:00	NVDA	Stock	2.4102	2.467	2.408	2.4559	223052120.0
2017-03-03 11:00:00	NVDA	Stock	2.4557	2.4692	2.448	2.4625	114390400.0
2017-03-03 12:00:00	NVDA	Stock	2.4625	2.4626	2.4433	2.4518	86669040.0
2017-03-03 13:00:00	NVDA	Stock	2.4518	2.4572	2.4443	2.4548	43820720.0
2017-03-03 14:00:00	NVDA	Stock	2.4545	2.4648	2.4532	2.4635	48004720.0
2017-03-03 15:00:00	NVDA	Stock	2.4638	2.4652	2.4575	2.4608	102204120.0
2017-03-03 16:00:00	NVDA	Stock	2.4608	2.4608	2.4575	2.4605	20314800.0
2017-03-03 17:00:00	NVDA	Stock	2.4612	2.4612	2.459	2.459	234240.0
2017-03-03 18:00:00	NVDA	Stock	2.459	2.4625	2.459	2.4612	70480.0
2017-03-03 19:00:00	NVDA	Stock	2.4612	2.4638	2.4612	2.4638	42200.0
2017-03-03 06:00:00	AMZN	Stock	42.4	42.4	42.4	42.4	4000.0
2017-03-03 08:00:00	AMZN	Stock	42.375	42.435	42.3	42.3685	172980.0
2017-03-03 09:00:00	AMZN	Stock	42.372	42.5993	42.3135	42.4655	5415320.0
2017-03-03 10:00:00	AMZN	Stock	42.4605	42.4952	42.3509	42.4385	4093920.0
2017-03-03 11:00:00	AMZN	Stock	42.438	42.499	42.4086	42.4555	3674900.0
2017-03-03 12:00:00	AMZN	Stock	42.4615	42.544	42.4238	42.5135	4158420.0

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

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