PREVIEW / stock_1hour / 2020-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-02.parquet
  size:    1.2 MB
  rows:    55,647
  symbols: 2,410

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-06-02 04:00:00	AAPL	Stock	80.6225	80.905	80.6225	80.905	44292.0
2020-06-02 05:00:00	AAPL	Stock	80.8525	80.9975	80.8525	80.9975	9920.0
2020-06-02 06:00:00	AAPL	Stock	80.98	80.995	80.85	80.9475	20484.0
2020-06-02 07:00:00	AAPL	Stock	80.8625	80.96	80.2025	80.3125	392504.0
2020-06-02 08:00:00	AAPL	Stock	80.8075	80.9538	80.05	80.225	603408.0
2020-06-02 09:00:00	AAPL	Stock	80.225	80.6175	80.125	80.255	10997432.0
2020-06-02 10:00:00	AAPL	Stock	80.2625	80.575	80.0425	80.1218	11868176.0
2020-06-02 11:00:00	AAPL	Stock	80.12	80.1375	79.7325	79.93	10404800.0
2020-06-02 12:00:00	AAPL	Stock	79.9275	80.2775	79.9125	80.2625	4670584.0
2020-06-02 13:00:00	AAPL	Stock	80.27	80.55	80.245	80.436	6424508.0
2020-06-02 14:00:00	AAPL	Stock	80.4375	80.5775	80.32	80.4975	6020356.0
2020-06-02 15:00:00	AAPL	Stock	80.4975	80.86	80.3275	80.855	12674872.0
2020-06-02 16:00:00	AAPL	Stock	80.8525	80.855	80.1515	80.7775	7569140.0
2020-06-02 17:00:00	AAPL	Stock	80.775	80.8	80.7625	80.775	116804.0
2020-06-02 18:00:00	AAPL	Stock	80.775	80.8	80.705	80.7475	118532.0
2020-06-02 19:00:00	AAPL	Stock	80.7475	80.87	80.7025	80.8375	178864.0
2020-06-02 04:00:00	MSFT	Stock	183.41	184.3	183.41	184.09	13241.0
2020-06-02 05:00:00	MSFT	Stock	184.08	184.42	184.0	184.35	2344.0
2020-06-02 06:00:00	MSFT	Stock	184.5	185.4	184.48	185.1	23065.0
2020-06-02 07:00:00	MSFT	Stock	185.01	185.01	184.18	184.18	83918.0
2020-06-02 08:00:00	MSFT	Stock	184.316	184.95	183.28	184.26	124066.0
2020-06-02 09:00:00	MSFT	Stock	184.374	184.85	182.31	182.5	3452767.0
2020-06-02 10:00:00	MSFT	Stock	182.49	183.45	181.91	182.32	3916438.0
2020-06-02 11:00:00	MSFT	Stock	182.32	182.32	181.35	181.98	3260895.0
2020-06-02 12:00:00	MSFT	Stock	181.96	182.57	181.93	182.45	1417496.0
2020-06-02 13:00:00	MSFT	Stock	182.47	183.42	182.41	183.4	1944062.0
2020-06-02 14:00:00	MSFT	Stock	183.42	183.66	183.12	183.54	2112304.0
2020-06-02 15:00:00	MSFT	Stock	183.56	185.0	183.2	185.0	4976816.0
2020-06-02 16:00:00	MSFT	Stock	185.0	185.01	183.399	184.91	4689248.0
2020-06-02 17:00:00	MSFT	Stock	184.93	185.0	184.61	184.92	21727.0
2020-06-02 18:00:00	MSFT	Stock	184.93	184.97	184.75	184.75	7465.0
2020-06-02 19:00:00	MSFT	Stock	184.75	185.2	184.61	185.2	27217.0
2020-06-02 04:00:00	NVDA	Stock	8.8615	8.8865	8.8615	8.879	44320.0
2020-06-02 05:00:00	NVDA	Stock	8.9	8.9043	8.895	8.9043	45240.0
2020-06-02 06:00:00	NVDA	Stock	8.9125	8.9125	8.9125	8.9125	109840.0
2020-06-02 07:00:00	NVDA	Stock	8.9002	8.9002	8.85	8.85	751000.0
2020-06-02 08:00:00	NVDA	Stock	8.89	8.9125	8.7895	8.835	1879240.0
2020-06-02 09:00:00	NVDA	Stock	8.8318	8.8318	8.6902	8.769	67289480.0
2020-06-02 10:00:00	NVDA	Stock	8.7663	8.8028	8.6975	8.7335	63624440.0
2020-06-02 11:00:00	NVDA	Stock	8.7335	8.7382	8.658	8.6823	48788800.0
2020-06-02 12:00:00	NVDA	Stock	8.682	8.735	8.6763	8.7288	28068160.0
2020-06-02 13:00:00	NVDA	Stock	8.7318	8.7812	8.7318	8.775	33419360.0
2020-06-02 14:00:00	NVDA	Stock	8.7738	8.797	8.74	8.7565	35177600.0
2020-06-02 15:00:00	NVDA	Stock	8.759	8.8373	8.7445	8.832	54521240.0
2020-06-02 16:00:00	NVDA	Stock	8.8348	8.8375	8.7512	8.8373	17569240.0
2020-06-02 17:00:00	NVDA	Stock	8.8395	8.8498	8.8284	8.8375	266840.0
2020-06-02 18:00:00	NVDA	Stock	8.8425	8.8495	8.825	8.8398	205680.0
2020-06-02 19:00:00	NVDA	Stock	8.8225	8.85	8.8225	8.85	130680.0
2020-06-02 04:00:00	AMZN	Stock	123.75	123.75	123.75	123.75	11540.0
2020-06-02 05:00:00	AMZN	Stock	123.9015	124.0275	123.9015	124.0	18480.0

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

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