PREVIEW / stock_1hour / 2019-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-15.parquet
  size:    1.1 MB
  rows:    50,121
  symbols: 2,652

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-15 04:00:00	AAPL	Stock	46.0625	46.3325	46.0625	46.175	73004.0
2019-03-15 05:00:00	AAPL	Stock	46.1725	46.175	46.125	46.175	20640.0
2019-03-15 06:00:00	AAPL	Stock	46.175	46.2925	46.1675	46.285	18108.0
2019-03-15 07:00:00	AAPL	Stock	46.28	46.28	46.18	46.225	165816.0
2019-03-15 08:00:00	AAPL	Stock	46.2495	46.3125	46.05	46.1625	422392.0
2019-03-15 09:00:00	AAPL	Stock	46.1625	46.2475	45.935	46.2275	36230500.0
2019-03-15 10:00:00	AAPL	Stock	46.2275	46.4175	46.1075	46.41	16335444.0
2019-03-15 11:00:00	AAPL	Stock	46.4125	46.6275	46.38	46.6025	15014308.0
2019-03-15 12:00:00	AAPL	Stock	46.6025	46.745	46.57	46.6112	11955992.0
2019-03-15 13:00:00	AAPL	Stock	46.615	46.8125	46.6075	46.7962	8589564.0
2019-03-15 14:00:00	AAPL	Stock	46.795	46.8025	46.67	46.7775	9668524.0
2019-03-15 15:00:00	AAPL	Stock	46.7775	46.8325	46.4725	46.5525	22328308.0
2019-03-15 16:00:00	AAPL	Stock	46.53	46.6178	46.4925	46.505	18333416.0
2019-03-15 17:00:00	AAPL	Stock	46.505	46.5075	46.475	46.475	78788.0
2019-03-15 18:00:00	AAPL	Stock	46.465	46.4875	46.445	46.4825	17688.0
2019-03-15 19:00:00	AAPL	Stock	46.4875	46.4875	46.47	46.47	44272.0
2019-03-15 04:00:00	MSFT	Stock	115.17	115.17	114.58	114.58	200.0
2019-03-15 05:00:00	MSFT	Stock	114.66	115.02	114.6	115.02	2326.0
2019-03-15 06:00:00	MSFT	Stock	115.03	115.35	115.03	115.35	4086.0
2019-03-15 07:00:00	MSFT	Stock	115.35	115.38	115.2	115.21	4838.0
2019-03-15 08:00:00	MSFT	Stock	115.431	115.431	115.0	115.02	24492.0
2019-03-15 09:00:00	MSFT	Stock	115.03	115.88	114.71	115.85	11945375.0
2019-03-15 10:00:00	MSFT	Stock	115.84	116.72	115.54	116.67	4342160.0
2019-03-15 11:00:00	MSFT	Stock	116.675	117.07	116.511	116.74	4032663.0
2019-03-15 12:00:00	MSFT	Stock	116.745	117.25	116.64	116.97	2882154.0
2019-03-15 13:00:00	MSFT	Stock	116.98	117.16	116.85	116.961	2219112.0
2019-03-15 14:00:00	MSFT	Stock	116.965	116.99	116.75	116.81	2290766.0
2019-03-15 15:00:00	MSFT	Stock	116.805	116.81	114.59	115.9	7032572.0
2019-03-15 16:00:00	MSFT	Stock	115.9	116.39	115.61	116.02	13155800.0
2019-03-15 17:00:00	MSFT	Stock	116.0	116.04	115.98	115.98	34046.0
2019-03-15 18:00:00	MSFT	Stock	116.03	116.03	115.97	116.03	1280.0
2019-03-15 19:00:00	MSFT	Stock	116.05	116.05	116.05	116.05	1905.0
2019-03-15 05:00:00	NVDA	Stock	4.17	4.17	4.1695	4.1695	46720.0
2019-03-15 06:00:00	NVDA	Stock	4.1675	4.1675	4.1675	4.1675	36000.0
2019-03-15 07:00:00	NVDA	Stock	4.1752	4.1873	4.1745	4.1812	396760.0
2019-03-15 08:00:00	NVDA	Stock	4.1802	4.1875	4.1492	4.1862	2799680.0
2019-03-15 09:00:00	NVDA	Stock	4.1838	4.2883	4.1678	4.2702	158305840.0
2019-03-15 10:00:00	NVDA	Stock	4.2709	4.2825	4.2358	4.261	104087480.0
2019-03-15 11:00:00	NVDA	Stock	4.2612	4.285	4.2382	4.2495	73160760.0
2019-03-15 12:00:00	NVDA	Stock	4.2486	4.2635	4.2422	4.2475	42316200.0
2019-03-15 13:00:00	NVDA	Stock	4.248	4.2638	4.2448	4.2513	33575000.0
2019-03-15 14:00:00	NVDA	Stock	4.2518	4.2585	4.241	4.249	33685760.0
2019-03-15 15:00:00	NVDA	Stock	4.2498	4.2541	4.2345	4.2455	78256600.0
2019-03-15 16:00:00	NVDA	Stock	4.2453	4.2525	4.245	4.2513	5568120.0
2019-03-15 17:00:00	NVDA	Stock	4.2488	4.2575	4.2488	4.2575	698680.0
2019-03-15 18:00:00	NVDA	Stock	4.2588	4.2588	4.25	4.258	137320.0
2019-03-15 19:00:00	NVDA	Stock	4.2578	4.2612	4.2538	4.2612	470680.0
2019-03-15 04:00:00	AMZN	Stock	85.3	85.55	85.3	85.4335	17600.0
2019-03-15 05:00:00	AMZN	Stock	85.462	85.462	85.399	85.45	22000.0
2019-03-15 06:00:00	AMZN	Stock	85.5	85.5025	85.5	85.5025	36000.0

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

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