PREVIEW / stock_1hour / 2021-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-16.parquet
  size:    1.4 MB
  rows:    65,605
  symbols: 2,958

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
2021-04-16 04:00:00	AAPL	Stock	134.29	134.36	134.1	134.1	11588.0
2021-04-16 05:00:00	AAPL	Stock	134.11	134.25	134.0	134.13	7051.0
2021-04-16 06:00:00	AAPL	Stock	134.13	134.27	134.05	134.24	7027.0
2021-04-16 07:00:00	AAPL	Stock	134.2	134.8	134.2	134.74	98596.0
2021-04-16 08:00:00	AAPL	Stock	134.3101	134.9	134.31	134.79	352559.0
2021-04-16 09:00:00	AAPL	Stock	134.78	134.98	133.28	133.41	14018404.0
2021-04-16 10:00:00	AAPL	Stock	133.415	134.58	133.3601	133.97	12363712.0
2021-04-16 11:00:00	AAPL	Stock	133.965	134.0979	133.67	133.83	8000344.0
2021-04-16 12:00:00	AAPL	Stock	133.825	134.1299	133.7301	133.78	6109495.0
2021-04-16 13:00:00	AAPL	Stock	133.785	133.9199	133.53	133.535	4682462.0
2021-04-16 14:00:00	AAPL	Stock	133.535	134.12	133.515	133.99	5088107.0
2021-04-16 15:00:00	AAPL	Stock	133.995	134.18	133.885	134.15	10511416.0
2021-04-16 16:00:00	AAPL	Stock	134.15	134.16	134.0	134.04	12179532.0
2021-04-16 17:00:00	AAPL	Stock	134.04	134.27	134.0	134.04	188146.0
2021-04-16 18:00:00	AAPL	Stock	134.05	134.15	134.05	134.12	40710.0
2021-04-16 19:00:00	AAPL	Stock	134.11	134.15	134.07	134.09	47708.0
2021-04-16 04:00:00	MSFT	Stock	258.26	258.88	257.96	258.52	2634.0
2021-04-16 05:00:00	MSFT	Stock	258.7	259.2	258.7	258.95	1512.0
2021-04-16 06:00:00	MSFT	Stock	259.1	259.5	259.1	259.17	2259.0
2021-04-16 07:00:00	MSFT	Stock	259.4	259.79	259.2	259.5	10713.0
2021-04-16 08:00:00	MSFT	Stock	259.48	260.34	258.852	259.9	28520.0
2021-04-16 09:00:00	MSFT	Stock	259.87	260.89	257.6014	258.3325	3975887.0
2021-04-16 10:00:00	MSFT	Stock	258.33	260.53	258.28	259.58	2484369.0
2021-04-16 11:00:00	MSFT	Stock	259.6	259.7	259.01	259.45	1498247.0
2021-04-16 12:00:00	MSFT	Stock	259.45	260.64	259.38	260.17	2176136.0
2021-04-16 13:00:00	MSFT	Stock	260.18	260.48	259.81	259.92	964925.0
2021-04-16 14:00:00	MSFT	Stock	259.91	260.8	259.86	260.58	1100032.0
2021-04-16 15:00:00	MSFT	Stock	260.59	261.0	260.14	260.74	2959582.0
2021-04-16 16:00:00	MSFT	Stock	260.74	260.74	260.42	260.55	3951041.0
2021-04-16 17:00:00	MSFT	Stock	260.55	260.74	260.33	260.33	15773.0
2021-04-16 18:00:00	MSFT	Stock	260.3	260.65	260.3	260.6	1743.0
2021-04-16 19:00:00	MSFT	Stock	260.62	260.98	260.6	260.75	10624.0
2021-04-16 04:00:00	NVDA	Stock	16.103	16.103	16.103	16.103	4960.0
2021-04-16 05:00:00	NVDA	Stock	16.1	16.1045	16.1	16.1	15480.0
2021-04-16 06:00:00	NVDA	Stock	16.1173	16.15	16.1173	16.15	18720.0
2021-04-16 07:00:00	NVDA	Stock	16.15	16.212	16.1488	16.1975	382320.0
2021-04-16 08:00:00	NVDA	Stock	16.175	16.2198	16.0969	16.1512	945960.0
2021-04-16 09:00:00	NVDA	Stock	16.1539	16.1673	15.8952	15.9023	53736040.0
2021-04-16 10:00:00	NVDA	Stock	15.906	16.0325	15.8835	15.975	41070480.0
2021-04-16 11:00:00	NVDA	Stock	15.9775	15.9875	15.9128	15.9715	14662040.0
2021-04-16 12:00:00	NVDA	Stock	15.975	16.0552	15.9635	15.976	20326240.0
2021-04-16 13:00:00	NVDA	Stock	15.9722	15.9933	15.8652	15.878	12220560.0
2021-04-16 14:00:00	NVDA	Stock	15.877	15.9578	15.8755	15.945	13935880.0
2021-04-16 15:00:00	NVDA	Stock	15.9498	15.9698	15.8912	15.9125	28750520.0
2021-04-16 16:00:00	NVDA	Stock	15.9125	15.9562	15.8925	15.8998	20013480.0
2021-04-16 17:00:00	NVDA	Stock	15.908	15.9125	15.8835	15.8895	592640.0
2021-04-16 18:00:00	NVDA	Stock	15.8895	15.9075	15.8895	15.9075	65560.0
2021-04-16 19:00:00	NVDA	Stock	15.9	15.9125	15.9	15.9125	13360.0
2021-04-16 07:00:00	AMZN	Stock	168.9	169.595	168.9	169.5	23840.0
2021-04-16 08:00:00	AMZN	Stock	169.35	169.75	168.5322	169.4	83240.0

> showing 50 of 65,605 rows — these rows as CSV

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