PREVIEW / stock_1hour / 2017-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-18.parquet
  size:    1.0 MB
  rows:    47,818
  symbols: 3,003

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-07-18 04:00:00	AAPL	Stock	37.3775	37.3775	37.375	37.375	8524.0
2017-07-18 05:00:00	AAPL	Stock	37.405	37.405	37.405	37.405	800.0
2017-07-18 06:00:00	AAPL	Stock	37.405	37.405	37.35	37.35	13480.0
2017-07-18 07:00:00	AAPL	Stock	37.35	37.38	37.275	37.275	98748.0
2017-07-18 08:00:00	AAPL	Stock	37.29	37.3725	37.2	37.215	284048.0
2017-07-18 09:00:00	AAPL	Stock	37.205	37.365	37.18	37.2075	9966904.0
2017-07-18 10:00:00	AAPL	Stock	37.21	37.335	37.1675	37.31	11646832.0
2017-07-18 11:00:00	AAPL	Stock	37.3075	37.3675	37.2525	37.32	6764176.0
2017-07-18 12:00:00	AAPL	Stock	37.32	37.435	37.275	37.42	6419244.0
2017-07-18 13:00:00	AAPL	Stock	37.4162	37.505	37.37	37.4685	5867656.0
2017-07-18 14:00:00	AAPL	Stock	37.4675	37.4725	37.37	37.405	6175960.0
2017-07-18 15:00:00	AAPL	Stock	37.405	37.5325	37.4	37.52	11354024.0
2017-07-18 16:00:00	AAPL	Stock	37.52	37.55	37.51	37.5375	4797136.0
2017-07-18 17:00:00	AAPL	Stock	37.5375	37.5625	37.5025	37.525	22424.0
2017-07-18 18:00:00	AAPL	Stock	37.52	37.525	37.5075	37.52	39320.0
2017-07-18 19:00:00	AAPL	Stock	37.525	37.55	37.5225	37.545	26656.0
2017-07-18 04:00:00	MSFT	Stock	73.52	73.52	73.52	73.52	100.0
2017-07-18 06:00:00	MSFT	Stock	73.49	73.57	73.49	73.57	1176.0
2017-07-18 07:00:00	MSFT	Stock	73.57	73.62	73.35	73.5	10241.0
2017-07-18 08:00:00	MSFT	Stock	73.5	73.56	73.3	73.34	78735.0
2017-07-18 09:00:00	MSFT	Stock	73.35	73.4	72.85	73.21	4429640.0
2017-07-18 10:00:00	MSFT	Stock	73.215	73.25	72.95	73.18	3730279.0
2017-07-18 11:00:00	MSFT	Stock	73.18	73.2	72.86	72.895	3273691.0
2017-07-18 12:00:00	MSFT	Stock	72.895	72.92	72.66	72.73	2381586.0
2017-07-18 13:00:00	MSFT	Stock	72.74	72.98	72.67	72.976	2248848.0
2017-07-18 14:00:00	MSFT	Stock	72.979	73.215	72.97	73.125	2064684.0
2017-07-18 15:00:00	MSFT	Stock	73.12	73.3	73.01	73.29	4238462.0
2017-07-18 16:00:00	MSFT	Stock	73.27	73.3	73.13	73.22	2133283.0
2017-07-18 17:00:00	MSFT	Stock	73.2	73.48	73.2	73.46	62635.0
2017-07-18 18:00:00	MSFT	Stock	73.45	73.49	73.4	73.48	8221.0
2017-07-18 19:00:00	MSFT	Stock	73.49	73.53	73.49	73.49	5640.0
2017-07-18 04:00:00	NVDA	Stock	4.1425	4.1425	4.0852	4.0875	159360.0
2017-07-18 05:00:00	NVDA	Stock	4.0875	4.095	4.0875	4.095	173080.0
2017-07-18 06:00:00	NVDA	Stock	4.0913	4.0913	4.0758	4.08	296520.0
2017-07-18 07:00:00	NVDA	Stock	4.0778	4.0825	4.0598	4.06	1506520.0
2017-07-18 08:00:00	NVDA	Stock	4.0662	4.0812	4.05	4.06	4497240.0
2017-07-18 09:00:00	NVDA	Stock	4.06	4.122	4.0325	4.1095	153363320.0
2017-07-18 10:00:00	NVDA	Stock	4.1098	4.1495	4.098	4.142	164877320.0
2017-07-18 11:00:00	NVDA	Stock	4.1434	4.1612	4.117	4.1255	104596200.0
2017-07-18 12:00:00	NVDA	Stock	4.1254	4.1343	4.1042	4.1242	65565360.0
2017-07-18 13:00:00	NVDA	Stock	4.125	4.1638	4.1242	4.1488	82262560.0
2017-07-18 14:00:00	NVDA	Stock	4.1487	4.149	4.1323	4.1355	47549960.0
2017-07-18 15:00:00	NVDA	Stock	4.1358	4.1605	4.1345	4.1498	92128480.0
2017-07-18 16:00:00	NVDA	Stock	4.149	4.154	4.1462	4.152	22372880.0
2017-07-18 17:00:00	NVDA	Stock	4.1515	4.154	4.15	4.154	288560.0
2017-07-18 18:00:00	NVDA	Stock	4.1545	4.1545	4.1508	4.1512	120320.0
2017-07-18 19:00:00	NVDA	Stock	4.1525	4.1538	4.1505	4.1505	425200.0
2017-07-18 04:00:00	AMZN	Stock	50.5325	50.6	50.5325	50.6	4060.0
2017-07-18 05:00:00	AMZN	Stock	50.55	50.55	50.55	50.55	4000.0
2017-07-18 07:00:00	AMZN	Stock	50.45	50.45	50.15	50.2235	201340.0

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

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