PREVIEW / stock_1hour / 2020-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-22.parquet
  size:    1.2 MB
  rows:    56,544
  symbols: 2,502

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-09-22 04:00:00	AAPL	Stock	111.0	111.0	110.0	110.63	68777.0
2020-09-22 05:00:00	AAPL	Stock	110.64	111.52	110.58	111.44	65790.0
2020-09-22 06:00:00	AAPL	Stock	111.42	111.68	111.0	111.19	60211.0
2020-09-22 07:00:00	AAPL	Stock	111.26	111.99	110.8	111.03	706882.0
2020-09-22 08:00:00	AAPL	Stock	111.03	112.37	110.8	112.17	1877338.0
2020-09-22 09:00:00	AAPL	Stock	112.16	112.94	110.27	111.45	26440618.0
2020-09-22 10:00:00	AAPL	Stock	111.43	111.86	109.4	109.44	27815102.0
2020-09-22 11:00:00	AAPL	Stock	109.46	110.39	109.16	110.04	18846200.0
2020-09-22 12:00:00	AAPL	Stock	110.04	110.67	109.47	109.82	15327245.0
2020-09-22 13:00:00	AAPL	Stock	109.828	110.7	109.68	110.65	15009581.0
2020-09-22 14:00:00	AAPL	Stock	110.66	111.45	110.47	110.868	19095562.0
2020-09-22 15:00:00	AAPL	Stock	110.866	112.45	110.68	111.8	30609483.0
2020-09-22 16:00:00	AAPL	Stock	111.81	111.92	111.21	111.5	8024277.0
2020-09-22 17:00:00	AAPL	Stock	111.55	111.81	111.3	111.53	200251.0
2020-09-22 18:00:00	AAPL	Stock	111.58	111.69	110.93	111.02	258603.0
2020-09-22 19:00:00	AAPL	Stock	111.01	111.1	110.5	110.6	430376.0
2020-09-22 04:00:00	MSFT	Stock	203.0	203.55	203.0	203.1	8968.0
2020-09-22 05:00:00	MSFT	Stock	203.1	205.0	203.1	204.62	8073.0
2020-09-22 06:00:00	MSFT	Stock	204.66	205.0	204.6	204.64	6536.0
2020-09-22 07:00:00	MSFT	Stock	204.81	205.2	203.11	203.38	65379.0
2020-09-22 08:00:00	MSFT	Stock	204.8	205.21	203.11	204.805	144008.0
2020-09-22 09:00:00	MSFT	Stock	204.98	205.42	202.075	202.92	3867142.0
2020-09-22 10:00:00	MSFT	Stock	202.94	204.51	202.83	202.905	3427382.0
2020-09-22 11:00:00	MSFT	Stock	202.93	204.344	202.27	204.3	2355962.0
2020-09-22 12:00:00	MSFT	Stock	204.29	205.24	203.87	204.24	2328283.0
2020-09-22 13:00:00	MSFT	Stock	204.23	206.13	203.912	205.96	2327538.0
2020-09-22 14:00:00	MSFT	Stock	205.98	206.85	205.51	205.74	2824194.0
2020-09-22 15:00:00	MSFT	Stock	205.77	208.1	205.54	207.38	5806471.0
2020-09-22 16:00:00	MSFT	Stock	207.42	207.85	207.12	207.2	3530138.0
2020-09-22 17:00:00	MSFT	Stock	207.14	207.42	207.14	207.16	11200.0
2020-09-22 18:00:00	MSFT	Stock	207.22	207.35	206.51	206.51	39616.0
2020-09-22 19:00:00	MSFT	Stock	206.62	207.59	206.5	207.38	33633.0
2020-09-22 04:00:00	NVDA	Stock	12.4988	12.6035	12.4988	12.5995	103560.0
2020-09-22 05:00:00	NVDA	Stock	12.5928	12.6838	12.5843	12.64	67240.0
2020-09-22 06:00:00	NVDA	Stock	12.6343	12.6995	12.6343	12.64	229520.0
2020-09-22 07:00:00	NVDA	Stock	12.6475	12.65	12.57	12.57	1182560.0
2020-09-22 08:00:00	NVDA	Stock	12.6208	12.65	12.5625	12.6138	1402080.0
2020-09-22 09:00:00	NVDA	Stock	12.6148	12.6625	12.2651	12.3448	91396280.0
2020-09-22 10:00:00	NVDA	Stock	12.3448	12.369	12.1913	12.2105	107619880.0
2020-09-22 11:00:00	NVDA	Stock	12.214	12.3312	12.1556	12.317	73574960.0
2020-09-22 12:00:00	NVDA	Stock	12.3158	12.425	12.3141	12.3681	66925520.0
2020-09-22 13:00:00	NVDA	Stock	12.3684	12.49	12.3526	12.4665	52658560.0
2020-09-22 14:00:00	NVDA	Stock	12.4648	12.5555	12.4564	12.4822	59517600.0
2020-09-22 15:00:00	NVDA	Stock	12.4835	12.648	12.4625	12.642	90120480.0
2020-09-22 16:00:00	NVDA	Stock	12.6422	12.6435	12.5888	12.5888	15816560.0
2020-09-22 17:00:00	NVDA	Stock	12.595	12.6075	12.59	12.6075	219640.0
2020-09-22 18:00:00	NVDA	Stock	12.6	12.6	12.542	12.542	358440.0
2020-09-22 19:00:00	NVDA	Stock	12.55	12.55	12.5	12.525	727320.0
2020-09-22 04:00:00	AMZN	Stock	149.15	149.5505	149.15	149.5505	6060.0
2020-09-22 05:00:00	AMZN	Stock	150.6	150.6	150.55	150.55	8240.0

> showing 50 of 56,544 rows — these rows as CSV

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