PREVIEW / stock_1hour / 2021-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-04.parquet
  size:    1.5 MB
  rows:    70,626
  symbols: 2,873

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-03-04 04:00:00	AAPL	Stock	121.77	122.25	120.93	121.5	54584.0
2021-03-04 05:00:00	AAPL	Stock	121.45	121.57	120.8	121.1	22572.0
2021-03-04 06:00:00	AAPL	Stock	121.1	121.73	120.7	121.68	29494.0
2021-03-04 07:00:00	AAPL	Stock	121.66	122.08	121.0	121.82	624630.0
2021-03-04 08:00:00	AAPL	Stock	121.42	122.49	121.01	122.13	602092.0
2021-03-04 09:00:00	AAPL	Stock	122.11	123.6	120.59	120.945	16667427.0
2021-03-04 10:00:00	AAPL	Stock	120.96	123.0	120.32	122.825	21530318.0
2021-03-04 11:00:00	AAPL	Stock	122.82	123.28	121.97	122.5433	12522731.0
2021-03-04 12:00:00	AAPL	Stock	122.55	123.05	119.76	120.39	20630116.0
2021-03-04 13:00:00	AAPL	Stock	120.395	120.71	118.69	118.7507	20508398.0
2021-03-04 14:00:00	AAPL	Stock	118.76	120.86	118.62	120.35	17818088.0
2021-03-04 15:00:00	AAPL	Stock	120.31	120.51	119.51	120.22	23235039.0
2021-03-04 16:00:00	AAPL	Stock	120.13	120.6643	119.7	119.7	7823286.0
2021-03-04 17:00:00	AAPL	Stock	119.7	120.13	119.62	119.9	525005.0
2021-03-04 18:00:00	AAPL	Stock	119.9	119.97	119.2	119.32	202310.0
2021-03-04 19:00:00	AAPL	Stock	119.27	119.35	118.0	118.69	397521.0
2021-03-04 04:00:00	MSFT	Stock	226.7	227.25	226.03	227.11	11106.0
2021-03-04 05:00:00	MSFT	Stock	227.0	227.32	226.14	226.8	8496.0
2021-03-04 06:00:00	MSFT	Stock	226.5	227.29	226.03	227.02	10632.0
2021-03-04 07:00:00	MSFT	Stock	227.02	227.6	226.74	227.18	26205.0
2021-03-04 08:00:00	MSFT	Stock	227.42	227.98	226.57	227.01	34757.0
2021-03-04 09:00:00	MSFT	Stock	227.27	229.1879	226.05	226.92	3183237.0
2021-03-04 10:00:00	MSFT	Stock	226.86	231.45	226.05	230.85	4787785.0
2021-03-04 11:00:00	MSFT	Stock	230.8558	232.49	230.05	231.0899	2909874.0
2021-03-04 12:00:00	MSFT	Stock	231.14	231.64	226.21	226.6642	3614506.0
2021-03-04 13:00:00	MSFT	Stock	226.65	227.46	224.26	224.33	4383975.0
2021-03-04 14:00:00	MSFT	Stock	224.33	227.82	224.29	227.18	3712574.0
2021-03-04 15:00:00	MSFT	Stock	227.16	227.39	225.2101	226.9	5111729.0
2021-03-04 16:00:00	MSFT	Stock	226.73	227.4802	225.9	226.02	3660880.0
2021-03-04 17:00:00	MSFT	Stock	226.3	226.73	225.52	226.47	51442.0
2021-03-04 18:00:00	MSFT	Stock	226.31	226.31	225.5	225.5	4807.0
2021-03-04 19:00:00	MSFT	Stock	225.48	226.22	224.1	225.0	19878.0
2021-03-04 04:00:00	NVDA	Stock	12.7888	12.8505	12.6625	12.6995	149440.0
2021-03-04 05:00:00	NVDA	Stock	12.7125	12.7125	12.55	12.6	241320.0
2021-03-04 06:00:00	NVDA	Stock	12.6003	12.71	12.5925	12.71	122640.0
2021-03-04 07:00:00	NVDA	Stock	12.6833	12.8137	12.6833	12.7375	780960.0
2021-03-04 08:00:00	NVDA	Stock	12.7476	12.85	12.7	12.8	1383120.0
2021-03-04 09:00:00	NVDA	Stock	12.8088	12.975	12.5628	12.575	38799120.0
2021-03-04 10:00:00	NVDA	Stock	12.5708	12.7528	12.3783	12.7248	64741680.0
2021-03-04 11:00:00	NVDA	Stock	12.7248	12.7983	12.6058	12.7318	19335840.0
2021-03-04 12:00:00	NVDA	Stock	12.7322	12.759	12.3588	12.4148	37892280.0
2021-03-04 13:00:00	NVDA	Stock	12.4192	12.4645	12.0978	12.1	50211600.0
2021-03-04 14:00:00	NVDA	Stock	12.099	12.4285	12.0838	12.3918	37124960.0
2021-03-04 15:00:00	NVDA	Stock	12.3958	12.4128	12.2515	12.3702	52060480.0
2021-03-04 16:00:00	NVDA	Stock	12.3715	12.42	12.3375	12.3375	22773880.0
2021-03-04 17:00:00	NVDA	Stock	12.3278	12.3702	12.3028	12.3213	852520.0
2021-03-04 18:00:00	NVDA	Stock	12.3125	12.3125	12.25	12.275	275120.0
2021-03-04 19:00:00	NVDA	Stock	12.25	12.25	12.125	12.15	618720.0
2021-03-04 04:00:00	AMZN	Stock	149.9	150.0	149.9	150.0	7280.0
2021-03-04 06:00:00	AMZN	Stock	149.5995	149.5995	149.5995	149.5995	2000.0

> showing 50 of 70,626 rows — these rows as CSV

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