PREVIEW / stock_1hour / 2018-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-08.parquet
  size:    1.1 MB
  rows:    49,221
  symbols: 2,846

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
2018-05-08 04:00:00	AAPL	Stock	46.29	46.29	46.1625	46.1625	2600.0
2018-05-08 05:00:00	AAPL	Stock	46.0875	46.1125	46.05	46.1125	10800.0
2018-05-08 06:00:00	AAPL	Stock	46.075	46.1025	46.065	46.1025	18800.0
2018-05-08 07:00:00	AAPL	Stock	46.0875	46.235	46.04	46.2	220548.0
2018-05-08 08:00:00	AAPL	Stock	46.1625	46.2975	46.04	46.2975	514792.0
2018-05-08 09:00:00	AAPL	Stock	46.3	46.315	45.9162	46.0948	15205808.0
2018-05-08 10:00:00	AAPL	Stock	46.095	46.4125	46.0775	46.291	16518792.0
2018-05-08 11:00:00	AAPL	Stock	46.2878	46.555	46.24	46.3025	13140344.0
2018-05-08 12:00:00	AAPL	Stock	46.3	46.4075	46.215	46.2825	6999764.0
2018-05-08 13:00:00	AAPL	Stock	46.28	46.3725	46.25	46.265	6492360.0
2018-05-08 14:00:00	AAPL	Stock	46.265	46.4575	46.115	46.2425	13356728.0
2018-05-08 15:00:00	AAPL	Stock	46.24	46.5175	46.1612	46.51	15059036.0
2018-05-08 16:00:00	AAPL	Stock	46.5125	46.5125	46.16	46.5075	13615416.0
2018-05-08 17:00:00	AAPL	Stock	46.495	46.5125	46.485	46.49	43324.0
2018-05-08 18:00:00	AAPL	Stock	46.4875	46.52	46.4875	46.52	107052.0
2018-05-08 19:00:00	AAPL	Stock	46.505	46.525	46.49	46.5	54064.0
2018-05-08 04:00:00	MSFT	Stock	96.03	96.03	96.03	96.03	100.0
2018-05-08 05:00:00	MSFT	Stock	96.01	96.01	96.01	96.01	661.0
2018-05-08 06:00:00	MSFT	Stock	96.01	96.1	95.9	95.9	400.0
2018-05-08 07:00:00	MSFT	Stock	95.99	96.0	95.72	95.92	1856.0
2018-05-08 08:00:00	MSFT	Stock	95.78	96.41	95.78	96.12	26775.0
2018-05-08 09:00:00	MSFT	Stock	96.12	96.15	95.21	95.45	2381088.0
2018-05-08 10:00:00	MSFT	Stock	95.455	95.95	95.36	95.637	2428377.0
2018-05-08 11:00:00	MSFT	Stock	95.64	96.16	95.51	95.635	2408697.0
2018-05-08 12:00:00	MSFT	Stock	95.64	95.72	95.12	95.21	1599574.0
2018-05-08 13:00:00	MSFT	Stock	95.2	95.75	95.145	95.565	1824415.0
2018-05-08 14:00:00	MSFT	Stock	95.58	96.11	95.063	95.38	2974306.0
2018-05-08 15:00:00	MSFT	Stock	95.38	95.84	95.275	95.84	3660842.0
2018-05-08 16:00:00	MSFT	Stock	95.81	95.88	95.7	95.81	3394238.0
2018-05-08 17:00:00	MSFT	Stock	95.76	95.85	95.75	95.82	1971.0
2018-05-08 18:00:00	MSFT	Stock	95.82	95.84	95.73	95.8	2012.0
2018-05-08 19:00:00	MSFT	Stock	95.85	95.85	95.76	95.81	1539.0
2018-05-08 05:00:00	NVDA	Stock	6.1882	6.192	6.1882	6.192	52000.0
2018-05-08 06:00:00	NVDA	Stock	6.2	6.2	6.1865	6.1865	16000.0
2018-05-08 07:00:00	NVDA	Stock	6.1862	6.224	6.1862	6.224	869320.0
2018-05-08 08:00:00	NVDA	Stock	6.193	6.2698	6.1792	6.2688	4524720.0
2018-05-08 09:00:00	NVDA	Stock	6.2693	6.2698	6.1678	6.1895	101621760.0
2018-05-08 10:00:00	NVDA	Stock	6.1908	6.2432	6.1808	6.217	69201480.0
2018-05-08 11:00:00	NVDA	Stock	6.2166	6.2628	6.2133	6.2358	62025320.0
2018-05-08 12:00:00	NVDA	Stock	6.2362	6.239	6.206	6.2198	29342200.0
2018-05-08 13:00:00	NVDA	Stock	6.217	6.2411	6.2093	6.2118	35229400.0
2018-05-08 14:00:00	NVDA	Stock	6.211	6.2568	6.197	6.225	73359320.0
2018-05-08 15:00:00	NVDA	Stock	6.2245	6.2602	6.2158	6.2599	65980080.0
2018-05-08 16:00:00	NVDA	Stock	6.26	6.27	6.2575	6.2638	18398640.0
2018-05-08 17:00:00	NVDA	Stock	6.265	6.265	6.2605	6.2605	451720.0
2018-05-08 18:00:00	NVDA	Stock	6.2643	6.2688	6.2635	6.265	730680.0
2018-05-08 19:00:00	NVDA	Stock	6.2628	6.268	6.2628	6.2675	278600.0
2018-05-08 04:00:00	AMZN	Stock	79.7005	79.803	79.6705	79.6705	7700.0
2018-05-08 05:00:00	AMZN	Stock	79.6705	79.673	79.6675	79.6675	9720.0
2018-05-08 06:00:00	AMZN	Stock	79.6	79.6	79.6	79.6	10500.0

> showing 50 of 49,221 rows — these rows as CSV

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