PREVIEW / stock_1hour / 2016-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-26.parquet
  size:    1.0 MB
  rows:    48,806
  symbols: 3,271

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-07-26 04:00:00	AAPL	Stock	24.2725	24.2725	24.2725	24.2725	28680.0
2016-07-26 05:00:00	AAPL	Stock	24.2725	24.29	24.2425	24.265	11080.0
2016-07-26 06:00:00	AAPL	Stock	24.2525	24.275	24.25	24.2625	11508.0
2016-07-26 07:00:00	AAPL	Stock	24.2625	24.5825	24.25	24.3	62496.0
2016-07-26 08:00:00	AAPL	Stock	24.2925	24.345	24.25	24.285	275736.0
2016-07-26 09:00:00	AAPL	Stock	24.2925	24.4925	24.195	24.415	23841056.0
2016-07-26 10:00:00	AAPL	Stock	24.42	24.4675	24.2275	24.2325	22714388.0
2016-07-26 11:00:00	AAPL	Stock	24.23	24.3075	24.215	24.3	20120096.0
2016-07-26 12:00:00	AAPL	Stock	24.3025	24.365	24.285	24.3275	12672388.0
2016-07-26 13:00:00	AAPL	Stock	24.3263	24.3375	24.2175	24.2225	14453968.0
2016-07-26 14:00:00	AAPL	Stock	24.2228	24.2438	24.1525	24.185	20199968.0
2016-07-26 15:00:00	AAPL	Stock	24.1855	24.22	24.105	24.168	34677068.0
2016-07-26 16:00:00	AAPL	Stock	24.1675	25.61	24.04	25.47	34528584.0
2016-07-26 17:00:00	AAPL	Stock	25.47	25.97	24.1675	25.7875	22010704.0
2016-07-26 18:00:00	AAPL	Stock	25.785	25.9225	25.7825	25.8925	3195800.0
2016-07-26 19:00:00	AAPL	Stock	25.895	25.8975	25.8075	25.8125	900476.0
2016-07-26 05:00:00	MSFT	Stock	56.5	56.5	56.5	56.5	483.0
2016-07-26 06:00:00	MSFT	Stock	56.5	56.64	56.49	56.5	1600.0
2016-07-26 07:00:00	MSFT	Stock	56.63	56.64	56.57	56.61	3550.0
2016-07-26 08:00:00	MSFT	Stock	56.57	56.63	56.57	56.61	4308.0
2016-07-26 09:00:00	MSFT	Stock	56.61	57.12	56.51	57.12	3924326.0
2016-07-26 10:00:00	MSFT	Stock	57.129	57.29	56.65	56.65	5586332.0
2016-07-26 11:00:00	MSFT	Stock	56.65	56.93	56.61	56.84	3180459.0
2016-07-26 12:00:00	MSFT	Stock	56.85	57.06	56.82	56.975	2263575.0
2016-07-26 13:00:00	MSFT	Stock	56.971	56.978	56.7	56.83	1939088.0
2016-07-26 14:00:00	MSFT	Stock	56.835	56.87	56.69	56.725	2023087.0
2016-07-26 15:00:00	MSFT	Stock	56.73	56.88	56.71	56.76	4528545.0
2016-07-26 16:00:00	MSFT	Stock	56.76	56.8	56.69	56.79	2691508.0
2016-07-26 17:00:00	MSFT	Stock	56.77	56.82	56.76	56.78	79257.0
2016-07-26 18:00:00	MSFT	Stock	56.8	56.9	56.79	56.9	24517.0
2016-07-26 19:00:00	MSFT	Stock	56.86	56.92	56.83	56.92	4651.0
2016-07-26 05:00:00	NVDA	Stock	1.4245	1.425	1.4245	1.425	72000.0
2016-07-26 07:00:00	NVDA	Stock	1.4033	1.4038	1.3988	1.3988	44400.0
2016-07-26 08:00:00	NVDA	Stock	1.3988	1.4033	1.3888	1.402	248960.0
2016-07-26 09:00:00	NVDA	Stock	1.4005	1.4175	1.4005	1.4168	57127240.0
2016-07-26 10:00:00	NVDA	Stock	1.4165	1.423	1.41	1.413	80178360.0
2016-07-26 11:00:00	NVDA	Stock	1.413	1.4153	1.4038	1.4082	61272760.0
2016-07-26 12:00:00	NVDA	Stock	1.4082	1.4136	1.4053	1.4108	28305560.0
2016-07-26 13:00:00	NVDA	Stock	1.4105	1.4105	1.4023	1.406	34528960.0
2016-07-26 14:00:00	NVDA	Stock	1.406	1.4228	1.404	1.4131	86883480.0
2016-07-26 15:00:00	NVDA	Stock	1.4133	1.4185	1.41	1.4158	64694040.0
2016-07-26 16:00:00	NVDA	Stock	1.4158	1.42	1.413	1.419	41062720.0
2016-07-26 17:00:00	NVDA	Stock	1.419	1.4233	1.419	1.4233	644960.0
2016-07-26 18:00:00	NVDA	Stock	1.4225	1.4313	1.4225	1.4275	238280.0
2016-07-26 19:00:00	NVDA	Stock	1.4262	1.427	1.4262	1.4262	122280.0
2016-07-26 05:00:00	AMZN	Stock	37.0095	37.0095	37.0095	37.0095	4000.0
2016-07-26 07:00:00	AMZN	Stock	37.067	37.15	37.067	37.1485	60340.0
2016-07-26 08:00:00	AMZN	Stock	37.1105	37.12	37.0585	37.084	67540.0
2016-07-26 09:00:00	AMZN	Stock	37.0635	37.1565	36.9095	37.019	5688140.0
2016-07-26 10:00:00	AMZN	Stock	37.025	37.0605	36.7905	36.8	7751640.0

> showing 50 of 48,806 rows — these rows as CSV

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