PREVIEW / stock_1hour / 2020-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-25.parquet
  size:    1.2 MB
  rows:    56,618
  symbols: 2,445

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-25 04:00:00	AAPL	Stock	126.625	126.625	125.8775	126.0625	32228.0
2020-08-25 05:00:00	AAPL	Stock	126.205	126.35	126.1375	126.1725	12028.0
2020-08-25 06:00:00	AAPL	Stock	126.225	126.225	125.8775	126.0625	12380.0
2020-08-25 07:00:00	AAPL	Stock	126.1125	126.25	125.05	125.1125	612020.0
2020-08-25 08:00:00	AAPL	Stock	126.0625	126.2475	124.755	125.0625	1017164.0
2020-08-25 09:00:00	AAPL	Stock	125.075	125.1792	123.7025	124.32	28400392.0
2020-08-25 10:00:00	AAPL	Stock	124.32	124.3375	123.0525	123.8575	32925520.0
2020-08-25 11:00:00	AAPL	Stock	123.865	124.8575	123.7175	123.9725	25488924.0
2020-08-25 12:00:00	AAPL	Stock	123.9825	124.1715	123.4725	123.8375	16159748.0
2020-08-25 13:00:00	AAPL	Stock	123.825	124.275	123.58	123.835	12975152.0
2020-08-25 14:00:00	AAPL	Stock	123.8525	124.205	123.708	124.1275	11603032.0
2020-08-25 15:00:00	AAPL	Stock	124.125	125.0725	124.0272	124.8275	29652500.0
2020-08-25 16:00:00	AAPL	Stock	124.8275	124.9975	124.8	124.9325	7546048.0
2020-08-25 17:00:00	AAPL	Stock	124.95	124.965	124.825	124.895	108668.0
2020-08-25 18:00:00	AAPL	Stock	124.905	124.9325	124.825	124.8325	89144.0
2020-08-25 19:00:00	AAPL	Stock	124.83	124.96	124.825	124.9075	196076.0
2020-08-25 04:00:00	MSFT	Stock	213.95	213.95	213.95	213.95	100.0
2020-08-25 05:00:00	MSFT	Stock	214.19	214.42	214.02	214.04	3028.0
2020-08-25 06:00:00	MSFT	Stock	213.89	214.28	213.8	214.22	1583.0
2020-08-25 07:00:00	MSFT	Stock	214.0	214.18	213.3	213.46	20620.0
2020-08-25 08:00:00	MSFT	Stock	213.947	214.0	213.0	213.3	37416.0
2020-08-25 09:00:00	MSFT	Stock	213.26	214.55	212.8	214.393	2256498.0
2020-08-25 10:00:00	MSFT	Stock	214.38	216.02	214.07	215.82	3275326.0
2020-08-25 11:00:00	MSFT	Stock	215.8	216.52	214.75	215.19	2571769.0
2020-08-25 12:00:00	MSFT	Stock	215.183	215.48	214.69	215.426	1257580.0
2020-08-25 13:00:00	MSFT	Stock	215.44	215.48	215.04	215.22	841093.0
2020-08-25 14:00:00	MSFT	Stock	215.22	216.15	215.0	216.084	1323137.0
2020-08-25 15:00:00	MSFT	Stock	216.08	216.61	215.85	216.456	2714920.0
2020-08-25 16:00:00	MSFT	Stock	216.47	217.88	216.26	217.86	3282133.0
2020-08-25 17:00:00	MSFT	Stock	217.86	218.38	217.75	218.0	47278.0
2020-08-25 18:00:00	MSFT	Stock	218.0	218.0	217.51	217.7	16650.0
2020-08-25 19:00:00	MSFT	Stock	217.66	218.01	217.4	217.59	17230.0
2020-08-25 04:00:00	NVDA	Stock	12.77	12.771	12.7575	12.7645	93240.0
2020-08-25 05:00:00	NVDA	Stock	12.75	12.75	12.75	12.75	8240.0
2020-08-25 06:00:00	NVDA	Stock	12.75	12.75	12.705	12.705	20440.0
2020-08-25 07:00:00	NVDA	Stock	12.7438	12.7438	12.608	12.6313	729560.0
2020-08-25 08:00:00	NVDA	Stock	12.7375	12.752	12.6075	12.6502	1071680.0
2020-08-25 09:00:00	NVDA	Stock	12.6505	12.732	12.594	12.6418	44305080.0
2020-08-25 10:00:00	NVDA	Stock	12.6378	12.7029	12.5738	12.6916	37784320.0
2020-08-25 11:00:00	NVDA	Stock	12.6895	12.7438	12.6343	12.6775	32832240.0
2020-08-25 12:00:00	NVDA	Stock	12.6788	12.6812	12.615	12.6688	26489280.0
2020-08-25 13:00:00	NVDA	Stock	12.668	12.7018	12.653	12.6704	15741920.0
2020-08-25 14:00:00	NVDA	Stock	12.671	12.7218	12.6625	12.6968	17395320.0
2020-08-25 15:00:00	NVDA	Stock	12.6955	12.7612	12.689	12.7508	43456040.0
2020-08-25 16:00:00	NVDA	Stock	12.7503	12.762	12.7485	12.762	9507320.0
2020-08-25 17:00:00	NVDA	Stock	12.7563	12.7563	12.744	12.751	151880.0
2020-08-25 18:00:00	NVDA	Stock	12.75	12.7612	12.743	12.7575	297320.0
2020-08-25 19:00:00	NVDA	Stock	12.7612	12.775	12.75	12.75	410240.0
2020-08-25 07:00:00	AMZN	Stock	165.5	165.65	164.275	164.55	151220.0
2020-08-25 08:00:00	AMZN	Stock	165.15	165.65	164.35	164.9995	212460.0

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

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