PREVIEW / stock_1hour / 2020-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-21.parquet
  size:    1.2 MB
  rows:    51,040
  symbols: 2,425

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-02-21 04:00:00	AAPL	Stock	79.425	79.5025	79.35	79.35	36804.0
2020-02-21 05:00:00	AAPL	Stock	79.42	79.625	79.42	79.625	21760.0
2020-02-21 06:00:00	AAPL	Stock	79.5	79.6725	79.4575	79.61	14476.0
2020-02-21 07:00:00	AAPL	Stock	79.5175	79.7775	79.5	79.675	179220.0
2020-02-21 08:00:00	AAPL	Stock	79.575	79.7825	79.525	79.6	356608.0
2020-02-21 09:00:00	AAPL	Stock	79.5875	80.1125	79.075	79.3175	17456884.0
2020-02-21 10:00:00	AAPL	Stock	79.32	79.445	78.8928	79.0725	13069612.0
2020-02-21 11:00:00	AAPL	Stock	79.075	79.32	78.91	79.2398	6915744.0
2020-02-21 12:00:00	AAPL	Stock	79.2338	79.355	78.6675	78.7762	8541180.0
2020-02-21 13:00:00	AAPL	Stock	78.78	78.8675	77.795	78.0288	14956560.0
2020-02-21 14:00:00	AAPL	Stock	78.02	78.155	77.625	78.0325	15588388.0
2020-02-21 15:00:00	AAPL	Stock	78.025	78.39	77.71	78.2575	17658796.0
2020-02-21 16:00:00	AAPL	Stock	78.2625	78.275	78.15	78.2	11671176.0
2020-02-21 17:00:00	AAPL	Stock	78.2	78.24	78.1625	78.2	140108.0
2020-02-21 18:00:00	AAPL	Stock	78.2	78.215	78.025	78.075	53640.0
2020-02-21 19:00:00	AAPL	Stock	78.0875	78.095	78.005	78.0625	70496.0
2020-02-21 04:00:00	MSFT	Stock	183.59	183.66	183.23	183.23	2524.0
2020-02-21 05:00:00	MSFT	Stock	183.3	183.66	183.3	183.66	2826.0
2020-02-21 06:00:00	MSFT	Stock	183.55	183.55	183.36	183.4	639.0
2020-02-21 07:00:00	MSFT	Stock	183.4	183.79	183.34	183.75	31594.0
2020-02-21 08:00:00	MSFT	Stock	183.45	183.84	183.19	183.54	63748.0
2020-02-21 09:00:00	MSFT	Stock	183.48	184.2	178.23	180.055	9286677.0
2020-02-21 10:00:00	MSFT	Stock	180.04	181.13	179.53	180.5	5735100.0
2020-02-21 11:00:00	MSFT	Stock	180.52	181.06	179.91	179.95	3480031.0
2020-02-21 12:00:00	MSFT	Stock	179.94	180.45	179.25	179.508	2756275.0
2020-02-21 13:00:00	MSFT	Stock	179.5	179.795	177.52	178.248	4461642.0
2020-02-21 14:00:00	MSFT	Stock	178.24	178.665	177.25	178.3	4613522.0
2020-02-21 15:00:00	MSFT	Stock	178.29	179.2	177.5	178.56	6685776.0
2020-02-21 16:00:00	MSFT	Stock	178.59	180.155	178.27	178.59	5055893.0
2020-02-21 17:00:00	MSFT	Stock	178.64	178.69	178.5	178.54	13676.0
2020-02-21 18:00:00	MSFT	Stock	178.54	178.55	178.3	178.55	12811.0
2020-02-21 19:00:00	MSFT	Stock	178.51	178.51	178.19	178.2	15770.0
2020-02-21 04:00:00	NVDA	Stock	7.625	7.6262	7.6112	7.615	56520.0
2020-02-21 05:00:00	NVDA	Stock	7.6262	7.6425	7.6262	7.6425	21960.0
2020-02-21 06:00:00	NVDA	Stock	7.6375	7.6375	7.6025	7.625	206480.0
2020-02-21 07:00:00	NVDA	Stock	7.6185	7.6515	7.6145	7.6238	1430800.0
2020-02-21 08:00:00	NVDA	Stock	7.6362	7.65	7.6125	7.6222	2312600.0
2020-02-21 09:00:00	NVDA	Stock	7.6182	7.6562	7.4195	7.4688	136331040.0
2020-02-21 10:00:00	NVDA	Stock	7.4662	7.5103	7.382	7.4409	134493440.0
2020-02-21 11:00:00	NVDA	Stock	7.4414	7.4995	7.4255	7.4681	68086080.0
2020-02-21 12:00:00	NVDA	Stock	7.4678	7.4925	7.365	7.3774	77455880.0
2020-02-21 13:00:00	NVDA	Stock	7.378	7.4108	7.295	7.3155	85431320.0
2020-02-21 14:00:00	NVDA	Stock	7.3141	7.3555	7.2665	7.3349	59101360.0
2020-02-21 15:00:00	NVDA	Stock	7.337	7.3672	7.2688	7.3525	102735600.0
2020-02-21 16:00:00	NVDA	Stock	7.3518	7.357	7.3252	7.35	30023480.0
2020-02-21 17:00:00	NVDA	Stock	7.35	7.3518	7.3293	7.3338	416920.0
2020-02-21 18:00:00	NVDA	Stock	7.3338	7.34	7.33	7.3325	482200.0
2020-02-21 19:00:00	NVDA	Stock	7.33	7.3312	7.3012	7.3243	360880.0
2020-02-21 04:00:00	AMZN	Stock	106.9495	106.9495	106.9495	106.9495	2000.0
2020-02-21 06:00:00	AMZN	Stock	106.9145	106.9145	106.9145	106.9145	2000.0

> showing 50 of 51,040 rows — these rows as CSV

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