PREVIEW / stock_1hour / 2022-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-22.parquet
  size:    1.3 MB
  rows:    59,963
  symbols: 2,278

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
2022-07-22 04:00:00	AAPL	Stock	154.75	155.0	154.72	154.95	30417.0
2022-07-22 05:00:00	AAPL	Stock	155.0	155.32	155.0	155.26	56525.0
2022-07-22 06:00:00	AAPL	Stock	155.15	155.73	154.98	155.45	53693.0
2022-07-22 07:00:00	AAPL	Stock	155.45	155.9	155.0	155.86	120267.0
2022-07-22 08:00:00	AAPL	Stock	155.37	155.86	154.58	155.49	304395.0
2022-07-22 09:00:00	AAPL	Stock	155.5	156.28	154.92	155.2644	7900497.0
2022-07-22 10:00:00	AAPL	Stock	155.27	156.0	154.9811	155.6703	8361073.0
2022-07-22 11:00:00	AAPL	Stock	155.6699	155.72	154.07	154.6155	7908882.0
2022-07-22 12:00:00	AAPL	Stock	154.61	154.92	153.97	154.5183	5969023.0
2022-07-22 13:00:00	AAPL	Stock	154.52	154.53	153.41	154.005	5324157.0
2022-07-22 14:00:00	AAPL	Stock	154.02	154.05	153.41	153.795	5108746.0
2022-07-22 15:00:00	AAPL	Stock	153.8	154.53	153.56	154.14	10478497.0
2022-07-22 16:00:00	AAPL	Stock	154.14	154.32	154.05	154.3	6665353.0
2022-07-22 17:00:00	AAPL	Stock	154.34	154.35	153.95	154.04	62576.0
2022-07-22 18:00:00	AAPL	Stock	154.08	154.09	153.85	153.99	22055.0
2022-07-22 19:00:00	AAPL	Stock	153.91	153.98	153.82	153.93	19377.0
2022-07-22 04:00:00	MSFT	Stock	263.69	264.59	263.17	264.25	5504.0
2022-07-22 05:00:00	MSFT	Stock	264.77	264.89	263.98	264.0	5686.0
2022-07-22 06:00:00	MSFT	Stock	264.18	264.84	264.18	264.4	7053.0
2022-07-22 07:00:00	MSFT	Stock	264.45	265.5	264.25	265.5	20298.0
2022-07-22 08:00:00	MSFT	Stock	264.2598	265.6598	263.57	265.35	40149.0
2022-07-22 09:00:00	MSFT	Stock	265.23	265.8	262.35	263.21	3382635.0
2022-07-22 10:00:00	MSFT	Stock	263.195	263.92	261.9	262.62	2226303.0
2022-07-22 11:00:00	MSFT	Stock	262.62	262.7	259.66	260.83	1601201.0
2022-07-22 12:00:00	MSFT	Stock	260.81	261.1299	259.36	260.43	1143573.0
2022-07-22 13:00:00	MSFT	Stock	260.405	260.43	259.07	259.8901	917646.0
2022-07-22 14:00:00	MSFT	Stock	259.92	260.3	259.16	259.995	895593.0
2022-07-22 15:00:00	MSFT	Stock	259.98	260.93	259.32	260.46	2719663.0
2022-07-22 16:00:00	MSFT	Stock	260.39	260.76	260.27	260.66	3789215.0
2022-07-22 17:00:00	MSFT	Stock	260.689	260.74	260.35	260.36	16902.0
2022-07-22 18:00:00	MSFT	Stock	260.25	260.49	260.12	260.2	1857.0
2022-07-22 19:00:00	MSFT	Stock	260.25	260.25	260.0	260.05	3674.0
2022-07-22 04:00:00	NVDA	Stock	17.799	17.899	17.732	17.805	151530.0
2022-07-22 05:00:00	NVDA	Stock	17.82	17.824	17.737	17.77	213400.0
2022-07-22 06:00:00	NVDA	Stock	17.754	17.82	17.75	17.8	92830.0
2022-07-22 07:00:00	NVDA	Stock	17.8	17.929	17.775	17.925	496530.0
2022-07-22 08:00:00	NVDA	Stock	17.788	18.0049	17.631	17.858	1395980.0
2022-07-22 09:00:00	NVDA	Stock	17.863	17.967	17.51	17.513	63897260.0
2022-07-22 10:00:00	NVDA	Stock	17.511	17.694	17.352	17.635	93607380.0
2022-07-22 11:00:00	NVDA	Stock	17.636	17.656	17.218	17.373	62008460.0
2022-07-22 12:00:00	NVDA	Stock	17.372	17.4233	17.243	17.258	42284220.0
2022-07-22 13:00:00	NVDA	Stock	17.259	17.2634	17.1365	17.2378	40336000.0
2022-07-22 14:00:00	NVDA	Stock	17.237	17.282	17.147	17.258	34330610.0
2022-07-22 15:00:00	NVDA	Stock	17.254	17.333	17.199	17.319	64205640.0
2022-07-22 16:00:00	NVDA	Stock	17.319	17.32	17.277	17.288	24755640.0
2022-07-22 17:00:00	NVDA	Stock	17.2988	17.299	17.26	17.2648	182520.0
2022-07-22 18:00:00	NVDA	Stock	17.263	17.27	17.233	17.247	145140.0
2022-07-22 19:00:00	NVDA	Stock	17.248	17.25	17.222	17.246	177250.0
2022-07-22 04:00:00	AMZN	Stock	124.27	124.27	123.55	124.08	10111.0
2022-07-22 05:00:00	AMZN	Stock	124.09	124.26	124.0	124.2	34211.0

> showing 50 of 59,963 rows — these rows as CSV

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