PREVIEW / stock_1hour / 2020-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-15.parquet
  size:    1.3 MB
  rows:    58,049
  symbols: 2,454

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-07-15 04:00:00	AAPL	Stock	97.6	97.6	97.185	97.43	27688.0
2020-07-15 05:00:00	AAPL	Stock	97.425	98.565	97.425	98.25	184256.0
2020-07-15 06:00:00	AAPL	Stock	98.225	98.73	98.18	98.725	62988.0
2020-07-15 07:00:00	AAPL	Stock	98.7275	99.47	98.25	98.39	700548.0
2020-07-15 08:00:00	AAPL	Stock	99.1225	99.475	97.0575	98.6475	1281724.0
2020-07-15 09:00:00	AAPL	Stock	98.6625	99.2475	98.0875	98.6075	21418444.0
2020-07-15 10:00:00	AAPL	Stock	98.6075	98.915	97.5675	97.7268	16453576.0
2020-07-15 11:00:00	AAPL	Stock	97.7375	97.815	96.7025	96.7212	27984908.0
2020-07-15 12:00:00	AAPL	Stock	96.7275	97.5475	96.49	97.4525	12909268.0
2020-07-15 13:00:00	AAPL	Stock	97.46	97.8375	97.1275	97.3882	10314956.0
2020-07-15 14:00:00	AAPL	Stock	97.385	97.9575	97.165	97.215	10503044.0
2020-07-15 15:00:00	AAPL	Stock	97.2175	97.9175	96.9775	97.7275	14138680.0
2020-07-15 16:00:00	AAPL	Stock	97.7475	97.79	97.6525	97.7375	4963232.0
2020-07-15 17:00:00	AAPL	Stock	97.74	97.75	97.6875	97.705	39104.0
2020-07-15 18:00:00	AAPL	Stock	97.725	97.8125	97.25	97.25	194480.0
2020-07-15 19:00:00	AAPL	Stock	97.2425	97.425	97.125	97.21	167248.0
2020-07-15 04:00:00	MSFT	Stock	209.74	209.74	208.8	208.8	7362.0
2020-07-15 05:00:00	MSFT	Stock	208.7	208.8	207.62	207.89	9747.0
2020-07-15 06:00:00	MSFT	Stock	207.88	209.45	207.87	209.27	11936.0
2020-07-15 07:00:00	MSFT	Stock	209.13	209.6	208.58	209.18	79275.0
2020-07-15 08:00:00	MSFT	Stock	209.15	209.6	208.5	209.11	104774.0
2020-07-15 09:00:00	MSFT	Stock	209.14	211.33	208.68	209.915	3959658.0
2020-07-15 10:00:00	MSFT	Stock	209.93	210.8	209.18	209.25	3249526.0
2020-07-15 11:00:00	MSFT	Stock	209.24	209.43	206.18	206.2	4209206.0
2020-07-15 12:00:00	MSFT	Stock	206.18	207.27	205.03	207.11	3476353.0
2020-07-15 13:00:00	MSFT	Stock	207.13	207.44	206.16	206.965	1833748.0
2020-07-15 14:00:00	MSFT	Stock	206.96	208.41	206.67	207.065	2105079.0
2020-07-15 15:00:00	MSFT	Stock	207.01	208.21	206.2	208.05	3646006.0
2020-07-15 16:00:00	MSFT	Stock	208.04	208.04	207.5	207.68	2619847.0
2020-07-15 17:00:00	MSFT	Stock	207.59	208.0	207.55	207.9	10097.0
2020-07-15 18:00:00	MSFT	Stock	208.04	208.1	207.0	207.0	18483.0
2020-07-15 19:00:00	MSFT	Stock	206.8	207.2	206.8	207.0	8256.0
2020-07-15 04:00:00	NVDA	Stock	10.4562	10.4562	10.425	10.425	69440.0
2020-07-15 05:00:00	NVDA	Stock	10.4	10.4125	10.377	10.377	21240.0
2020-07-15 06:00:00	NVDA	Stock	10.355	10.4175	10.355	10.4175	83560.0
2020-07-15 07:00:00	NVDA	Stock	10.42	10.4873	10.4013	10.4143	818760.0
2020-07-15 08:00:00	NVDA	Stock	10.4375	10.49	10.3565	10.4238	1516920.0
2020-07-15 09:00:00	NVDA	Stock	10.4215	10.435	10.2362	10.2635	44538640.0
2020-07-15 10:00:00	NVDA	Stock	10.2665	10.3851	10.2345	10.3075	42729600.0
2020-07-15 11:00:00	NVDA	Stock	10.309	10.316	10.091	10.0966	52287160.0
2020-07-15 12:00:00	NVDA	Stock	10.09	10.178	10.0558	10.1722	40013640.0
2020-07-15 13:00:00	NVDA	Stock	10.1745	10.2375	10.1268	10.206	23601200.0
2020-07-15 14:00:00	NVDA	Stock	10.205	10.2648	10.1665	10.1825	27268240.0
2020-07-15 15:00:00	NVDA	Stock	10.1805	10.2518	10.158	10.2265	41688280.0
2020-07-15 16:00:00	NVDA	Stock	10.2272	10.2272	10.2	10.2138	28016880.0
2020-07-15 17:00:00	NVDA	Stock	10.2213	10.2373	10.2213	10.2313	196960.0
2020-07-15 18:00:00	NVDA	Stock	10.2373	10.2468	10.1812	10.1812	421760.0
2020-07-15 19:00:00	NVDA	Stock	10.1752	10.206	10.154	10.1575	279920.0
2020-07-15 04:00:00	AMZN	Stock	154.7725	154.801	154.7725	154.801	4000.0
2020-07-15 05:00:00	AMZN	Stock	154.525	154.525	154.3	154.3	12000.0

> showing 50 of 58,049 rows — these rows as CSV

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