PREVIEW / stock_1hour / 2020-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-06.parquet
  size:    1.2 MB
  rows:    51,758
  symbols: 2,475

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-01-06 04:00:00	AAPL	Stock	73.8575	73.8775	73.49	73.725	110820.0
2020-01-06 05:00:00	AAPL	Stock	73.725	73.825	73.6725	73.7375	58660.0
2020-01-06 06:00:00	AAPL	Stock	73.6775	73.78	73.475	73.675	120060.0
2020-01-06 07:00:00	AAPL	Stock	73.685	73.875	73.6025	73.6875	589080.0
2020-01-06 08:00:00	AAPL	Stock	73.7625	73.875	73.57	73.65	1090608.0
2020-01-06 09:00:00	AAPL	Stock	73.63	74.2475	73.1875	74.21	22372624.0
2020-01-06 10:00:00	AAPL	Stock	74.22	74.5597	74.0562	74.51	15879492.0
2020-01-06 11:00:00	AAPL	Stock	74.5175	74.91	74.4125	74.6145	14269836.0
2020-01-06 12:00:00	AAPL	Stock	74.61	74.615	74.285	74.5312	9197808.0
2020-01-06 13:00:00	AAPL	Stock	74.5387	74.8425	74.51	74.7982	7459688.0
2020-01-06 14:00:00	AAPL	Stock	74.7975	74.99	74.745	74.845	9546892.0
2020-01-06 15:00:00	AAPL	Stock	74.845	74.97	74.735	74.945	14053000.0
2020-01-06 16:00:00	AAPL	Stock	74.95	74.9675	74.825	74.8925	5757244.0
2020-01-06 17:00:00	AAPL	Stock	74.88	74.9225	74.8525	74.885	102108.0
2020-01-06 18:00:00	AAPL	Stock	74.885	74.89	74.75	74.7525	76424.0
2020-01-06 19:00:00	AAPL	Stock	74.7625	74.92	74.7625	74.905	86468.0
2020-01-06 04:00:00	MSFT	Stock	157.4	157.4	156.8	156.92	21619.0
2020-01-06 05:00:00	MSFT	Stock	156.9	157.1	156.73	157.0	7326.0
2020-01-06 06:00:00	MSFT	Stock	156.82	157.11	156.82	157.11	4889.0
2020-01-06 07:00:00	MSFT	Stock	157.11	157.67	157.0	157.33	24729.0
2020-01-06 08:00:00	MSFT	Stock	157.35	157.66	157.01	157.34	46696.0
2020-01-06 09:00:00	MSFT	Stock	157.37	158.275	156.51	158.25	2825639.0
2020-01-06 10:00:00	MSFT	Stock	158.25	158.925	157.99	158.61	2119417.0
2020-01-06 11:00:00	MSFT	Stock	158.62	158.82	158.24	158.24	1268820.0
2020-01-06 12:00:00	MSFT	Stock	158.24	158.346	157.975	158.306	1214262.0
2020-01-06 13:00:00	MSFT	Stock	158.28	158.54	158.223	158.375	955182.0
2020-01-06 14:00:00	MSFT	Stock	158.364	158.7	158.27	158.495	1110224.0
2020-01-06 15:00:00	MSFT	Stock	158.5	159.1	158.27	159.02	3118208.0
2020-01-06 16:00:00	MSFT	Stock	159.03	159.05	158.75	158.81	4227094.0
2020-01-06 17:00:00	MSFT	Stock	158.81	159.03	158.65	158.8	1311002.0
2020-01-06 18:00:00	MSFT	Stock	158.8	158.8	158.67	158.67	3361.0
2020-01-06 19:00:00	MSFT	Stock	158.67	158.94	158.67	158.8	8286.0
2020-01-06 04:00:00	NVDA	Stock	5.825	5.825	5.7693	5.8	215000.0
2020-01-06 05:00:00	NVDA	Stock	5.806	5.8078	5.7995	5.7995	71680.0
2020-01-06 06:00:00	NVDA	Stock	5.7985	5.8072	5.7975	5.8072	61640.0
2020-01-06 07:00:00	NVDA	Stock	5.818	5.8438	5.7925	5.8315	583240.0
2020-01-06 08:00:00	NVDA	Stock	5.8107	5.8375	5.802	5.8064	1168400.0
2020-01-06 09:00:00	NVDA	Stock	5.8125	5.8682	5.7828	5.8605	56405560.0
2020-01-06 10:00:00	NVDA	Stock	5.861	5.9318	5.8505	5.9178	46811400.0
2020-01-06 11:00:00	NVDA	Stock	5.9183	5.9241	5.8998	5.9112	23373640.0
2020-01-06 12:00:00	NVDA	Stock	5.9112	5.9112	5.8838	5.8875	18907440.0
2020-01-06 13:00:00	NVDA	Stock	5.887	5.911	5.8843	5.8995	18013400.0
2020-01-06 14:00:00	NVDA	Stock	5.8992	5.9175	5.894	5.9133	13504520.0
2020-01-06 15:00:00	NVDA	Stock	5.9138	5.9282	5.9083	5.9258	28456680.0
2020-01-06 16:00:00	NVDA	Stock	5.9265	5.9312	5.9112	5.9273	4327360.0
2020-01-06 17:00:00	NVDA	Stock	5.9278	5.9325	5.9263	5.9263	6733560.0
2020-01-06 18:00:00	NVDA	Stock	5.926	5.926	5.9238	5.924	127760.0
2020-01-06 19:00:00	NVDA	Stock	5.9228	5.935	5.9228	5.935	134120.0
2020-01-06 04:00:00	AMZN	Stock	92.985	92.985	92.6695	92.809	26820.0
2020-01-06 05:00:00	AMZN	Stock	92.9	92.9	92.85	92.85	13300.0

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

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