PREVIEW / stock_1hour / 2018-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-16.parquet
  size:    1.1 MB
  rows:    49,187
  symbols: 2,746

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-11-16 04:00:00	AAPL	Stock	47.645	47.645	47.4775	47.5975	28100.0
2018-11-16 05:00:00	AAPL	Stock	47.5325	47.55	47.45	47.475	18328.0
2018-11-16 06:00:00	AAPL	Stock	47.45	47.5925	47.41	47.5	24268.0
2018-11-16 07:00:00	AAPL	Stock	47.5	47.5675	47.395	47.54	124616.0
2018-11-16 08:00:00	AAPL	Stock	47.4625	47.6	47.315	47.55	555392.0
2018-11-16 09:00:00	AAPL	Stock	47.5325	48.19	47.365	48.1525	20083156.0
2018-11-16 10:00:00	AAPL	Stock	48.1525	48.7425	48.0925	48.4342	31051972.0
2018-11-16 11:00:00	AAPL	Stock	48.4325	48.52	48.1325	48.2075	13518084.0
2018-11-16 12:00:00	AAPL	Stock	48.212	48.6275	48.0875	48.4112	13969872.0
2018-11-16 13:00:00	AAPL	Stock	48.4172	48.475	48.0578	48.1625	8184120.0
2018-11-16 14:00:00	AAPL	Stock	48.1575	48.5938	48.1175	48.5475	9666484.0
2018-11-16 15:00:00	AAPL	Stock	48.5472	48.6375	48.355	48.3825	19596080.0
2018-11-16 16:00:00	AAPL	Stock	48.3825	48.445	48.3775	48.425	11766008.0
2018-11-16 17:00:00	AAPL	Stock	48.4375	48.4675	48.42	48.4675	90576.0
2018-11-16 18:00:00	AAPL	Stock	48.4575	48.5	48.44	48.4975	59880.0
2018-11-16 19:00:00	AAPL	Stock	48.495	48.5	48.465	48.5	24972.0
2018-11-16 04:00:00	MSFT	Stock	106.7	106.7	106.7	106.7	500.0
2018-11-16 06:00:00	MSFT	Stock	106.4	106.4	106.13	106.13	2735.0
2018-11-16 07:00:00	MSFT	Stock	106.65	106.66	106.3	106.64	7075.0
2018-11-16 08:00:00	MSFT	Stock	106.4	106.69	106.0	106.69	38778.0
2018-11-16 09:00:00	MSFT	Stock	106.56	107.95	106.39	107.77	4920214.0
2018-11-16 10:00:00	MSFT	Stock	107.765	108.61	107.56	108.16	3756059.0
2018-11-16 11:00:00	MSFT	Stock	108.17	108.24	107.26	107.5	2846901.0
2018-11-16 12:00:00	MSFT	Stock	107.51	108.88	107.3	108.31	3408201.0
2018-11-16 13:00:00	MSFT	Stock	108.31	108.38	107.73	107.9	2815146.0
2018-11-16 14:00:00	MSFT	Stock	107.9	108.64	107.635	108.59	2628171.0
2018-11-16 15:00:00	MSFT	Stock	108.59	108.865	108.15	108.32	4388620.0
2018-11-16 16:00:00	MSFT	Stock	108.29	108.69	108.05	108.36	5801154.0
2018-11-16 17:00:00	MSFT	Stock	108.35	108.36	108.35	108.36	1412.0
2018-11-16 18:00:00	MSFT	Stock	108.45	108.49	108.36	108.47	3481.0
2018-11-16 19:00:00	MSFT	Stock	108.49	108.5	108.41	108.5	1963.0
2018-11-16 04:00:00	NVDA	Stock	4.2088	4.2555	4.1885	4.2425	1053040.0
2018-11-16 05:00:00	NVDA	Stock	4.2378	4.2418	4.1825	4.1875	672480.0
2018-11-16 06:00:00	NVDA	Stock	4.19	4.2025	4.1332	4.1528	1256000.0
2018-11-16 07:00:00	NVDA	Stock	4.1532	4.1938	4.1505	4.185	12259160.0
2018-11-16 08:00:00	NVDA	Stock	4.1825	4.1942	4.1145	4.157	29766200.0
2018-11-16 09:00:00	NVDA	Stock	4.1575	4.2275	4.0402	4.199	539047240.0
2018-11-16 10:00:00	NVDA	Stock	4.2	4.2665	4.1505	4.2152	347771880.0
2018-11-16 11:00:00	NVDA	Stock	4.216	4.23	4.128	4.1284	149212240.0
2018-11-16 12:00:00	NVDA	Stock	4.1284	4.1572	4.0888	4.1228	176040960.0
2018-11-16 13:00:00	NVDA	Stock	4.1232	4.13	4.075	4.0775	141690880.0
2018-11-16 14:00:00	NVDA	Stock	4.0772	4.1165	4.0772	4.0982	127072560.0
2018-11-16 15:00:00	NVDA	Stock	4.0986	4.117	4.0825	4.1095	186028600.0
2018-11-16 16:00:00	NVDA	Stock	4.1108	4.1315	4.1012	4.115	5607120.0
2018-11-16 17:00:00	NVDA	Stock	4.115	4.1245	4.115	4.115	583720.0
2018-11-16 18:00:00	NVDA	Stock	4.115	4.1242	4.114	4.1192	559440.0
2018-11-16 19:00:00	NVDA	Stock	4.1192	4.1245	4.1158	4.12	571040.0
2018-11-16 04:00:00	AMZN	Stock	80.223	80.223	80.2	80.2	10480.0
2018-11-16 05:00:00	AMZN	Stock	80.1445	80.1445	80.0	80.0	6500.0
2018-11-16 06:00:00	AMZN	Stock	79.97	80.0	79.805	80.0	19540.0

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

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