PREVIEW / stock_1hour / 2020-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-27.parquet
  size:    1.2 MB
  rows:    55,958
  symbols: 2,449

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
2020-08-27 04:00:00	AAPL	Stock	126.5275	126.645	126.3825	126.4225	18208.0
2020-08-27 05:00:00	AAPL	Stock	126.36	126.36	126.005	126.325	13652.0
2020-08-27 06:00:00	AAPL	Stock	126.325	126.375	126.2925	126.375	25612.0
2020-08-27 07:00:00	AAPL	Stock	126.375	127.4675	126.29	127.1375	623140.0
2020-08-27 08:00:00	AAPL	Stock	126.825	127.445	126.2625	126.985	630484.0
2020-08-27 09:00:00	AAPL	Stock	126.9725	127.485	126.25	126.7568	16923724.0
2020-08-27 10:00:00	AAPL	Stock	126.7662	126.8375	125.715	126.1962	18313632.0
2020-08-27 11:00:00	AAPL	Stock	126.19	126.44	125.895	126.1828	9917720.0
2020-08-27 12:00:00	AAPL	Stock	126.1925	126.21	123.8325	124.405	20476204.0
2020-08-27 13:00:00	AAPL	Stock	124.3725	125.4325	124.04	125.3788	15816232.0
2020-08-27 14:00:00	AAPL	Stock	125.3875	125.865	125.2725	125.665	11284964.0
2020-08-27 15:00:00	AAPL	Stock	125.6588	125.8	124.9925	125.01	16314556.0
2020-08-27 16:00:00	AAPL	Stock	125.01	125.25	125.01	125.1	5840576.0
2020-08-27 17:00:00	AAPL	Stock	125.1	125.1075	124.8	124.9125	251132.0
2020-08-27 18:00:00	AAPL	Stock	124.9125	125.0375	124.77	125.0	140960.0
2020-08-27 19:00:00	AAPL	Stock	125.0	125.225	124.9125	125.225	248776.0
2020-08-27 04:00:00	MSFT	Stock	221.21	221.5	221.0	221.0	5965.0
2020-08-27 05:00:00	MSFT	Stock	220.92	221.17	220.5	221.0	7276.0
2020-08-27 06:00:00	MSFT	Stock	221.16	221.77	221.0	221.33	4794.0
2020-08-27 07:00:00	MSFT	Stock	221.08	221.52	219.99	220.45	21855.0
2020-08-27 08:00:00	MSFT	Stock	221.018	221.7	220.0	220.75	32566.0
2020-08-27 09:00:00	MSFT	Stock	220.71	230.44	219.4	228.5	9158157.0
2020-08-27 10:00:00	MSFT	Stock	228.45	231.15	225.0	229.405	12920485.0
2020-08-27 11:00:00	MSFT	Stock	229.4	230.07	228.08	229.42	5257324.0
2020-08-27 12:00:00	MSFT	Stock	229.443	229.443	224.23	225.22	5073308.0
2020-08-27 13:00:00	MSFT	Stock	225.22	227.286	224.73	227.286	3518266.0
2020-08-27 14:00:00	MSFT	Stock	227.25	228.7	226.91	227.93	2990752.0
2020-08-27 15:00:00	MSFT	Stock	227.93	229.06	226.41	226.56	5376563.0
2020-08-27 16:00:00	MSFT	Stock	226.58	227.56	226.32	227.19	3985344.0
2020-08-27 17:00:00	MSFT	Stock	227.13	227.6	227.05	227.22	36059.0
2020-08-27 18:00:00	MSFT	Stock	227.24	228.65	227.24	228.65	31643.0
2020-08-27 19:00:00	MSFT	Stock	228.8	228.8	228.25	228.35	28319.0
2020-08-27 04:00:00	NVDA	Stock	12.7805	12.791	12.775	12.791	17080.0
2020-08-27 05:00:00	NVDA	Stock	12.775	12.7763	12.775	12.7763	8000.0
2020-08-27 06:00:00	NVDA	Stock	12.7503	12.7503	12.7463	12.7463	34000.0
2020-08-27 07:00:00	NVDA	Stock	12.7438	12.7725	12.7188	12.742	336440.0
2020-08-27 08:00:00	NVDA	Stock	12.7498	12.8048	12.7318	12.7575	447280.0
2020-08-27 09:00:00	NVDA	Stock	12.7505	12.8576	12.71	12.7241	55006520.0
2020-08-27 10:00:00	NVDA	Stock	12.7278	12.8008	12.65	12.783	48623920.0
2020-08-27 11:00:00	NVDA	Stock	12.7818	12.8202	12.75	12.7642	27343880.0
2020-08-27 12:00:00	NVDA	Stock	12.764	12.764	12.5865	12.6046	39533440.0
2020-08-27 13:00:00	NVDA	Stock	12.601	12.683	12.5664	12.6766	21008040.0
2020-08-27 14:00:00	NVDA	Stock	12.6745	12.7444	12.6684	12.708	16825360.0
2020-08-27 15:00:00	NVDA	Stock	12.7098	12.7295	12.6	12.6295	41196640.0
2020-08-27 16:00:00	NVDA	Stock	12.6283	12.6488	12.6078	12.62	15275720.0
2020-08-27 17:00:00	NVDA	Stock	12.62	12.625	12.5995	12.5995	389120.0
2020-08-27 18:00:00	NVDA	Stock	12.605	12.605	12.575	12.593	947440.0
2020-08-27 19:00:00	NVDA	Stock	12.5825	12.6035	12.5788	12.6035	302120.0
2020-08-27 07:00:00	AMZN	Stock	171.59	171.6525	171.305	171.484	158340.0
2020-08-27 08:00:00	AMZN	Stock	171.8129	172.5225	171.4	171.875	156520.0

> showing 50 of 55,958 rows — these rows as CSV

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