PREVIEW / stock_1hour / 2020-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-01.parquet
  size:    1.3 MB
  rows:    57,372
  symbols: 2,466

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-09-01 04:00:00	AAPL	Stock	132.1	132.5	131.55	132.14	263384.0
2020-09-01 05:00:00	AAPL	Stock	132.13	132.69	131.83	132.4	142702.0
2020-09-01 06:00:00	AAPL	Stock	132.45	132.5	132.01	132.39	110937.0
2020-09-01 07:00:00	AAPL	Stock	132.32	132.4	131.16	131.99	886833.0
2020-09-01 08:00:00	AAPL	Stock	131.98	132.54	131.164	131.4	1941908.0
2020-09-01 09:00:00	AAPL	Stock	131.42	132.92	129.04	131.64	25704673.0
2020-09-01 10:00:00	AAPL	Stock	131.65	132.2	130.77	131.77	18188789.0
2020-09-01 11:00:00	AAPL	Stock	131.78	132.65	131.75	132.31	14456127.0
2020-09-01 12:00:00	AAPL	Stock	132.31	133.94	132.247	133.705	15088271.0
2020-09-01 13:00:00	AAPL	Stock	133.706	134.8	133.23	134.67	14320073.0
2020-09-01 14:00:00	AAPL	Stock	134.67	134.7	133.67	133.97	13081743.0
2020-09-01 15:00:00	AAPL	Stock	133.95	134.54	133.55	134.2	17775367.0
2020-09-01 16:00:00	AAPL	Stock	134.2	134.75	134.14	134.45	7825498.0
2020-09-01 17:00:00	AAPL	Stock	134.45	134.6	134.25	134.34	192782.0
2020-09-01 18:00:00	AAPL	Stock	134.34	134.34	134.12	134.12	214144.0
2020-09-01 19:00:00	AAPL	Stock	134.12	135.0	134.1	135.0	250515.0
2020-09-01 04:00:00	MSFT	Stock	225.88	227.42	225.81	225.93	26977.0
2020-09-01 05:00:00	MSFT	Stock	226.0	227.2	226.0	226.82	18199.0
2020-09-01 06:00:00	MSFT	Stock	226.73	227.48	226.51	227.48	5283.0
2020-09-01 07:00:00	MSFT	Stock	227.33	227.45	226.7	226.91	52487.0
2020-09-01 08:00:00	MSFT	Stock	226.958	227.45	226.45	226.7	83533.0
2020-09-01 09:00:00	MSFT	Stock	226.7	226.7	224.43	226.03	3185632.0
2020-09-01 10:00:00	MSFT	Stock	226.03	226.98	225.83	226.14	2906481.0
2020-09-01 11:00:00	MSFT	Stock	226.125	226.85	225.29	226.149	2134739.0
2020-09-01 12:00:00	MSFT	Stock	226.15	226.45	224.86	224.99	1827657.0
2020-09-01 13:00:00	MSFT	Stock	224.98	226.18	224.6	225.625	2049788.0
2020-09-01 14:00:00	MSFT	Stock	225.61	226.67	225.45	226.62	1571119.0
2020-09-01 15:00:00	MSFT	Stock	226.62	227.45	226.02	227.32	2944645.0
2020-09-01 16:00:00	MSFT	Stock	227.27	227.89	226.7	227.89	2902680.0
2020-09-01 17:00:00	MSFT	Stock	227.88	227.9	226.78	227.17	24835.0
2020-09-01 18:00:00	MSFT	Stock	227.15	227.8	226.98	227.35	26079.0
2020-09-01 19:00:00	MSFT	Stock	227.74	228.0	227.37	228.0	26283.0
2020-09-01 04:00:00	NVDA	Stock	13.465	13.465	13.4502	13.4628	405600.0
2020-09-01 05:00:00	NVDA	Stock	13.4635	13.469	13.4635	13.469	96920.0
2020-09-01 06:00:00	NVDA	Stock	13.4622	13.4825	13.4622	13.4825	47560.0
2020-09-01 07:00:00	NVDA	Stock	13.4752	13.4875	13.455	13.4875	780160.0
2020-09-01 08:00:00	NVDA	Stock	13.4745	13.525	13.455	13.4668	1901120.0
2020-09-01 09:00:00	NVDA	Stock	13.4668	13.7502	13.4261	13.7102	67861920.0
2020-09-01 10:00:00	NVDA	Stock	13.714	13.886	13.682	13.8	103507400.0
2020-09-01 11:00:00	NVDA	Stock	13.8072	13.8435	13.7402	13.804	34331640.0
2020-09-01 12:00:00	NVDA	Stock	13.8032	13.9938	13.7002	13.7547	98488040.0
2020-09-01 13:00:00	NVDA	Stock	13.7515	13.8358	13.6902	13.7375	38614520.0
2020-09-01 14:00:00	NVDA	Stock	13.7409	13.83	13.716	13.7771	28086120.0
2020-09-01 15:00:00	NVDA	Stock	13.7762	13.8662	13.747	13.825	50119960.0
2020-09-01 16:00:00	NVDA	Stock	13.821	13.8708	13.805	13.8538	17321920.0
2020-09-01 17:00:00	NVDA	Stock	13.8538	13.875	13.8363	13.8748	423600.0
2020-09-01 18:00:00	NVDA	Stock	13.872	13.872	13.8602	13.87	140520.0
2020-09-01 19:00:00	NVDA	Stock	13.87	13.8955	13.857	13.87	603480.0
2020-09-01 04:00:00	AMZN	Stock	174.0	174.1875	174.0	174.1875	14000.0
2020-09-01 05:00:00	AMZN	Stock	174.5	174.5	174.4	174.4	5200.0

> showing 50 of 57,372 rows — these rows as CSV

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