PREVIEW / stock_1hour / 2002-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-03.parquet
  size:    408 KB
  rows:    19,160
  symbols: 1,433

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
2002-06-03 08:00:00	AAPL	Stock	0.417	0.4173	0.417	0.4171	106400.0
2002-06-03 09:00:00	AAPL	Stock	0.417	0.4179	0.4127	0.4154	30744000.0
2002-06-03 10:00:00	AAPL	Stock	0.4154	0.4188	0.4045	0.4056	54443200.0
2002-06-03 11:00:00	AAPL	Stock	0.4055	0.4095	0.4032	0.4068	17690400.0
2002-06-03 12:00:00	AAPL	Stock	0.407	0.4086	0.4057	0.4073	9312800.0
2002-06-03 13:00:00	AAPL	Stock	0.4073	0.4136	0.4071	0.4127	22265600.0
2002-06-03 14:00:00	AAPL	Stock	0.413	0.415	0.4098	0.4113	25496800.0
2002-06-03 15:00:00	AAPL	Stock	0.4114	0.4125	0.408	0.4089	48003200.0
2002-06-03 16:00:00	AAPL	Stock	0.4091	0.41	0.4064	0.4091	6333600.0
2002-06-03 08:00:00	MSFT	Stock	25.575	25.66	25.425	25.55	92808.0
2002-06-03 09:00:00	MSFT	Stock	25.575	25.605	25.285	25.545	8220800.0
2002-06-03 10:00:00	MSFT	Stock	25.545	25.82	25.3	25.35	11651600.0
2002-06-03 11:00:00	MSFT	Stock	25.365	25.37	24.952	25.032	10355200.0
2002-06-03 12:00:00	MSFT	Stock	25.035	25.14	24.925	25.1075	5620200.0
2002-06-03 13:00:00	MSFT	Stock	25.115	25.1685	24.905	24.975	5436000.0
2002-06-03 14:00:00	MSFT	Stock	24.97	25.315	24.829	25.18	15136000.0
2002-06-03 15:00:00	MSFT	Stock	25.185	25.185	24.585	24.705	24329600.0
2002-06-03 16:00:00	MSFT	Stock	24.705	25.1311	24.625	24.85	2980600.0
2002-06-03 17:00:00	MSFT	Stock	24.735	24.75	24.7	24.7	24200.0
2002-06-03 18:00:00	MSFT	Stock	24.73	24.74	24.7	24.74	6000.0
2002-06-03 08:00:00	NVDA	Stock	0.275	0.279	0.274	0.2779	3360000.0
2002-06-03 09:00:00	NVDA	Stock	0.2767	0.278	0.2693	0.271	124812000.0
2002-06-03 10:00:00	NVDA	Stock	0.271	0.2733	0.2591	0.2627	275952000.0
2002-06-03 11:00:00	NVDA	Stock	0.2627	0.2646	0.2596	0.2628	92400000.0
2002-06-03 12:00:00	NVDA	Stock	0.2633	0.2645	0.2614	0.2637	55884000.0
2002-06-03 13:00:00	NVDA	Stock	0.2637	0.2662	0.2629	0.2647	67644000.0
2002-06-03 14:00:00	NVDA	Stock	0.265	0.2682	0.2639	0.2652	98088000.0
2002-06-03 15:00:00	NVDA	Stock	0.2653	0.2663	0.2617	0.2623	127620000.0
2002-06-03 16:00:00	NVDA	Stock	0.2624	0.2658	0.2622	0.2627	10944000.0
2002-06-03 17:00:00	NVDA	Stock	0.2632	0.2641	0.2631	0.2633	2064000.0
2002-06-03 18:00:00	NVDA	Stock	0.2626	0.2626	0.2626	0.2626	24000.0
2002-06-03 08:00:00	AMZN	Stock	0.915	0.9205	0.915	0.9205	10000.0
2002-06-03 09:00:00	AMZN	Stock	0.9115	0.9685	0.911	0.913	10218000.0
2002-06-03 10:00:00	AMZN	Stock	0.914	0.925	0.9015	0.9045	15110000.0
2002-06-03 11:00:00	AMZN	Stock	0.9045	0.909	0.9015	0.9055	8576000.0
2002-06-03 12:00:00	AMZN	Stock	0.9055	0.907	0.9015	0.904	6382000.0
2002-06-03 13:00:00	AMZN	Stock	0.9055	0.9055	0.8985	0.903	8616000.0
2002-06-03 14:00:00	AMZN	Stock	0.902	0.904	0.897	0.897	7208000.0
2002-06-03 15:00:00	AMZN	Stock	0.897	0.9025	0.8965	0.898	12522000.0
2002-06-03 16:00:00	AMZN	Stock	0.8985	0.8995	0.8975	0.898	1116000.0
2002-06-03 17:00:00	AMZN	Stock	0.898	0.898	0.898	0.898	102000.0
2002-06-03 18:00:00	AMZN	Stock	0.899	0.899	0.899	0.899	8000.0
2002-06-03 09:00:00	CL	Stock	26.975	27.315	26.97	27.26	350400.0
2002-06-03 10:00:00	CL	Stock	27.28	27.4	27.225	27.27	684600.0
2002-06-03 11:00:00	CL	Stock	27.26	27.375	27.21	27.37	402600.0
2002-06-03 12:00:00	CL	Stock	27.365	27.435	27.295	27.41	478200.0
2002-06-03 13:00:00	CL	Stock	27.405	27.45	27.31	27.375	338600.0
2002-06-03 14:00:00	CL	Stock	27.375	27.42	27.35	27.36	500400.0
2002-06-03 15:00:00	CL	Stock	27.355	27.375	27.025	27.065	1312000.0
2002-06-03 16:00:00	CL	Stock	27.065	27.255	27.025	27.255	168600.0

> showing 50 of 19,160 rows — these rows as CSV

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