PREVIEW / stock_1hour / 2019-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-18.parquet
  size:    1.1 MB
  rows:    50,622
  symbols: 2,663

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
2019-03-18 04:00:00	AAPL	Stock	46.675	46.71	46.635	46.66	6872.0
2019-03-18 05:00:00	AAPL	Stock	46.65	46.65	46.605	46.6225	10588.0
2019-03-18 06:00:00	AAPL	Stock	46.62	46.625	46.525	46.525	7792.0
2019-03-18 07:00:00	AAPL	Stock	46.53	46.6025	46.47	46.525	159948.0
2019-03-18 08:00:00	AAPL	Stock	46.525	46.6475	46.4675	46.5	320360.0
2019-03-18 09:00:00	AAPL	Stock	46.51	46.9115	46.375	46.8325	15310280.0
2019-03-18 10:00:00	AAPL	Stock	46.83	47.0975	46.8225	47.055	18534020.0
2019-03-18 11:00:00	AAPL	Stock	47.055	47.0575	46.795	46.8925	11986416.0
2019-03-18 12:00:00	AAPL	Stock	46.8925	46.9175	46.755	46.855	7632644.0
2019-03-18 13:00:00	AAPL	Stock	46.85	47.025	46.825	47.025	6336140.0
2019-03-18 14:00:00	AAPL	Stock	47.022	47.0552	46.9275	46.9908	8472580.0
2019-03-18 15:00:00	AAPL	Stock	46.9925	47.0625	46.915	47.0075	12673092.0
2019-03-18 16:00:00	AAPL	Stock	46.99	47.0975	46.989	47.0775	10035004.0
2019-03-18 17:00:00	AAPL	Stock	47.0775	47.0775	47.05	47.0628	32392.0
2019-03-18 18:00:00	AAPL	Stock	47.0725	47.0925	47.07	47.0875	22516.0
2019-03-18 19:00:00	AAPL	Stock	47.0925	47.1	47.07	47.1	71820.0
2019-03-18 04:00:00	MSFT	Stock	116.5	116.5	116.5	116.5	889.0
2019-03-18 05:00:00	MSFT	Stock	116.45	116.5	116.3	116.47	2100.0
2019-03-18 06:00:00	MSFT	Stock	116.27	116.38	116.21	116.3	830.0
2019-03-18 07:00:00	MSFT	Stock	116.35	116.45	116.24	116.4	13480.0
2019-03-18 08:00:00	MSFT	Stock	116.3	116.5	116.1	116.1	34518.0
2019-03-18 09:00:00	MSFT	Stock	116.18	116.99	116.0	116.965	2659428.0
2019-03-18 10:00:00	MSFT	Stock	116.97	117.27	116.8	117.07	2831610.0
2019-03-18 11:00:00	MSFT	Stock	117.07	117.1	116.2	116.49	2812583.0
2019-03-18 12:00:00	MSFT	Stock	116.49	116.89	116.294	116.81	2030687.0
2019-03-18 13:00:00	MSFT	Stock	116.8	117.05	116.795	117.05	1527033.0
2019-03-18 14:00:00	MSFT	Stock	117.045	117.28	116.95	117.28	1739548.0
2019-03-18 15:00:00	MSFT	Stock	117.28	117.61	117.2	117.59	5134649.0
2019-03-18 16:00:00	MSFT	Stock	117.58	117.7	117.53	117.7	7719467.0
2019-03-18 17:00:00	MSFT	Stock	117.7	117.73	117.57	117.7	3727.0
2019-03-18 18:00:00	MSFT	Stock	117.7	117.77	117.64	117.64	2862.0
2019-03-18 19:00:00	MSFT	Stock	117.63	117.8	117.63	117.76	4742.0
2019-03-18 04:00:00	NVDA	Stock	4.2712	4.2835	4.2712	4.2835	34000.0
2019-03-18 05:00:00	NVDA	Stock	4.2838	4.2838	4.265	4.265	28000.0
2019-03-18 06:00:00	NVDA	Stock	4.2768	4.2825	4.269	4.2702	154640.0
2019-03-18 07:00:00	NVDA	Stock	4.275	4.2875	4.275	4.2848	280840.0
2019-03-18 08:00:00	NVDA	Stock	4.2845	4.2875	4.2563	4.275	1927560.0
2019-03-18 09:00:00	NVDA	Stock	4.2718	4.3312	4.2638	4.313	91738280.0
2019-03-18 10:00:00	NVDA	Stock	4.3138	4.3225	4.2515	4.2818	97903000.0
2019-03-18 11:00:00	NVDA	Stock	4.2828	4.2872	4.2075	4.2105	81173960.0
2019-03-18 12:00:00	NVDA	Stock	4.2108	4.2315	4.1965	4.229	60432800.0
2019-03-18 13:00:00	NVDA	Stock	4.2295	4.2432	4.211	4.2133	32830680.0
2019-03-18 14:00:00	NVDA	Stock	4.2133	4.3021	4.212	4.2338	27384480.0
2019-03-18 15:00:00	NVDA	Stock	4.2345	4.2385	4.216	4.2243	54303400.0
2019-03-18 16:00:00	NVDA	Stock	4.2238	4.233	4.2175	4.2288	4292640.0
2019-03-18 17:00:00	NVDA	Stock	4.23	4.2325	4.2255	4.2307	98840.0
2019-03-18 18:00:00	NVDA	Stock	4.2315	4.2395	4.23	4.23	252720.0
2019-03-18 19:00:00	NVDA	Stock	4.2312	4.2438	4.2307	4.2438	705280.0
2019-03-18 05:00:00	AMZN	Stock	85.7	85.7	85.7	85.7	2000.0
2019-03-18 07:00:00	AMZN	Stock	85.7	85.9	85.675	85.825	113860.0

> showing 50 of 50,622 rows — these rows as CSV

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