PREVIEW / stock_1hour / 2020-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-08.parquet
  size:    1.3 MB
  rows:    59,901
  symbols: 2,407

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-06-08 04:00:00	AAPL	Stock	82.75	82.85	82.5625	82.775	21760.0
2020-06-08 05:00:00	AAPL	Stock	82.8475	82.875	82.675	82.675	8684.0
2020-06-08 06:00:00	AAPL	Stock	82.61	82.72	82.575	82.66	10684.0
2020-06-08 07:00:00	AAPL	Stock	82.6475	82.875	82.5875	82.6975	314528.0
2020-06-08 08:00:00	AAPL	Stock	82.75	82.8725	82.4625	82.67	469912.0
2020-06-08 09:00:00	AAPL	Stock	82.685	82.845	82.2025	82.28	13153716.0
2020-06-08 10:00:00	AAPL	Stock	82.2788	82.5378	81.83	82.5025	13142528.0
2020-06-08 11:00:00	AAPL	Stock	82.5075	82.7375	82.4222	82.6225	6881168.0
2020-06-08 12:00:00	AAPL	Stock	82.63	82.6775	82.4575	82.625	4416084.0
2020-06-08 13:00:00	AAPL	Stock	82.6325	83.11	82.4875	83.109	7349356.0
2020-06-08 14:00:00	AAPL	Stock	83.1025	83.2675	82.9875	83.195	8786212.0
2020-06-08 15:00:00	AAPL	Stock	83.1975	83.4	83.04	83.3825	12940096.0
2020-06-08 16:00:00	AAPL	Stock	83.3875	83.4	83.2875	83.35	7167452.0
2020-06-08 17:00:00	AAPL	Stock	83.3125	83.3375	83.295	83.305	16004.0
2020-06-08 18:00:00	AAPL	Stock	83.2875	83.325	83.15	83.15	34920.0
2020-06-08 19:00:00	AAPL	Stock	83.15	83.245	83.0775	83.2	53256.0
2020-06-08 04:00:00	MSFT	Stock	187.02	187.05	186.6	187.05	2026.0
2020-06-08 05:00:00	MSFT	Stock	187.19	187.19	186.8	186.8	2877.0
2020-06-08 06:00:00	MSFT	Stock	186.6	186.77	186.5	186.5	3353.0
2020-06-08 07:00:00	MSFT	Stock	186.6	186.93	185.5	185.8	84905.0
2020-06-08 08:00:00	MSFT	Stock	186.12	186.95	185.5	186.31	109917.0
2020-06-08 09:00:00	MSFT	Stock	186.3	186.55	184.62	185.13	4900874.0
2020-06-08 10:00:00	MSFT	Stock	185.13	185.68	184.44	185.335	4672025.0
2020-06-08 11:00:00	MSFT	Stock	185.34	186.45	185.332	186.35	3056972.0
2020-06-08 12:00:00	MSFT	Stock	186.37	187.195	186.2	186.89	2085240.0
2020-06-08 13:00:00	MSFT	Stock	186.895	187.84	186.43	187.76	1858648.0
2020-06-08 14:00:00	MSFT	Stock	187.75	188.28	187.68	188.036	2229882.0
2020-06-08 15:00:00	MSFT	Stock	188.03	188.55	187.405	188.35	4429076.0
2020-06-08 16:00:00	MSFT	Stock	188.36	188.49	186.766	188.2	5295013.0
2020-06-08 17:00:00	MSFT	Stock	188.2	188.282	188.07	188.282	24322.0
2020-06-08 18:00:00	MSFT	Stock	188.06	188.23	187.9	188.13	16853.0
2020-06-08 19:00:00	MSFT	Stock	187.93	188.4	187.93	188.3	20912.0
2020-06-08 05:00:00	NVDA	Stock	8.9	8.925	8.9	8.9	51040.0
2020-06-08 06:00:00	NVDA	Stock	8.9185	8.9185	8.9028	8.9028	16000.0
2020-06-08 07:00:00	NVDA	Stock	8.9092	8.91	8.875	8.8925	615640.0
2020-06-08 08:00:00	NVDA	Stock	8.91	8.9175	8.8642	8.9125	1273880.0
2020-06-08 09:00:00	NVDA	Stock	8.9098	8.9125	8.7468	8.7738	68425200.0
2020-06-08 10:00:00	NVDA	Stock	8.7725	8.7785	8.6858	8.7318	79754520.0
2020-06-08 11:00:00	NVDA	Stock	8.732	8.7538	8.7	8.718	41697640.0
2020-06-08 12:00:00	NVDA	Stock	8.719	8.7662	8.7102	8.73	32616360.0
2020-06-08 13:00:00	NVDA	Stock	8.7305	8.7923	8.728	8.7853	28639320.0
2020-06-08 14:00:00	NVDA	Stock	8.786	8.7935	8.7525	8.7924	28897280.0
2020-06-08 15:00:00	NVDA	Stock	8.7908	8.8085	8.7525	8.807	55616960.0
2020-06-08 16:00:00	NVDA	Stock	8.805	8.8052	8.7692	8.7958	3637960.0
2020-06-08 17:00:00	NVDA	Stock	8.7975	8.7975	8.765	8.765	307800.0
2020-06-08 18:00:00	NVDA	Stock	8.7793	8.8	8.765	8.77	462080.0
2020-06-08 19:00:00	NVDA	Stock	8.765	8.786	8.7632	8.7775	403320.0
2020-06-08 06:00:00	AMZN	Stock	124.2	124.7495	124.2	124.7495	58580.0
2020-06-08 07:00:00	AMZN	Stock	124.4455	125.24	124.4455	124.849	496600.0
2020-06-08 08:00:00	AMZN	Stock	124.5175	125.221	124.4395	125.125	573020.0

> showing 50 of 59,901 rows — these rows as CSV

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