PREVIEW / stock_1hour / 2023-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-31.parquet
  size:    1.3 MB
  rows:    57,403
  symbols: 1,340

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-10-31 04:00:00	AAPL	Stock	169.6	169.8	169.28	169.8	11867.0
2023-10-31 05:00:00	AAPL	Stock	169.76	169.82	169.6	169.8	7125.0
2023-10-31 06:00:00	AAPL	Stock	169.88	170.15	169.81	169.95	3859.0
2023-10-31 07:00:00	AAPL	Stock	169.91	170.1	169.5	169.5	52040.0
2023-10-31 08:00:00	AAPL	Stock	169.45	170.19	168.52	169.09	222991.0
2023-10-31 09:00:00	AAPL	Stock	169.09	169.45	167.9	168.56	4547948.0
2023-10-31 10:00:00	AAPL	Stock	168.55	169.87	168.32	169.71	5506938.0
2023-10-31 11:00:00	AAPL	Stock	169.71	169.8155	168.845	169.76	3939440.0
2023-10-31 12:00:00	AAPL	Stock	169.75	170.07	169.27	169.9958	3293205.0
2023-10-31 13:00:00	AAPL	Stock	170.01	170.75	169.77	170.645	3554857.0
2023-10-31 14:00:00	AAPL	Stock	170.64	170.74	169.931	170.53	2872208.0
2023-10-31 15:00:00	AAPL	Stock	170.54	170.9	170.38	170.77	5369073.0
2023-10-31 16:00:00	AAPL	Stock	170.76	170.77	170.17	170.21	5971466.0
2023-10-31 17:00:00	AAPL	Stock	170.23	170.49	170.18	170.37	36376.0
2023-10-31 18:00:00	AAPL	Stock	170.37	170.44	170.22	170.3483	7611.0
2023-10-31 19:00:00	AAPL	Stock	170.32	170.39	170.02	170.3801	12535.0
2023-10-31 04:00:00	MSFT	Stock	336.5	337.64	336.5	337.53	1484.0
2023-10-31 05:00:00	MSFT	Stock	337.83	338.0	337.81	337.97	1622.0
2023-10-31 06:00:00	MSFT	Stock	338.22	338.89	337.83	338.46	4444.0
2023-10-31 07:00:00	MSFT	Stock	338.49	339.24	338.49	339.24	13959.0
2023-10-31 08:00:00	MSFT	Stock	338.84	339.7	335.25	339.0	63103.0
2023-10-31 09:00:00	MSFT	Stock	339.0	339.44	335.12	336.19	1759068.0
2023-10-31 10:00:00	MSFT	Stock	336.17	337.8498	335.58	336.62	2177420.0
2023-10-31 11:00:00	MSFT	Stock	336.64	336.9798	334.69	336.11	1504573.0
2023-10-31 12:00:00	MSFT	Stock	336.09	336.87	335.2	336.71	1040948.0
2023-10-31 13:00:00	MSFT	Stock	336.73	338.49	336.65	338.085	1206497.0
2023-10-31 14:00:00	MSFT	Stock	338.07	338.15	337.1001	337.9857	1089925.0
2023-10-31 15:00:00	MSFT	Stock	337.99	338.44	337.19	338.14	2128874.0
2023-10-31 16:00:00	MSFT	Stock	338.09	338.12	337.0	338.11	3083940.0
2023-10-31 17:00:00	MSFT	Stock	337.19	337.98	337.19	337.6992	10892.0
2023-10-31 18:00:00	MSFT	Stock	337.68	337.8137	337.3507	337.8137	8207.0
2023-10-31 19:00:00	MSFT	Stock	337.82	337.82	337.36	337.65	3735.0
2023-10-31 04:00:00	NVDA	Stock	40.6	40.981	40.564	40.95	188600.0
2023-10-31 05:00:00	NVDA	Stock	40.93	40.93	40.85	40.914	21720.0
2023-10-31 06:00:00	NVDA	Stock	40.921	40.936	40.869	40.905	32710.0
2023-10-31 07:00:00	NVDA	Stock	40.93	41.1	40.893	40.925	617850.0
2023-10-31 08:00:00	NVDA	Stock	40.566	41.1	40.4133	40.44	2590010.0
2023-10-31 09:00:00	NVDA	Stock	40.439	40.59	39.23	39.645	81436340.0
2023-10-31 10:00:00	NVDA	Stock	39.636	40.289	39.51	40.246	85923370.0
2023-10-31 11:00:00	NVDA	Stock	40.255	40.3533	40.023	40.2533	51189510.0
2023-10-31 12:00:00	NVDA	Stock	40.247	40.395	40.041	40.351	36505760.0
2023-10-31 13:00:00	NVDA	Stock	40.362	40.654	40.201	40.631	35390230.0
2023-10-31 14:00:00	NVDA	Stock	40.635	40.685	40.41	40.67	36322590.0
2023-10-31 15:00:00	NVDA	Stock	40.6665	40.879	40.632	40.77	57117430.0
2023-10-31 16:00:00	NVDA	Stock	40.77	40.78	40.383	40.48	15760350.0
2023-10-31 17:00:00	NVDA	Stock	40.46	40.78	40.46	40.6698	998780.0
2023-10-31 18:00:00	NVDA	Stock	40.65	40.669	40.5277	40.533	280840.0
2023-10-31 19:00:00	NVDA	Stock	40.535	40.549	40.475	40.51	506320.0
2023-10-31 04:00:00	AMZN	Stock	131.89	132.47	131.55	132.4	22865.0
2023-10-31 05:00:00	AMZN	Stock	132.39	132.42	132.01	132.42	6894.0

> showing 50 of 57,403 rows — these rows as CSV

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