PREVIEW / stock_1hour / 2018-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-12.parquet
  size:    1.1 MB
  rows:    49,427
  symbols: 2,882

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-03-12 04:00:00	AAPL	Stock	45.025	45.25	45.025	45.2125	21544.0
2018-03-12 05:00:00	AAPL	Stock	45.215	45.2275	45.1375	45.2225	19444.0
2018-03-12 06:00:00	AAPL	Stock	45.22	45.22	45.1575	45.1575	9600.0
2018-03-12 07:00:00	AAPL	Stock	45.185	45.2	45.125	45.1625	324716.0
2018-03-12 08:00:00	AAPL	Stock	45.1625	45.2	45.075	45.0975	358696.0
2018-03-12 09:00:00	AAPL	Stock	45.09	45.48	45.0325	45.3475	19651536.0
2018-03-12 10:00:00	AAPL	Stock	45.35	45.55	45.3475	45.3975	23499536.0
2018-03-12 11:00:00	AAPL	Stock	45.4	45.4712	45.22	45.4712	14258200.0
2018-03-12 12:00:00	AAPL	Stock	45.4712	45.52	45.4125	45.4375	10414516.0
2018-03-12 13:00:00	AAPL	Stock	45.4375	45.545	45.402	45.4125	10534368.0
2018-03-12 14:00:00	AAPL	Stock	45.4165	45.45	45.265	45.4263	11265596.0
2018-03-12 15:00:00	AAPL	Stock	45.425	45.5975	45.385	45.4325	21657696.0
2018-03-12 16:00:00	AAPL	Stock	45.4325	45.4975	45.43	45.45	6267932.0
2018-03-12 17:00:00	AAPL	Stock	45.4575	45.475	45.445	45.4625	31948.0
2018-03-12 18:00:00	AAPL	Stock	45.465	45.475	45.4525	45.475	13164.0
2018-03-12 19:00:00	AAPL	Stock	45.475	45.475	45.445	45.4725	29196.0
2018-03-12 04:00:00	MSFT	Stock	97.0	97.0	96.86	96.86	1672.0
2018-03-12 05:00:00	MSFT	Stock	96.95	96.95	96.83	96.83	999.0
2018-03-12 06:00:00	MSFT	Stock	96.83	96.95	96.8	96.95	3211.0
2018-03-12 07:00:00	MSFT	Stock	96.96	97.1	96.78	96.81	20968.0
2018-03-12 08:00:00	MSFT	Stock	96.79	97.1	96.72	96.76	35839.0
2018-03-12 09:00:00	MSFT	Stock	96.8	96.91	96.04	96.88	2877180.0
2018-03-12 10:00:00	MSFT	Stock	96.885	96.9	96.23	96.31	3281135.0
2018-03-12 11:00:00	MSFT	Stock	96.32	96.525	96.065	96.5	2199676.0
2018-03-12 12:00:00	MSFT	Stock	96.505	96.85	96.495	96.75	1747681.0
2018-03-12 13:00:00	MSFT	Stock	96.755	97.13	96.74	96.945	2128328.0
2018-03-12 14:00:00	MSFT	Stock	96.945	97.09	96.575	96.687	1982335.0
2018-03-12 15:00:00	MSFT	Stock	96.69	97.21	96.65	96.76	4186418.0
2018-03-12 16:00:00	MSFT	Stock	96.77	96.87	96.59	96.7	2954639.0
2018-03-12 17:00:00	MSFT	Stock	96.62	96.77	96.62	96.77	10400.0
2018-03-12 18:00:00	MSFT	Stock	96.7	96.75	96.7	96.75	1323.0
2018-03-12 19:00:00	MSFT	Stock	96.77	96.79	96.7	96.7	1900.0
2018-03-12 04:00:00	NVDA	Stock	6.1633	6.1633	6.148	6.148	19200.0
2018-03-12 05:00:00	NVDA	Stock	6.1625	6.1668	6.1625	6.1668	56160.0
2018-03-12 06:00:00	NVDA	Stock	6.1743	6.1743	6.1652	6.1652	56080.0
2018-03-12 07:00:00	NVDA	Stock	6.1525	6.18	6.1525	6.175	972640.0
2018-03-12 08:00:00	NVDA	Stock	6.1575	6.18	6.1462	6.1698	1970760.0
2018-03-12 09:00:00	NVDA	Stock	6.1628	6.2822	6.1502	6.2757	135252880.0
2018-03-12 10:00:00	NVDA	Stock	6.275	6.325	6.2746	6.2972	137321720.0
2018-03-12 11:00:00	NVDA	Stock	6.2968	6.3102	6.2435	6.3012	85828760.0
2018-03-12 12:00:00	NVDA	Stock	6.3005	6.3075	6.2763	6.2901	46550560.0
2018-03-12 13:00:00	NVDA	Stock	6.2898	6.2913	6.2513	6.2518	45513800.0
2018-03-12 14:00:00	NVDA	Stock	6.2528	6.2738	6.228	6.2481	61678480.0
2018-03-12 15:00:00	NVDA	Stock	6.2472	6.2788	6.2375	6.244	71896120.0
2018-03-12 16:00:00	NVDA	Stock	6.244	6.2492	6.2425	6.243	2938120.0
2018-03-12 17:00:00	NVDA	Stock	6.2425	6.2522	6.2425	6.2462	742520.0
2018-03-12 18:00:00	NVDA	Stock	6.2462	6.2745	6.2462	6.2708	588840.0
2018-03-12 19:00:00	NVDA	Stock	6.2738	6.2738	6.2638	6.2673	289240.0
2018-03-12 04:00:00	AMZN	Stock	79.5	79.642	79.4015	79.48	31980.0
2018-03-12 05:00:00	AMZN	Stock	79.4255	79.55	79.4255	79.5465	8000.0

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

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