PREVIEW / stock_1hour / 2020-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-03.parquet
  size:    1.3 MB
  rows:    57,779
  symbols: 2,452

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-03 04:00:00	AAPL	Stock	106.86	107.325	106.825	106.87	88924.0
2020-08-03 05:00:00	AAPL	Stock	106.9925	107.0	106.765	106.765	27816.0
2020-08-03 06:00:00	AAPL	Stock	106.765	107.37	106.765	107.3	160704.0
2020-08-03 07:00:00	AAPL	Stock	107.3	108.2925	107.3	107.875	1570196.0
2020-08-03 08:00:00	AAPL	Stock	107.82	108.295	107.375	108.15	1992384.0
2020-08-03 09:00:00	AAPL	Stock	108.1692	111.18	107.75	110.545	57721796.0
2020-08-03 10:00:00	AAPL	Stock	110.53	111.6365	109.07	109.55	60953896.0
2020-08-03 11:00:00	AAPL	Stock	109.5575	110.165	109.2275	109.846	24710976.0
2020-08-03 12:00:00	AAPL	Stock	109.8525	109.915	108.845	109.185	20686672.0
2020-08-03 13:00:00	AAPL	Stock	109.181	109.4075	108.65	108.98	17741128.0
2020-08-03 14:00:00	AAPL	Stock	108.995	109.9075	108.925	109.6425	22662456.0
2020-08-03 15:00:00	AAPL	Stock	109.6575	109.7225	108.77	108.915	26799080.0
2020-08-03 16:00:00	AAPL	Stock	108.9375	109.6525	108.75	108.9225	7843064.0
2020-08-03 17:00:00	AAPL	Stock	108.905	108.9125	108.75	108.8375	90776.0
2020-08-03 18:00:00	AAPL	Stock	108.8375	108.87	108.75	108.75	75268.0
2020-08-03 19:00:00	AAPL	Stock	108.7625	108.93	108.6	108.9	178056.0
2020-08-03 04:00:00	MSFT	Stock	207.71	210.0	205.5	209.71	178321.0
2020-08-03 05:00:00	MSFT	Stock	210.0	210.34	208.38	208.89	40383.0
2020-08-03 06:00:00	MSFT	Stock	208.95	209.74	208.3	209.46	73848.0
2020-08-03 07:00:00	MSFT	Stock	209.58	211.74	209.3	210.5	393283.0
2020-08-03 08:00:00	MSFT	Stock	211.23	211.75	209.5	211.524	774723.0
2020-08-03 09:00:00	MSFT	Stock	211.52	215.16	209.8	212.955	14090488.0
2020-08-03 10:00:00	MSFT	Stock	212.97	214.04	211.38	212.445	8090081.0
2020-08-03 11:00:00	MSFT	Stock	212.44	214.13	212.27	214.115	4849191.0
2020-08-03 12:00:00	MSFT	Stock	214.116	214.29	213.18	213.73	3333472.0
2020-08-03 13:00:00	MSFT	Stock	213.735	215.07	213.55	214.97	6751788.0
2020-08-03 14:00:00	MSFT	Stock	214.98	217.64	214.67	216.26	9974899.0
2020-08-03 15:00:00	MSFT	Stock	216.27	217.24	214.2	216.54	11760932.0
2020-08-03 16:00:00	MSFT	Stock	216.54	217.57	213.78	217.0	5780507.0
2020-08-03 17:00:00	MSFT	Stock	217.11	217.35	216.4	216.7	109621.0
2020-08-03 18:00:00	MSFT	Stock	216.77	216.8	216.08	216.27	58254.0
2020-08-03 19:00:00	MSFT	Stock	216.2	216.5	215.82	216.2	43557.0
2020-08-03 04:00:00	NVDA	Stock	10.625	10.675	10.625	10.675	16120.0
2020-08-03 05:00:00	NVDA	Stock	10.672	10.672	10.6665	10.6665	16000.0
2020-08-03 06:00:00	NVDA	Stock	10.6738	10.7	10.6738	10.7	55480.0
2020-08-03 07:00:00	NVDA	Stock	10.7058	10.7183	10.6902	10.7125	812760.0
2020-08-03 08:00:00	NVDA	Stock	10.7	10.7125	10.6875	10.6963	601160.0
2020-08-03 09:00:00	NVDA	Stock	10.6928	10.8802	10.6925	10.8596	64321320.0
2020-08-03 10:00:00	NVDA	Stock	10.8615	10.9052	10.8113	10.8855	55371720.0
2020-08-03 11:00:00	NVDA	Stock	10.8839	10.988	10.875	10.9869	46131840.0
2020-08-03 12:00:00	NVDA	Stock	10.9878	11.0988	10.972	11.0427	73160280.0
2020-08-03 13:00:00	NVDA	Stock	11.0431	11.0915	11.014	11.034	34386040.0
2020-08-03 14:00:00	NVDA	Stock	11.0358	11.047	10.97	11.0245	32273280.0
2020-08-03 15:00:00	NVDA	Stock	11.0228	11.0363	10.9548	11.0103	39838560.0
2020-08-03 16:00:00	NVDA	Stock	11.0103	11.025	11.0	11.0175	5045920.0
2020-08-03 17:00:00	NVDA	Stock	11.0105	11.015	11.0103	11.0125	133480.0
2020-08-03 18:00:00	NVDA	Stock	11.0128	11.0225	11.0103	11.0103	78800.0
2020-08-03 19:00:00	NVDA	Stock	11.0112	11.0225	11.0103	11.0103	115560.0
2020-08-03 04:00:00	AMZN	Stock	159.151	159.2455	158.802	158.9975	26260.0
2020-08-03 05:00:00	AMZN	Stock	158.905	159.045	158.887	159.045	12540.0

> showing 50 of 57,779 rows — these rows as CSV

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