PREVIEW / stock_1hour / 2023-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-12.parquet
  size:    1.3 MB
  rows:    58,145
  symbols: 1,428

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
2023-09-12 04:00:00	AAPL	Stock	179.78	179.78	179.07	179.44	18103.0
2023-09-12 05:00:00	AAPL	Stock	179.49	179.89	179.49	179.86	12062.0
2023-09-12 06:00:00	AAPL	Stock	179.86	180.02	179.72	179.9	26366.0
2023-09-12 07:00:00	AAPL	Stock	179.91	179.96	179.69	179.75	60083.0
2023-09-12 08:00:00	AAPL	Stock	179.91	180.2	179.55	179.75	240194.0
2023-09-12 09:00:00	AAPL	Stock	179.74	180.13	178.45	178.73	6416142.0
2023-09-12 10:00:00	AAPL	Stock	178.73	178.7399	176.23	176.345	11878367.0
2023-09-12 11:00:00	AAPL	Stock	176.345	177.12	176.25	176.6801	6207466.0
2023-09-12 12:00:00	AAPL	Stock	176.685	177.27	176.395	176.9691	5206604.0
2023-09-12 13:00:00	AAPL	Stock	176.97	177.87	175.45	176.3999	11866136.0
2023-09-12 14:00:00	AAPL	Stock	176.39	176.78	174.82	175.3287	15961540.0
2023-09-12 15:00:00	AAPL	Stock	175.33	176.46	175.0004	176.31	12082985.0
2023-09-12 16:00:00	AAPL	Stock	176.31	176.83	176.21	176.3603	6776643.0
2023-09-12 17:00:00	AAPL	Stock	176.4	176.58	176.35	176.45	98848.0
2023-09-12 18:00:00	AAPL	Stock	176.4	176.48	176.34	176.39	36735.0
2023-09-12 19:00:00	AAPL	Stock	176.38	176.44	176.33	176.35	42776.0
2023-09-12 04:00:00	MSFT	Stock	336.46	336.58	336.0	336.0	3314.0
2023-09-12 05:00:00	MSFT	Stock	335.9	335.9	335.9	335.9	100.0
2023-09-12 06:00:00	MSFT	Stock	336.31	336.31	336.31	336.31	300.0
2023-09-12 07:00:00	MSFT	Stock	336.38	336.51	335.56	335.56	9527.0
2023-09-12 08:00:00	MSFT	Stock	336.2	336.93	335.2	335.49	29360.0
2023-09-12 09:00:00	MSFT	Stock	335.3	336.79	334.87	335.845	1142750.0
2023-09-12 10:00:00	MSFT	Stock	335.845	335.88	333.26	333.445	1587027.0
2023-09-12 11:00:00	MSFT	Stock	333.45	333.98	332.22	333.1101	1312011.0
2023-09-12 12:00:00	MSFT	Stock	333.13	334.0599	332.98	333.25	724322.0
2023-09-12 13:00:00	MSFT	Stock	333.3	334.24	332.31	332.34	735479.0
2023-09-12 14:00:00	MSFT	Stock	332.33	332.78	331.8101	332.09	994729.0
2023-09-12 15:00:00	MSFT	Stock	332.125	333.11	331.48	331.74	2396440.0
2023-09-12 16:00:00	MSFT	Stock	331.75	332.16	331.61	331.97	3342351.0
2023-09-12 17:00:00	MSFT	Stock	331.85	331.97	331.77	331.8	3970.0
2023-09-12 18:00:00	MSFT	Stock	331.8	331.94	331.71	331.9	7177.0
2023-09-12 19:00:00	MSFT	Stock	331.9	332.0	331.77	332.0	3780.0
2023-09-12 04:00:00	NVDA	Stock	45.1	45.1	44.829	44.83	98090.0
2023-09-12 05:00:00	NVDA	Stock	44.917	44.92	44.883	44.92	11050.0
2023-09-12 06:00:00	NVDA	Stock	44.937	45.024	44.937	44.977	14190.0
2023-09-12 07:00:00	NVDA	Stock	44.986	44.986	44.845	44.845	434760.0
2023-09-12 08:00:00	NVDA	Stock	44.975	45.35	44.814	44.863	1125210.0
2023-09-12 09:00:00	NVDA	Stock	44.832	45.555	44.531	45.455	52486690.0
2023-09-12 10:00:00	NVDA	Stock	45.458	45.673	44.962	45.0675	54109570.0
2023-09-12 11:00:00	NVDA	Stock	45.069	45.481	44.937	45.3841	33363950.0
2023-09-12 12:00:00	NVDA	Stock	45.391	45.472	45.26	45.339	20727490.0
2023-09-12 13:00:00	NVDA	Stock	45.3295	45.445	45.1	45.2	26676460.0
2023-09-12 14:00:00	NVDA	Stock	45.2	45.3436	45.03	45.076	24230820.0
2023-09-12 15:00:00	NVDA	Stock	45.0735	45.12	44.815	44.87	33752350.0
2023-09-12 16:00:00	NVDA	Stock	44.87	44.87	44.706	44.755	11572340.0
2023-09-12 17:00:00	NVDA	Stock	44.7513	44.76	44.731	44.755	188730.0
2023-09-12 18:00:00	NVDA	Stock	44.755	44.819	44.747	44.79	209490.0
2023-09-12 19:00:00	NVDA	Stock	44.782	44.782	44.735	44.755	270790.0
2023-09-12 04:00:00	AMZN	Stock	142.13	142.31	142.0	142.15	8844.0
2023-09-12 05:00:00	AMZN	Stock	142.1	142.29	142.08	142.12	7063.0

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

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