PREVIEW / stock_1hour / 2020-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-06.parquet
  size:    1.2 MB
  rows:    55,166
  symbols: 2,441

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-06 04:00:00	AAPL	Stock	62.9025	63.0275	62.4875	62.8675	116716.0
2020-04-06 05:00:00	AAPL	Stock	62.8	63.175	62.5525	62.9675	70548.0
2020-04-06 06:00:00	AAPL	Stock	62.915	62.995	62.75	62.8475	32584.0
2020-04-06 07:00:00	AAPL	Stock	62.795	62.875	62.375	62.4675	836484.0
2020-04-06 08:00:00	AAPL	Stock	62.5	62.825	62.271	62.6875	980996.0
2020-04-06 09:00:00	AAPL	Stock	62.6758	63.415	62.345	63.315	23193220.0
2020-04-06 10:00:00	AAPL	Stock	63.3275	63.52	63.0675	63.2525	21458768.0
2020-04-06 11:00:00	AAPL	Stock	63.245	63.52	63.1875	63.4058	12657472.0
2020-04-06 12:00:00	AAPL	Stock	63.41	63.655	63.355	63.5925	13832440.0
2020-04-06 13:00:00	AAPL	Stock	63.595	63.94	63.4675	63.935	12591744.0
2020-04-06 14:00:00	AAPL	Stock	63.935	63.9975	63.6525	63.9875	11185168.0
2020-04-06 15:00:00	AAPL	Stock	63.985	65.7775	63.8425	65.5713	46448844.0
2020-04-06 16:00:00	AAPL	Stock	65.6175	65.6175	65.3375	65.4675	21415836.0
2020-04-06 17:00:00	AAPL	Stock	65.475	65.475	65.31	65.37	160760.0
2020-04-06 18:00:00	AAPL	Stock	65.33	65.4175	65.1575	65.1975	229624.0
2020-04-06 19:00:00	AAPL	Stock	65.18	65.75	65.1525	65.675	373976.0
2020-04-06 04:00:00	MSFT	Stock	159.9	160.92	159.1	160.75	36887.0
2020-04-06 05:00:00	MSFT	Stock	160.3	161.44	160.0	160.97	16455.0
2020-04-06 06:00:00	MSFT	Stock	160.75	160.75	160.0	160.47	11542.0
2020-04-06 07:00:00	MSFT	Stock	160.18	160.38	158.99	159.8	216760.0
2020-04-06 08:00:00	MSFT	Stock	159.74	160.33	159.0	160.103	238417.0
2020-04-06 09:00:00	MSFT	Stock	160.05	161.0	157.58	160.39	8132215.0
2020-04-06 10:00:00	MSFT	Stock	160.39	161.02	159.58	160.3	6521819.0
2020-04-06 11:00:00	MSFT	Stock	160.29	161.49	160.17	161.27	4752820.0
2020-04-06 12:00:00	MSFT	Stock	161.27	162.076	161.11	162.02	4593847.0
2020-04-06 13:00:00	MSFT	Stock	162.02	162.05	160.86	161.99	3648938.0
2020-04-06 14:00:00	MSFT	Stock	162.0	162.0	161.22	161.985	4300835.0
2020-04-06 15:00:00	MSFT	Stock	161.98	166.5	161.52	165.27	15100289.0
2020-04-06 16:00:00	MSFT	Stock	165.27	165.5	163.8	165.08	11087424.0
2020-04-06 17:00:00	MSFT	Stock	165.05	165.06	164.51	164.65	38114.0
2020-04-06 18:00:00	MSFT	Stock	164.69	164.7	164.22	164.3	50648.0
2020-04-06 19:00:00	MSFT	Stock	164.4	165.3	164.11	165.3	48754.0
2020-04-06 04:00:00	NVDA	Stock	6.3352	6.3975	6.3352	6.387	281960.0
2020-04-06 05:00:00	NVDA	Stock	6.375	6.3975	6.375	6.389	130120.0
2020-04-06 06:00:00	NVDA	Stock	6.393	6.3968	6.3785	6.3785	37800.0
2020-04-06 07:00:00	NVDA	Stock	6.359	6.385	6.3238	6.3375	1858360.0
2020-04-06 08:00:00	NVDA	Stock	6.325	6.3688	6.32	6.35	2433960.0
2020-04-06 09:00:00	NVDA	Stock	6.3562	6.544	6.3233	6.5293	118901320.0
2020-04-06 10:00:00	NVDA	Stock	6.5282	6.568	6.4645	6.5368	111439720.0
2020-04-06 11:00:00	NVDA	Stock	6.537	6.563	6.5175	6.5323	71242080.0
2020-04-06 12:00:00	NVDA	Stock	6.5341	6.5828	6.498	6.58	66035000.0
2020-04-06 13:00:00	NVDA	Stock	6.58	6.6098	6.5532	6.6018	53352200.0
2020-04-06 14:00:00	NVDA	Stock	6.6023	6.6039	6.552	6.5972	46219200.0
2020-04-06 15:00:00	NVDA	Stock	6.5956	6.747	6.5862	6.71	137466920.0
2020-04-06 16:00:00	NVDA	Stock	6.71	6.715	6.6875	6.695	42010640.0
2020-04-06 17:00:00	NVDA	Stock	6.6943	6.71	6.678	6.6938	713520.0
2020-04-06 18:00:00	NVDA	Stock	6.685	6.702	6.67	6.67	936840.0
2020-04-06 19:00:00	NVDA	Stock	6.6675	6.7345	6.665	6.7345	1429320.0
2020-04-06 04:00:00	AMZN	Stock	98.2845	98.2845	97.25	97.25	33420.0
2020-04-06 05:00:00	AMZN	Stock	97.995	97.995	97.995	97.995	2000.0

> showing 50 of 55,166 rows — these rows as CSV

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