PREVIEW / stock_1hour / 2021-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-03.parquet
  size:    1.4 MB
  rows:    63,446
  symbols: 2,689

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-09-03 04:00:00	AAPL	Stock	153.77	154.12	153.77	154.03	11798.0
2021-09-03 05:00:00	AAPL	Stock	154.01	154.01	153.91	153.91	2496.0
2021-09-03 06:00:00	AAPL	Stock	153.95	153.95	153.86	153.88	2416.0
2021-09-03 07:00:00	AAPL	Stock	153.89	154.3	153.88	154.18	105122.0
2021-09-03 08:00:00	AAPL	Stock	153.9	154.55	153.266	154.14	740011.0
2021-09-03 09:00:00	AAPL	Stock	154.18	154.63	153.09	154.335	10941518.0
2021-09-03 10:00:00	AAPL	Stock	154.33	154.62	153.7	153.89	10265358.0
2021-09-03 11:00:00	AAPL	Stock	153.885	154.24	153.75	153.9815	4571208.0
2021-09-03 12:00:00	AAPL	Stock	153.99	154.19	153.765	153.85	4311997.0
2021-09-03 13:00:00	AAPL	Stock	153.84	154.22	153.83	154.1901	4116376.0
2021-09-03 14:00:00	AAPL	Stock	154.191	154.24	153.785	154.065	4361232.0
2021-09-03 15:00:00	AAPL	Stock	154.0607	154.45	154.05	154.31	7975052.0
2021-09-03 16:00:00	AAPL	Stock	154.31	154.38	154.17	154.22	4524139.0
2021-09-03 17:00:00	AAPL	Stock	154.24	154.34	154.23	154.3	40652.0
2021-09-03 18:00:00	AAPL	Stock	154.3	154.3	154.23	154.28	15863.0
2021-09-03 19:00:00	AAPL	Stock	154.29	154.34	154.29	154.29	37613.0
2021-09-03 04:00:00	MSFT	Stock	302.19	302.35	301.65	301.7	1424.0
2021-09-03 05:00:00	MSFT	Stock	302.02	302.04	302.02	302.04	200.0
2021-09-03 06:00:00	MSFT	Stock	301.98	301.98	301.98	301.98	100.0
2021-09-03 07:00:00	MSFT	Stock	301.99	301.99	301.67	301.67	6677.0
2021-09-03 08:00:00	MSFT	Stock	301.9776	302.48	300.5	301.64	62951.0
2021-09-03 09:00:00	MSFT	Stock	301.5	301.88	300.26	301.7	1383564.0
2021-09-03 10:00:00	MSFT	Stock	301.68	302.42	301.2	301.76	1407743.0
2021-09-03 11:00:00	MSFT	Stock	301.77	302.6	301.51	301.9	951594.0
2021-09-03 12:00:00	MSFT	Stock	301.89	302.15	301.49	301.67	792886.0
2021-09-03 13:00:00	MSFT	Stock	301.68	302.3899	301.665	302.11	715323.0
2021-09-03 14:00:00	MSFT	Stock	302.1	302.1199	301.565	301.725	836920.0
2021-09-03 15:00:00	MSFT	Stock	301.73	302.01	300.875	301.15	1660355.0
2021-09-03 16:00:00	MSFT	Stock	301.2	301.29	301.0464	301.07	2930212.0
2021-09-03 17:00:00	MSFT	Stock	301.06	301.13	301.04	301.04	1750.0
2021-09-03 18:00:00	MSFT	Stock	301.09	301.12	300.9	300.99	702.0
2021-09-03 19:00:00	MSFT	Stock	300.99	301.0	300.9	300.98	1674.0
2021-09-03 04:00:00	NVDA	Stock	22.45	22.45	22.4	22.416	6490.0
2021-09-03 05:00:00	NVDA	Stock	22.413	22.413	22.413	22.413	1250.0
2021-09-03 06:00:00	NVDA	Stock	22.446	22.479	22.446	22.479	21510.0
2021-09-03 07:00:00	NVDA	Stock	22.47	22.475	22.43	22.464	73000.0
2021-09-03 08:00:00	NVDA	Stock	22.44	22.541	22.3401	22.42	1716050.0
2021-09-03 09:00:00	NVDA	Stock	22.41	22.6279	22.2	22.622	32288980.0
2021-09-03 10:00:00	NVDA	Stock	22.622	22.788	22.601	22.714	47692320.0
2021-09-03 11:00:00	NVDA	Stock	22.711	22.909	22.669	22.836	39684610.0
2021-09-03 12:00:00	NVDA	Stock	22.838	22.9768	22.78	22.957	31325860.0
2021-09-03 13:00:00	NVDA	Stock	22.9573	22.986	22.8492	22.8863	19712720.0
2021-09-03 14:00:00	NVDA	Stock	22.8869	22.935	22.846	22.8655	16079240.0
2021-09-03 15:00:00	NVDA	Stock	22.866	22.914	22.822	22.841	23585190.0
2021-09-03 16:00:00	NVDA	Stock	22.8414	22.865	22.83	22.86	14200780.0
2021-09-03 17:00:00	NVDA	Stock	22.858	22.894	22.85	22.894	128220.0
2021-09-03 18:00:00	NVDA	Stock	22.897	22.898	22.855	22.88	198910.0
2021-09-03 19:00:00	NVDA	Stock	22.894	22.896	22.86	22.871	110090.0
2021-09-03 04:00:00	AMZN	Stock	173.5	173.5	173.5	173.5	9940.0
2021-09-03 05:00:00	AMZN	Stock	173.4	173.4	173.4	173.4	19240.0

> showing 50 of 63,446 rows — these rows as CSV

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