PREVIEW / stock_1hour / 2020-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-28.parquet
  size:    1.2 MB
  rows:    56,039
  symbols: 2,459

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-28 04:00:00	AAPL	Stock	125.2525	125.625	125.2025	125.4625	37784.0
2020-08-28 05:00:00	AAPL	Stock	125.375	125.4125	125.265	125.325	9108.0
2020-08-28 06:00:00	AAPL	Stock	125.3425	125.3425	125.1075	125.225	13460.0
2020-08-28 07:00:00	AAPL	Stock	125.225	125.95	125.175	125.895	476272.0
2020-08-28 08:00:00	AAPL	Stock	125.895	125.986	125.01	125.775	893480.0
2020-08-28 09:00:00	AAPL	Stock	125.805	126.285	124.8575	125.875	18386704.0
2020-08-28 10:00:00	AAPL	Stock	125.875	125.88	125.0575	125.127	14537044.0
2020-08-28 11:00:00	AAPL	Stock	125.1185	125.895	125.0	125.6075	11960612.0
2020-08-28 12:00:00	AAPL	Stock	125.5925	125.675	125.125	125.3625	8243764.0
2020-08-28 13:00:00	AAPL	Stock	125.36	125.4075	124.5775	125.03	13129996.0
2020-08-28 14:00:00	AAPL	Stock	125.035	125.675	124.92	125.1962	14379516.0
2020-08-28 15:00:00	AAPL	Stock	125.1962	126.4425	124.705	124.725	36531708.0
2020-08-28 16:00:00	AAPL	Stock	124.8075	125.341	124.695	124.985	29071752.0
2020-08-28 17:00:00	AAPL	Stock	124.975	125.2875	124.89	125.275	376212.0
2020-08-28 18:00:00	AAPL	Stock	125.2525	125.3125	125.175	125.2675	117040.0
2020-08-28 19:00:00	AAPL	Stock	125.2575	125.5	125.2575	125.495	201628.0
2020-08-28 04:00:00	MSFT	Stock	228.8	228.8	227.13	227.5	6552.0
2020-08-28 05:00:00	MSFT	Stock	227.13	227.95	227.13	227.76	3000.0
2020-08-28 06:00:00	MSFT	Stock	227.3	228.0	227.02	227.61	3910.0
2020-08-28 07:00:00	MSFT	Stock	227.95	228.51	227.22	228.51	40342.0
2020-08-28 08:00:00	MSFT	Stock	227.55	228.646	226.58	227.94	252751.0
2020-08-28 09:00:00	MSFT	Stock	227.601	230.644	227.5	229.89	4293962.0
2020-08-28 10:00:00	MSFT	Stock	229.91	230.37	228.38	228.805	3505949.0
2020-08-28 11:00:00	MSFT	Stock	228.83	229.43	228.55	228.95	1726639.0
2020-08-28 12:00:00	MSFT	Stock	228.935	229.05	228.11	228.51	1587582.0
2020-08-28 13:00:00	MSFT	Stock	228.51	228.57	226.58	227.925	2428815.0
2020-08-28 14:00:00	MSFT	Stock	227.93	228.4	227.39	227.789	1536332.0
2020-08-28 15:00:00	MSFT	Stock	227.83	229.12	227.76	228.94	3183481.0
2020-08-28 16:00:00	MSFT	Stock	228.91	229.35	228.25	228.9	2378508.0
2020-08-28 17:00:00	MSFT	Stock	228.84	228.9	227.5	227.75	34081.0
2020-08-28 18:00:00	MSFT	Stock	227.62	228.25	227.59	228.12	13248.0
2020-08-28 19:00:00	MSFT	Stock	228.15	228.5	228.15	228.5	15661.0
2020-08-28 04:00:00	NVDA	Stock	12.65	12.65	12.6098	12.6098	35720.0
2020-08-28 06:00:00	NVDA	Stock	12.5878	12.5878	12.5878	12.5878	7800.0
2020-08-28 07:00:00	NVDA	Stock	12.61	12.6463	12.6	12.64	616960.0
2020-08-28 08:00:00	NVDA	Stock	12.6247	12.6598	12.5721	12.6125	1638840.0
2020-08-28 09:00:00	NVDA	Stock	12.6175	12.8216	12.6125	12.82	48534520.0
2020-08-28 10:00:00	NVDA	Stock	12.82	12.875	12.774	12.8072	57613200.0
2020-08-28 11:00:00	NVDA	Stock	12.809	13.1178	12.785	13.08	112107440.0
2020-08-28 12:00:00	NVDA	Stock	13.0803	13.1395	12.9658	13.0518	65040200.0
2020-08-28 13:00:00	NVDA	Stock	13.0498	13.0556	12.9502	13.0125	37372920.0
2020-08-28 14:00:00	NVDA	Stock	13.019	13.1458	13.0058	13.1035	58238160.0
2020-08-28 15:00:00	NVDA	Stock	13.104	13.148	13.0843	13.148	62647160.0
2020-08-28 16:00:00	NVDA	Stock	13.1478	13.1498	13.0067	13.136	25277480.0
2020-08-28 17:00:00	NVDA	Stock	13.1425	13.1425	13.1305	13.135	831240.0
2020-08-28 18:00:00	NVDA	Stock	13.1355	13.1478	13.1338	13.1475	332240.0
2020-08-28 19:00:00	NVDA	Stock	13.1452	13.15	13.1438	13.1438	283960.0
2020-08-28 07:00:00	AMZN	Stock	170.703	170.9975	170.528	170.9975	46920.0
2020-08-28 08:00:00	AMZN	Stock	170.7512	170.95	170.425	170.89	150420.0
2020-08-28 09:00:00	AMZN	Stock	171.0	171.2225	169.325	170.711	4348920.0

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

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