PREVIEW / stock_1hour / 2021-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-03.parquet
  size:    1.4 MB
  rows:    66,584
  symbols: 2,943

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
2021-06-03 04:00:00	AAPL	Stock	124.88	124.89	124.62	124.89	5966.0
2021-06-03 05:00:00	AAPL	Stock	124.89	124.89	124.61	124.62	4881.0
2021-06-03 06:00:00	AAPL	Stock	124.66	124.66	124.0	124.01	13246.0
2021-06-03 07:00:00	AAPL	Stock	124.12	124.45	123.84	124.07	239279.0
2021-06-03 08:00:00	AAPL	Stock	124.06	124.748	123.81	124.24	522131.0
2021-06-03 09:00:00	AAPL	Stock	124.24	124.85	123.27	123.62	10474992.0
2021-06-03 10:00:00	AAPL	Stock	123.62	123.94	123.13	123.935	12409635.0
2021-06-03 11:00:00	AAPL	Stock	123.94	124.15	123.55	123.71	7774579.0
2021-06-03 12:00:00	AAPL	Stock	123.71	123.85	123.38	123.68	5322488.0
2021-06-03 13:00:00	AAPL	Stock	123.68	124.04	123.3	123.9001	5191212.0
2021-06-03 14:00:00	AAPL	Stock	123.9	124.09	123.6	123.64	4263158.0
2021-06-03 15:00:00	AAPL	Stock	123.64	123.915	123.39	123.54	8684150.0
2021-06-03 16:00:00	AAPL	Stock	123.54	123.54	123.45	123.47	5557023.0
2021-06-03 17:00:00	AAPL	Stock	123.48	123.58	123.47	123.58	39818.0
2021-06-03 18:00:00	AAPL	Stock	123.58	123.67	123.54	123.54	42320.0
2021-06-03 19:00:00	AAPL	Stock	123.54	123.6	123.43	123.54	86381.0
2021-06-03 04:00:00	MSFT	Stock	247.0	247.21	247.0	247.11	1308.0
2021-06-03 05:00:00	MSFT	Stock	247.2	247.21	247.05	247.09	3424.0
2021-06-03 06:00:00	MSFT	Stock	246.77	246.77	245.68	245.68	1138.0
2021-06-03 07:00:00	MSFT	Stock	246.25	246.63	245.0	245.0	32330.0
2021-06-03 08:00:00	MSFT	Stock	245.6616	246.75	244.8	245.53	66136.0
2021-06-03 09:00:00	MSFT	Stock	245.69	246.39	243.6	243.79	2493160.0
2021-06-03 10:00:00	MSFT	Stock	243.77	245.41	243.0	245.39	3296035.0
2021-06-03 11:00:00	MSFT	Stock	245.42	246.34	244.93	245.4671	1727037.0
2021-06-03 12:00:00	MSFT	Stock	245.47	245.819	244.9	245.64	1120358.0
2021-06-03 13:00:00	MSFT	Stock	245.65	245.77	244.43	245.31	1014305.0
2021-06-03 14:00:00	MSFT	Stock	245.31	245.39	244.86	244.92	1188749.0
2021-06-03 15:00:00	MSFT	Stock	244.91	246.01	244.9097	245.7	2502885.0
2021-06-03 16:00:00	MSFT	Stock	245.71	245.95	245.5	245.71	3922987.0
2021-06-03 17:00:00	MSFT	Stock	245.8	245.8	245.72	245.75	1488.0
2021-06-03 18:00:00	MSFT	Stock	245.81	245.81	245.6	245.6	3949.0
2021-06-03 19:00:00	MSFT	Stock	245.58	245.6	245.5	245.55	3942.0
2021-06-03 04:00:00	NVDA	Stock	16.775	16.8625	16.775	16.8625	55680.0
2021-06-03 05:00:00	NVDA	Stock	16.8378	16.8378	16.7765	16.7825	80360.0
2021-06-03 06:00:00	NVDA	Stock	16.7882	16.7882	16.65	16.65	333880.0
2021-06-03 07:00:00	NVDA	Stock	16.6945	16.6998	16.5558	16.5558	984840.0
2021-06-03 08:00:00	NVDA	Stock	16.6515	16.8202	16.5538	16.6375	1219080.0
2021-06-03 09:00:00	NVDA	Stock	16.6375	16.9188	16.583	16.7712	57371880.0
2021-06-03 10:00:00	NVDA	Stock	16.764	16.941	16.7268	16.939	52869280.0
2021-06-03 11:00:00	NVDA	Stock	16.942	16.991	16.8575	16.9878	44819720.0
2021-06-03 12:00:00	NVDA	Stock	16.9885	17.2	16.9885	17.1936	63483240.0
2021-06-03 13:00:00	NVDA	Stock	17.1939	17.259	17.1215	17.1306	48405800.0
2021-06-03 14:00:00	NVDA	Stock	17.1278	17.1848	17.0312	17.1008	41303520.0
2021-06-03 15:00:00	NVDA	Stock	17.0959	17.1442	16.954	16.967	46770200.0
2021-06-03 16:00:00	NVDA	Stock	16.9698	16.9698	16.9375	16.95	18990440.0
2021-06-03 17:00:00	NVDA	Stock	16.955	16.9625	16.9463	16.9625	29400.0
2021-06-03 18:00:00	NVDA	Stock	16.967	17.0093	16.967	16.9833	198680.0
2021-06-03 19:00:00	NVDA	Stock	16.978	16.9945	16.9568	16.9568	123760.0
2021-06-03 05:00:00	AMZN	Stock	161.21	161.21	160.9995	160.9995	8900.0
2021-06-03 06:00:00	AMZN	Stock	160.95	160.95	160.797	160.797	4440.0

> showing 50 of 66,584 rows — these rows as CSV

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