PREVIEW / stock_1hour / 2022-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-06.parquet
  size:    1.3 MB
  rows:    61,188
  symbols: 2,317

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-06 04:00:00	AAPL	Stock	141.9	142.0	141.03	141.25	24687.0
2022-07-06 05:00:00	AAPL	Stock	141.14	141.49	141.03	141.42	9919.0
2022-07-06 06:00:00	AAPL	Stock	141.42	141.56	141.12	141.3	13920.0
2022-07-06 07:00:00	AAPL	Stock	141.21	141.21	140.45	140.62	79625.0
2022-07-06 08:00:00	AAPL	Stock	141.2202	141.57	140.23	140.9101	346925.0
2022-07-06 09:00:00	AAPL	Stock	140.92	142.87	140.8211	142.82	8911640.0
2022-07-06 10:00:00	AAPL	Stock	142.82	143.7501	142.015	142.23	12552012.0
2022-07-06 11:00:00	AAPL	Stock	142.21	142.42	141.08	141.7087	6990959.0
2022-07-06 12:00:00	AAPL	Stock	141.71	142.07	141.525	141.9	3913018.0
2022-07-06 13:00:00	AAPL	Stock	141.9	142.55	141.875	142.44	3712316.0
2022-07-06 14:00:00	AAPL	Stock	142.435	143.64	141.86	143.615	9500482.0
2022-07-06 15:00:00	AAPL	Stock	143.62	144.12	142.365	142.96	12004383.0
2022-07-06 16:00:00	AAPL	Stock	142.96	143.08	142.7	142.91	6461788.0
2022-07-06 17:00:00	AAPL	Stock	142.9439	142.99	142.84	142.88	50326.0
2022-07-06 18:00:00	AAPL	Stock	142.87	143.06	142.87	142.92	34831.0
2022-07-06 19:00:00	AAPL	Stock	142.92	143.05	142.62	142.62	51891.0
2022-07-06 04:00:00	MSFT	Stock	262.0	263.8	262.0	262.26	5498.0
2022-07-06 05:00:00	MSFT	Stock	262.26	262.85	262.26	262.85	2312.0
2022-07-06 06:00:00	MSFT	Stock	262.8	263.28	262.7	262.7	1739.0
2022-07-06 07:00:00	MSFT	Stock	262.7	262.85	261.73	261.73	13619.0
2022-07-06 08:00:00	MSFT	Stock	262.2901	263.86	261.4	263.02	20519.0
2022-07-06 09:00:00	MSFT	Stock	263.32	265.38	262.4	265.205	2016945.0
2022-07-06 10:00:00	MSFT	Stock	265.25	266.16	263.6	264.95	2117233.0
2022-07-06 11:00:00	MSFT	Stock	264.93	265.05	262.82	264.185	1659598.0
2022-07-06 12:00:00	MSFT	Stock	264.18	264.745	263.88	264.6	907810.0
2022-07-06 13:00:00	MSFT	Stock	264.59	265.35	264.55	265.08	899058.0
2022-07-06 14:00:00	MSFT	Stock	265.09	267.32	264.19	267.31	2198158.0
2022-07-06 15:00:00	MSFT	Stock	267.31	267.99	265.19	266.24	3028960.0
2022-07-06 16:00:00	MSFT	Stock	266.25	266.46	265.68	266.25	4534568.0
2022-07-06 17:00:00	MSFT	Stock	266.46	266.46	266.08	266.08	3616.0
2022-07-06 18:00:00	MSFT	Stock	266.37	266.59	266.21	266.22	5795.0
2022-07-06 19:00:00	MSFT	Stock	266.18	266.47	266.01	266.45	4725.0
2022-07-06 04:00:00	NVDA	Stock	14.98	15.0	14.872	14.901	350070.0
2022-07-06 05:00:00	NVDA	Stock	14.9	14.95	14.88	14.95	110240.0
2022-07-06 06:00:00	NVDA	Stock	14.95	14.972	14.921	14.93	23110.0
2022-07-06 07:00:00	NVDA	Stock	14.939	14.959	14.84	14.865	191920.0
2022-07-06 08:00:00	NVDA	Stock	14.9052	14.998	14.82	14.9531	777850.0
2022-07-06 09:00:00	NVDA	Stock	14.96	15.1672	14.837	15.0385	65437960.0
2022-07-06 10:00:00	NVDA	Stock	15.034	15.224	14.789	15.209	80123770.0
2022-07-06 11:00:00	NVDA	Stock	15.21	15.236	14.923	14.9895	60431380.0
2022-07-06 12:00:00	NVDA	Stock	14.991	15.093	14.9602	15.078	34707740.0
2022-07-06 13:00:00	NVDA	Stock	15.079	15.156	15.076	15.1213	31640760.0
2022-07-06 14:00:00	NVDA	Stock	15.1244	15.294	14.976	15.293	78209920.0
2022-07-06 15:00:00	NVDA	Stock	15.295	15.319	15.034	15.13	75182680.0
2022-07-06 16:00:00	NVDA	Stock	15.13	15.175	15.116	15.1309	19574680.0
2022-07-06 17:00:00	NVDA	Stock	15.1415	15.1415	15.125	15.135	145020.0
2022-07-06 18:00:00	NVDA	Stock	15.135	15.156	15.126	15.131	197630.0
2022-07-06 19:00:00	NVDA	Stock	15.135	15.139	15.114	15.118	268980.0
2022-07-06 04:00:00	AMZN	Stock	113.57	113.76	112.7	112.85	16004.0
2022-07-06 05:00:00	AMZN	Stock	112.77	113.12	112.53	113.12	8840.0

> showing 50 of 61,188 rows — these rows as CSV

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