PREVIEW / stock_1hour / 2020-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-01.parquet
  size:    1.2 MB
  rows:    54,259
  symbols: 2,424

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-04-01 04:00:00	AAPL	Stock	62.75	62.75	61.5675	61.8425	71268.0
2020-04-01 05:00:00	AAPL	Stock	61.8375	62.1	61.75	62.0	19292.0
2020-04-01 06:00:00	AAPL	Stock	62.0275	62.12	61.565	61.75	39156.0
2020-04-01 07:00:00	AAPL	Stock	61.8925	62.175	61.6	62.0	542480.0
2020-04-01 08:00:00	AAPL	Stock	61.7225	62.0925	61.37	61.7775	1101444.0
2020-04-01 09:00:00	AAPL	Stock	61.69	62.18	61.4245	61.5662	18391320.0
2020-04-01 10:00:00	AAPL	Stock	61.57	61.925	61.44	61.7905	20301552.0
2020-04-01 11:00:00	AAPL	Stock	61.7875	62.075	61.2925	61.4488	17003924.0
2020-04-01 12:00:00	AAPL	Stock	61.445	61.445	60.545	60.6425	18063688.0
2020-04-01 13:00:00	AAPL	Stock	60.64	60.965	60.57	60.8525	12880828.0
2020-04-01 14:00:00	AAPL	Stock	60.85	60.97	60.225	60.2532	12763996.0
2020-04-01 15:00:00	AAPL	Stock	60.26	60.475	59.7825	60.19	29721896.0
2020-04-01 16:00:00	AAPL	Stock	60.33	60.375	60.0775	60.33	13258892.0
2020-04-01 17:00:00	AAPL	Stock	60.33	60.4125	60.2725	60.405	74836.0
2020-04-01 18:00:00	AAPL	Stock	60.41	60.7275	60.41	60.4525	197172.0
2020-04-01 19:00:00	AAPL	Stock	60.5425	60.745	60.375	60.71	156116.0
2020-04-01 04:00:00	MSFT	Stock	154.08	154.36	152.01	153.8	16574.0
2020-04-01 05:00:00	MSFT	Stock	154.0	154.47	153.16	154.27	8381.0
2020-04-01 06:00:00	MSFT	Stock	154.49	154.51	153.11	153.5	12137.0
2020-04-01 07:00:00	MSFT	Stock	153.48	154.0	152.65	153.2	154402.0
2020-04-01 08:00:00	MSFT	Stock	157.71	157.71	152.13	153.399	264807.0
2020-04-01 09:00:00	MSFT	Stock	153.21	156.24	152.66	154.94	7194731.0
2020-04-01 10:00:00	MSFT	Stock	155.0	156.57	154.52	156.35	5736262.0
2020-04-01 11:00:00	MSFT	Stock	156.355	157.75	154.63	155.085	5864883.0
2020-04-01 12:00:00	MSFT	Stock	155.07	155.13	152.8	152.81	5098297.0
2020-04-01 13:00:00	MSFT	Stock	152.8	153.89	152.67	153.71	4569528.0
2020-04-01 14:00:00	MSFT	Stock	153.69	154.22	151.32	151.41	4640999.0
2020-04-01 15:00:00	MSFT	Stock	151.415	153.0	150.82	151.94	9306387.0
2020-04-01 16:00:00	MSFT	Stock	151.99	153.574	151.85	152.6	5732830.0
2020-04-01 17:00:00	MSFT	Stock	152.61	152.64	152.3	152.32	12597.0
2020-04-01 18:00:00	MSFT	Stock	152.33	153.49	152.33	152.9	52788.0
2020-04-01 19:00:00	MSFT	Stock	152.9	153.65	152.56	153.58	55610.0
2020-04-01 04:00:00	NVDA	Stock	6.375	6.425	6.375	6.375	38240.0
2020-04-01 05:00:00	NVDA	Stock	6.41	6.4275	6.41	6.4275	40000.0
2020-04-01 06:00:00	NVDA	Stock	6.441	6.441	6.3838	6.3838	73520.0
2020-04-01 07:00:00	NVDA	Stock	6.4048	6.4075	6.375	6.3953	1272840.0
2020-04-01 08:00:00	NVDA	Stock	6.3815	6.4172	6.35	6.39	1871400.0
2020-04-01 09:00:00	NVDA	Stock	6.383	6.483	6.33	6.3328	82988000.0
2020-04-01 10:00:00	NVDA	Stock	6.334	6.4738	6.2928	6.414	100421960.0
2020-04-01 11:00:00	NVDA	Stock	6.411	6.5382	6.3612	6.381	78296080.0
2020-04-01 12:00:00	NVDA	Stock	6.3788	6.387	6.2362	6.2705	77126280.0
2020-04-01 13:00:00	NVDA	Stock	6.2686	6.309	6.2415	6.2798	48747840.0
2020-04-01 14:00:00	NVDA	Stock	6.2775	6.3052	6.166	6.1746	55824120.0
2020-04-01 15:00:00	NVDA	Stock	6.1732	6.1875	6.032	6.0753	137703040.0
2020-04-01 16:00:00	NVDA	Stock	6.0768	6.1	6.0662	6.0847	4137280.0
2020-04-01 17:00:00	NVDA	Stock	6.0813	6.0913	6.075	6.075	450200.0
2020-04-01 18:00:00	NVDA	Stock	6.0763	6.125	6.0763	6.1062	1160520.0
2020-04-01 19:00:00	NVDA	Stock	6.12	6.1435	6.0998	6.1425	509320.0
2020-04-01 04:00:00	AMZN	Stock	96.25	96.25	95.8495	95.8495	25860.0
2020-04-01 05:00:00	AMZN	Stock	95.9	95.9	95.9	95.9	2000.0

> showing 50 of 54,259 rows — these rows as CSV

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